Oracle12c Data Guard搭建手册(六)
2013, Oracle and/or itsaffiliates. All rights reserved.
connected to target database: CNDBA(DBID=119362621)
connected to auxiliary database: CNDBA (notmounted)
RMAN>duplicatetarget database for standby from active database nofilenamecheck dorecover;
[ora12c@dave network-scripts]$ rman targetsys/oracle@cndba_p auxiliary sys/oracle@cndba_s;
Recovery Manager: Release 12.1.0.1.0 -Production on Wed Aug 6 20:41:02 2014
Copyright (c) 1982, 2013, Oracle and/or itsaffiliates. All rights reserved.
connected to target database: CNDBA(DBID=119362621)
connected to auxiliary database: CNDBA (notmounted)
RMAN> duplicate target database forstandby from active database nofilenamecheck dorecover;
Starting Duplicate Db at 06-AUG-14
using target database control file insteadof recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=21 devicetype=DISK
current log archived
contents of Memory Script:
{
backup as copy reuse
targetfile '/home/ora12c/app/oracle/product/12.1.0/db_1/dbs/orapwcndba' auxiliaryformat
'/home/ora12c/app/oracle/product/12.1.0/db_1/dbs/orapwcndba' ;
}
executing Memory Script
Starting backup at 06-AUG-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=48 device type=DISK
Finished backup at 06-AUG-14
contents of Memory Script:
{
sql clone "alter system set control_files =
''/home/ora12c/app/oracle/oradata/CNDBA/controlfile/o1_mf_9y3rqtn9_.ctl'',''/home/ora12c/app/oracle/fast_recovery_area/CNDBA/controlfile/o1_mf_9y3rqvky_.ctl''comment=
'
'Set by RMAN'' scope=spfile";
restore clone from service 'cndba_p' standby controlfile;
}
executing Memory Script
sql statement: alter system set control_files = ''/home/ora12c/app/oracle/oradata/CNDBA/controlfile/o1_mf_9y3rqtn9_.ctl'',''/home/ora12c/app/oracle/fast_recovery_area/CNDBA/controlfile/o1_mf_9y3rqvky_.ctl''comment= ''Set by RMAN'' scope=spfile
Starting restore at 06-AUG-14
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafilebackup set restore
channel ORA_AUX_DISK_1: using networkbackup set from service cndba_p
channel ORA_AUX_DISK_1: restoring controlfile
channel ORA_AUX_DISK_1: restore complete,elapsed time: 00:00:07
output file name=/home/ora12c/app/oracle/oradata/CNDBA/controlfile/o1_mf_9y3rqtn9_.ctl
output filename=/home/ora12c/app/oracle/fast_recovery_area/CNDBA/controlfile/o1_mf_9y3rqvky_.ctl
Finished restore at 06-AUG-14
contents of Memory Script:
{
sql clone 'alter database mount standby database';
}
executing Memory Script
sql statement: alter database mount standbydatabase
contents of Memory Script:
{
set newname for clone tempfile 1to new;
set newname for clone tempfile 2to new;
set newname for clone tempfile 3to new;
switchclone tempfile all;
set newname for clone datafile 1to new;
set newname for clone datafile 3to new;
set newname for clone datafile 4to new;
set newname for clone datafile 5to new;
set newname for clone datafile 6to new;
set newname for clone datafile 7to new;
set newname for clone datafile 8to new;
set newname for clone