Physical Standby – Configure physical standby & FRA for PROD

Posted: March 7, 2013 in StandBy
Tags:

Here i will be trying to implement physical standby with FRA implemented on PROD & Standby. My main goals are:

  1. Configure physical standby & FRA for PROD
  2. Configure automatic archive deletion from standby
  3. Check the effects of deletion policy set to “APPLIED ON ALL STANDBY”

This might be too lenghty for a single post, so i will break it in 3 posts, each for a single goal. So, this post will only  contain the physical standby creation and FRA implementation.

For creating standby database we need to do the following steps on PRIMARY/PROD database. Assume primary database name is PLMQDBS.

Add following parameters to PROD init file.

db_name='PLMQDBS'
db_unique_name='PLMQDBS'
db_recovery_file_dest_size=7516192768
db_recovery_file_dest='/u05/oradata/PLMQDBS/flash'
log_archive_config='DG_CONFIG=(PLMQDBS,PLMQDBST)'
log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=PLMQDBS'
log_archive_dest_2='SERVICE=PLMQDBST ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=PLMQDBST'
log_archive_dest_state_2='DEFER'
fal_server='PLMQDBST'
DB_FILE_NAME_CONVERT='/u04/oradata/CORE/PLMQDBS','/u04/oradata/PLMQDBS'
LOG_FILE_NAME_CONVERT='/u02/oradata/CORE/PLMQDBS','/u02/oradata/PLMQDBS','/u03/oradata/CORE/PLMQDBS','/u03/oradata/PLMQDBS'

Now, add the tns entry for standby at the primary database. Standby DB should be pingable from primary.

PLMQDBST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = PLMQDBS)
)
)

All the required changes at PROD are done. Now, switch to standby by server and perform the following steps.

At Standby Server copy the init.ora , orapw.ora & listener.ora file from prod to standby server and make the changes in init.ora  file as below, no need to change anything in orapw .ora:

db_name='PLMQDBS'
db_unique_name='PLMQDBST'
db_recovery_file_dest_size=7516192768
db_recovery_file_dest='/u05/oradata/CORE/flash'
log_archive_config='DG_CONFIG=(PLMQDBST,PLMQDBS)'
log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=PLMQDBST'
log_archive_dest_2='SERVICE=PLMQDBS ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=PLMQDBS'
log_archive_dest_state_2='DEFER'
DB_FILE_NAME_CONVERT='/u04/oradata/PLMQDBS','/u04/oradata/CORE/PLMQDBS'
LOG_FILE_NAME_CONVERT='/u02/oradata/PLMQDBS','/u02/oradata/CORE/PLMQDBS','/u03/oradata/PLMQDBS','/u03/oradata/CORE/PLMQDBS'

Please note that the db_unique_name is different on standby server and db_name is same as prod. This is required to uniquely identify the standby DB name and also, it helps in smoothly switchover/failover to standby, in case of need. Now add the tns entry for PROD & Standby at standby and create a listener for standby database as below given.

 

PLMQDBS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = myhost1)(PORT = 1525))
)
(CONNECT_DATA =
(SERVICE_NAME = PLMQDBS)
)
)

PLMQDBST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = PLMQDBS)
)
)

SID_LIST_LISTENER_HFM11TMP =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME = /u01/app/oracore/product/11.2.0/dbhome_1)
(SID_NAME = PLMQDBS)
)
)
LISTENER_PLMQDBS =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 1522))
)
)
)

Once this is set, now we are ready for duplicate command for standby. Before that start the standby instance in nomount state as:

oracore@myhost1 $ export ORACLE_SID=PLMQDBS
oracore@myhost1 $ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Thu Mar 7 09:48:12 2013

Copyright (c) 1982, 2009, Oracle. All rights reserved.

SQL> conn sys as sysdba
Enter password:
Connected to an idle instance.
SQL> startup nomount
ORACLE instance started.

Total System Global Area 4175568896 bytes
Fixed Size 2213384 bytes
Variable Size 805308920 bytes
Database Buffers 3355443200 bytes
Redo Buffers 12603392 bytes

