多选题Which of the following are correct about block media recovery?()APhysical and logical block corruption is recorded automatically in V$DATABASE_BLOCK_ CORRUPTIONBLogical corruptions are repairable by BMRCPhysical corruptions are repairable by BMRDRMAN can use any backup for a BMR restoreEARCHIVELOG mode is not required if you have both a full and incremental backup for restore
多选题
Which of the following are correct about 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
参考解析
解析:
暂无解析
相关考题:
Which of the following statements about ORACLE is (are) correct?Ⅰ.ORACLE follows SQL standardⅡ.ORACLE database defines two logical types: table and viewA.ⅠonlyB.Ⅱ onlyC.Ⅰ and ⅡD.none of the above
In HDLC Protocol, when Supervisory Frame's type code is '00'.About the following statements, which is correct.A.Receive ReadyB.Receive not ReadyC.RejectD.Selective Reject
Which of the following is not an advantage of block media recovery (BMR)?()A、 Reduced MTTR.B、 Datafiles remain offline while corrupt blocks are repaired.C、 Datafiles remain online while corrupt blocks are repaired.D、 A and C
When you are performing media recover, and an archived log is lost or corrupt, which type of recover must you perform?()A、Until SCNB、Until timeC、Until cancelD、Recover using backup control file.
Which of the following statements is NOT true about RMAN?()A、It improves usability by enabling you to reuse the scripts to perform recovery operations.B、It detects block corruption while restoration and recovery operations.C、It enables you to perform block media recovery.D、It is capable to recover through unrecoverable operations, with only full database backups.
A customer is concerned about excessive media jamming in their device. Which of the following is the FIRST thing a technician should check?()A、Media feed rollersB、Cassette drawersC、Fusing sectionD、Device log data
Which of the following commands should be used to obtain information about the software packages available on the installation media?()A、 lsattrB、 inutocC、 installpD、 lsresource
A customer purchases a virtual media key on a x3650 M3. They ask where to install the key. Which of the following provides the correct answer?()A、Problem Determination and Service GuideB、xRefC、ServerGuide Hardware ReferenceD、COG
You are using the Block Media Recovery feature to recover the blocks that are marked corrupt since the last backup. Which view will you query to display information about the data blocks that are marked corrupt since the last backup?()A、 V$BACKUP_CORRUPTIONB、 V$COPY_CORRUPTIONC、 V$DATABASE_BLOCK_CORRUPTIOND、 RC_BACKUP_CORRUPTION
If a backup is expired, which of the following is true?() A、 It can never be used for a restore/recover operation.B、 Oracle will remove the backup set pieces from the flash recovery area.C、 The backup has been used at least once to restore and recover the database.D、 The backup is no longer valid because of a resetlogs operation.E、 The physical backup set pieces are missing from the media.
Which of the following are correct about block media recovery?()A、 Physical and logical block corruption is recorded automatically in V$DATABASE_BLOCK_ CORRUPTIONB、 Logical corruptions are repairable by BMRC、 Physical corruptions are repairable by BMRD、 RMAN can use any backup for a BMR restoreE、 ARCHIVELOG mode is not required if you have both a full and incremental backup for restore
Which of the following commands cannot be executed when the database open?()A、RECOVER DATABASEB、RECOVER TABLESPACEC、RECOVER DATAFILED、ALTER DATABASE RECOVER DATAFILE
While querying the EMPLOYEES table, you receive an ORA-01578 message indicating block corruption in File# 1201 and Block# 1968. You analyze the table and the corruption is verified. Which RMAN command do you use to perform BMR and repair the corrupt block?() A、 RECOVER FILE=1201 BLOCK=1968B、 RECOVER CORRUPTION LISTC、 RECOVER DATAFILE 1201 BLOCK 1968D、 RECOVER BLOCK CORRUPTION LISTE、 None of the above
You issue the following statement: SQL SELECT FIRSTNAME, LASTNAME FROM HR.EMPLOYEE; You receive the following error: 01578: ORACLE data block corrupted (file# 6, block # 54) ORA-01110 : data file 6: ’u01/oracle/oradata/data1.dbf’ How will you resolve this problem of data block corruption by reducing the mean time to recover (MTTR)?()A、 by using the DBMS_REPAIR packageB、 by using the DBVERIFY utilityC、 by using Block Media RecoveryD、 by issuing the ANALYZE TABLE HR.EMPLOYEES VALIDATE STRUCTURE command
If you find errors in the view V$DATABASE_BLOCK_CORRUPTION with a status of MEDIA_CORRUPT, what RMAN command would you run to correct the problem?()A、 recover lost blocksB、 recover corrupt blocksC、 recover media corrupt blocks from listD、 recover corrupt blocks from listE、 recover corruption list
You are performing a block media recovery on the tools01.dbf data file in the SALES database by using RMAN. Which two statements are correct in this scenario?()A、You must ensure that the SALES database is mounted or open.B、You must restore a backup control file to perform a block media recovery.C、You must take the tools01.dbf data file offline before you start a block media recovery.D、You must put the database in NOARCHIVELOG mode to perform a block media recovery.E、You can perform only a complete media recovery of individual blocks; point-in-time recovery of individual data blocks is not supported.
单选题Which of the following statements is NOT true about RMAN?()AIt improves usability by enabling you to reuse the scripts to perform recovery operations.BIt detects block corruption while restoration and recovery operations.CIt enables you to perform block media recovery.DIt is capable to recover through unrecoverable operations, with only full database backups.
单选题You issue the following statement: SQL SELECT FIRSTNAME, LASTNAME FROM HR.EMPLOYEE; You receive the following error: 01578: ORACLE data block corrupted (file# 6, block # 54) ORA-01110 : data file 6: ’u01/oracle/oradata/data1.dbf’ How will you resolve this problem of data block corruption by reducing the mean time to recover (MTTR)?()A by using the DBMS_REPAIR packageB by using the DBVERIFY utilityC by using Block Media RecoveryD by issuing the ANALYZE TABLE HR.EMPLOYEES VALIDATE STRUCTURE command
单选题Which of the following descriptions about IP spoofing is correct?()AIP source address is forgedBIP destination address is forgedCIP TCP source port is forgedDIP TCP destination port is forgedENone of above
多选题Which two statements are true about Block Media Recovery (BMR)?()ABMR increases the Mean Time To Recover (MTTR).BBMR can only be implemented using Recovery Manager (RMAN).CThe blocks that need to be recovered are accessible during BMR.DBMR cannot be performed using cumulative incremental backups.EThe datafile must be restored if most of the blocks in the datafile are corrupt.
单选题You are using the Block Media Recovery feature to recover the blocks that are marked corrupt since the last backup. Which view will you query to display information about the data blocks that are marked corrupt since the last backup?()A V$BACKUP_CORRUPTIONB V$COPY_CORRUPTIONC V$DATABASE_BLOCK_CORRUPTIOND RC_BACKUP_CORRUPTION
单选题Which of the following commands should be used to obtain information about the software packages available on the installation media?()A lsattrB inutocC installpD lsresource
单选题A customer is concerned about excessive media jamming in their device. Which of the following is the FIRST thing a technician should check?()AMedia feed rollersBCassette drawersCFusing sectionDDevice log data
单选题If a backup is expired, which of the following is true?()A It can never be used for a restore/recover operation.B Oracle will remove the backup set pieces from the flash recovery area.C The backup has been used at least once to restore and recover the database.D The backup is no longer valid because of a resetlogs operation.E The physical backup set pieces are missing from the media.
单选题While working on the database, you receive the following error: 01578: ORACLE data block corrupted (file# 6, block # 54) ORA-01110 : data file 6: ’u01/oracle/oradata/data1.dbf’ You decide to recover the corrupted data block by using the Block Media Recovery feature. Which option is NOT a disadvantage of using block media recovery?()A Block Media Recovery must be used with RMAN.B You must perform complete recovery of individual blocks.C You must have a full RMAN backup, not an incremental backup.D You must use the DBVERIFY utility before using the Block Media Recovery feature.
单选题If you find errors in the view V$DATABASE_BLOCK_CORRUPTION with a status of MEDIA_CORRUPT, what RMAN command would you run to correct the problem?()A recover lost blocksB recover corrupt blocksC recover media corrupt blocks from listD recover corrupt blocks from listE recover corruption list
单选题Which of the following is not an advantage of block media recovery (BMR)?()A Reduced MTTR.B Datafiles remain offline while corrupt blocks are repaired.C Datafiles remain online while corrupt blocks are repaired.D A and C
单选题When you are performing media recover, and an archived log is lost or corrupt, which type of recover must you perform?()AUntil SCNBUntil timeCUntil cancelDRecover using backup control file.