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

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'

相关日志