Tags

, ,

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)     )   ) ############################################# #############################################

Advertisements