Please make sure that yo are able to ping PROD, RMAN catalog database from standby server. Once that is done, use the below command for creation of standby through rman.

rman target sys/hahaha@plmqdbs catalog RMANPRD1/hahaha@rmap1 auxiliary /

Logs for this standby creation is as:

Recovery Manager: Release 11.2.0.1.0 - Production on Tue Mar 5 16:49:05 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

connected to target database: PLMQDBS (DBID=165665636)
connected to recovery catalog database
connected to auxiliary database: PLMQDBS (not mounted)

RMAN> duplicate target database for standby dorecover;

Starting Duplicate Db at 05-MAR-13
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=153 device type=DISK
allocated channel: ORA_AUX_DISK_2
channel ORA_AUX_DISK_2: SID=203 device type=DISK
allocated channel: ORA_AUX_DISK_3
channel ORA_AUX_DISK_3: SID=253 device type=DISK
allocated channel: ORA_AUX_DISK_4
channel ORA_AUX_DISK_4: SID=303 device type=DISK

contents of Memory Script:
{
set until scn 19582065;
restore clone standby controlfile;
}
executing Memory Script

executing command: SET until clause

Starting restore at 05-MAR-13
using channel ORA_AUX_DISK_1
using channel ORA_AUX_DISK_2
using channel ORA_AUX_DISK_3
using channel ORA_AUX_DISK_4

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: reading from backup piece /oraclebackup/PLMQDBS/c-165665636-20130305-02
channel ORA_AUX_DISK_1: piece handle=/oraclebackup/PLMQDBS/c-165665636-20130305-02 tag=TAG20130305T144957
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:08
output file name=/u02/oradata/CORE/PLMQDBS/control02.ctl
output file name=/u03/oradata/CORE/PLMQDBS/control03.ctl
Finished restore at 05-MAR-13

contents of Memory Script:
{
sql clone 'alter database mount standby database';
}
executing Memory Script

sql statement: alter database mount standby database

contents of Memory Script:
{
set until scn 19582065;
set newname for tempfile 1 to
"/u04/oradata/CORE/PLMQDBS/temp01.dbf";
switch clone tempfile all;
set newname for datafile 1 to
"/u04/oradata/CORE/PLMQDBS/system01.dbf";
set newname for datafile 2 to
"/u04/oradata/CORE/PLMQDBS/sysaux01.dbf";
set newname for datafile 3 to
"/u04/oradata/CORE/PLMQDBS/undots01.dbf";
set newname for datafile 4 to
"/u04/oradata/CORE/PLMQDBS/PLM01.DBF";
set newname for datafile 5 to
"/u04/oradata/CORE/PLMQDBS/PLM_DATA01.DBF";
set newname for datafile 6 to
"/u04/oradata/CORE/PLMQDBS/PLM_INDEX01.DBF";
set newname for datafile 7 to
"/u04/oradata/CORE/PLMQDBS/TVC_DATA01.DBF";
set newname for datafile 8 to
"/u04/oradata/CORE/PLMQDBS/TVC_INDEX01.DBF";
set newname for datafile 9 to
"/u04/oradata/CORE/PLMQDBS/userdata01.dbf";
set newname for datafile 10 to
"/u04/oradata/CORE/PLMQDBS/cad_ts01.dbf";
restore
clone database
;
}
executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME

