单选题You executed the following commands in an RMAN session for your database instance that has failures: RMAN> LIST FAILURE; After some time, you executed the following command in the same session: RMAN> ADVISE FAILURE; But there are new failures recorded

题目
单选题
You executed the following commands in an RMAN session for your database instance that has failures: RMAN> LIST FAILURE; After some time, you executed the following command in the same session: RMAN> ADVISE FAILURE; But there are new failures recorded in the Automatic Diagnostic Repository (ADR) after the execution of the last LIST FAILURE command. Which statement is true for the above ADVISE FAILURE command in this scenario?（）
A

It produces a warning for new failures before advising for CRITICAL and HIGH failures.

B

It ignores new failures and considers the failures listed in the last LIST FAILURE command only.

C

It produces an error with recommendation to run the LIST FAILURE command before the ADVISE FAILURE command.

D

It produces advice only for new failures and the failures listed in the last LIST FAILURE command are ignored.

相似考题

1.Multiple RMAN sessions are connected to the database instance.Examine the following output when backup commands are running in server sessions:What could have helped you to correlate server sessions with channels?（）A. Implement RMAN multiplexingB. Set the DEBUG ON in the RMAN scriptC. Specify the command ID in the RMAN scriptD. Use a tag with the RMAN BACKUP command

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

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

4.Observe the following warning in an RMAN session of your database instance:WARNING: new failures were found since last LIST FAILURE commandWhich statement describes the scenario that must have produced this warning?（）A. The CHANGE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository(ADR)B. The VALIDATE DATABASE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR)C. The ADVISE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURED. The RECOVER command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURE command was executed

