recover database using backup controlfile
也就是說,不加using backup controlfile的情況。
在普通的recover database 或者 recover tablespace, recover datafile時, Oracle會以當前controlfile所紀錄的SCN為準,利用archive log和 redo log的redo entry, 把相關的datafile 的 block恢復到“當前controlfile所紀錄的SCN”
而某些情況下,Oracle需要把資料恢復到比當前controlfile所紀錄的SCN還要靠後的位置(比如說,control file是backup controlfile , 或者 controlfile是根據trace create的。),這時候,就需要用using backup controlfile. 恢復就不會受“當前controlfile所紀錄的SCN”的限制。
這時候的限制就來自於你的語句(until time , until scn),或者可用的archive log(until cancel)
需要注意的是using backup controlfile只是告訴oracle這個控制檔案是older,當前的redo log的log_no與它是對不上的,所以要跳過redo log直接套用archivelog
反過來,假如你不用using backup controlfile,那麼oracle會拿這個older的controlfile的log_no與redolog的log_no比對,因為對不上,oracle就會報錯退出恢復
[@more@]來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/95530/viewspace-1036114/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- recover database using backup controlfile理解Database
- recover database using backup controlfile與 recover database 的區別Database
- recover database until cancel using backup controlfileDatabase
- Recover database using backup controlfile until cancelDatabase
- recover database using backup controlfile利用archivelog files.DatabaseHive
- recover database using backup control fileDatabase
- oracle create a new database using backup controlfile to traceOracleDatabase
- 冷備控制檔案 & Using Backup Controlfile
- using backup controlfile 和 until cancel區別
- using backup controlfile和 until cancel 區別
- How to restore and recover a database from an RMAN backup_881395.1RESTDatabase
- alter database backup controlfile to trace的問題Database
- alter database backup controlfile to trace的含義Database
- 重建控制檔案--alter database backup controlfile to traceDatabase
- 水煮十四——《using backup controlfile 和 until cancel區別
- recover database until cancel和 recover database區別Database
- Case two -- Recover a datafile in primary site from the backup taken in standby site without using c
- Recover_DatabaseDatabase
- rman recover databaseDatabase
- Recover a Database Having Added a Datafile Since Last Backup (Doc ID 29430.1)DatabaseAST
- Oracle 12C Transport a Database to a Different Platform Using Backup SetsOracleDatabasePlatform
- Case One -- Recover a datafile in primary site from the backup taken in standby site using catalog d
- 關於using backup controlfile(丟失控制檔案和資料檔案)
- recover database until timeDatabase
- 冷備手工完全恢復(recover database,recover tablespace,recover datafile)Database
- 12C Duplicating a Database to a Remote Host by Using Backup-based DuplicationDatabaseREM
- oracle full database backupOracleDatabase
- Rman backup standby databaseDatabase
- Cold Database backup scriptDatabase
- Restore standby database controlfile in ASM (refreshing standby controlfile)RESTDatabaseASM
- rman restore database(spfile,controlfile, datafile)RESTDatabase
- 12c-RECOVER PLUGGABLE DATABASEDatabase
- Oracle 12c: Recover tables using RMANOracle
- Cold backup and restore the entire databaseRESTDatabase
- rman backup database force 功能Database
- alter system backup controlfile to trace內容詳解
- Recover A Lost Datafile With No Backup (Doc ID 1060605.6)
- SQLBackupAndFTP12.0 failed to backup database with full backup typeSQLFTPAIDatabase