renamed tempfile 1 to /u04/oradata/CORE/PLMQDBS/temp01.dbf in control file

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 05-MAR-13
using channel ORA_AUX_DISK_1
using channel ORA_AUX_DISK_2
using channel ORA_AUX_DISK_3
using channel ORA_AUX_DISK_4

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00009 to /u04/oradata/CORE/PLMQDBS/userdata01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00010 to /u04/oradata/CORE/PLMQDBS/cad_ts01.dbf
channel ORA_AUX_DISK_1: reading from backup piece /oraclebackup/PLMQDBS/DF_L0_PLMQDBS_02032013_c2o3i414_4482_1
channel ORA_AUX_DISK_2: starting datafile backup set restore
channel ORA_AUX_DISK_2: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_2: restoring datafile 00003 to /u04/oradata/CORE/PLMQDBS/undots01.dbf
channel ORA_AUX_DISK_2: restoring datafile 00004 to /u04/oradata/CORE/PLMQDBS/PLM01.DBF
channel ORA_AUX_DISK_2: reading from backup piece /oraclebackup/PLMQDBS/DF_L0_PLMQDBS_02032013_c1o3i414_4481_1
channel ORA_AUX_DISK_3: starting datafile backup set restore
channel ORA_AUX_DISK_3: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_3: restoring datafile 00001 to /u04/oradata/CORE/PLMQDBS/system01.dbf
channel ORA_AUX_DISK_3: restoring datafile 00005 to /u04/oradata/CORE/PLMQDBS/PLM_DATA01.DBF
channel ORA_AUX_DISK_3: restoring datafile 00007 to /u04/oradata/CORE/PLMQDBS/TVC_DATA01.DBF
channel ORA_AUX_DISK_3: reading from backup piece /oraclebackup/PLMQDBS/DF_L0_PLMQDBS_02032013_bvo3i414_4479_1
channel ORA_AUX_DISK_4: starting datafile backup set restore
channel ORA_AUX_DISK_4: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_4: restoring datafile 00002 to /u04/oradata/CORE/PLMQDBS/sysaux01.dbf
channel ORA_AUX_DISK_4: restoring datafile 00006 to /u04/oradata/CORE/PLMQDBS/PLM_INDEX01.DBF
channel ORA_AUX_DISK_4: restoring datafile 00008 to /u04/oradata/CORE/PLMQDBS/TVC_INDEX01.DBF
channel ORA_AUX_DISK_4: reading from backup piece /oraclebackup/PLMQDBS/DF_L0_PLMQDBS_02032013_c0o3i414_4480_1
channel ORA_AUX_DISK_1: piece handle=/oraclebackup/PLMQDBS/DF_L0_PLMQDBS_02032013_c2o3i414_4482_1 tag=LEVEL0
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:01:18
channel ORA_AUX_DISK_2: piece handle=/oraclebackup/PLMQDBS/DF_L0_PLMQDBS_02032013_c1o3i414_4481_1 tag=LEVEL0
channel ORA_AUX_DISK_2: restored backup piece 1
channel ORA_AUX_DISK_2: restore complete, elapsed time: 00:01:17
channel ORA_AUX_DISK_3: piece handle=/oraclebackup/PLMQDBS/DF_L0_PLMQDBS_02032013_bvo3i414_4479_1 tag=LEVEL0
channel ORA_AUX_DISK_3: restored backup piece 1
channel ORA_AUX_DISK_3: restore complete, elapsed time: 00:01:36
channel ORA_AUX_DISK_4: piece handle=/oraclebackup/PLMQDBS/DF_L0_PLMQDBS_02032013_c0o3i414_4480_1 tag=LEVEL0
channel ORA_AUX_DISK_4: restored backup piece 1
channel ORA_AUX_DISK_4: restore complete, elapsed time: 00:01:46
Finished restore at 05-MAR-13

contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script

