暂无图片
Oracle 用rman备份 恢复创建dg redo log和standby log都恢复不到备库 , 这是为什么?
我来答
分享
QIU飞
2021-12-07
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
暂无图片
lnn

备份的是归档,不是在线,备库redo还得手动创建

你可以用deplicate

log_file_name_convert转换

暂无图片 评论
暂无图片 有用 0
QIU飞

谢谢

暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