data guard无法应用日志

Kevene

配置参数如下
primary
######################################################
#DB_NAME=chicago
DB_UNIQUE_NAME=rmans
LOG_ARCHIVE_CONFIG='DG_CONFIG=(rman,rmans)'
LOG_ARCHIVE_DEST_1='LOCATION=/data/oracle/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=rman'
LOG_ARCHIVE_DEST_2='SERVICE=rmans LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=rmans'
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=standby
FAL_CLIENT=primary
DB_FILE_NAME_CONVERT='rmans','rman'
LOG_FILE_NAME_CONVERT='/home/oracle/oradata/rmans/','/home/oracle/oradata/rman/','/data/oracle/archs','/data/oracle/arch'
STANDBY_FILE_MANAGEMENT=AUTO

standby

######################################################
#DB_NAME=chicago
DB_UNIQUE_NAME=rmans
LOG_ARCHIVE_CONFIG='DG_CONFIG=(rman,rmans)'
LOG_ARCHIVE_DEST_1='LOCATION=/data/oracle/archs VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=rmans'
LOG_ARCHIVE_DEST_2='SERVICE=rman LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=rman'
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=primary
FAL_CLIENT=standby
DB_FILE_NAME_CONVERT='rman','rmans'
LOG_FILE_NAME_CONVERT='/home/oracle/oradata/rman/','/home/oracle/oradata/rmans/','/data/oracle/arch','/data/oracle/archs'
STANDBY_FILE_MANAGEMENT=AUTO

ccsnmoracle

LOG_ARCHIVE_DEST_2='SERVICE=rmans LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)

这里有问题。

'SERVICE=rmans 应该用tns文件中定义的连接名。

hmilyhit

感觉你粘贴的有点乱

你贴的两个都是 DB_UNIQUE_NAME=rmans 两个不能一样


log_archive_dest 的 service 和 tnsnames.ora 中的service 名要一致

[ 本帖最后由 hmilyhit 于 2010-7-16 08:37 编辑 ]

五“宅”一生

DB_UNIQUE_NAME不能一样。