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