使用Active database duplicate建立dataguard(四)
;
sqlclone "alter system set log_archive_dest_1 =
''LOCATION=/u01/arch/tgg/VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=tgg'' comment=
''''scope=spfile";
sqlclone "alter system set db_unique_name =
''tgg''comment=
''''scope=spfile";
sqlclone "alter system set db_file_name_convert =
''/ogg/'',''/tgg/'' comment=
''''scope=spfile";
sqlclone "alter system set log_file_name_convert =
''/ogg/'',''/tgg/'' comment=
''''scope=spfile";
sqlclone "alter system set control_files =
''/u01/oradata/tgg/control01.ctl''comment=
''''scope=spfile";
sqlclone "alter system set log_archive_max_processes =
5comment=
''''scope=spfile";
sqlclone "alter system set fal_server =
''ogg''comment=
''''scope=spfile";
sqlclone "alter system set standby_file_management =
''AUTO''comment=
''''scope=spfile";
sqlclone "alter system set log_archive_config =
''dg_config=(ogg,tgg)''comment=
''''scope=spfile";
sqlclone "alter system set log_archive_dest_2 =
''service=oggASYNC valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=ogg''comment=
''''scope=spfile";
shutdownclone immediate;
startupclone nomount;
}
executingMemory Script
sqlstatement: alter system set audit_file_dest = ''/u01/oracle/admin/tgg/adump'' comment= '''' scope=spfile
sqlstatement: alter system set log_archive_dest_1 = ''LOCATION=/u01/arch/tgg/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES)DB_UNIQUE_NAME=ogg'' comment= '''' scope=spfile
sqlstatement: alter system set db_unique_name = ''tgg'' comment= ''''scope=spfile
sqlstatement: alter system set db_file_name_convert = ''/ogg/'',''/tgg/'' comment= '''' scope=spfile
sqlstate
ment: alter system set log_file_name_convert = ''/ogg/'',''/tgg/'' comment= '''' scope=spfile
sqlstatement: alter system set control_files = ''/u01/oradata/tgg/control01.ctl'' comment= '''' scope=spfile
sqlstatement: alter system set log_archive_max_processes = 5 comment='''' scope=spfile
sqlstatement: alter system set fal_client = ''tgg'' comment= ''''scope=spfile
sqlstatement: alter system set fal_server = ''ogg'' comment= ''''scope=spfile
sqlstatement: alter system set standby_file_management = ''AUTO''comment= '''' scope=spfile
sqlstatement: alter system set log_archive_config = ''dg_config=(ogg,tgg)'' comment= '''' scope=spfile
sqlstatement: alter system set log_archive_dest_2 = ''service=oggASYNC valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=ogg''comment= '''' scope=spfile
Oracleinstance shut down
connectedto auxiliary database (not started)
Oracleinstance started
TotalSystem Global Area 523108352 bytes
FixedSize 1365740 bytes
VariableSize 314575124 bytes
DatabaseBuffers 201326592 bytes
RedoBuffers 5840896 bytes
allocatedchannel: stby
channelstby: SID=18 device type=DISK
contentsof Memory Script:
{
backupas copy current controlfile for standby auxiliary format '/u01/oradata/tgg/control01.ctl';
}
executingMemory Script
Startingbackup at 28-OCT-13
channelprmy1: starting datafile copy
copyingstandby control file
outputfile name=/u01/oracle/product/11.2/db_1/dbs/snapcf_ogg.ftag=TAG20131028T163405 RECID=1 STAMP=830018047
channelprmy1: datafile copy complete, elapsed time: 00:00:03
Finishedbackup at 28-OCT-13
contentsof Memory Script:
{
sql