Tags
Dataguard Configuration, Dataguard Configuration Basics, Oracle 9i 9.2.0.8 Dataguard Configuration
cold copy or begin backup & end backup ->> All .log .dbf
Create standby control file ALTER DATABASE CREATE STANDBY CONTROLFILE AS ‘/…/data/stbycontrol.ctl’;
initora + passwordfile;
startup nomount;
alter database mount standby database;
REDO+1
alter database add STANDBY LOGFILE GROUP 6 ‘/…/data/stbyredo6a.log’ size 50m;
alter database add STANDBY LOGFILE GROUP 7 ‘/…/data/stbyredo7a.log’ size 50m;
alter database add STANDBY LOGFILE GROUP 8 ‘/…/data/stbyredo8a.log’ size 50m;
alter database add STANDBY LOGFILE GROUP 9 ‘/…/data/stbyredo9a.log’ size 50m;
alter database add STANDBY LOGFILE GROUP 10 ‘/…/data/stbyredo10a.log’ size 50m;
alter database add STANDBY LOGFILE GROUP 11 ‘/…/data/stbyredo11a.log’ size 50m;
….
….
Password File orapwd file=orapwSID password=sys_pass23 entries=20
a. Primary Side log_archive_dest_1 = ‘LOCATION=/…/arch MANDATORY’
standby_file_management = auto standby_archive_dest = /archive_dest
b. Standby
log_archive_dest_1 = ‘LOCATION=/…/arch MANDATORY’
standby_file_management = auto standby_archive_dest = /archive_dest
alter system set standby_archive_dest =’/archive_dest’; alter system set standby_file_management = auto;
alter system set fal_client = PRM_SID; alter system set fal_server = DRC_SID;
alter system set fal_client = DRC_SID; alter system set fal_server = PRM_SID;
alter system set LOG_ARCHIVE_DEST_2 = ‘service=DRC_SID optional lgwr async=20480 noaffirm reopen=15 max_failure=10 delay=0 net_timeout=30’;
alter system set LOG_ARCHIVE_DEST_2 = ‘service=PRM_SID optional lgwr async=20480 noaffirm reopen=15 max_failure=10 delay=0 net_timeout=30’;
alter system set log_archive_dest_state_2 = enable
alter system set log_archive_dest_state_2 = defer
############################################################
############################################################
#Listeners
LISTENER_SID= (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS= (PROTOCOL= IPC)(KEY= SID)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = XX.XX.XX.XX)(PORT = 16001)) ) ) ) SID_LIST_LISTENER_SID = ( SID_LIST= (SID_DESC = (ORACLE_HOME = /ORACLE_HOME) (SID_NAME =SID) ) )
ADMIN_RESTRICTIONS_LISTENER_SID=ON LOGGING_LISTENER_SID=OFF
LISTENER_SID_DGP = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = XX.XX.XX.XX)(PORT =16001) (SEND_BUF_SIZE=255000) (RECV_BUF_SIZE=255000)) ) ) ) SID_LIST_LISTENER_SID_DGP= ( SID_LIST= (SID_DESC = (SDU=32767) (ORACLE_HOME = /ORACLE_HOME) (SID_NAME =SID) ) )
ADMIN_RESTRICTIONS_LISTENER_SID_DGP=ON LOGGING_LISTENER_SID_DGP=OFF
#########################################################
###Standby Listeners LISTENER_SID_STBY= (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS= (PROTOCOL= IPC)(KEY= SID)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = XX.XX.XX.XX)(PORT = 16002)) ) ) ) SID_LIST_LISTENER_SID_STBY = ( SID_LIST= (SID_DESC = (ORACLE_HOME = /ORACLE_HOME) (SID_NAME =SID) ) )
ADMIN_RESTRICTIONS_LISTENER_SID_STBY=ON LOGGING_LISTENER_SID_STBY=OFF
LISTENER_SID_DGS = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = XX.XX.XX.XX)(PORT = 16002) (SEND_BUF_SIZE=255000) (RECV_BUF_SIZE=255000)) ) ) ) SID_LIST_LISTENER_SID_DGS= ( SID_LIST= (SID_DESC = (SDU=32767) (ORACLE_HOME = /ORACLE_HOME) (SID_NAME =SID) ) ) ADMIN_RESTRICTIONS_LISTENER_SID_DGS=ON LOGGING_LISTENER_SID_DGS=OFF
###################################################
###################################################
########################################## ##########################################
#TNSNAMES.ora PRM_SID= (DESCRIPTION= (RECV_BUF_SIZE=255000) (SDU=32767) (SEND_BUF_SIZE=255000) (ADDRESS= (PROTOCOL=TCP) (HOST=XX.XX.XX.XX) (PORT=16002) ) (CONNECT_DATA= (SERVER=dedicated) (SID=SID) ) )
DRC_SID= (DESCRIPTION= (RECV_BUF_SIZE=255000) (SDU=32767) (SEND_BUF_SIZE=255000) (ADDRESS= (PROTOCOL=TCP) (HOST=XX.XX.XX.XX) (PORT=16002) ) (CONNECT_DATA= (SERVER=dedicated) (SID=SID) ) )
SID_PROD= (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=XX.XX.XX.XX) (PORT=16001) ) (CONNECT_DATA= (SERVER=dedicated) (SID=SID) ) ) ############################################# #############################################