更多“单选题You executed the following commands in an RMAN session for your database instance that has failures: RMAN LIST FAILURE; After some time, you executed the following command in the same session: RMAN ADVISE FAILURE; But there are new failures recorded in”相关问题

  • 第1题：

    In Recovery Manager （RMAN）， you have set control file autobackup to ON by using the following command：  CONFIGURE CONTROLFILE AUTOBACKUP ON;  Which two events would cause the control file to be backed up automatically？ （）

    • A、a tablespace is taken offline
    • B、the database instance is restarted
    • C、a new data file is added to an existing tablespace
    • D、a successful backup is recorded in the RMAN repository
    • E、the RMAN connection is disconnected from the target database

    正确答案:C,D

  • 第2题：

    You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.  You want the RMAN to import metadata for database IDs 1423241 and 1423242， registered in RCAT10， into the recovery catalog owned by RCO11. You also want to deregister them from the catalog after import. You executed the following commands to achieve this：   RMAN> CONNECT CATALOG rco11/password@catdb  RMAN> IMPORT CATALOG rcat10/oracle@inst1 DBID=1423241，1423242；   What happens if the RCO11 catalog has scripts with the same name as that of the scripts in RCAT10 catalog？（）

    • A、 The scripts in the RCO11 catalog are overwritten.
    • B、 RMAN renames the local stored scripts in the RCO11 catalog.
    • C、 The RMAN session in which the command is executed aborts.
    • D、 RMAN renames the global scripts that are imported from the RCAT10 catalog.

    正确答案:D

  • 第3题：

    Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt：     RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF；   RMAN> BACKUP DATABASE；   Which files from the database will be backed up as a result of this BACKUP command？（）

    • A、 control file
    • B、 all datafiles
    • C、 password file
    • D、 online redo log file
    • E、 archive redo log file
    • F、 server parameter file
    • G、 only the SYSTEM datafile

    正确答案:A,B,F

  • 第4题：

    You executed the following commands in an RMAN session for your database instance that has failures：  RMAN> LIST FAILURE；  After some time， you executed the following command in the same session： RMAN> ADVISE FAILURE；  But there are new failures recorded in the Automatic Diagnostic Repository （ADR） after the execution ofthe last LIST FAILURE command.  Which statement is true for the above ADVISE FAILURE command in this scenario（）

    • A、It produces a warning for new failures before advising for CRITICAL and HIGH failures.
    • B、It ignores new failures and considers the failures listed in the last LIST FAILURE command only.
    • C、It produces advice only for new failures and the failures listed in the last LIST FAILURE command are ignored
    • D、It produces an error with recommendation to run the LIST FAILURE command before the ADVISE FAILURE command.

    正确答案:A

  • 第5题：

    You executed the following command in Recovery Manager （RMAN） against your Oracle 10g database：  RMAN> REPORT NEED BACKUP days 3;  What would be the output of this command？（） 

    • A、a list of files that require a backup within three days
    • B、a list of files that have not been backed up for three days
    • C、a list of files that RMAN recommends be backed up only once in every three days， based on low volatility
    • D、a list of files for which a backup has already been performed and may need a backup after three days

    正确答案:B

  • 第6题：

    Observe the following warning in an RMAN session of your database instance: WARNING: new failures were found since last LIST FAILURE command Which statement describes the scenario that must have produced this warning?（）

    • A、The CHANGE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository(ADR)
    • B、The VALIDATE DATABASE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR)
    • C、The ADVISE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURE
    • D、The RECOVER command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURE command was executed

    正确答案:C

  • 第7题：

    单选题
    You executed the following command in Recovery Manager （RMAN） against your Oracle 10g database：  RMAN> REPORT NEED BACKUP days 3;  What would be the output of this command？（）
    A

    a list of files that require a backup within three days

    B

    a list of files that have not been backed up for three days

    C

    a list of files that RMAN recommends be backed up only once in every three days， based on low volatility

    D

    a list of files for which a backup has already been performed and may need a backup after three days


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

  • 第8题：

    多选题
    Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt：   RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；   After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）
    A

    when you change the name of a datafile

    B

    when you drop a table from the database

    C

    when you take an export of the database

    D

    when you back up the database using OS utilities

    E

    when you issue an ALTER SYSTEM SWITCH LOGFILE statement

    F

    when you issue a BACKUP command from inside the RMAN run block


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

  • 第9题：

    单选题
    You executed the following commands in an RMAN session for your database instance that has failures: RMAN> LIST FAILURE; After some time, you executed the following command in the same session: RMAN> ADVISE FAILURE; But there are new failures recorded in the Automatic Diagnostic Repository (ADR) after the execution of the last LIST FAILURE command. Which statement is true for the above ADVISE FAILURE command in this scenario?（）
    A

    It produces a warning for new failures before advising for CRITICAL and HIGH failures.

    B

    It ignores new failures and considers the failures listed in the last LIST FAILURE command only.

    C

    It produces an error with recommendation to run the LIST FAILURE command before the ADVISE FAILURE command.

    D

    It produces advice only for new failures and the failures listed in the last LIST FAILURE command are ignored.


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

  • 第10题：

    单选题
    Observe the following warning in an RMAN session of your database instance: WARNING: new failures were found since last LIST FAILURE command Which statement describes the scenario that must have produced this warning?（）
    A

    The CHANGE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository(ADR)

    B

    The VALIDATE DATABASE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR)

    C

    The ADVISE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURE

    D

    The RECOVER command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURE command was executed


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

  • 第11题：

    单选题
    Your database is in ARCHIVELOG mode. On Friday evening， you perform an online database backup by using the BACKUP DATABASE command at the Recovery Manager （RMAN） prompt and close the  database. On Monday， the System Administrator informs you about the failure of two hard disks. One of the lost disks contains two datafiles， HR1.DBF and HR2.DBF， both of which belong to a read/write tablespace named HR. The disk also contains a datafile， USERS.DBF， which belongs to a read/write tablespace named USERS. You need to restore and recover the database backup that was performed on Friday evening. After mounting the database， you issue the following RMAN commands：        RMAN>RESTORE DATABASE；        RMAN>RECOVER DATABASE；   After successfully executing these RMAN commands， you issue the following statement using SQL*Plus：        SQL>ALTER DATABASE OPEN；   You receive the following errors when attempting to open the database：        ORA-01157： cannot identify/lock data file 10 see DBWR trace file        ORA-01110： data file 10： ’D:///USERS.DBF’   What is the cause of these errors？（）
    A

     The USERS.DBF datafile is corrupted and cannot be restored by RMAN.

    B

     The USERS.DBF datafile was not backed up using the RMAN BACKUP DATABASE command.

    C

     The USERS.DBF datafile was not restored using the RMAN RESTORE DATABASE command.

    D

     The USERS.DBF datafile was not recovered using the RMAN RECOVER DATABASE command.


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

  • 第12题：

    单选题
    The backup retention policy is configured as RECOVERY WINDOW 2. You executed the following command in Recovery Manager （RMAN） against your database： RMAN> REPORT OBSOLETE； What would you see in the output？（）
    A

     a list of all those files that have been deleted in the last two days

    B

     a list of all those files that have been recovered within the last two days

    C

     a list of all the expired backups and copies

    D

     a list of backups and copies that are outside the range covered by the current retention policy


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

  • 第13题：

    You want to perform in incomplete recovery of your database.  You plan to use these commands to recover your database：  SET UNTIL TIME = ’2000-12-09：11：44：00’；  RESTORE DATABASE； RECOVER DATABASE；  How should the commands be executed？ （）

    • A、Only the SET command must be within a RUN block.
    • B、All commands should be executed at the RMAN prompt.
    • C、All three commands must be within a single RUN block.
    • D、Only the RESTORE and RECOVER commands must be within a single RUN block.

    正确答案:C

  • 第14题：

    The backup retention policy is configured as RECOVERY WINDOW 2. You executed the following command in Recovery Manager （RMAN） against your database： RMAN> REPORT OBSOLETE； What would you see in the output？（）

    • A、 a list of all those files that have been deleted in the last two days
    • B、 a list of all those files that have been recovered within the last two days
    • C、 a list of all the expired backups and copies
    • D、 a list of backups and copies that are outside the range covered by the current retention policy

    正确答案:D

  • 第15题：

    You executed the following command in Recovery Manager （RMAN）：  RMAN> RESTORE CONTROLFILE；  Which operation must you perform before this command is executed？（） 

    • A、back up the control file to trace
    • B、bring database to the MOUNT state
    • C、open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target database
    • D、set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog

    正确答案:C

  • 第16题：

    Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt：   RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；   After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）

    • A、 when you change the name of a datafile
    • B、 when you drop a table from the database
    • C、 when you take an export of the database
    • D、 when you back up the database using OS utilities
    • E、 when you issue an ALTER SYSTEM SWITCH LOGFILE statement
    • F、 when you issue a BACKUP command from inside the RMAN run block

    正确答案:A,E,F

  • 第17题：

    Your database is in ARCHIVELOG mode. On Friday evening， you perform an online database backup by using the BACKUP DATABASE command at the Recovery Manager （RMAN） prompt and close the  database. On Monday， the System Administrator informs you about the failure of two hard disks. One of the lost disks contains two datafiles， HR1.DBF and HR2.DBF， both of which belong to a read/write tablespace named HR. The disk also contains a datafile， USERS.DBF， which belongs to a read/write tablespace named USERS. You need to restore and recover the database backup that was performed on Friday evening. After mounting the database， you issue the following RMAN commands：        RMAN>RESTORE DATABASE；        RMAN>RECOVER DATABASE；   After successfully executing these RMAN commands， you issue the following statement using SQL*Plus：        SQL>ALTER DATABASE OPEN；   You receive the following errors when attempting to open the database：        ORA-01157： cannot identify/lock data file 10 see DBWR trace file        ORA-01110： data file 10： ’D:///USERS.DBF’   What is the cause of these errors？（）

    • A、 The USERS.DBF datafile is corrupted and cannot be restored by RMAN.
    • B、 The USERS.DBF datafile was not backed up using the RMAN BACKUP DATABASE command.
    • C、 The USERS.DBF datafile was not restored using the RMAN RESTORE DATABASE command.
    • D、 The USERS.DBF datafile was not recovered using the RMAN RECOVER DATABASE command.

    正确答案:C

  • 第18题：

    Observe the following warning in an RMAN session of your database instance：   WARNING:// new failures were found since last LIST FAILURE command   Which statement describes the scenario that must have produced this warning？（）

    • A、 The CHANGE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository（ADR）
    • B、 The VALIDATE DATABASE command has detected new failures recorded in the Automatic Diagnostic Repository （ADR）
    • C、 The ADVISE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository （ADR） since the last LIST FAILURE
    • D、 The RECOVER command has detected new failures recorded in the Automatic Diagnostic Repository （ADR） since the last LIST FAILURE command was executed

    正确答案:C

  • 第19题：

    单选题
    You want to perform in incomplete recovery of your database.  You plan to use these commands to recover your database：  SET UNTIL TIME = ’2000-12-09：11：44：00’；  RESTORE DATABASE； RECOVER DATABASE；  How should the commands be executed？ （）
    A

    Only the SET command must be within a RUN block.

    B

    All commands should be executed at the RMAN prompt.

    C

    All three commands must be within a single RUN block.

    D

    Only the RESTORE and RECOVER commands must be within a single RUN block.


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

  • 第20题：

    单选题
    You executed the following command in Recovery Manager （RMAN）： RMAN> RESTORE CONTROLFILE; Which operation must you perform before this command is executed？（）
    A

    back up the control file to trace

    B

    bring database to the MOUNT state

    C

    open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target database

    D

    set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog


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

  • 第21题：

    单选题
    You executed the following command in Recovery Manager （RMAN）：  RMAN> RESTORE CONTROLFILE；  Which operation must you perform before this command is executed？（）
    A

     back up the control file to trace

    B

     bring database to the MOUNT state

    C

     open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target database

    D

     set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog


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

  • 第22题：

    单选题
    Observe the following warning in an RMAN session of your database instance：   WARNING:// new failures were found since last LIST FAILURE command   Which statement describes the scenario that must have produced this warning？（）
    A

     The CHANGE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository（ADR）

    B

     The VALIDATE DATABASE command has detected new failures recorded in the Automatic Diagnostic Repository （ADR）

    C

     The ADVISE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository （ADR） since the last LIST FAILURE

    D

     The RECOVER command has detected new failures recorded in the Automatic Diagnostic Repository （ADR） since the last LIST FAILURE command was executed


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

  • 第23题：

    多选题
    Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt：     RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF；   RMAN> BACKUP DATABASE；   Which files from the database will be backed up as a result of this BACKUP command？（）
    A

    control file

    B

    all datafiles

    C

    password file

    D

    online redo log file

    E

    archive redo log file

    F

    server parameter file

    G

    only the SYSTEM datafile


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

  • 第24题：

    单选题
    You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.  You want the RMAN to import metadata for database IDs 1423241 and 1423242， registered in RCAT10， into the recovery catalog owned by RCO11. You also want to deregister them from the catalog after import. You executed the following commands to achieve this：   RMAN> CONNECT CATALOG rco11/password@catdb  RMAN> IMPORT CATALOG rcat10/oracle@inst1 DBID=1423241，1423242；   What happens if the RCO11 catalog has scripts with the same name as that of the scripts in RCAT10 catalog？（）
    A

     The scripts in the RCO11 catalog are overwritten.

    B

     RMAN renames the local stored scripts in the RCO11 catalog.

    C

     The RMAN session in which the command is executed aborts.

    D

     RMAN renames the global scripts that are imported from the RCAT10 catalog.


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

相关内容