Shulou(Shulou.com)06/01 Report--

For the specific command methods of backup and migration, please refer to the document: http://blog.itpub.net/29487349/viewspace-2142872/

After the full recovery of the data file, when you are ready to use incremental full recovery of the data, choose to use norestlogs to restore the database as follows:

Backup control file 9 (which can also be considered a dump to a file):

Click (here) to collapse or open

SQL > RECOVER DATABASE

ORA-00279: a change of 1122729 (generated at 16:47:55 in 07 Universe 31) is required for thread 1

ORA-00289: suggestion: d:\ ARCHIVELOG\ ARC0000000072_0949876315.0001

ORA-00280: change 1122729 (for thread 1) in sequence # 72-note here that the file was actually backed up and deleted in the system directory when it was complete, although the archive was manually switched several times, but the archive still needs to be used for recovery. Therefore, it is recommended that the relevant archive logs be restored according to the data file scn number when the data file is recovered.

Specify log: {= suggested | filename | AUTO | CANCEL}

Auto

ORA-00279: a change of 1122757 (generated at 16:48:55 in 07 Universe 31) is required for thread 1

ORA-00289: suggestion: d:\ ARCHIVELOG\ ARC0000000073_0949876315.0001

ORA-00280: change 1122757 (for thread 1) in sequence # 73

ORA-00279: a change of 1122778 (generated at 16:48:59 in 07 Universe 31) is required for thread 1

ORA-00289: suggestion: d:\ ARCHIVELOG\ ARC0000000074_0949876315.0001

ORA-00280: change 1122778 (for thread 1) in sequence # 74

Applied logs.

Complete the media recovery.

SQL >

Open the database:

Click (here) to collapse or open

SQL > alter database open

The database has changed.

Again, it is not recommended to use this method to restore. Of course, we may be able to ensure the availability and validity of the online log during the migration, and of course you can tolerate the loss of backup information and related information in the control file. In general, the rman backup files used do not contain online logs, so it is recommended to back up and restore the database in a full and incremental manner. Including migration, of course!

Reference documentation: How to RESTORE / RECOVER Offline RMAN backup without OPEN RESETLOGS (Doc ID 1077022.1)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.