1.copy/scp Oracle home from primary and relink
2.Modify Init and tns files as below on standby
[oratpr@drhost dbs]$
db_unique_name = SID
*.FAL_CLIENT='SID'
*.fal_server='SID_STBY'
*.log_archive_config='dg_config=(SID,SID_STBY)'
*.LOG_ARCHIVE_DEST_1='LOCATION=USE_DB_RECOVERY_FILE_DEST MANDATORY'
*.LOG_ARCHIVE_DEST_2='service=SID_STBY valid_for=(online_logfiles,primary_role) db_unique_name=SID LGWR ASYNC=20480 OPTIONAL REOPEN=15 NET_TIMEOUT=30'
*.log_archive_dest_state_2='DEFER'
*.log_archive_dest_state_3='DEFER'
*.LOG_ARCHIVE_FORMAT='%t_%s_%r.dbf'
*.db_recovery_file_dest='/archivelogs/SID'
*.db_recovery_file_dest_size=100G
[oratpr@drhost SID_drhost]$ cat SID_drhost_ifile.ora
SID_STBY=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=primaryhost)(PORT=1571))
(CONNECT_DATA=
(SID=SID)
)
)
3.Modify init/tns file on primary to include following
init
-----
*.DB_UNIQUE_NAME='SID'
*.FAL_CLIENT='SID'
*.fal_server='SID_STBY'
*.log_archive_config='dg_config=(SID,SID_STBY)'
*.LOG_ARCHIVE_DEST_1='LOCATION=USE_DB_RECOVERY_FILE_DEST MANDATORY'
*.LOG_ARCHIVE_DEST_2='service=SID_STBY LGWR ASYNC=20480 valid_for=(online_logfiles,primary_role) db_unique_name=SID_STBY OPTIONAL REOPEN=15 NET_TIMEOUT=30'
*.log_archive_dest_state_2='DEFER'
*.log_archive_dest_state_3='DEFER'
*.LOG_ARCHIVE_FORMAT='%t_%s_%r.dbf'
*.standby_archive_dest='LOCATION=USE_DB_RECOVERY_FILE_DEST'
*.standby_file_management='AUTO'
*.remote_login_passwordfile='EXCLUSIVE'
tns
---
[oratpr@primaryhost SID_primaryhost]$ cat SID_primaryhost_ifile.ora
SID_STBY = (DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=drhost.cm.charter.com)(PORT=1571))
(CONNECT_DATA=(SID=SID_stdby))
)
4. Mount /copy backup on DR and start restore as below
a. startup database with nomount
b.Validate that you able to connect sys/***@sid_primary as sysdba
If not scp password file from primary to standby
c. Connect to rman and run restore
rman target sys/****@sid_stdby auxiliary sys/****@sid_prim
sql 'alter session set optimizer_mode=rule';
DUPLICATE TARGET DATABASE FOR STANDBY DORECOVER NOFILENAMECHECK;
d. After restore is done it will complain for archives
If required , restore missing archives from backup .
on standby
rman target /
restore archivelog from sequence <.....missing sequenece fro which restore failed >;
5. Enable archive shipping on primary , restart db if required
*.log_archive_dest_state_2='enable'
6.Initiate redo apply on standby
alter database recover managed standby database disconnect;
7. Check alert log and validate that db/primary are in sync
For opening DR
==================
SQL> RECOVER MANAGED STANDBY DATABASE CANCEL;
Media recovery complete.
SQL> ALTER DATABASE ACTIVATE STANDBY DATABASE;
Database altered.
SQL> shut immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 1073741824 bytes
Fixed Size 2089336 bytes
Variable Size 427822728 bytes
Database Buffers 629145600 bytes
Redo Buffers 14684160 bytes
Database mounted.
Database opened.
2.Modify Init and tns files as below on standby
[oratpr@drhost dbs]$
db_unique_name = SID
*.FAL_CLIENT='SID'
*.fal_server='SID_STBY'
*.log_archive_config='dg_config=(SID,SID_STBY)'
*.LOG_ARCHIVE_DEST_1='LOCATION=USE_DB_RECOVERY_FILE_DEST MANDATORY'
*.LOG_ARCHIVE_DEST_2='service=SID_STBY valid_for=(online_logfiles,primary_role) db_unique_name=SID LGWR ASYNC=20480 OPTIONAL REOPEN=15 NET_TIMEOUT=30'
*.log_archive_dest_state_2='DEFER'
*.log_archive_dest_state_3='DEFER'
*.LOG_ARCHIVE_FORMAT='%t_%s_%r.dbf'
*.db_recovery_file_dest='/archivelogs/SID'
*.db_recovery_file_dest_size=100G
[oratpr@drhost SID_drhost]$ cat SID_drhost_ifile.ora
SID_STBY=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=primaryhost)(PORT=1571))
(CONNECT_DATA=
(SID=SID)
)
)
3.Modify init/tns file on primary to include following
init
-----
*.DB_UNIQUE_NAME='SID'
*.FAL_CLIENT='SID'
*.fal_server='SID_STBY'
*.log_archive_config='dg_config=(SID,SID_STBY)'
*.LOG_ARCHIVE_DEST_1='LOCATION=USE_DB_RECOVERY_FILE_DEST MANDATORY'
*.LOG_ARCHIVE_DEST_2='service=SID_STBY LGWR ASYNC=20480 valid_for=(online_logfiles,primary_role) db_unique_name=SID_STBY OPTIONAL REOPEN=15 NET_TIMEOUT=30'
*.log_archive_dest_state_2='DEFER'
*.log_archive_dest_state_3='DEFER'
*.LOG_ARCHIVE_FORMAT='%t_%s_%r.dbf'
*.standby_archive_dest='LOCATION=USE_DB_RECOVERY_FILE_DEST'
*.standby_file_management='AUTO'
*.remote_login_passwordfile='EXCLUSIVE'
tns
---
[oratpr@primaryhost SID_primaryhost]$ cat SID_primaryhost_ifile.ora
SID_STBY = (DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=drhost.cm.charter.com)(PORT=1571))
(CONNECT_DATA=(SID=SID_stdby))
)
4. Mount /copy backup on DR and start restore as below
a. startup database with nomount
b.Validate that you able to connect sys/***@sid_primary as sysdba
If not scp password file from primary to standby
c. Connect to rman and run restore
rman target sys/****@sid_stdby auxiliary sys/****@sid_prim
sql 'alter session set optimizer_mode=rule';
DUPLICATE TARGET DATABASE FOR STANDBY DORECOVER NOFILENAMECHECK;
d. After restore is done it will complain for archives
If required , restore missing archives from backup .
on standby
rman target /
restore archivelog from sequence <.....missing sequenece fro which restore failed >;
5. Enable archive shipping on primary , restart db if required
*.log_archive_dest_state_2='enable'
6.Initiate redo apply on standby
alter database recover managed standby database disconnect;
7. Check alert log and validate that db/primary are in sync
For opening DR
==================
SQL> RECOVER MANAGED STANDBY DATABASE CANCEL;
Media recovery complete.
SQL> ALTER DATABASE ACTIVATE STANDBY DATABASE;
Database altered.
SQL> shut immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 1073741824 bytes
Fixed Size 2089336 bytes
Variable Size 427822728 bytes
Database Buffers 629145600 bytes
Redo Buffers 14684160 bytes
Database mounted.
Database opened.
