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

题目

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 d ata 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
相似考题

1.Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager (RMAN)?()A. You can use RMAN stored scriptsB. Recovery is faster if data is stored in catalog in addition to the control fileC. You can store backup information of all registered databases in one placeD. Database backups are automatically deleted when they are older than the specified time period

2.You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN).Which two are the prerequisites to perform this operation? ()(Choose two)A. You must configure block change tracking fileB. You must have first level 1 backups for RMAN to restore blocksC. You must ensure that the SALES database is mounted or openD. You must have full or level 0 backups for RMAN to restore blocksE. You must take the tools01.dbf data file offline before you start a block media recovery

3.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 existsB、The recovery catalog is emptyC、The base recovery catalog must be droppedD、A target database is registered in the recovery catalog

4.You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN).Which two are the prerequisites to perform this operation?()A. You must configure block change tracking fileB. You must have first level 1 backups for RMAN to restore blocksC. You must ensure that the SALES database is mounted or openD. You must have full or level 0 backups for RMAN to restore blocksE. You must take the tools01.dbf data file offline before you start a block media recovery

参考答案和解析
正确答案:C
更多“In Recovery Manager (RMAN), you”相关问题

  • 第1题：

    Identity two advantages of using a recovery catalog in-load of the control File of the target database Recovery Manager （RMAN）.（）

    • A、 You can use RMAN stored scripts.
    • B、 Recovery is faster if data is stored in catalog in addition to the control file.
    • C、 You can store backup Information of all registered databases in one place.
    • D、 Database backups are automatically deleted when they are older than the specified time period.

    正确答案:A,C

  • 第2题：

    You are connected to Recovery Manager （RMAN） without a recovery catalog. There is no copy of the control file available. You want to restore the control file from an autobackup. To retrieve the autobackup，you need the database ID （DBID）.  In which two sources would you find the DBID？ （）

    • A、the trace file
    • B、the alert log file
    • C、an RMAN session log file
    • D、the server parameter file
    • E、the formatted name of a control file autobackup

    正确答案:C,E

  • 第3题：

    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

  • 第4题：

    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

  • 第5题：

    Your database is configured on non-ASM disk storage. You need to migrate your database to ASM disk storage.  Which statement is true about migrating from non-ASM disk storage to ASM disk storage？（） 

    • A、 You can use the operating system utility to migrate from non-ASM disk storage to ASM disk storage.
    • B、 You cannot perform a database backup from non-ASM disk storage to tape and then move it to ASM disk storage.
    • C、 You can use the SWITCH DATABASE TO COPY Recovery Manager （RMAN） command to switch back to non-ASM disk storage if you have not deleted your original datafiles.
    • D、 You cannot use Recovery Manager （RMAN） to migrate from non-ASM disk storage to ASM disk storage if you are not using RMAN for your backup and recovery strategies.

    正确答案:C

  • 第6题：

    You are using the backup scheduler in Enterprise Manager （EM） to schedule a backup of your database. Which type of script does the backup scheduler generate？（）

    • A、SQL script
    • B、PL/SQL script
    • C、Operating System （OS） script
    • D、Enterprise Manager （EM） script
    • E、Recovery Manager （RMAN） script

    正确答案:E

  • 第7题：

    多选题
    On which three can you use Recovery Manager （RMAN） to perform incremental backup？（）
    A

    data files

    B

    control files

    C

    tablespaces

    D

    password file

    E

    parameter file

    F

    whole database

    G

    flashback log file

    H

    archived log files

    I

    change tracking file


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

  • 第8题：

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

  • 第9题：

    单选题
    Which options must you configure while performing an automated Tablespace Point-in-Time Recovery (TSPITR) by using Recovery Manager (RMAN)?（）
    A

    New channels for restore and recovery tasks

    B

    New name for the data files of the tablespace

    C

    Auxiliary name for the data files of the tablespace

    D

    Auxiliary destinations for an auxiliary set of data files


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

  • 第10题：

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

  • 第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 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.


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

  • 第13题：

    You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN). Which two are the prerequisites to perform this operation? （）(Choose two)

    • A、You must configure block change tracking file
    • B、You must have first level 1 backups for RMAN to restore blocks
    • C、You must ensure that the SALES database is mounted or open
    • D、You must have full or level 0 backups for RMAN to restore blocks
    • E、You must take the tools01.dbf data file offline before you start a block media recovery

    正确答案:C,D

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    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

  • 第17题：

    Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager （RMAN）.（）

    • A、 You can use RMAN stored scripts
    • B、 Recovery is faster if data is stored in catalog in addition to the control file
    • C、 You can store backup information of all registered databases in one place
    • D、 Database backups are automatically deleted when they are older than the specified time period

    正确答案:A,C

  • 第18题：

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

  • 第19题：

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

  • 第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


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

  • 第21题：

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


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

  • 第22题：

    多选题
    You are connected to Recovery Manager （RMAN） without a recovery catalog. There is no copy of the control file available. You want to restore the control file from an autobackup. To retrieve the autobackup，you need the database ID （DBID）.  In which two sources would you find the DBID？ （）
    A

    the trace file

    B

    the alert log file

    C

    an RMAN session log file

    D

    the server parameter file

    E

    the formatted name of a control file autobackup


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

  • 第23题：

    单选题
    You set the recovery window to seven days and the backup optimization to ON using the CONFIGURE command of Recovery Manager （RMAN）. The most recent backup of the TOOLStablespace to disk was taken on January 3. The TOOLStablespace is read-only.On February 21， when you execute a command to back up all the tablespaces to disk， you find that RMAN backs up the TOOLS tablespace also， even though the contents of the tablespace have not changed after the backup on January 3. Because there are no changes made to the TOOLStablespace， you decide that the tablespace should not be backed up by RMAN. What can you do to skip backing up the TOOLStablespace without changing the current backup optimization setting？（）
    A

     configure a default device for RMAN backups

    B

     temporarily disable the retention policy for RMAN backups

    C

     configure automatic channel allocation for RMAN backups

    D

     use the CONFIGURE command to reconfigure the recovery window to 60 days


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

  • 第24题：

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

相关内容