单选题You executed the following command in the Recovery Manager （RMAN）：   RMAN> REPORT NEED BACKUP days 3；   What is the output of this command？（）AA list of files that require a backup within 3 daysBA list of files requiring more than 3 days of archivelogs 

题目
单选题
You executed the following command in the Recovery Manager （RMAN）：   RMAN> REPORT NEED BACKUP days 3；   What is the output of this command？（）
A

 A list of files that require a backup within 3 days

B

 A list of files requiring more than 3 days of archivelogs to apply

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 as already been performed in the last three days and which is  required to be backed up again based on the high number of transactions performed on them

相似考题

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

2.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 daysB、 a list of files that have not been backed up for three daysC、 a list of files that RMAN recommends be backed up only once in every three days， based on low volatilityD、 a list of files for which a backup has already been performed and may need a backup after three days

3. You executed the following command in Recovery Manager （RMAN） to perform a backup of the DETTBS tablespace：  RMAN> BACKUP TABLESPACE DETTBS;  Under which conditions would this command execute successfully？ （）A、The database is in NOMOUNT state.B、The database is in ARCHIVELOG mode and the tablespace is online.C、The database is in ARCHIVELOG mode and the tablespace is offline.D、The database is in NOARCHIVELOG mode and the tablespace is online.E、The database is in NOARCHIVELOG mode and the tablespace is offline.

4. You executed the following command to perform a backup of the USERS tablespace：  SQL> ALTER TABLESPACE users BEGIN BACKUP； ALTER TABLESPACE users BEGIN BACKUP *  ERROR at line 1：  ORA-01123： cannot start online backup； media recovery not enabled  What could be the reason for this error（）A、The MTTR Advisor is disabled.B、The database is in NOARCHIVELOG mode.C、The tablespace is already in backup mode.D、The Flash Recovery Area is not configured.

