oracle 00314,ORA-00314: log 1 of thread 1, expected sequence# doesn't match

ORA-00314: log 1 of thread 1, expected sequence# doesn't match

2018-08-10

alter database clear logfile group 1;会清空redo01.log

SQL>select name, log_mode from v$database;

SQL>shutdown immediate;

SQL>startup spfile=/u02/oracle/10.2.0/dbs/initdydb.ora;

SQL>alter database archivelog;

SQL> create spfile from pfile;

SQL> alter database clear logfile group 1;

alter database open;

Current log sequence           15332

SQL> alter database open;

alter database open

*

ERROR at line 1:

ORA-00314: log 1 of thread 1, expected sequence#  doesn't match

ORA-00312: online log 1 thread 1: '/u02/oracle/oradata/dydb/redo01.log'

分类：Linux | 标签： |

相关日志