Oracle 11g DataGuard增加standby日誌組報錯"ORA-01156: recovery or flashback"

kunlunzhiying發表於2016-11-29
Oracle
Oracle 11g DataGuard增加standby日誌組報錯

SQL> alter system set standby_file_management=manual;

System altered.

SQL> ALTER DATABASE ADD STANDBY LOGFILE  thread 1 GROUP 9 ('/ORADATA/redolog/GTFDBDG/onlinelog/standby_group_09_01.log',
'/ORADATA/redolog/GTFDBDG/onlinelog/standby_group_09_02.log') SIZE 512M;  2  
ALTER DATABASE ADD STANDBY LOGFILE  thread 1 GROUP 9 '/ORADATA/redolog/GTFDBDG/onlinelog/standby_group_09_01.log',
*
ERROR at line 1:
ORA-01156: recovery or flashback in progress may need access to files

解決方法：
關閉備庫日誌應用程式

SQL> alter database recover managed standby database cancel;

Database altered.

SQL> ALTER DATABASE ADD STANDBY LOGFILE  thread 1 GROUP 9 ('/ORADATA/redolog/GTFDBDG/onlinelog/standby_group_09_01.log',
'/ORADATA/redolog/GTFDBDG/onlinelog/standby_group_09_02.log') SIZE 512M;  2  

Database altered.

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/28211342/viewspace-2129276/，如需轉載，請註明出處，否則將追究法律責任。

相關文章