多选题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 failure

题目
多选题
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

相似考题

1.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

2.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.

3.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

4.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 （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 failure”相关问题

  • 第1题：

    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).


    参考答案：C

  • 第2题：

    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 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 back the database

    正确答案:B

  • 第3题：

    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 blocks
    • B、use the DBMS_REPAIR package
    • C、use the RMAN TSPITR command
    • D、use the RMAN BLOCKRECOVER command
    • E、use the RESTORE DATABASE and RECOVER DATABASE commands
    • F、investigate the time at which the corruption occurred and perform a point-in-time recovery

    正确答案:D

  • 第4题：

    Which two kinds of failures make the Data Recovery Advisor （DRA） generate a manual checklist（）

    • A、failure when no standby database is configured
    • B、failure because a data file is renamed accidentally
    • C、failure that requires no archive logs to be applied for recovery
    • D、failure due to loss of connectivity-for example， an unplugged disk cable

    正确答案:B,D

  • 第5题：

    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 utility
    • B、the DBVERIFY utility
    • C、the ANALYZE command
    • D、the RMAN REPORT command
    • E、the RMAN CROSSCHECK command
    • F、the CHECK_OBJECT procedure of the DBMS_REPAIR package

    正确答案:B

  • 第6题：

    Which two kinds of failures make the Data Recovery Advisor (DRA)generate a manual checklist? （）

    • A、failures because a data file is renamed by error
    • B、failures when no standby database is configured
    • C、failures that require no archive logs to be applied for recovery
    • D、failures due to loss of connectivity-for example, an unplugged disk cable

    正确答案:A,D

  • 第7题：

    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

    正确答案:A,D

  • 第8题：

    单选题
    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 package

    B

     by using the DBVERIFY utility

    C

     by using Block Media Recovery

    D

     by issuing the ANALYZE TABLE HR.EMPLOYEES VALIDATE STRUCTURE command


    正确答案： C
    解析： 暂无解析

  • 第9题：

    多选题
    Which  kinds of failures make the Data Recovery Advisor （DRA） generate a manual checklist？（）
    A

    Failure when no standby database is configured

    B

    Failure because a data file is renamed accidentally

    C

    Failure that requires no archive logs to be applied for recovery

    D

    Failure due to loss of connectivity-for example， an unplugged disk cable


    正确答案： A,D
    解析： 暂无解析

  • 第10题：

    多选题
    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.


    正确答案： D,C
    解析： 暂无解析

  • 第11题：

    多选题
    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？ （）
    A

    Restore the lost data file from the backup， and then flash back the database.

    B

    Restore the data file pertaining to index tablespace， and then recover the tablespace.

    C

    Restore all the data files， and then perform an incomplete recovery to get the tablespace back.

    D

    Restore all the data files， and then perform an incomplete recovery using the backup control file.

    E

    Drop and re-create the index tablespace， and then re-create all of the indexes in that tablespace.


    正确答案： B,E
    解析： 暂无解析

  • 第12题：

    单选题
    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 package

    B

     by using the DB_BLOCK_CHECKING parameter

    C

     by using the DBVERIFY utility

    D

     will not be completely resolved until the hardware fault is corrected


    正确答案： D
    解析： 暂无解析

  • 第13题：

    Which  kinds of failures make the Data Recovery Advisor （DRA） generate a manual checklist？（）

    • A、Failure when no standby database is configured
    • B、Failure because a data file is renamed accidentally
    • C、Failure that requires no archive logs to be applied for recovery
    • D、Failure due to loss of connectivity-for example， an unplugged disk cable

    正确答案:B,D

  • 第14题：

    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.

    正确答案:C,D

  • 第15题：

    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 blocks
    • B、 use the DBMS_REPAIR package
    • C、 use the RMAN TSPITR command
    • D、 use the RMAN BLOCKRECOVER command
    • E、 use the RESTORE DATABASE and RECOVER DATABASE commands
    • F、 investigate the time at which the corruption occurred and perform a point-in-time recovery

    正确答案:D

  • 第16题：

    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.

    正确答案:B

  • 第17题：

    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 package
    • B、 by using the DB_BLOCK_CHECKING parameter
    • C、 by using the DBVERIFY utility
    • D、 will not be completely resolved until the hardware fault is corrected

    正确答案:D

  • 第18题：

    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 package
    • B、 by using the DBVERIFY utility
    • C、 by using Block Media Recovery
    • D、 by issuing the ANALYZE TABLE HR.EMPLOYEES VALIDATE STRUCTURE command

    正确答案:C

  • 第19题：

    多选题
    Which two kinds of failures make the Data Recovery Advisor （DRA） generate a manual checklist（）
    A

    failure when no standby database is configured

    B

    failure because a data file is renamed accidentally

    C

    failure that requires no archive logs to be applied for recovery

    D

    failure due to loss of connectivity-for example， an unplugged disk cable


    正确答案： D,A
    解析： 暂无解析

  • 第20题：

    单选题
    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 utility

    B

    the DBVERIFY utility

    C

    the ANALYZE command

    D

    the RMAN REPORT command

    E

    the RMAN CROSSCHECK command

    F

    the CHECK_OBJECT procedure of the DBMS_REPAIR package


    正确答案： B
    解析： 暂无解析

  • 第21题：

    单选题
    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 technology

    B

    restore the data files from backup and perform a complete recovery

    C

    restore only the corrupted data file and perform tablespace recovery

    D

    restore the data files from backup and perform cancel­based recovery

    E

    restore the entire database from the most recent backup and start the instance and open the database


    正确答案： B
    解析： 暂无解析

  • 第22题：

    单选题
    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.


    正确答案： A
    解析： 暂无解析

  • 第23题：

    多选题
    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


    正确答案： A,B
    解析： 暂无解析

  • 第24题：

    多选题
    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=1968

    B

    RECOVER CORRUPTION LIST

    C

    RECOVER DATAFILE 1201 BLOCK 1968

    D

    RECOVER BLOCK CORRUPTION LIST

    E

    None of the above


    正确答案： C,E
    解析： 暂无解析

相关内容