Oracle OCP 1Z0 053 Q401(Block Media Recovery)
A. Physical and logical block corruption is recorded automatically in V$DATABASE_BLOCK_
CORRUPTION.
B. Logical corruptions are repairable by BMR.
C. Physical corruptions are repairable by BMR.
D. RMAN can use any backup for a BMR restore.
E. ARCHIVELOG mode is not required if you have both a full and incremental backup for restore.
Answer: AC
Prerequisites for Block Media Recovery
The following prerequisites apply to the RECOVER ... BLOCK command:
-
The target database must run in ARCHIVELOG mode and be open or mounted with a current control file.
-
If the target database is a standby database, then it must be in a consistent state, recovery cannot be in session, and the backup must be older than the corrupted file.
-
The backups of the data files containing the corrupt blocks must be full or level 0 backups and not proxy copies.
If only proxy copy backups exist, then you can restore them to a nondefault location on disk, in which case RMAN considers them data file copies and searches them for blocks during block media recovery.
-
RMAN can use only archived redo logs for the recovery.
RMAN cannot use level 1 incremental backups. Block media recovery cannot survive a missing or inaccessible archived redo log, although it can sometimes survive missing redo records.
-
Flashback Database must be enabled on the target database for RMAN to search the flashback logs for good copies of corrupt blocks.
If flashback logging is enabled and contains older, uncorrupted versions of the corrupt blocks, then RMAN can use these blocks, possibly speeding up the recovery.
-
The target database must be associated with a real-time query physical standby database for RMAN to search the database for good copies of corrupt blocks.
參考:http://blog.itpub.net/17013648/viewspace-1292381/
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/8520577/viewspace-2076161/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle OCP 1Z0 053 Q399(block media recovery)OracleBloC
- Oracle OCP 1Z0 053 Q517(Block Media Recovery&Archivelog Mode&Flashback Logging)OracleBloCHive
- Oracle OCP 1Z0 053 Q564(Datafile Recovery with RMAN)Oracle
- Oracle OCP 1Z0 053 Q389(Recovery Writer Process)Oracle
- Oracle OCP 1Z0 053 Q507(Rman Recovery)Oracle
- Oracle OCP 1Z0 053 Q709(Recovery Redo log)Oracle
- Oracle OCP 1Z0 053 Q570( point-in-time recovery)Oracle
- Oracle OCP 1Z0 053 Q613(automatic management of backup and recovery)Oracle
- Oracle OCP 1Z0 053 Q359(Point-in-time tablespace recovery)Oracle
- Oracle OCP 1Z0 053 Q650Oracle
- Oracle OCP 1Z0 053 Q324Oracle
- Oracle OCP 1Z0 053 Q27Oracle
- Oracle OCP 1Z0 053 Q49Oracle
- Oracle OCP 1Z0 053 Q10Oracle
- Oracle OCP 1Z0 053 Q685Oracle
- Oracle OCP 1Z0 053 Q454Oracle
- Oracle OCP 1Z0 053 Q500Oracle
- Oracle 1Z0 053 Q684(Incomplete Recovery)Oracle
- Oracle OCP 1Z0 053 Q444(Scheduler)Oracle
- Oracle OCP 1Z0 053 Q440(Scheduler)Oracle
- Oracle OCP 1Z0 053 Q601Oracle
- Oracle OCP 1Z0 053 Q472(Locale)Oracle
- Oracle OCP 1Z0 053 Q525(ASM)OracleASM
- Oracle OCP 1Z0 053 Q292(NFS)OracleNFS
- Oracle OCP 1Z0 053 Q538(ASM)OracleASM
- Oracle OCP 1Z0 053 Q416Oracle
- Oracle OCP 1Z0 053 Q648(Flashback)Oracle
- Oracle OCP 1Z0 053 Q520Oracle
- Oracle OCP 1Z0 053 Q607Oracle
- Oracle OCP 1Z0 053 Q500(Rman)Oracle
- Oracle OCP 1Z0 053 Q707Oracle
- Oracle OCP 1Z0 053 Q28(INCREMENTAL)OracleREM
- Oracle OCP 1Z0 053 Q332Oracle
- Oracle OCP 1Z0 053 Q269Oracle
- Oracle OCP 1Z0 053 Q83(Flashback Database)OracleDatabase
- Oracle OCP 1Z0 053 Q344(V$SESSION)OracleSession
- Oracle OCP 1Z0 053 Q558(V$BACKUP)Oracle
- Oracle OCP 1Z0 053 Q427(Transportable Tablespace)Oracle