使用Active database duplicate建立dataguard(二)
arameter_value_convert'ogg','tgg'
setdb_unique_name='tgg'
setdb_file_name_convert='/ogg/','/tgg/'
setlog_file_name_convert='/ogg/','/tgg/'
setcontrol_files='/u01/oradata/tgg/control01.ctl'
setlog_archive_max_processes='5'
setfal_server='ogg'
setstandby_file_management='AUTO'
setlog_archive_config='dg_config=(ogg,tgg)'
setlog_archive_dest_1 = 'LOCATION=/u01/arch/tgg/VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=tgg'
setlog_archive_dest_2='service=ogg ASYNCvalid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=ogg';
}
命令和输出
[oracle@rac2dbs]$ sqlplus '/as sysdba'
SQL*Plus:Release 11.2.0.4.0 Production on Mon Oct 28 16:48:39 2013
Copyright(c) 1982, 2013, Oracle. All rights reserved.
Connectedto an idle instance.
SQL>startup nomount pfile=$ORACLE_HOME/dbs/initcc.ora
ORACLEinstance started.
TotalSystem Global Area 150654976 bytes
FixedSize 1363216 bytes
VariableSize 96469744 bytes
DatabaseBuffers 50331648 bytes
RedoBuffers 2490368 bytes
SQL>exit
Disconnectedfrom Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 -Production
Withthe Partitioning, OLAP, Data Mining and Real Application Testingoptions
[oracle@rac2dbs]$ rman target sys/oracle@ogg auxiliary sys/oracle@tgg
RecoveryManager: Release 11.2.0.4.0 - Production on Mon Oct 28 16:49:10 2013
Copyright(c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connectedto target database: OGG (DBID=2931384159)
connectedto auxiliary database: OGG (not mounted)
RMAN>run {
allocatechannel prmy1 type disk;
allocatechannel prmy2 type disk;
allocateauxiliary channel stby type disk;
duplicatetarget database for standby from active database
spfile
parameter_value_convert'ogg','tgg'
setdb_unique_name='tgg'
setdb_file_name_convert='/ogg/','/tgg/'
setlog_file_name_convert='/ogg/','/tgg/'
setcontrol_files='/u01/oradata/tgg/control01.ctl'
setlog_archive_max_processes='5'
setfal_client='tgg'
setfal_server='ogg'
setstandby_file_management='AUTO'
setlog_archive_config='dg_config=(ogg,tgg)'
setlog_archive_dest_2='service=ogg ASYNCvalid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=ogg';
}2>
3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13>14> 15> 16> 17> 18> 19>
usingtarget database control file instead of recovery catalog
allocatedchannel: prmy1
channelprmy1: SID=27 device type=DISK
allocatedchannel: prmy2
channelprmy2: SID=26 device type=DISK
allocatedchannel: stby
channelstby: SID=19 device type=DISK
StartingDuplicate Db at 28-OCT-13
contentsof Memory Script:
{
backupas copy reuse
targetfile '/u01/oracle/product/11.2/db_1/dbs/orapwogg' auxiliary format
'/u01/oracle/product/11.2/db_1/dbs/orapwtgg' targetfile
'/u01/oracle/product/11.2/db_1/dbs/spfileogg.ora'auxiliary format
'/u01/oracle/product/11.2/db_1/dbs/spfiletgg.ora' ;
sqlclone "alter system set spfile=''/u01/oracle/product/11.2/db_1/dbs/spfiletgg.ora''";
}
executingMemory Script
Startingbackup at 28-OCT-13
Finishedbackup at 28-OCT-13
sqlstatement: alter system set spfile=''/u01/oracle/product/11.2/db_1/dbs/spfiletgg.ora''
contentsof Memory Script:
{
sqlclone "alter system set audit_file_dest =
''/u01/oracle/admin/tgg/adump''comment=
''''scope=spfile"