OCP-1Z0-053-V12.02-683题(一)

683. Your production database it f unctional on the SHOST1 host. Y ou are backing up the production

database by using Recovery Manager (RMAN) with the recovery catalog. You want to replicate the

production database to anther host , SHOST2, for testing new applications.

After you ensured that the backups of the target database are accessible on the new host, what must you

do to restore and recover the backup for the test environment

A.Restoring the control file from the backup by using the NOCATAL OG option to restore, and recovering the data files

B.Restoring the data files by us ing the NOCATALOG option and us ing the SET NEWNAME command to change the location

C.Restoring the server parameter file from the backup by using the recovery catalog to restore, and recovering the data files

D.Restoring the data files from the backup by using the recovery catalog to recover the files, and using the SWITCH command to change the location.

Answer: D

答案解析：

参考：http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmadvre.htm#BRADV370

正确答案选A

你的生产库在SHOST1，你使用rman的恢复目录来备份生产库。你想复制生产库到另一台主机上SHOST2作为测试用

之后你确定在新的主机上你的目标数据库的备份能够被访问，什么是你必须要在测试环境还原和恢复的？

Start RMAN on hostb and connect to the target database without connecting to the recovery catalog. C错D错

If the file systems on the destination system are set up to have the same paths as the source host, then do not use SET NEWNAME for those files restored to the same path as on the source host. B错误

Testing the Restore of a Database on a New Host

This scenario assumes that you want to test whether you can restore your database to a new host. In this scenario, you have two networked Linux hosts,hosta and hostb. A target database named trgta is on hosta and is registered in recovery catalog catdb. You want to test the restore and recovery of trgta onhostb, while keeping database trgta up and running on hosta.

Now, assume that the directory structure of hostb is different from hosta. The target database is located in /net/hosta/dev3/oracle/dbs, but you want to restore the database to /net/hostb/oracle/oradata/test. You have tape backups of data files, control files, archived redo logs, and the server parameter file on a media manager accessible by both hosts. The ORACLE_SID for the trgta database is trgta and does not change for the restored database.

Caution:

To restore the database on a new host:

Ensure that the backups of the target database are accessible on the new host.

To test disaster recovery, you must have a recoverable backup of the target database. When preparing your disaster recovery strategy, ensure that the backups of the data files, control files, and server parameter file are restorable on hostb. Thus, you must configure the media management software so that hostb is a media manager client and can read the backup sets created on hosta. Consult the media management vendor for support on this issue.

1. Configure the ORACLE_SID on hostb.

   This scenario assumes that you want to start the RMAN client on hostb and authenticate yourself through the operating system. However, you must be connected to hostb either locally or through a net service name.

   After logging in to hostb with administrator privileges, edit the /etc/group file so that you are included in the DBA group:

   dba:*:614:

   Set the ORACLE_SID environment variable on hostb to the same value used on hosta:

   % setenv ORACLE_SID trgta

   Start RMAN on hostb and connect to t