首页 > Linux操作系统 > Linux操作系统 > [草稿]data guard
data guard时standby数据文件不对???
主数据库是demo
从数据库是standby1
都设置好时。两个数据都可以正常使用
当是一查stadby1数据库的数据文件地址还是主数据库demo的数据文件地址。
我在spfilestandby1.ora文件中已经设置了正确的数据文件地址了呀
以下是demo的spfiledemo.ora文件
*.db_unique_name='demo'
*.log_archive_config='dg_config=(demo,standby1)'
*.log_archive_dest_1='location=d:\demolog VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=demo'
*.log_archive_dest_2='service=standby1 VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=standby1'
*.LOG_ARCHIVE_DEST_STATE_1=ENABLE
*.LOG_ARCHIVE_DEST_STATE_2=ENABLE
*.fal_client='standby1'
-------------
*.db_name=’ning’
*.db_unique_name=’NING’
*.fal_client=’NING’
*.fal_server=’STANDBY’
*.log_archive_dest_1=’location=f:\oracle\arch\ning valid_for=(all_logfiles,all_roles) db_unique_name=ning’
*.log_archive_dest_2=’service=standby valid_for=(online_logfiles,primary_role) db_unique_name=ning’
*.log_archive_dest_state_2=’ENABLE’
以下是spfilestandby1.ora
*.db_name=demo
*.db_unique_name=standby1
*.DB_FILE_NAME_CONVERT=('c:\oracle\product\10.2.0\oradata\demo','d:\standby1')
*.LOG_FILE_NAME_CONVERT=('c:\oracle\product\10.2.0\oradata\demo','d:\standby1')
*.standby_archive_dest='d:\standby1\archive'
*.fal_server='demo'
*.fal_client='standby1'
*.standby_file_management='AUTO'
*.log_archive_config='dg_config=(demo,standby1)'
*.log_archive_dest_1='location=D:\standby1\archive VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=standby1'
*.LOG_ARCHIVE_DEST_2='SERVICE=demo LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=demo'
-------------------------------
*.db_name=’STANDBY’
*.db_unique_name=’standby’
*.fal_client=’standby’
*.fal_server=’ning’
*.log_archive_dest_1=’location=f:\oracle\arch\standby valid_for=(all_logfiles,all_roles) db_unique_name=standby’
*.log_archive_dest_2=’service=ning valid_for=(online_logfiles,primary_role) db_unique_name=standby’
*.log_archive_dest_state_2=’ENABLE’
SYNC or ASYNC when using LGWR process.
SYNC if using ARCH process
逻辑dg: 是将主库传过去的日志,通过logmnr转成sql语句在备库执行
逻辑dg: 主库和备库保证逻辑一致性
===============================
1.4 配置主库初始化参数文件
DB_NAME=guard1
DB_UNIQUE_NAME=guard1
LOG_ARCHIVE_CONFIG='DG_CONFIG=(guard1,guard2)'
LOG_ARCHIVE_DEST_1='LOCATION=/u01/app/flash_recovery_area/GUARD1/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=guard1'
LOG_ARCHIVE_DEST_2='SERVICE=guard2 LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=guard2'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
LOG_ARCHIVE_FORMAT=%t_%s_%r.arc
LOG_ARCHIVE_MAX_PROCESSES=30
/*以下部分为主机切换为备库使用*/
FAL_SERVER=guard2
FAL_CLIENT=guard1
DB_FILE_NAME_CONVERT='guard2','guard1'
LOG_FILE_NAME_CONVERT='/u01/app/oradata/guard2','/u01/app/oradata/guard1'
STANDBY_FILE_MANAGEMENT=AUTO
http://ningoo.itpub.net/post/2149/190758
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/35489/viewspace-610121/ ,如需转载,请注明出处,否则将追究法律责任。