dataguard做duplicate时备库报redo无法打开或识别的离奇问题

[复制链接]
查看11 | 回复0 | 2011-11-1 16:26:29 | 显示全部楼层 |阅读模式
各位,最近在做ADG的时候遇到一个离奇问题,RMAN备份复制到备库后,在主库执行duplicate target database for standby nofilenamecheck;后,备库的alert日志会报以下错误:
Completed: alter database mount standby database
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Sun Aug 08 21:56:27 2021
Using STANDBY_ARCHIVE_DEST parameter default value as /u02/archivelog
Errors in file /u01/app/oracle/diag/rdbms/product/product/trace/product_lgwr_17653.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/u01/app/oracle/fast_recovery_area/PRODUCT/onlinelog/redo01.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/product/product/trace/product_lgwr_17653.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/u01/app/oracle/fast_recovery_area/PRODUCT/onlinelog/redo01.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/product/product/trace/product_lgwr_17653.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/u01/app/oracle/fast_recovery_area/PRODUCT/onlinelog/redo02.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/product/product/trace/product_lgwr_17653.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/u01/app/oracle/fast_recovery_area/PRODUCT/onlinelog/redo02.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/product/product/trace/product_lgwr_17653.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '/u01/app/oracle/fast_recovery_area/PRODUCT/onlinelog/redo03.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/product/product/trace/product_lgwr_17653.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '/u01/app/oracle/fast_recovery_area/PRODUCT/onlinelog/redo03.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Sun Aug 08 22:11:04 2021
db_recovery_file_dest_size of 4182 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.

然后整个过程就卡在那里不动了,
/u01/app/oracle/fast_recovery_area/PRODUCT/onlinelog这个目录是存在的,权限也没问题,另外主库那边的redo是放在/u01/app/oracle/oradata/product/默认路径下的
尝试在备库修改以下参数,报错依然出现(无论我更改备库2的路径还是保持原状都一样),如:
alter system set log_file_name_convert='/u01/app/oracle/oradata/product/','/u01/app/oracle/oradata/product/' scope=spfile;

alter system set log_file_name_convert='/u01/app/oracle/oradata/product/','/u01/app/oracle/fast_recovery_area/PRODUCT/onlinelog/' scope=spfile;
报错依旧,之前部署过很多DG项目了,配置过程没问题,这次遇到这个问题,百思不得奇解!?有遇到过类似情况的朋友吗?
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行