暂无图片
dg 复制备库RMAN-05535
我来答
分享
xuan _
2024-04-24
dg 复制备库RMAN-05535


.两边路径一致设置转换参数报错依旧。
db_file_name_convert string /u01/app/oracle/oradata/ORCL,
/u01/app/oracle/oradata/ORCL
log_file_name_convert string /u01/app/oracle/oradata/ORCL,
/u01/app/oracle/oradata/ORCL

2.设置standby_file_management 为MANUAL也是报错
standby_file_management string MANUAL



我来答
添加附件
收藏
分享
问题补充
3条回答
默认
最新
一般

查询一下V$LOGFILE,确认所有的logfile路径是否一致

standby_file_management需要配置成auto

暂无图片 评论
暂无图片 有用 0
xuan _
题主
2024-04-25
路径一直的 standby_file_management不能设置自动 设置自动报错 重做日志文件为自动不允许更改
学习Oracle

Duplicate for Standby fails with RMAN-05535 even when LOG_FILE_NAME_CONVERT is set (Doc ID 2756315.1)

1. alter database rename file '<ORACLE_HOME>/dbs/broken0' to '<PATH1>/<ORACLE_SID>/redo1/redo01.log';

2. Confirm the redo log filename have changed using the following query: 
select v1.thread#, v1.group#, v2.member from v$log v1, v$logfile v2 where v1.group#=v2.group#
order by v1.group#;
Repeat step #1 above for any redo logfile listed in the above query which has not been renamed.  
3. The above steps does not create the redo log file, it just updates the controlfile with a valid location and name.  Once all the redo
log files have been renamed, you must execute the following to physically create them: 

alter database clear logfile group <REDO LOG group  number>;

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

看下密钥文件对不对

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