ORA-00338

dg环境从库报错:

ORA-00338: log 5 of thread 1 is more recent than control file

ORA-00312: online log 5 thread 1: '/u01/app/oracle/oradata/slnngkdg/stdbyredo05.log'

Wed Feb 27 16:48:39 2019

RFS[2]: Selected log 4 for thread 1 sequence 580 dbid -882553477 branch 994182077

Wed Feb 27 16:48:39 2019

Archived Log entry 570 added for thread 1 sequence 579 ID 0xcb66097b dest 1:

Wed Feb 27 16:48:40 2019

Media Recovery Waiting for thread 1 sequence 580 (in transit)

Recovery of Online Redo Log: Thread 1 Group 4 Seq 580 Reading mem 0

解决办法:

1.退出日志应用模式

alter database recover managed standby database cancel;

2.关闭数据库

shutdown immediate

3.启动数据库到mount状态

startup mount

4.清除报错的日志组5

ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 5;

5.应用日志

alter database recover managed standby database using current logfile disconnect from session;

6.日志应用完后先退出然后再打开数据库

alter database recover managed standby database cancel;

alter database open;

7.再次应用日志

alter database recover managed standby database using current logfile disconnect from session;