参考答案和解析
正确答案： B
解析： 暂无解析
更多“You executed the following command in the Recovery Manager （”相关问题

  • 第1题：

    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

  • 第2题：

    You defined the Recovery Manager （RMAN） retention policy to recovery window of 7 days by executing the following command：  RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS；  When a backup is performed， what would be the status of this backup after seven days？（）

    • A、 The backup would be marked as invalid.
    • B、 The backup would be marked as obsolete.
    • C、 The backup would be removed from the media.
    • D、 The backup would be removed from the RMAN repository.

    正确答案:B

  • 第3题：

    You administer an Oracle Database 10g and a third-party database. You use Recovery Manager （RMAN） to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command？（）

    • A、 target database
    • B、 auxiliary database
    • C、 third-party database
    • D、 recovery catalog database

    正确答案:C

  • 第4题：

    You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario？（）

    • A、The backup status will be marked expired in RMAN recovery catalog.
    • B、The backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.
    • C、The backup will be deleted physically from the OS （Operating system）and the backup information is removed from the recovery catalogl
    • D、The backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）.
    • E、The backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）， if you are not using Oracle Managed Files （OMF）.

    正确答案:C

  • 第5题：

    单选题
    You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario？（）
    A

    The backup status will be marked expired in RMAN recovery catalog.

    B

    The backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.

    C

    The backup will be deleted physically from the OS （Operating system）and the backup information is removed from the recovery catalogl

    D

    The backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）.

    E

    The backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）， if you are not using Oracle Managed Files （OMF）.


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

  • 第6题：

    单选题
    You decided to change the location of the flash recovery area. You executed the following command： Which statement is true？（）
    A

    The location can be changed only if the flash recovery area is empty.

    B

    After executing the command， all new flash recovery area files will be created in the new location.

    C

    The command will generate an error because you cannot change the flash recovery area while the database is open.

    D

    All the existing files in the flash recovery area will be moved to the new location， and all new Flash Recovery Area files will be created in the new location.


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

  • 第7题：

    单选题
    You executed the following command in Recovery Manager （RMAN）：   RMAN> REPORT NEED BACKUP days 3；   What is the output of this command？（）
    A

     a list of files that require a backup within three days

    B

     a list of files requiring more than 3 days of archive logs to apply

    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 in the last three days and which is required to be backed up again based on the high number of transactions performed on them


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

  • 第8题：

    单选题
    You decided to change the location of the flash recovery area. You executed the following command：   ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’+disk1’ SCOPE=BOTH SID=’*’；   Which statement is true？（）
    A

     The location can be changed only if the flash recovery area is empty.

    B

     After executing the command， all new flash recovery area files will be created in the new location.

    C

     The command will generate an error because you cannot change the flash recovery area while the database is open.

    D

     All the existing files in the flash recovery area will be moved to the new location and all new Flash Recovery Area files will be created in the new location.


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

  • 第9题：

    单选题
    You disabled the Flashback Database feature by using the following command：  SQL> ALTER DATABASE FLASHBACK OFF；  What would be the effect of this command on the existing flashback logs？（）
    A

     Flashback logs are not deleted.

    B

     Flashback logs are deleted automatically.

    C

     Flashback logs are deleted only if you are using Recovery Manager （RMAN）

    D

     Flashback logs are deleted only if you are using Oracle Manager Files （OFM）

    E

     Flashback logs are deleted only if you are using Automatic Storage Management （ASM）


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

  • 第10题：

    多选题
    You executed the following command in Recovery Manager （RMAN） to perform a backup of the DETTBS tablespace：  RMAN> BACKUP TABLESPACE DETTBS；  Under which conditions would this command execute successfully？ （）
    A

    The database is in NOMOUNT state.

    B

    The database is in ARCHIVELOG mode and the tablespace is online.

    C

    The database is in ARCHIVELOG mode and the tablespace is offline.

    D

    The database is in NOARCHIVELOG mode and the tablespace is online.

    E

    The database is in NOARCHIVELOG mode and the tablespace is offline.


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

  • 第11题：

    单选题
    You disabled the Flashback Database feature by using the following command：  SQL> ALTER DATABASE FLASHBACK OFF;  What would be the effect of this command on the existing flashback logs？（）
    A

    Flashback logs are not deleted.

    B

    Flashback logs are deleted automatically.

    C

    Flashback logs are deleted only if you are using Recovery Manager （RMAN）.

    D

    Flashback logs are deleted only if you are using Oracle Managed Files （OMF）.

    E

    Flashback logs are deleted only if you are using Automatic Storage Management （ASM）.


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

  • 第12题：

    You decided to change the location of the flash recovery area. You executed the following command：   ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’+disk1’ SCOPE=BOTH SID=’*’；   Which statement is true？（）

    • A、 The location can be changed only if the flash recovery area is empty.
    • B、 After executing the command， all new flash recovery area files will be created in the new location.
    • C、 The command will generate an error because you cannot change the flash recovery area while the database is open.
    • D、 All the existing files in the flash recovery area will be moved to the new location and all new Flash Recovery Area files will be created in the new location.

    正确答案:B

  • 第13题：

    You disabled the Flashback Database feature by using the following command：  SQL> ALTER DATABASE FLASHBACK OFF；  What would be the effect of this command on the existing flashback logs？（）

    • A、 Flashback logs are not deleted.
    • B、 Flashback logs are deleted automatically.
    • C、 Flashback logs are deleted only if you are using Recovery Manager （RMAN）
    • D、 Flashback logs are deleted only if you are using Oracle Manager Files （OFM）
    • E、 Flashback logs are deleted only if you are using Automatic Storage Management （ASM）

    正确答案:B

  • 第14题：

    You used the following command in Recovery Manager （RMAN） as part of the recovery process： RESTORE CONTROLFILE FROM AUTOBACKUP;  How does RMAN find the control file autobackup？（）

    • A、by using the trace file
    • B、by using the alert log file
    • C、by using the database ID
    • D、by using the server parameter file
    • E、by using the V$CONTROLFILE view
    • F、by using the autobackup format configuration setting

    正确答案:C,F

  • 第15题：

    Which statement about using RMAN stored scripts is true?（）

    • A、To create and execute an RMAN stored script, you must use a recovery catalog.
    • B、When executing a stored script and a command fails, the remainder of the script is executed, and a message is written to the alert log file.
    • C、RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.
    • D、When you execute a stored script, it always executes using the persistent channel settings previously set with the CONFIGURE command.

    正确答案:A

  • 第16题：

    多选题
    In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog and restored the control file by using the following command：  RMAN> RESTORE CONTROLFILE；  Which two operations do you need to perform after restoring the control file from backup？（）
    A

    shut down and restart the instance

    B

    add new tempfiles to the temporary tablespaces after recovery

    C

    perform a media recovery and open the database with the RESETLOGS option

    D

    perform a media recovery and bring the database to NOARCHIVELOG mode


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

  • 第17题：

    单选题
    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
    解析： 暂无解析

  • 第18题：

    多选题
    You used the following command in Recovery Manager （RMAN） as part of the recovery process： RESTORE CONTROLFILE FROM AUTOBACKUP;  How does RMAN find the control file autobackup？（）
    A

    by using the trace file

    B

    by using the alert log file

    C

    by using the database ID

    D

    by using the server parameter file

    E

    by using the V$CONTROLFILE view

    F

    by using the autobackup format configuration setting


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

  • 第19题：

    单选题
    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
    解析： 暂无解析

  • 第20题：

    单选题
    Which statement about using RMAN stored scripts is true?（）
    A

    To create and execute an RMAN stored script, you must use a recovery catalog.

    B

    When executing a stored script and a command fails, the remainder of the script is executed, and a message is written to the alert log file.

    C

    RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.

    D

    When you execute a stored script, it always executes using the persistent channel settings previously set with the CONFIGURE command.


    正确答案： 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题：

    单选题
    You administer an Oracle Database 10g and a third-party database. You use Recovery Manager （RMAN） to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command？（）
    A

     target database

    B

     auxiliary database

    C

     third-party database

    D

     recovery catalog database


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

相关内容