datafile 1 switched to datafile copy
input datafile copy RECID=1 STAMP=809283329 file name=/u04/oradata/CORE/PLMQDBS/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=2 STAMP=809283329 file name=/u04/oradata/CORE/PLMQDBS/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=3 STAMP=809283329 file name=/u04/oradata/CORE/PLMQDBS/undots01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=4 STAMP=809283330 file name=/u04/oradata/CORE/PLMQDBS/PLM01.DBF
datafile 5 switched to datafile copy
input datafile copy RECID=5 STAMP=809283330 file name=/u04/oradata/CORE/PLMQDBS/PLM_DATA01.DBF
datafile 6 switched to datafile copy
input datafile copy RECID=6 STAMP=809283330 file name=/u04/oradata/CORE/PLMQDBS/PLM_INDEX01.DBF
datafile 7 switched to datafile copy
input datafile copy RECID=7 STAMP=809283330 file name=/u04/oradata/CORE/PLMQDBS/TVC_DATA01.DBF
datafile 8 switched to datafile copy
input datafile copy RECID=8 STAMP=809283330 file name=/u04/oradata/CORE/PLMQDBS/TVC_INDEX01.DBF
datafile 9 switched to datafile copy
input datafile copy RECID=9 STAMP=809283330 file name=/u04/oradata/CORE/PLMQDBS/userdata01.dbf
datafile 10 switched to datafile copy
input datafile copy RECID=10 STAMP=809283330 file name=/u04/oradata/CORE/PLMQDBS/cad_ts01.dbf

contents of Memory Script:
{
set until scn 19582065;
recover
standby
clone database
delete archivelog
;
}
executing Memory Script

executing command: SET until clause

Starting recover at 05-MAR-13
using channel ORA_AUX_DISK_1
using channel ORA_AUX_DISK_2
using channel ORA_AUX_DISK_3
using channel ORA_AUX_DISK_4
channel ORA_AUX_DISK_1: starting incremental datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00009: /u04/oradata/CORE/PLMQDBS/userdata01.dbf
destination for restore of datafile 00010: /u04/oradata/CORE/PLMQDBS/cad_ts01.dbf
channel ORA_AUX_DISK_1: reading from backup piece /oraclebackup/PLMQDBS/DF_L1_PLMQDBS_04032013_cso3ncpc_4508_1
channel ORA_AUX_DISK_2: starting incremental datafile backup set restore
channel ORA_AUX_DISK_2: specifying datafile(s) to restore from backup set
destination for restore of datafile 00001: /u04/oradata/CORE/PLMQDBS/system01.dbf
destination for restore of datafile 00005: /u04/oradata/CORE/PLMQDBS/PLM_DATA01.DBF
destination for restore of datafile 00007: /u04/oradata/CORE/PLMQDBS/TVC_DATA01.DBF
channel ORA_AUX_DISK_2: reading from backup piece /oraclebackup/PLMQDBS/DF_L1_PLMQDBS_04032013_cpo3ncpb_4505_1
channel ORA_AUX_DISK_3: starting incremental datafile backup set restore
channel ORA_AUX_DISK_3: specifying datafile(s) to restore from backup set
destination for restore of datafile 00003: /u04/oradata/CORE/PLMQDBS/undots01.dbf
destination for restore of datafile 00004: /u04/oradata/CORE/PLMQDBS/PLM01.DBF
channel ORA_AUX_DISK_3: reading from backup piece /oraclebackup/PLMQDBS/DF_L1_PLMQDBS_04032013_cro3ncpc_4507_1
channel ORA_AUX_DISK_4: starting incremental datafile backup set restore
channel ORA_AUX_DISK_4: specifying datafile(s) to restore from backup set
destination for restore of datafile 00002: /u04/oradata/CORE/PLMQDBS/sysaux01.dbf
destination for restore of datafile 00006: /u04/oradata/CORE/PLMQDBS/PLM_INDEX01.DBF
destination for restore of datafile 00008: /u04/oradata/CORE/PLMQDBS/TVC_INDEX01.DBF
channel ORA_AUX_DISK_4: reading from backup piece /oraclebackup/PLMQDBS/DF_L1_PLMQDBS_04032013_cqo3ncpb_4506_1
channel ORA_AUX_DISK_1: piece handle=/oraclebackup/PLMQDBS/DF_L1_PLMQDBS_04032013_cso3ncpc_4508_1 tag=LEVEL1
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02
channel ORA_AUX_DISK_2: piece handle=/oraclebackup/PLMQDBS/DF_L1_PLMQDBS_04032013_cpo3ncpb_4505_1 tag=LEVEL1
channel ORA_AUX_DISK_2: restored backup piece 1
channel ORA_AUX_DISK_2: restore complete, elapsed time: 00:00:05
channel ORA_AUX_DISK_3: piece handle=/oraclebackup/PLMQDBS/DF_L1_PLMQDBS_04032013_cro3ncpc_4507_1 tag=LEVEL1
channel ORA_AUX_DISK_3: restored backup piece 1
channel ORA_AUX_DISK_3: restore complete, elapsed time: 00:00:16
channel ORA_AUX_DISK_4: piece handle=/oraclebackup/PLMQDBS/DF_L1_PLMQDBS_04032013_cqo3ncpb_4506_1 tag=LEVEL1
channel ORA_AUX_DISK_4: restored backup piece 1
channel ORA_AUX_DISK_4: restore complete, elapsed time: 00:00:15

