网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
Which two activities are NOT supported by the Data Recovery Advisor （DRA）（）
A
Recover from failures in the RAC environment.
B
Diagnose and repair a data file corruption online.
C
Diagnose and repair a data file corruption offline.
D
Diagnose and repair failures on a standby database
参考答案
参考解析
解析：
暂无解析
更多 “多选题Which two activities are NOT supported by the Data Recovery Advisor （DRA）（）ARecover from failures in the RAC environment.BDiagnose and repair a data file corruption online.CDiagnose and repair a data file corruption offline.DDiagnose and repair failures on a standby database” 相关考题
考题
Examine the following RMAN script:Which statement describes the purpose of the script?()
A. The data file is checked for physical corruption and backed up if found clean.B. The backup of data file 5 is performed and the interactive messages during the backup are suppressed.C. The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup.D. The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed
考题
View the Exhibit to examine the error while executing the REPAIR FAILURE command in an RMAN session.What is the reason for this error?()
A. Another repair session is running concurrently.B. The failure ID has not been mentioned in the command for data file 5.C. There are new failures recorded in the Automatic Diagnostic Repository (ADR).D. The ADVISE FAILURE command has not been issued before the REPAIR FAILURE command.
考题
Which two activities are NOT supported by the Data Recovery Advisor?()
A. Diagnose and repair a data file corruption offline.B. Diagnose and repair a data file corruption online.C. Diagnose and repair failures on a standby database.D. Recover from failures in the Real Application Cluster (RAC) environment.
考题
Which two kinds of failures make the Data Recovery Advisor (DRA)generate a manual checklist? ()
A. failures because a data file is renamed by errorB. failures when no standby database is configuredC. failures that require no archive logs to be applied for recoveryD. failures due to loss of connectivity-for example, an unplugged disk cable
考题
View the Exhibit to examine the error during the database startup.You open an RMAN session for the database instance. To repair the failure, you executed the following as the first command in the RMAN session:RMAN REPAIR FAILURE;Which statement describes the consequence of the command?（）A. The command performs the recovery and closes the failures.B. The command only displays the advice and the RMAN script required for repair.C. The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command.D. The command executes the RMAN script to repair the failure and removes the entry from the Automatic Diagnostic Repository (ADR).
考题
Which kinds of failures make the Data Recovery Advisor （DRA） generate a manual checklist？（）A、Failure when no standby database is configuredB、Failure because a data file is renamed accidentallyC、Failure that requires no archive logs to be applied for recoveryD、Failure due to loss of connectivity-for example， an unplugged disk cable
考题
A data file became corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）A、flash back all the tables in the data file， one by oneB、restore the data file to a new location and perform a media recoveryC、flash back the database; there is no need to restore the data fileD、restore the data file from the most recent backup and flash back the database
考题
Which two activities are NOT supported by the Data Recovery Advisor?（）A、Diagnose and repair a data file corruption offline.B、Diagnose and repair a data file corruption online.C、Diagnose and repair failures on a standby database.D、Recover from failures in the Real Application Cluster (RAC) environment.
考题
Your database is open and running in ARCHIVELOG mode. You take RMAN full backups every Sunday night. On Monday morning， while querying the user1.employees table， you receive the following error message： 01578： ORACLE data block corrupted （file # 5， block # 51） ORA-01110： data file 5： ’/u01/app/oracle/oradata/orcl/example01.dbf’ You need to rectify the corruption while ensuring the following： The data file should remain online. The mean time to recover （MTTR） should be minimal. You are not using a backup control file， and all the archived logs are accessible. Which option would you choose？（）A、flash back the corrupted blocksB、use the DBMS_REPAIR packageC、use the RMAN TSPITR commandD、use the RMAN BLOCKRECOVER commandE、use the RESTORE DATABASE and RECOVER DATABASE commandsF、investigate the time at which the corruption occurred and perform a point-in-time recovery
考题
You work as a database administrator at Certkiller .com. Your database is open and running in ARCHIVELOGmode. You take RMANfull backups every Sunday night. On Monday morning， while querying the user1.employeestable， you receive the following error message： 01578： ORACLE data block corrupted （file # 5， block # 51） ORA-01110： data file 5：’/u01/app/oracle/oradata/orcl/example01.dbf’ You need to rectify the corruption while ensuring the following： The data file should remain online. The mean time to recover （MTTR） should be minimal. You are not using a backup control file and all the archived logs are accessible. Which option would you choose？（）A、 flash back the corrupted blocksB、 use the DBMS_REPAIR packageC、 use the RMAN TSPITR commandD、 use the RMAN BLOCKRECOVER commandE、 use the RESTORE DATABASE and RECOVER DATABASE commandsF、 investigate the time at which the corruption occurred and perform a point-in-time recovery
考题
Which two kinds of failures make the Data Recovery Advisor （DRA） generate a manual checklist（）A、failure when no standby database is configuredB、failure because a data file is renamed accidentallyC、failure that requires no archive logs to be applied for recoveryD、failure due to loss of connectivity-for example， an unplugged disk cable
考题
A data file become corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）A、 Flash back all the tables in the data file， one by one.B、 Restore the data file to a new location and perform a media recovery.C、 Flash back the database， there is no need to restore the data file.D、 Restore the data file from the most recent backup and flash the database.
考题
There was media failure and you need to check the data files for any block corruption. Which option would you use to create a report on any corruptions found within the database？（） A、the DBNEWID utilityB、the DBVERIFY utilityC、the ANALYZE commandD、the RMAN REPORT commandE、the RMAN CROSSCHECK commandF、the CHECK_OBJECT procedure of the DBMS_REPAIR package
考题
You issued the following command to analyze the SCOTT.EMP table for block corruption： ANALYZE TABLE SCOTT.EMP VALIDATE STRUCTURE； You received the following error： ORA-01578： ORACLE data block corrupted （file # %s， block # %s） How will you resolve the block corruption problem？（）A、 by using the DBMS_REPAIR packageB、 by using the DB_BLOCK_CHECKING parameterC、 by using the DBVERIFY utilityD、 will not be completely resolved until the hardware fault is corrected
考题
Which two kinds of failures make the Data Recovery Advisor (DRA)generate a manual checklist? （）A、failures because a data file is renamed by errorB、failures when no standby database is configuredC、failures that require no archive logs to be applied for recoveryD、failures due to loss of connectivity-for example, an unplugged disk cable
考题
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 two activities are NOT supported by the Data Recovery Advisor （DRA）（）A、Recover from failures in the RAC environment.B、Diagnose and repair a data file corruption online.C、Diagnose and repair a data file corruption offline.D、Diagnose and repair failures on a standby database
考题
多选题Which two kinds of failures make the Data Recovery Advisor （DRA） generate a manual checklist（）Afailure when no standby database is configuredBfailure because a data file is renamed accidentallyCfailure that requires no archive logs to be applied for recoveryDfailure due to loss of connectivity-for example， an unplugged disk cable
考题
单选题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
考题
单选题There was media failure and you need to check the data files for any block corruption. Which option would you use to create a report on any corruptions found within the database？（）A
the DBNEWID utilityB
the DBVERIFY utilityC
the ANALYZE commandD
the RMAN REPORT commandE
the RMAN CROSSCHECK commandF
the CHECK_OBJECT procedure of the DBMS_REPAIR package
考题
多选题Which kinds of failures make the Data Recovery Advisor （DRA） generate a manual checklist？（）AFailure when no standby database is configuredBFailure because a data file is renamed accidentallyCFailure that requires no archive logs to be applied for recoveryDFailure due to loss of connectivity-for example， an unplugged disk cable
考题
单选题Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning， media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday.What would you do in this situation？（）A
recover using Oracle Flashback Database technologyB
restore the data files from backup and perform a complete recoveryC
restore only the corrupted data file and perform tablespace recoveryD
restore the data files from backup and perform cancelbased recoveryE
restore the entire database from the most recent backup and start the instance and open the database
考题
多选题Which two activities are NOT supported by the Data Recovery Advisor?（）ADiagnose and repair a data file corruption offline.BDiagnose and repair a data file corruption online.CDiagnose and repair failures on a standby database.DRecover from failures in the Real Application Cluster (RAC) environment.
考题
单选题A data file become corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）A
Flash back all the tables in the data file， one by one.B
Restore the data file to a new location and perform a media recovery.C
Flash back the database， there is no need to restore the data file.D
Restore the data file from the most recent backup and flash the database.
考题
多选题You lost a data file that belongs to an index tablespace in your database， which operates in ARCHIVELOG mode. Loss of the data file resulted in increased response time on your queries. Which two options would you use to solve this problem？ （）ARestore the lost data file from the backup， and then flash back the database.BRestore the data file pertaining to index tablespace， and then recover the tablespace.CRestore all the data files， and then perform an incomplete recovery to get the tablespace back.DRestore all the data files， and then perform an incomplete recovery using the backup control file.EDrop and re-create the index tablespace， and then re-create all of the indexes in that tablespace.
考题
多选题Which two activities are NOT supported by the Data Recovery Advisor DRA（）ARecover from failures in the RAC environment.BDiagnose and repair a data file corruption online.CDiagnose and repair a data file corruption offline.DDiagnose and repair failures on a standby database
考题
单选题You issued the following command to analyze the SCOTT.EMP table for block corruption： ANALYZE TABLE SCOTT.EMP VALIDATE STRUCTURE； You received the following error： ORA-01578： ORACLE data block corrupted （file # %s， block # %s） How will you resolve the block corruption problem？（）A
by using the DBMS_REPAIR packageB
by using the DB_BLOCK_CHECKING parameterC
by using the DBVERIFY utilityD
will not be completely resolved until the hardware fault is corrected
考题
多选题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？（）ARECOVER FILE=1201 BLOCK=1968BRECOVER CORRUPTION LISTCRECOVER DATAFILE 1201 BLOCK 1968DRECOVER BLOCK CORRUPTION LISTENone of the above
热门标签
最新试卷