Which commands are used for RMAN database recovery？（）A、 restoreB、 repairC、 copyD、 recoverE、 replace

题目

Which commands are used for RMAN database recovery？（）

  • A、 restore
  • B、 repair
  • C、 copy
  • D、 recover
  • E、 replace
相似考题

1.WhichcommandsareusedforRMANdatabaserecovery?()A.restoreB.repairC.copyD.recoverE.replace

2.For an incomplete recovery， which four backup types can be used by Recovery Manager （RMAN） to restore data files？ （）A、RMAN image copiesB、RMAN database backupsC、RMAN tablespace backupsD、user­managed backups placed in the flash recovery areaE、user­managed backups that have been cataloged with RMANF、user­managed data file backups for which the full path name is specified

3.Which statement is true regarding RMAN components？（）A、Each target database requires its own recover catalog. B、RMAN scripts can be stored in the recovery catalog or the target control file. C、A channel is a stream of data to a device type and corresponds to one server session. D、The RMAN executable interprets sever session commands and establishes connections to the target database.

4. Which is the correct way to connect to both the target database and the recovery catalog from the RMAN command line？（） Assume that the target database is called ORCL and that the recovery catalog database is called RCAT. Also assume that the recovery-catalog owner is called RCAT_OWN. Assume the environment is configured for the ORCL database. A、 rman target=/ catalog=/@rcatB、 rman target=/ catalog=rcat_own/rcat_ownC、 rman target=/ catalog=rcat_own/rcat_own@RCATD、 rman target=sys/robert@orcl catalog=rcat_own/rcat_own@RCATE、 You cannot connect to the target database and the recovery catalog at the same time.

更多“Which commands are used for RMAN database recovery？（）A、 restoreB、 repairC、 copyD、 recoverE、 replace”相关问题

  • 第1题：

    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

  • 第2题：

    You have created a script in the recovery catalog called backup_database. Which of the following commands would successfully execute that script？（）  

    • A、 run { open script backup_database； run script backup_database }
    • B、 run { engage script backup_database； }
    • C、 run { run script backup_database； }
    • D、 Run { execute script backup_database； }
    • E、 The name backup_database is an invalid name for an RMAN script. Trying to run it from RMAN would result in an error.

    正确答案:D

  • 第3题：

    Which one of the following RMAN commands is used to register the database files with repository that were backed up using O/S commands？（）

    • A、CHANGE
    • B、CATALOG
    • C、CROSSCHECK
    • D、SWITCH

    正确答案:B

  • 第4题：

    You observe that the senior database administrator always uses the following command when connecting to Recovery Manager （RMAN）， and then starts executing commands to backup the database files：  $ rman target /  What would be the effect of this command？（）

    • A、RMAN would use the current operating system location to place the backup.
    • B、RMAN would use the control file of the target database to maintain the backup.
    • C、RMAN would use the recovery catalog of the target database to maintain the backup.
    • D、RMAN would use the control file of the target database to maintain the backup metadata. 
    • E、RMAN would use the recovery catalog of the target database to maintain the backup metadata.

    正确答案:D

  • 第5题：

    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

  • 第6题：

    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

  • 第7题：

    Which two RMAN commands initiate a resynchronization of the recovery catalog with the target database control file？（）

    • A、COPY
    • B、BACKUP
    • C、CHANGE
    • D、DELETE
    • E、CATALOG

    正确答案:A,B,D

  • 第8题：

    单选题
    You observe that the senior database administrator always uses the following command when connecting to Recovery Manager （RMAN）， and then starts executing commands to backup the database files： % rman target / What would be the effect of this command？（）
    A

     RMAN would use the current operating system location to place the backup.

    B

     RMAN would use the control file of the target database to maintain the backup.

    C

     RMAN would use the recovery catalog of the target database to maintain the backup.

    D

     RMAN would use the control file of the target database to maintain the backup metadata.

    E

     RMAN would use the recovery catalog of the target database to maintain the backup metadata.


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

  • 第9题：

    多选题
    Which commands are used for RMAN database recovery？（）
    A

    restore

    B

    repair

    C

    copy

    D

    recover

    E

    replace


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

  • 第10题：

    多选题
    Which two RMAN commands initiate a resynchronization of the recovery catalog with the target database control file？（）
    A

    COPY

    B

    BACKUP

    C

    CHANGE

    D

    DELETE

    E

    CATALOG


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

  • 第11题：

    多选题
    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 full path name is specified


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

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

  • 第14题：

    You are ready to implement RMAN in the backup and recover strategy for your company. Which system privilege must the RMAN user have to be able to connect and execute RMAN commands on a target database？（）

    • A、SYSDBA
    • B、SYSOPER
    • C、No system privileges are required for the RMAN user.
    • D、Only SYS user can connect and execute RMAN commands on a target database.

    正确答案:A

  • 第15题：

    To perform a database point-in-time recovery using RMAN， after database restoration， you must ensure that the database is in which of the following states？（）

    • A、OPEN
    • B、MOUNT
    • C、NOMOUNT
    • D、CLOSE

    正确答案:B

  • 第16题：

    Which two are characteristics of user-managed backup and recovery operations？（）

    • A、Recovery is initiated using SQL*Plus.
    • B、Database files are backed up using SQL commands.
    • C、Database files are backed up with Recovery Manager.
    • D、Database files are restored using Recovery Manager.
    • E、Database files are backed up using operating system commands.

    正确答案:A,B

  • 第17题：

    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

  • 第18题：

    You are performing a database recovery because a user’s schema is dropped. While performing the recovery， you use the UNTIL SEQUENCE clause. Which type of database recovery are you performing？（）

    • A、 user managed complete recovery
    • B、 user managed incomplete recovery
    • C、 RMAN-based complete recovery
    • D、 RMAN-based incomplete recovery

    正确答案:D

  • 第19题：

    单选题
    Which statement is true regarding RMAN components？（）
    A

    Each target database requires its own recover catalog. 

    B

    RMAN scripts can be stored in the recovery catalog or the target control file. 

    C

    A channel is a stream of data to a device type and corresponds to one server session. 

    D

    The RMAN executable interprets sever session commands and establishes connections to the target database.


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

  • 第20题：

    单选题
    You have created a script in the recovery catalog called backup_database. Which of the following commands would successfully execute that script？（）
    A

     run { open script backup_database； run script backup_database }

    B

     run { engage script backup_database； }

    C

     run { run script backup_database； }

    D

     Run { execute script backup_database； }

    E

     The name backup_database is an invalid name for an RMAN script. Trying to run it from RMAN would result in an error.


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

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

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

  • 第23题：

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

相关内容