ORA-01511 error in renaming log/data files ORA-00261 log 4 of thread 1 is being
数据库版本12.2，使用standby备库备份恢复出一套可读写的数据库，在rename standby redolog时遇到ORA-01511 error in renaming log/data files ORA-00261 log 4 of thread 1 is being archived or modified，该错误是因为备库还处于reco ver模式，standby redo logfile还在使用中时做的全库备份。
solution:
-
restore controlfile时指定primary
-
alter database clear unarchived logfile group 4;
-
alter database drop standby logfile group 4;
-
alter database open resetlogs;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10271187/viewspace-2637584/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- 12.2新特性之ADG多节点启动MRP进程
- Warning: ORA-16714: the value of property ArchiveLagTarget is inconsistent
- 恢复数据库hang住/parallel recovery read buffer free
- ORA-00600: 内部错误代码，参数: [6002], [6], [28], [1], [52], [], [], []
- ORA-13639: The CURRENT operation was interrupted because it timed OUT
- 表空间小写导致ORA-31655错误
- ORA-12154:TNS:无法解析指定的连接标识符
- 测试将表缓存到keep池
- ASM file metadata operation
- RMAN恢复单个表空间或被DROP/DELETE/TRUNCATE的表
