Test standby

Source DB

SQL> select FILE_NAME from dba_data_files;

FILE_NAME
--------------------------------------------------------------------------------
+DATA/stdbt1/datafile/users.312.754509463
+DATA/stdbt1/datafile/undotbs1.311.754509463
+DATA/stdbt1/datafile/sysaux.310.754509463
+DATA/stdbt1/datafile/system.309.754509461
SQL> select member from gv$logfile;

MEMBER
--------------------------------------------------------------------------------
+DATA/stdbt1/onlinelog/group_3.317.754509635
+RECOVERY/stdbt1/onlinelog/group_3.810.754509639
+DATA/stdbt1/onlinelog/group_2.316.754509631
+RECOVERY/stdbt1/onlinelog/group_2.811.754509633
+DATA/stdbt1/onlinelog/group_1.315.754509627
+RECOVERY/stdbt1/onlinelog/group_1.812.754509629
SQL> alter database force logging;

Database altered.

SQL> show parameter remote_login_passwordfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile            string      EXCLUSIVE

SQL> alter system set STANDBY_FILE_MANAGEMENT=AUTO;

System altered.

SQL> show parameter recover

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      +RECOVERY
db_recovery_file_dest_size           big integer 3882M

SQL> show parameter db_uniq

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_unique_name                       string      STDBT1

ALTER DATABASE CREATE STANDBY CONTROLFILE AS '/data/STDBT1_backup/STDBT1_standby.ctl';

SQL> create pfile='/data/STDBT1_backup/initSTDBT1.ora' from spfile;

Configure tnsnames – both source and target (or LDAP)

cat  > $ORACLE_HOME/network/admin/tnsnames.ora < < EOF
STDBT1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = ldbtdb03-vip.******.com)(PORT = 1528))
    (LOAD_BALANCE = on)
    (FAILOVER = on)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = STDBT1)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )

STDBT1_STANDBY =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = kdctdb01-vip.******.com)(PORT = 1522))
    (LOAD_BALANCE = on)
    (FAILOVER = on)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = STDBT1)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )

EOF

Target

ASM

ASMCMD> lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 4096 1048576 100000 93051 0 93051 0 N DEV_DATA_01/
MOUNTED EXTERN N 512 4096 1048576 1000000 289392 0 289392 0 N DEV_DATA_02/
MOUNTED EXTERN N 512 4096 1048576 20000 19600 0 19600 0 N DEV_RECOVERY_01/
MOUNTED EXTERN N 512 4096 1048576 202214 193632 0 193632 0 N DEV_RECOVERY_02/

mkdir /data/STDBT1_backup

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>