Shutdown Standby
Database:
-- step 1:
Disable standby archive writing:
-- In primary database
SQL> show parameter
log_archive_dest_3;
NAME TYPE VALUE
------------------------------------ --------------------------------- -----------
log_archive_dest_3
string service="ipxtest",
LGWR ASYNC
NOAFFIRM delay=0 optional comp
ression=disable max_failure=0
max_connections=1 reopen=300 d
b_unique_name="ipxtest", valid
_for=(all_logfiles,primary_rol
e)
SQL> show parameter
log_archive_dest_state_3;
NAME TYPE VALUE
------------------------------------ --------------------------------- -----------
log_archive_dest_state_3
string
ENABLE
SQL> alter system set
log_archive_dest_state_3=defer scope = both;
System altered.
SQL> show parameter
log_archive_dest_state_3;
NAME TYPE VALUE
------------------------------------ --------------------------------- -----------
log_archive_dest_state_3
string
DEFER
-- step 2: Disable auto recovery at standby site:
-- In Standby database
SQL> select process, status,
thread#, sequence#, block#,blocks from v$managed_standby;
PROCESS STATUS THREAD# SEQUENCE#
BLOCK# BLOCKS
--------------------------- ------------------------------------
---------- ----------------------------------
ARCH CLOSING 1 3288 3635200 300
ARCH CLOSING 1 3287 3682304 1745
ARCH CONNECTED 0 0 0 0
ARCH CLOSING 1 3289 28672 1614
RFS IDLE 0 0 0 0
RFS IDLE 0 0 0 0
RFS IDLE 1 3290 13690 1
MRP0
APPLYING_LOG 1 3290 13689 4194304
8 rows selected.
SQL> alter database
recover managed standby database cancel;
Database altered.
SQL> select process, status,
thread#, sequence#, block#,blocks from v$managed_standby;
PROCESS STATUS THREAD# SEQUENCE# BLOCK#
BLOCKS
--------------------------- ------------------------------------ ----------
---------- ---------- ----------
ARCH CLOSING 1 3288 3635200 300
ARCH CLOSING 1 3287 3682304 1745
ARCH
CONNECTED 0 0 0 0
ARCH CLOSING 1 3289 28672 1614
RFS IDLE 0 0 0 0
RFS IDLE 0 0 0 0
RFS IDLE 1 3290 15030 2
7 rows selected.
SQL> shutdown immediate
-- STARTUP STANDBY DATABASE
-- Step 1: Coping all archive from primary to DR
generated during shutdown.
in this step we will copy all archive those were generated after
standby database was taken down.
$scp /arhive_log_location/*.arc oracle@DR-Site-IP:/ arhive_log_location
-- Step 2: Startup standby database and configure
automatic recovery:
SQL>
startup nomount
SQL> alter database
mount standby database;
SQL> alter database
recover managed standby database disconnect using current logfile;
Database altered.
SQL> select process, status,
thread#, sequence#, block#,blocks from v$managed_standby;
PROCESS STATUS THREAD# SEQUENCE# BLOCK#
BLOCKS
--------------------------- ------------------------------------ ----------
---------- ---------- ----------
ARCH CLOSING 1 3288 3635200 300
ARCH CLOSING 1 3287 3682304 1745
ARCH
CONNECTED 0 0 0 0
ARCH CLOSING 1 3290 16384 565
RFS IDLE 0 0 0 0
RFS IDLE 0 0 0 0
MRP0
WAIT_FOR_LOG 1 3291 0 0
7 rows selected.
-- step 3: Enable standby archive writing:
In primary database
SQL> alter system set
log_archive_dest_state_3=enable scope=both;
System altered.
SQL> show parameter
log_archive_dest_state_3;
NAME TYPE VALUE
------------------------------------ --------------------------------- -----------
log_archive_dest_state_3
string
ENABLE
|