itgle.com

单选题You are using Recovery Manager （RMAN） with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure， you lost your production database comp

题目
单选题
You are using Recovery Manager （RMAN） with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure， you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional. You could consider performing the following steps to accomplish this task：   1） Restore an autobackup of the server parameter file.  2） Restore the control file.  3） Start the target database Instance.  4） Mount the database. 5） Restore the data files.  6） Open the database with the RESETLOGS option.  7） Recover the data files.  8） Set DBID for the target database   Which option illustrates the correct sequence that you must use？（）
A

 8， 1， 3， 2， 4， 5， 7， 6

B

 1， 8， 3， 4， 2， 5， 7， 6

C

 1， 3， 4， 2， 8， 5， 6， 7

D

 1， 3， 2， 4， 6， 5， 7， 8

相似考题

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

更多“You are using Recovery Manager （RMAN） with a recovery catalo”相关问题

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

    It is a holiday and no transactions are being performed on the database. You took a consistent backup of your database without using Recovery Manager （RMAN）. How would you make use of this consistent backup in RMAN？（）

    • A、cannot be used in RMAN
    • B、by starting up the database again
    • C、by using the CATALOG command of RMAN
    • D、by using the RECOVER CATALOG command in RMAN
    • E、by re-creating the target control file to rebuild the RMAN repository

    正确答案:C

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

    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

  • 第6题：

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

  • 第7题：

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

  • 第8题：

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

  • 第9题：

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

  • 第10题：

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


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

  • 第11题：

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

  • 第12题：

    单选题
    It is a holiday and no transactions are being performed on the database. You took a consistent backup of your database without using Recovery Manager （RMAN）. How would you make use of this consistent backup in RMAN？（）
    A

    cannot be used in RMAN

    B

    by starting up the database again

    C

    by using the CATALOG command of RMAN

    D

    by using the RECOVER CATALOG command in RMAN

    E

    by re-creating the target control file to rebuild 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 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题：

    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题：

    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

  • 第18题：

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

  • 第19题：

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


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

  • 第20题：

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

  • 第21题：

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

  • 第22题：

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

  • 第23题：

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

  • 第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
    解析： 暂无解析

相关内容