OCP-1Z0-053-V12.02-497题

Riveore

墨衍会员 · AI 创作全网分发码龄19年

关注

原创最新推荐文章于 2023-07-26 18:18:56 发布 5.7k 阅读 AI 写同款· GEO 优化 ›

AI权益加码！Claude Code、Cursor等20+工具免费用！购周边限时加赠Coding Plan Lite，畅享主流AI工具！学习进阶更高效！阅读详情

497.You are managing the APPPROD database as a DBA. You plan to duplicate this database in the

same system with the name DUPDB. You issued the following RMAN commands to create a duplicate

database:

RMAN> CONNECT target sys/sys@APPPROD

RMAN> DUPLICATE TARGET DATABASE TO dupdb FROM ACTIVE DATABASE

DB_FILE_NAME_CONVERT '/oracle/oradata/prod/',

'/scratch/oracle/oradata/dupdb/' SPILE PARAMETER_VALUE_CONVERT

'/oracle/oradata/prod/', '/scratch/oracle/oradata/dupdb/' SET

SGA_MAX_SIZE = '300M' SET SGA_TARGET = '250M' SET LOG_FILE_NAME_CONVERT

'/oracle/oradata/prod/redo/',

'/scratch/oracle/oradata/dupdb/redo/';

Which three are the prerequisites for the successful execution of the above command? (Choose three.)

A. The source database should be open.

B. The target database should be in ARCHIVELOG mode if it is open.

C. RMAN should be connected to both the instances as SYSDBA.

D. The target database backups should be copied to the source database backup directories.

E. The password file must exist for the source database and have the same SYS user password as the target.

Answer: BCE

答案解析：

参考：http://blog.csdn.net/rlhua/article/details/13509067

官方参考：http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta020.htm#RCMRF90152

题问：以下哪三个前提条件才能使以上的命令成功？

A,源数据库应该为打开，错误，也可以是mount状态。

D,目标数据库的备份必须拷贝到源数据库目录。错误，上面的复制数据库语句是从活动的数据库来复制的，不需要备份。

Prerequisites Specific to Active Database Duplication

When you execute DUPLICATE with FROM ACTIVE DATABASE, at least one normal target channel and at least one AUXILIARY channel are required.

When you connect RMAN to the source database as TARGET, you must specify a password, even if RMAN uses operating system authentication. The source database must be mounted or open. If the source database is open, then archiving must be enabled. If the source database is not open, then it must have been shut down consistently.

When you connect RMAN to the auxiliary instance, you must provide a net service name. This requirement applies even if the auxiliary instance is on the local host.

The source database and auxiliary instances must use the same SYSDBA password, which means that both instances must have password files. You can create the password file with a single password so you can start the auxiliary instance and enable the source database to connect to it.

The DUPLICATE behavior for password files varies depending on whether your duplicate database acts as a standby database. If you create a duplicate database that is not a standby database, then RMAN does not copy the password file by default. You can specify the PASSWORD FILE option to indicate that RMAN should overwrite the existing password file on the auxiliary instance. If you create a standby database, then RMAN copies the password file to the standby host by default, overwriting the existing password file. In this case, the PASSWORD FILE clause is not necessary.

You cannot use the UNTIL clause when performing active database duplication. RMAN chooses a time based on when the online data files have been completely copied, so that the data files can be recovered to a consistent point in time.

收录于