Procedure :
a. StandBy Site
1. Shutdown the database.
su – ora<sid>
shutdown immediate;
2. Delete all files under /oracle/SID/sapdata<n>, /oracle/SID/mirrlog<n>, /oracle/SID/origlog<n>
3. Execute the following command
SQL> startup nomount pfile=/oracle/AB1/11203/dbs/initAB1DR.ora
ORACLE instance started.
Total System Global Area 1.8774E+10 bytes
Fixed Size 2236128 bytes
Variable Size 9596567840 bytes
Database Buffers 9126805504 bytes
Redo Buffers 48386048 bytes
SQL>
b. Primary Site
4. Execute the following commands
pgpbibpprddc2:oraAB1 17> rman target sys/sap123@AB1_PRIMARY.WORLD auxiliary sys/sap123@AB1DR_STANDBY.WORLD
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Oct 14 12:35:04 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: AB1 (DBID=2377696196)
connected to auxiliary database: AB1 (not mounted)
RMAN>
run {
allocate channel ch1 type disk;
allocate channel ch2 type disk;
allocate channel ch3 type disk;
allocate channel ch4 type disk;
allocate channel ch5 type disk;
allocate channel ch6 type disk;
allocate channel ch7 type disk;
allocate channel ch8 type disk;
allocate auxiliary channel ch10 type disk;
allocate auxiliary channel ch11 type disk;
allocate auxiliary channel ch12 type disk;
allocate auxiliary channel ch13 type disk;
allocate auxiliary channel ch14 type disk;
allocate auxiliary channel ch15 type disk;
allocate auxiliary channel ch16 type disk;
allocate auxiliary channel ch17 type disk;
duplicate target database for standby from active database DORECOVER NOFILENAMECHECK
spfile
set db_unique_name='AB1DR'
set control_files='/oracle/AB1/origlogA/cntrl/cntrlAB1DR.dbf','/oracle/AB1/origlogB/cntrl/cntrlAB1DR.dbf','/oracle/AB1/sapdata1/cntrl/cntrlAB1DR.dbf'
set log_archive_max_processes='10'
set fal_client='AB1DR_STANDBY.WORLD'
set fal_server='AB1_PRIMARY.WORLD'
set standby_file_management='AUTO'
set log_archive_config='dg_config=(AB1,AB1DR)'
set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = 10.102.1.168)(PORT =1521))'
set log_archive_dest_1= 'LOCATION=/oracle/AB1/oraarch/AB1arch MANDATORY Valid_for=(all_logfiles,all_roles) db_unique_name=AB1DR'
set log_archive_dest_2= 'SERVICE=AB1_PRIMARY.WORLD ARCH VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=AB1'
;
}
No comments:
Post a Comment