ORACLE 11g rac+单实例数据库构建dataguard(四)
database for standby;
Starting Duplicate Db at 12-AUG-13
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=19 device type=DISK
contents of Memory Script:
{
restore clone standby controlfile;
}
executing Memory Script
Starting restore at 12-AUG-13
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: copied control file copy
input file name=/home/oracle/control01.ctl
output file name=/u01/oradata/racdg/control01.ctl
Finished restore at 12-AUG-13
contents of Memory Script:
{
sql clone 'alter database mount standby database';
}
executing Memory Script
sql statement: alter database mount standby database
contents of Memory Script:
{
set newname for tempfile 1 to
"/u01/oradata/racdg/temp.262.818615321";
switch clone tempfile all;
set newname for datafile 1 to
"/u01/oradata/racdg/system.259.818615175";
set newname for datafile 2 to
"/u01/oradata/racdg/sysaux.260.818615237";
set newname for datafile 3 to
"/u01/oradata/racdg/undotbs1.261.818615291";
set newname for datafile 4 to
"/u01/oradata/racdg/undotbs2.263.818615365";
set newname for datafile 5 to
"/u01/oradata/racdg/users.264.818615419";
restore
clone database
;
}
executing Memory Script
executing command: SET NEWNAME
renamed tempfile 1 to /u01/oradata/racdg/temp.262.818615321 in control file
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 12-AUG-13
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00001 to/u01/oradata/racdg/system.259.818615175
channel ORA_AUX_DISK_1: restoring datafile 00002 to/u01/oradata/racdg/sysaux.260.818615237
channel ORA_AUX_DISK_1: restoring datafile 00003 to/u01/oradata/racdg/undotbs1.261.818615291
channel ORA_AUX_DISK_1: restoring datafile 00004 to/u01/oradata/racdg/undotbs2.263.818615365
channel ORA_AUX_DISK_1: restoring datafile 00005 to /u01/oradata/racdg/users.264.818615419
channel ORA_AUX_DISK_1: reading from backup piece /home/oracle/racfull_5_1
channel ORA_AUX_DISK_1: piece handle=/home/oracle/racfull_5_1tag=TAG20130812T200604
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:04:15
Finished restore at 12-AUG-13
contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script
datafile 1 switched to datafile copy
input datafile copy RECID=2 STAMP=823299518 file name=/u01/oradata/racdg/system.259.818615175
datafile 2 switched to datafile copy
input datafile copy RECID=3 STAMP=823299518 filename=/u01/oradata/racdg/sysaux.260.818615237
datafile 3 switched to datafile copy
input datafile copy RECID=4 STAMP=823299518 file name=/u01/oradata/racdg/undotbs1.261.818615291
datafile 4 switched to datafile copy
input datafil