To back up the RMAN backup and recovery control files, we must first back up the database. The database backup process is as follows: RMAN backs up the entire database
To back up the RMAN backup and recovery control files, we must first back up the database. The database backup process is as follows: RMAN backs up the entire database
1. Preface
As a saying goes, "You must know what it is, but you must
ALTER DATABASE Create datafile causes the original data file to be lost
We have a client with a small system to recover, after Oracle Database Recovery Check detection We found a strange phenomenon in the Red box section
1. The head of the file is fuzzy No, does not conform to the database unusual crash common sense, also and other files this sta
Database status
Control File
Controlling data file information in a file
Data File header information
Redo Information
Based on the information gathered by the current database recovery check script (Oracle database Recovery
Oracle online log files record the logs of data block changes during database operation. After the database becomes corrupted or fails abnormally, you must use online logs (or archive logs, repeat the changes in the database.When the log file itself is damaged (lost), the database may not be able to open normally. In this case, the recovery test is conducted (for reference only ):
Change redo log size)
Orac
has professional management software database Repair technical engineer, professional to provide housekeeper, U.S. Ping, think fast, branch vein management software Technical services, computer repair \ re-install system technical Services. Unable to log on, and so on error processing (connection failure, enter the correct server name, SQL server does not exist or deny access, User sa login failure and so on), data corruption repair, software extranet remote access, annual balance, software vers
1. Preface
As a saying goes, "You must know what it is, but you must know what it is ". But I don't know why. Why. This series of articles will show you how to do it and why it will also be involved. However, due to the limited level, the principle is not profound enough. I hope that the readers can understand the concept.
I have read a lot of materials recently and are also thinking about the value that the technology we are pursuing can bring to this society. It's a bit boring to walk on the r
ERP Software database overwrite data recovery success/Reload database system software, resulting in file overwrite with same name"Data Recovery failure description"A hotel in Shanghai ERP software was originally installed on the C drive, the user mistakenly operation to uninstall the software, found that the software has not,But before the operation did not copy
Non-current online Log File fault recovery 1. ORA-00313 error when starting the database. ORA-00313: openfailedformembersofloggroup
Non-current online Log File fault recovery 1. ORA-00313 error when starting the database. ORA-00313: open failed for members of log group
Non-current online Log
This article is a simulated test. The main steps are as follows:1. Perform rman full backup for the Test Database (nocatalog mode)2. Delete all files in the oradata \ orcl Directory3. Use rman for recovery.The detailed steps are as follows:1. Perform rman full backup for the Test DatabaseC: \ Documents Ents and Settings \ xGss2000> rman nocatalog target/Recovery Manager: Release 10.2.0.1.0-Production on Sunday, September 11, August 14 00:06:16 2011Cop
1,Control File(Controlfile)Loss recovery
Based on the control file's compound multi-path nature, there are two types of loss: one is the damage or loss of a control file, and the other is the loss of all control files. In the first case, you only need to copy the control file to the path of the corrupt or lost control
Article Title: Linux and Unix file system backup and recovery methods. Linux is a technology channel of the IT lab in China. Includes basic categories such as desktop applications, Linux system management, kernel research, embedded systems, and open source.
Backup target: User File or entire File System
Key backup Prob
RMAN backup and recovery-parameter file Restoration
In RMAN, "restoration" and "restoration" have different meanings. "restoration" refers to accessing the previously generated backup set to obtain one or more objects, then restore these objects at a location on the disk. Detached from restoration. Recovery is an actual operation that allows a database to be open
You must be logged on as an administrator to perform these steps.
A recovery certificate is a special Encrypting File System (EFS) certificate that can be recovered if the encryption key is lost or corrupted if the certificate is created and installed correctly. You need to create a recovery certificate, install the certificate, and then update the previous encr
Recently because of the busy work, coupled with the end of a lot of projects, there is no time to write Bo, today, a friend asked about the Windows 2003 shadow copies of the function, said is only a whole disk restore, from itself, when we look at the disk properties, this is the case, this Windows R2 , Windows R2 is different, in Windows R2 we can restore files directly in the disk properties, in fact, under Windows 2003 can also achieve file-level
Tags: Linux data recovery Ext4 file system fsckThere are several concepts that need to be understood before data recovery cases beginBlock group: The entire space of the Ext4 file system is divided into block groups, and the structure within each block group is roughly the same.Block Group Descriptor Table: each block
\FTTEST01 ', ' E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\USERS02. DBF ', ' E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\ZXF1. DBF ', ' E:\ORACLE\PRODUCT\10.2.0\ORADATa\orcl\zxf2. DBF ', ' E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\TZX01. DBF ' CHARACTER SET ZHS16GBK;
3.recover database; Restore Database
4. Open database alter DB open;
Since Noresetlogs is recovered with the high SCN of the current log, there is basically no problem.
IV: Using Resetlogs to perform control files and database
"User units"A branch of China Unicom"Data Recovery failure description"Sun Fiber Storage System, the central storage of 6 pieces of 300G hard disk RAID6, divided into several lun,map to different services on the server, the server runs the Sun Solaris operating system.In normal operation, the user needs to add a new application, so an IBM server is added, then a LUN in the store is mapped to the new IBM server in the online state, and unexpectedly, th
Data Recovery tips how to restore a computer file deleted
During the use of computers, we often delete useless computer files, but sometimes important files may be deleted accidentally. If you just delete the file to the recycle bin, you just need to find the file in the recycle bin and restore it. But what if the rec
a file in Windows Explorer, Windows puts the file in the Recycle Bin, and even if we empty the Recycle Bin (or do not start the Recycle Bin feature), the operating system does not actually erase the file's data.
What Windows calls deletion actually simply changes the first letter of the file name to a special character, the cluster is then marked as idle, but t
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.