搭建DG时(我的环境是11g rac asm 备库是11g 文件系统
备库参数文件
log_file_name_convert='+DATA/DSG/ONLINELOG','/u01/app/oracle/oradata/dsg','+FRA/DSG/ONLINELOG','/u01/app/oracle/flash_recovery_area/dsg/reco/DSG_DG/onlinelog'
primary 数据库strings在前,备库的strings在后
db_file_name_convert='+DATA/DSG/DATAFILE','/u01/app/oracle/oradata/dsg','+DATA/DSG/TEMPFILE','/u01/app/oracle/oradata/dsg'
主库参数文件
log_file_name_convert='/u01/app/oracle/oradata/dsg','+DATA/DSG/ONLINELOG','/u01/app/oracle/flash_recovery_area/dsg/reco/DSG_DG/onlinelog','+FRA/DSG/ONLINELOG'
db_file_name_convert='/u01/app/oracle/oradata/dsg','+DATA/DSG/DATAFILE','/u01/app/oracle/oradata/dsg','+DATA/DSG/TEMPFILE'
strings与备库刚好相反
备库参数文件
log_file_name_convert='+DATA/DSG/ONLINELOG','/u01/app/oracle/oradata/dsg','+FRA/DSG/ONLINELOG','/u01/app/oracle/flash_recovery_area/dsg/reco/DSG_DG/onlinelog'
primary 数据库strings在前,备库的strings在后
db_file_name_convert='+DATA/DSG/DATAFILE','/u01/app/oracle/oradata/dsg','+DATA/DSG/TEMPFILE','/u01/app/oracle/oradata/dsg'
主库参数文件
log_file_name_convert='/u01/app/oracle/oradata/dsg','+DATA/DSG/ONLINELOG','/u01/app/oracle/flash_recovery_area/dsg/reco/DSG_DG/onlinelog','+FRA/DSG/ONLINELOG'
db_file_name_convert='/u01/app/oracle/oradata/dsg','+DATA/DSG/DATAFILE','/u01/app/oracle/oradata/dsg','+DATA/DSG/TEMPFILE'
strings与备库刚好相反