data guard , primary, standy init.ora 备忘

来源：互联网发布：招商行情分析软件编辑：程序博客网时间：2024/06/06 07:02

primary.ora

DB_NAME=tmdb
DB_UNIQUE_NAME=primary
LOG_ARCHIVE_CONFIG='DG_CONFIG=(primary,standby)'
LOG_ARCHIVE_DEST_1='location=/u01/oracle/flash_recovery_area valid_for=(ALL_LOGFILES,ALL_ROLES)DB_UNIQUE_NAME=primary'
LOG_ARCHIVE_DEST_2= 'SERVICE=standby LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=standby'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
LOG_ARCHIVE_MAX_PROCESSES=30
FAL_SERVER=standby
FAL_CLIENT=primary
DB_FILE_NAME_CONVERT='standby','primary'
STANDBY_FILE_MANAGEMENT=AUTO

slave.ora
DB_NAME=tmdb
DB_UNIQUE_NAME=standby
LOG_ARCHIVE_CONFIG='DG_CONFIG=(primary,standby)'
LOG_ARCHIVE_DEST_1='location=/u01/oracle/flash_recovery_area valid_for=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=standby'
LOG_ARCHIVE_DEST_2= 'SERVICE=primary LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=primary'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
LOG_ARCHIVE_MAX_PROCESSES=30
FAL_SERVER=primary
FAL_CLIENT=standby
DB_FILE_NAME_CONVERT='standby','primary'
STANDBY_FILE_MANAGEMENT=AUTO