12c rac dg开启日志应用报错 ora-00313 ora-00312 ora-17503 ora-15012处理

错误

当备库开启日志应用后看到告警日志报大量ora-00313\ora-00312\ora-17503等错误

处理方法

SQL> alter database clear unarchived logfile group 1;

alter database clear unarchived logfile group 1

*

ERROR at line 1:

ORA-01156: recovery or flashback in progress may need access to files

停止日志应用

SQL>

SQL> alter database recover managed standby database cancel;

Database altered.

SQL>

对日志组clear

SQL> alter database clear unarchived logfile group 1;

Database altered.

SQL> alter database clear unarchived logfile group 2;

Database altered.

SQL> alter database clear unarchived logfile group 3;

Database altered.

SQL> alter database clear unarchived logfile group 4;

Database altered.

SQL>

alter database recover managed standby database disconnect from session;