环境 Readhat 4+ 10gR2 Dataguard搭建好后,传送日志
主:ETMCDB 从:PD
alter database recover managed standby database disconnect from session;
Database altered.
显示完成后alert.log中的错误提示
FAL[server]: Fail to queue the whole FAL gap
并且
idle> select max(sequence#) from v$archived_log;
MAX(SEQUENCE#)
--------------
更多错误信息为
sys@ETMCDB> select message from v$dataguard_status;
MESSAGE
--------------------------------------------------------------------------------
ARC0: Archival started
ARC1: Archival started
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
ARC2: Archival started
ARC1: Becoming the heartbeat ARCH
Error 1031 received logging on to the standby
FAL[server, ARC1]: Error 1031 creating remote archivelog file 'PD'
参数文件
initETMCDB.ora
*.DB_UNIQUE_NAME='ETMCDB'
*.FAL_CLIENT='ETMCDB'
*.FAL_SERVER='PD'
*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(ETMCDB,PD)'
*.LOG_ARCHIVE_DEST_1='LOCATION=/u01/oradata/arch1/ETMCDB/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=ETMCDB'
*.LOG_ARCHIVE_DEST_2='SERVICE=PD LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=PD'
*.db_file_name_convert='/u02/oradata/PD','/u01/oradata/ETMCDB','/u02/oradata/PD','/u02/oradata/ETMCDB'
*.log_file_name_convert='/u02/oradata/PD','/u01/oradata/ETMCDB'
*.LOG_ARCHIVE_DEST_STATE_1='ENABLE'
*.LOG_ARCHIVE_DEST_STATE_2='ENABLE'
initPD.ora
*.DB_UNIQUE_NAME='PD'
*.FAL_CLIENT='ETMCDB'
*.FAL_SERVER='PD'
*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(ETMCDB,PD)'
*.LOG_ARCHIVE_DEST_1='LOCATION=/u01/oradata/arch1/PD/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=PD'
*.LOG_ARCHIVE_DEST_2='SERVICE=ETMCDB LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=ETMCDB'
*.db_file_name_convert='/u01/oradata/ETMCDB','/u02/oradata/PD','/u02/oradata/ETMCDB','/u02/oradata/PD'
*.log_file_name_convert='/u01/oradata/ETMCDB','/u02/oradata/PD'
*.LOG_ARCHIVE_DEST_STATE_1='ENABLE'
*.LOG_ARCHIVE_DEST_STATE_2='ENABLE'
监听都配好了tnsping也没问题
密码文件也没问题,两边的密码都一样 sys/oracle登陆也都没问题
大家帮忙看看啊
[ 本帖最后由 xxdxxdxxd 于 2010-2-9 11:51 编辑 ]
|