OCP prepare 20140701

1. Completely backup and incomplete backup of RMAN

Oracle databases can achieve Incomplete recovery and full recovery of databases. Full recovery is to restore the database to the latest time, that is, lossless recovery, to ensure that the database is not lost. Incomplete recovery specifically restores the database to a specific time point or SCN and a specific sequence as needed. We can implement Incomplete recovery based on user management, or through RMAN. This document describes the Incomplete recovery based on RMAN and provides examples. For the concepts and practices of Database Backup Recovery and RMAN backup recovery, refer to the link at the end of the article.

Http://blog.csdn.net/leshami/article/details/9253867

 

2. resetlogs noresetlogs

Http://www.itpub.net/thread-905297-1-1.html

Resetlogs refers to reusing online redo logs, while noresetlogs means not reusing online redo logs, that is, re-creating logs.

If it is completely restored, Yong noresetlogs will be restlogs if it is not completely restored.

 

3. Using backup controlfile

Normally, when the current control file is lost or the current control file is inconsistent with the control file to be restored, we need to re-create a control file or use unsing
Backup controlfile to restore the control file. To put it simply, as long as the backup control file is inconsistent with the current control file to restore the database, you need to use the unsing
Backup controlfile method. Once this method is used, you must use the resetlgos option to open the database.

For more information about the control file, see Oracle control file)

For details about using backup controlfile, refer to using backup controlfile.

I. Considerations for restoring backup control files (whether or not the recovery directory catalog is used)
1. Even if no data file needs to be restored, the recover command must be used in the unsing backup controlfile mode.
2. Whether the backup control file is used for point-in-time recovery or full recovery, open resetlogs must be used to open the database.
3. If online logs cannot be accessed, they must be used before they are completely restored to the earliest SCN in the online log file. This is because RMAN does not back up online log files.
4. During recovery, RMAN automatically searches for online logs and archive logs not recorded in the RMAN storage warehouse for recovery.
5. RMAN automatically searches for valid archived and online logs based on the archiving location in the initialization parameter file and the online log information of the control file. Use unsing backup controlfile
During recovery, once the archiving destination and archive format change, or you add a new online log member, you will receive a RMAN-06054 error message.

Http://blog.csdn.net/leshami/article/details/7962187