在物理备库取消日志应用时,出现ORA-16136的错误
SQL> alter database recover managed standby database cancel;
alter database recover managed standby database cancel
*
ERROR at line 1:
ORA-16136: Managed Standby Recovery not active
由错误提示看来,就是备库本没有启用应用日志的功能的,所以发出取消命令的话就出现了ORA-16136错误了。现在的问题是,备库的应用日志功能一直
都是启用的,现在怎么变成了没有启用了呢?
检查备库告警日志文件内容
[oracle@lonion bdump]$ cat alert_standby.log
Tue Sep 18 15:01:16 2012
RFS[1]: Successfully opened standby log 4: '/u01/app/oracle/oradata/standby/standbyredo01.log'
Tue Sep 18 15:01:20 2012
Media Recovery Log /u01/app/oracle/archivelog/1_38_760823283.arc
File #6 added to control file as 'UNNAMED00006' because
the parameter STANDBY_FILE_MANAGEMENT is set to MANUAL
The file should be manu