Pages

Thursday, May 14, 2020

Rebuild the Oracle 11g DR configuration for SAP using RMAN


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