使用Active database duplicate建立dataguard(五)
clone 'alter database mount standby database';
}
executingMemory Script
sqlstatement: alter database mount standby database
contentsof Memory Script:
{
setnewname for tempfile 1 to
"/u01/oradata/tgg/temp01.dbf";
switchclone tempfile all;
setnewname for datafile 1 to
"/u01/oradata/tgg/system01.dbf";
setnewname for datafile 2 to
"/u01/oradata/tgg/sysaux01.dbf";
setnewname for datafile 3 to
"/u01/oradata/tgg/undotbs01.dbf";
setnewname for datafile 4 to
"/u01/oradata/tgg/users01.dbf";
backupas copy reuse
datafile 1 auxiliary format
"/u01/oradata/tgg/system01.dbf" datafile
2auxiliary format
"/u01/oradata/tgg/sysaux01.dbf" datafile
3auxiliary format
"/u01/oradata/tgg/undotbs01.dbf" datafile
4auxiliary format
"/u01/oradata/tgg/users01.dbf" ;
sql'alter system archive log current';
}
executingMemory Script
executingcommand: SET NEWNAME
renamedtempfile 1 to /u01/oradata/tgg/temp01.dbf in control file
executingcommand: SET NEWNAME
executingcommand: SET NEWNAME
executingcommand: SET NEWNAME
executingcommand: SET NEWNAME
Startingbackup at 28-OCT-13
channelprmy1: starting datafile copy
inputdatafile file number=00001 name=/u01/oradata/ogg/system01.dbf
channelprmy2: starting datafile copy
inputdatafile file number=00002 name=/u01/oradata/ogg/sysaux01.dbf
outputfile name=/u01/oradata/tgg/sysaux01.dbf tag=TAG20131028T163416
channelprmy2: datafile copy complete, elapsed time: 00:01:07
channelprmy2: starting datafile copy
inputdatafile file number=00003 name=/u01/oradata/ogg/undotbs01.dbf
outputfile name=/u01/oradata/tgg/system01.dbf tag=TAG20131028T163416
channelprmy1: datafile copy complete, elapsed time: 00:01:23
channelprmy1: starting datafile copy
inputdatafile file number=00004 name=/u01/oradata/ogg/users01.dbf
outputfile name=/u01/oradata/tgg/users01.dbf tag=TAG20131028T163416
channelprmy1: datafile copy complete, elapsed time: 00:00:16
outputfile name=/u01/oradata/tgg/undotbs01.dbf tag=TAG20131028T163416
channelprmy2: datafile copy complete, elapsed time: 00:00:32
Finishedbackup at 28-OCT-13
sqlstatement: alter system archive log current
contentsof Memory Script:
{
switchclone datafile all;
}
executingMemory Script
datafile1 switched to datafile copy
inputdatafile copy RECID=1 STAMP=830019088 filename=/u01/oradata/tgg/system01.dbf
datafile2 switched to datafile copy
inputdatafile copy RECID=2 STAMP=830019088 filename=/u01/oradata/tgg/sysaux01.dbf
datafile3 switched to datafile copy
inputdatafile copy RECID=3 STAMP=830019088 filename=/u01/oradata/tgg/undotbs01.dbf
datafile4 switched to datafile copy
inputdatafile copy RECID=4 STAMP=830019088 filename=/u01/oradata/tgg/users01.dbf
FinishedDuplicate Db at 28-OCT-13
releasedchannel: prmy1
releasedchannel: prmy2
releasedchannel: stby
至此已经完成
13.验证
[oracle@rac2dbs]$ sqlplus '/as sysdba'
SQL*Plus:Release 11.2.0.4.0 Production on Mon Oct 28 16:53:09 2013
Copyright(c) 1982, 2013, Oracle. All rights reserved.
Connectedto:
OracleDatabase 11g Enterprise Edition Release 11.2.0.4.0 - Production
Withthe Partitioning, OLAP, Data Mining and Real Application Testingoptions
SQL>
show parameter spfile
NAME TYPE VALUE
---------------------------------------