CMS专题

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

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

正确答案:A

第2题:

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

第3题:

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


参考答案:A, D

第4题:

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

第5题:

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

第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 full path name is specified

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

第7题:

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

第8题:

Using the LIST command in Recovery Manager (RMAN), which two pieces of information in the RMANrepository 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 RMAN


参考答案:A, D

第9题:

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

第10题:

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

更多相关问题