starting media recovery

channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=2803
channel ORA_AUX_DISK_1: reading from backup piece /oraclebackup/PLMQDBS/ARC_1HR_PLMQDBS_05032013_d3o3o1rl_4515_1
channel ORA_AUX_DISK_2: starting archived log restore to default destination
channel ORA_AUX_DISK_2: restoring archived log
archived log thread=1 sequence=2804
channel ORA_AUX_DISK_2: restoring archived log
archived log thread=1 sequence=2805
channel ORA_AUX_DISK_2: reading from backup piece /oraclebackup/PLMQDBS/ARC_1HR_PLMQDBS_05032013_d5o3omu2_4517_1
channel ORA_AUX_DISK_3: starting archived log restore to default destination
channel ORA_AUX_DISK_3: restoring archived log
archived log thread=1 sequence=2806
channel ORA_AUX_DISK_3: restoring archived log
archived log thread=1 sequence=2807
channel ORA_AUX_DISK_3: restoring archived log
archived log thread=1 sequence=2808
channel ORA_AUX_DISK_3: restoring archived log
archived log thread=1 sequence=2809
channel ORA_AUX_DISK_3: restoring archived log
archived log thread=1 sequence=2810
channel ORA_AUX_DISK_3: restoring archived log
archived log thread=1 sequence=2811
channel ORA_AUX_DISK_3: reading from backup piece /oraclebackup/PLMQDBS/ARC_1HR_PLMQDBS_05032013_d8o3p9s2_4520_1
channel ORA_AUX_DISK_1: piece handle=/oraclebackup/PLMQDBS/ARC_1HR_PLMQDBS_05032013_d3o3o1rl_4515_1 tag=ARC_1HR
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02
archived log file name=/u05/oradata/CORE/flash/PLMQDBST/archivelog/2013_03_05/o1_mf_1_2803_8md5d91h_.arc thread=1 sequence=2803
channel clone_default: deleting archived log(s)
archived log file name=/u05/oradata/CORE/flash/PLMQDBST/archivelog/2013_03_05/o1_mf_1_2803_8md5d91h_.arc RECID=1 STAMP=809283353
channel ORA_AUX_DISK_2: piece handle=/oraclebackup/PLMQDBS/ARC_1HR_PLMQDBS_05032013_d5o3omu2_4517_1 tag=ARC_1HR
channel ORA_AUX_DISK_2: restored backup piece 1
channel ORA_AUX_DISK_2: restore complete, elapsed time: 00:00:04
archived log file name=/u05/oradata/CORE/flash/PLMQDBST/archivelog/2013_03_05/o1_mf_1_2804_8md5d9z2_.arc thread=1 sequence=2804
channel clone_default: deleting archived log(s)
archived log file name=/u05/oradata/CORE/flash/PLMQDBST/archivelog/2013_03_05/o1_mf_1_2804_8md5d9z2_.arc RECID=6 STAMP=809283355
archived log file name=/u05/oradata/CORE/flash/PLMQDBST/archivelog/2013_03_05/o1_mf_1_2805_8md5db1t_.arc thread=1 sequence=2805
channel clone_default: deleting archived log(s)
archived log file name=/u05/oradata/CORE/flash/PLMQDBST/archivelog/2013_03_05/o1_mf_1_2805_8md5db1t_.arc RECID=2 STAMP=809283354
channel ORA_AUX_DISK_3: piece handle=/oraclebackup/PLMQDBS/ARC_1HR_PLMQDBS_05032013_d8o3p9s2_4520_1 tag=ARC_1HR
channel ORA_AUX_DISK_3: restored backup piece 1
channel ORA_AUX_DISK_3: restore complete, elapsed time: 00:00:08
archived log file name=/u05/oradata/CORE/flash/PLMQDBST/archivelog/2013_03_05/o1_mf_1_2806_8md5d9xo_.arc thread=1 sequence=2806
channel clone_default: deleting archived log(s)
archived log file name=/u05/oradata/CORE/flash/PLMQDBST/archivelog/2013_03_05/o1_mf_1_2806_8md5d9xo_.arc RECID=9 STAMP=809283355
archived log file name=/u05/oradata/CORE/flash/PLMQDBST/archivelog/2013_03_05/o1_mf_1_2807_8md5dbo0_.arc thread=1 sequence=2807
channel clone_default: deleting archived log(s)
archived log file name=/u05/oradata/CORE/flash/PLMQDBST/archivelog/2013_03_05/o1_mf_1_2807_8md5dbo0_.arc RECID=5 STAMP=809283354
archived log file name=/u05/oradata/CORE/flash/PLMQDBST/archivelog/2013_03_05/o1_mf_1_2808_8md5db0r_.arc thread=1 sequence=2808
channel clone_default: deleting archived log(s)
archived log file name=/u05/oradata/CORE/flash/PLMQDBST/archivelog/2013_03_05/o1_mf_1_2808_8md5db0r_.arc RECID=7 STAMP=809283355
archived log file name=/u05/oradata/CORE/flash/PLMQDBST/archivelog/2013_03_05/o1_mf_1_2809_8md5db6s_.arc thread=1 sequence=2809
channel clone_default: deleting archived log(s)
archived log file name=/u05/oradata/CORE/flash/PLMQDBST/archivelog/2013_03_05/o1_mf_1_2809_8md5db6s_.arc RECID=3 STAMP=809283354
archived log file name=/u05/oradata/CORE/flash/PLMQDBST/archivelog/2013_03_05/o1_mf_1_2810_8md5db2q_.arc thread=1 sequence=2810
channel clone_default: deleting archived log(s)
archived log file name=/u05/oradata/CORE/flash/PLMQDBST/archivelog/2013_03_05/o1_mf_1_2810_8md5db2q_.arc RECID=8 STAMP=809283355
archived log file name=/u05/oradata/CORE/flash/PLMQDBST/archivelog/2013_03_05/o1_mf_1_2811_8md5db8d_.arc thread=1 sequence=2811
channel clone_default: deleting archived log(s)
archived log file name=/u05/oradata/CORE/flash/PLMQDBST/archivelog/2013_03_05/o1_mf_1_2811_8md5db8d_.arc RECID=4 STAMP=809283354
media recovery complete, elapsed time: 00:00:04
Finished recover at 05-MAR-13
Finished Duplicate Db at 05-MAR-13

RMAN> exit

Once, this is completed, now we can put the standby database in managed mode. On standby database give the following command.

SQL> alter database recover managed standby database disconnect from session noparallel;

Database altered.

Now, login to PROD database and check what archives are generated.

SEQUENCE# FIRST_TIME
———- ———–
51108 07-MAR-2013
51109 07-MAR-2013
51110 07-MAR-2013
51111 07-MAR-2013
51112 07-MAR-2013
51113 07-MAR-2013

Now, check on standby that archives are applied or not as

SEQUENCE# APPLIED
———- ———
51108 YES
51109 YES
51110 YES
51111 YES
51112 YES
51113 YES

By this, i have finished goal of this series. Standby database is created and FRA is also in place. Now, in next post i will try to delete archives automatically from standby whenever it got applied on standby.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s