Oracle 用rman备份 恢复创建dg redo log和standby log都恢复不到备库 , 这是为什么?
Oracle 用rman备份 恢复创建dg redo log和standby log都恢复不到备库 , 这是为什么?
我来答
添加附件
收藏
复制链接
微信扫码分享
在小程序上查看
分享
添加附件
问题补充
3条回答
默认
最新
只要你查询v$logfile,redo log以及standby redo log路径正确:
1.你可以在为开启dg同步之前手工执行ALTER DATABASE CLEAR LOGFILE GROUP x;生成物理上对应的文件。
2.或者你无需执行,会在你开启恢复的时候,oracle自动完成clear生成物理对应文件,这个过程可以从alert日志中看到。
例如下面就是第二种情况的示例:
ALTER DATABASE RECOVER managed standby database disconnect from session
Attempt to start background Managed Standby Recovery process (honordg)
Tue Feb 02 01:59:20 2021
MRP0 started with pid=20, OS id=45884
MRP0: Background Managed Standby Recovery process started (honordg)
Serial Media Recovery started
Managed Standby Recovery not using Real Time Apply
Waiting for all non-current ORLs to be archived...
All non-current ORLs have been archived.
Errors in file /oracle/app/oracle/diag/rdbms/honordg/honordg/trace/honordg_mrp0_45884.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '+DATADG/honor/onlinelog/group_1.261.984508005'
ORA-17503: ksfdopn:2 Failed to open file +DATADG/honor/onlinelog/group_1.261.984508005
ORA-15001: diskgroup "DATADG" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
Clearing online redo logfile 1 +DATADG/honor/onlinelog/group_1.261.984508005
Clearing online log 1 of thread 1 sequence number 1748
评论
有用 0
备份的是归档,不是在线,备库redo还得手动创建
你可以用deplicate
log_file_name_convert转换
评论
有用 0回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
墨值悬赏

