DB_FILE_NAME_CONVERT、LOG_FILE_NAME_CONVERT --路径转换,
注意:
备库在前,主库在后!
备库在前,主库在后!!
备库在前,主库在后!!!
 
附:主库参数文件模板
db_unique_name='primary123'
LOG_ARCHIVE_CONFIG='DG_CONFIG=(fgwebdb,dgwebdb)'
LOG_ARCHIVE_DEST_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=primary123'
LOG_ARCHIVE_DEST_2='SERVICE=dgwebdb LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=standby123'
log_archive_format='%t_%s_%r.arc'
fal_client='primary123'
FAL_SERVER='standby123'
DB_FILE_NAME_CONVERT='D:\ORACLE\ORADATA\standby123','D:\ORACLE\ORADATA\primary123'
LOG_FILE_NAME_CONVERT='D:\ORACLE\ORADATA\standby123','D:\ORACLE\ORADATA\primary123'
standby_file_management=AUTO

posted on 2022-03-09 14:46  水语者9  阅读(99)  评论(0编辑  收藏  举报