单选题In Recovery Manager (RMAN), you are taking image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task, you realize that one of the dat

题目
单选题
In Recovery Manager (RMAN), you are taking image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy. Because a media failure caused the data file to be damaged, you want to place the data file in a different location while resto ing the file.  Which option must you consider for this task?()
A

 using only the RMAN SWITCH command to set the new location for the data file

B

 placing the database in the MOUNT state for the restore and recovery operations

C

 using an RMAN RUN block with the SET NEWNAME and then the SWITCH command

D

 configuring two channels: one for the restore operation and the other for the recovery operation


相似考题
参考答案和解析
正确答案: A
解析: 暂无解析
更多“In Recovery Manager (RMAN), you are taking image copies of t”相关问题
  • 第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 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

  • 第3题:

    For an incomplete recovery, which four backup types can be used by Recovery Manager (RMAN) to restore data files?()

    • A、 RMAN image copies.
    • B、 RMAN database backups.
    • C、 RMAN tablespace backups.
    • D、 User-managed backups placed in the flash recovery area.
    • E、 User-managed backups that have been cataloged with RMAN.
    • F、 User-managed data file backups for which the pull path name is specified.

    正确答案:A,B,C,E

  • 第4题:

    单选题
    You want to create the Recovery Manager (RMAN) Virtual Private Catalog (VPC) to maintain a separation of responsibilities along with a consolidation of RMAN repository.  Which condition must be met before you create the VPC?()
    A

     A base catalog exists

    B

     The recovery catalog is empty

    C

     The base recovery catalog must be dropped

    D

     A target database is registered in the recovery catalog


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

  • 第5题:

    单选题
    The database is running in ARCHIVELOG mode and the FORMAT option is not configured in RMAN for disk backups. You configured the flash recovery area location and size by using the DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE initialization parameters. Which statement is correct in this scenario?()
    A

     If the FORMAT option to the RMAN BACKUP command is specified, then RMAN creates backup pieces and image copies in the flash recovery area with names in the Oracle Managed Files (OMF) format.

    B

     If any local destinations for LOG_ARCHIVE_DEST_n are set, then archived redo logs are stored in these destinations as well as in the flash recovery area.

    C

     If the flash recovery area location is configured using the DB_RECOVERY_FILE_DEST initialization parameter, then the RMAN backup of Oracle managed datafiles (OMF) only will go to the flash recovery area by default.

    D

     If no other destination is configured for recovery files, then RMAN places the control file autobackups in the flash recovery area by default.


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

  • 第6题:

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

  • 第7题:

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

  • 第8题:

    多选题
    Using the LIST command in Recovery Manager (RMAN), which two pieces of information in the RMANrepository can be listed?() (Choose two.)
    A

    stored scripts in the recovery catalog.

    B

    backups that can be deleted from disk.

    C

    backup sets and image copies are obsolete.

    D

    backups that do not have the AVAILABLE status in the RMAN repository.


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

  • 第9题:

    多选题
    Using the LIST command in Recovery Manager (RMAN), which two pieces of information from the RMANrepository can be listed?()
    A

    Stored scripts in the recovery catalog

    B

    Backups that can be deleted from disk

    C

    Backup sets and images copies that are obsolete

    D

    Backups that do not have the AVAILABLE status in the RMAN repository


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

  • 第10题:

    多选题
    Using the LIST command in Recovery Manager (RMAN), which two pieces of information from the RMAN repository can be listed?()
    A

    Stored scripts in the recovery catalog

    B

    Backups that can be deleted from disk

    C

    Backup sets and images copies that are obsolete

    D

    Backups that do not have the AVAILABLE status in the RMAN repository


    正确答案: C,A
    解析: 暂无解析

  • 第11题:

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

  • 第12题:

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

  • 第13题:

    You want to implement the backup and recovery strategy in your database using Recovery Manager (RMAN). You have chosen the control file of the target database for the RMAN repository.  Which command-line RMAN command would you use to establish a local connection between RMAN and the RMAN repository if your database is using password file authentication?()

    • A、 rman TARGET / NOCATALOG
    • B、 rman TARGET sys/password
    • C、 rman TARGET sys/password AS SYSDBA
    • D、 rman TARGET sys/password@db_name CATALOG rman_user/rman_password@rcat

    正确答案:B

  • 第14题:

    In Recovery Manager (RMAN), you are taking image copies of the datafiles of your production database and rolling them forward as regular intervals. You attempt to restart your database instance after a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the datafile by using the image copy. You could perform the following steps to accomplish this:   1) Mount the database  2) Take the data file offline  3) Bring the data file online  4) Use the RMAN SWITCH TO command to switch the image copy  5) Apply the archived redo logs  6) Open the database  7) Use the RMAN RESTORE TO command to switch to the image copy   Which two options illustrate the correct sequence of steps that you could follow?()

    • A、 2, 6, 4, 5, 3
    • B、 1, 2, 4, 5, 3, 6
    • C、 1, 2, 4, 6, 3
    • D、 1, 2, 7, 5, 3, 6

    正确答案:B,D

  • 第15题:

    You are using Recovery Manager (RMAN) to perform backups. In which three situations would you perform a compressed backup?()

    • A、You are backing up to tape and your tape device performs its own compression.
    • B、You are making image copies, and you have not enabled tablespace compression.
    • C、You are using disk-based backups and disk space in your Flash Recovery Area, or other disk-based backup destinations are limited.
    • D、You are performing your backups to some device over a network where reduced network bandwidth is more important than CPU usage.
    • E、You are using some archival backup media, such as CD or DVD, where reducing backup sizes saves  media costs and archival storage.

    正确答案:C,D,E

  • 第16题:

    多选题
    In Recovery Manager (RMAN), you are taking image copies of the datafiles of your production database and rolling them forward as regular intervals. You attempt to restart your database instance after a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the datafile by using the image copy. You could perform the following steps to accomplish this: 1) Mount the database 2) Take the data file offline 3) Bring the data file online 4) Use the RMAN SWITCH TO command to switch the image copy 5) Apply the archived redo logs 6) Open the database 7) Use the RMAN RESTORE TO command to switch to the image copy Which two options illustrate the correct sequence of steps that you could follow?() (Choose two.)
    A

    2, 6, 4, 5, 3

    B

    1, 2, 4, 5, 3, 6

    C

    1, 2, 4, 6, 3

    D

    1, 2, 7, 5, 3, 6


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

  • 第17题:

    多选题
    For an incomplete recovery, which four backup types can be used by Recovery Manager (RMAN) to restore data files?()
    A

    RMAN image copies.

    B

    RMAN database backups.

    C

    RMAN tablespace backups.

    D

    User-managed backups placed in the flash recovery area.

    E

    User-managed backups that have been cataloged with RMAN.

    F

    User-managed data file backups for which the pull path name is specified.


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

  • 第18题:

    多选题
    Using the LIST command in Recovery Manager (RMAN), which two pieces of information from the RMAN repository can be listed? ()
    A

    backups that can be deleted

    B

    stored scripts in the recovery catalog

    C

    backup sets and image copies that are obsolete

    D

    only the most recent backup sets or image copies

    E

    backups that do not have the AVAILABLE status in RMAN repository


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

  • 第19题:

    多选题
    Which two statements regarding compressed backups in Recovery Manager (RMAN) are true?()
    A

    Backup compression is disabled by default.

    B

    Backup compression can be used with both backup sets and image copies.

    C

    Backup compression cannot be enabled using the CONFIGURE command.

    D

    Backup compression works only if the COMPATIBILITY parameter is set to 9.0.0.0 or higher.

    E

    Backup compression applies to only backup sets.

    F

    Backup compression applies to only image copies.


    正确答案: A,F
    解析: 暂无解析

  • 第20题:

    单选题
    You want to create the Recovery Manager (RMAN) Virtual Private Catalog (VPC) to maintain a separation of responsibilities along with a consolidation of RMAN repository. Which condition must be met before you create the VPC?()
    A

    A base catalog exists

    B

    The recovery catalog is empty

    C

    The base recovery catalog must be dropped

    D

    A target database is registered in the recovery catalog


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

  • 第21题:

    多选题
    Using the LIST command in Recovery Manager (RMAN),which two pieces of information in the RMAN repository can be listed?()
    A

    stored scripts in the recovery catalog

    B

    backups that can be deleted from disk

    C

    backup sets and image copies are obsolete

    D

    backups that do not have the AVAILABLE status in the RMAN repository


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

  • 第22题:

    单选题
    In Recovery Manager (RMAN), you are taking image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy. Because a media failure caused the data file to be damaged, you want to place the data file in a different location while restoring the file. Which option must you consider for this task?()
    A

    using only the RMAN SWITCH command to set the new location for the data file

    B

    placing the database in the MOUNT state for the restore and recovery operations.

    C

    using an RMAN RUN block with the SET NEWNAME and then the SWITCH command.

    D

    configuring two channels: one for the restore operation and the other for the recovery operation


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

  • 第23题:

    多选题
    In Recovery Manager (RMAN), you are taking image copies of the datafiles of your production database and rolling them forward as regular intervals. You attempt to restart your database instance after a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the datafile by using the image copy. You could perform the following steps to accomplish this:   1) Mount the database  2) Take the data file offline  3) Bring the data file online  4) Use the RMAN SWITCH TO command to switch the image copy  5) Apply the archived redo logs  6) Open the database  7) Use the RMAN RESTORE TO command to switch to the image copy   Which two options illustrate the correct sequence of steps that you could follow?()
    A

    2, 6, 4, 5, 3

    B

    1, 2, 4, 5, 3, 6

    C

    1, 2, 4, 6, 3

    D

    1, 2, 7, 5, 3, 6


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