Steps to Create a Physical Standby Database

  2. Prepare the primary database.
  3. Set parameters on the physical standby database.
  4. Configure Oracle Net Services.
  5. Start the standby database instance.(startup mount)
  6. Execute the DUPLICATE TARGE DATABASE FOR STANDBY FROM ACTIVE DATABASE RMAN command.
  7. Start the transport and application of redo.

Preparing the Primary Database

  2. Enable FORCE LOGGING at the database level.
  3. Create a pasword file if required.
  4. Create standby redo logs.
  5. Set initiablization parameters.
  6. Enable archiving.
搭建DataGuard，修改初始化参数文件所需要的配置信息



DB_UNIQUE_NAME='orcl'
LOG_ARCHIVE_CONFIG='DG_CONFIG=(orcl,FUNDDG)'
LOG_ARCHIVE_DEST_1='LOCATION=/bak_center/arch/orcl/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orcl'
LOG_ARCHIVE_DEST_2='SERVICE=FUNDDG LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=FUNDDG'
LOG_ARCHIVE_DEST_STATE_1='ENABLE'
LOG_ARCHIVE_DEST_STATE_2='ENABLE'
REMOTE_LOGIN_PASSWORDFILE='EXCLUSIVE'
LOG_ARCHIVE_MAX_PROCESSES=3

FAL_CLIENT='orcl'
FAL_SERVER='FUNDDG'
DB_FILE_NAME_CONVERT='/opt/oradata/orcl/','/gsfund/app/oracle/oradata/FUNDDG/'
LOG_FILE_NAME_CONVERT='/opt/oradata/orcl/','/gsfund/app/oracle/oradata/FUNDDG/'
STANDBY_FILE_MANAGEMENT='AUTO'