1.Create an Oracle password file for the auxiliary instance. (optional)
2.Establish Oracle Net connectivity to the auxiliary instance. (optional)
3.Create an initialization parameter file for the auxiliary instance.

4.Start the auxiliary instance in NOMOUNT mode.
5.Mount or open the target database.
6.Ensure that backups and archived redo log files are available.

不论是备份还是归档,路径都要跟主库保持一致,且,主库最新生成的是归档 auxiliary 要能访问到。

7.Allocate auxiliary channels if needed. (optional)
8.Execute the DUPLICATE command. (rman sys/oracle@xxx auxiliary /)

run{
ALLOCATE CHANNEL pri1 DEVICE TYPE DISK;
ALLOCATE CHANNEL pri2 DEVICE TYPE DISK;
ALLOCATE AUXILIARY CHANNEL aux1 DEVICE TYPE DISK;
ALLOCATE AUXILIARY CHANNEL aux2 DEVICE TYPE DISK;
SET NEWNAME FOR DATABASE TO '/u01/app/oracle/oradata/ocm/%b';
duplicate target database to ocp
nofilenamecheck
logfile
group 1 ('/u01/app/oracle/oradata/ocp/redo01a.log','/u01/app/oracle/oradata/ocp/redo01b.log') SIZE 50M REUSE,
group 2 ('/u01/app/oracle/oradata/ocp/redo02a.log','/u01/app/oracle/oradata/ocp/redo02b.log') SIZE 50M REUSE,
group 3 ('/u01/app/oracle/oradata/ocp/redo03a.log','/u01/app/oracle/oradata/ocp/redo03b.log') SIZE 50M REUSE;
}
-- By 许望(RHCA、OCM、VCP)
最后修改:2020 年 02 月 27 日 03 : 51 PM
如果觉得我的文章对你有用,请随意赞赏