|
[oracle@c2 ~]$ sqlplus / as sysdba
SQL*Plus:> Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an> SQL> startup
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed>
Variable> Database Buffers 180355072 bytes
Redo Buffers 2973696 bytes
Database mounted.
ORA-00322: log 3 of thread 1 is not current copy
ORA-00312: online log 3 thread 1: '/oradata/orcl/redo03.log'
解决方法:
SQL> select group#,status from v$log;
GROUP# STATUS
---------- ------------------------------------------------
1 CURRENT
3 INACTIVE
2 INACTIVE
SQL>>
Database>
SQL>>
Database> SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
/oradata/orcl/system01.dbf
/oradata/orcl/undotbs01.dbf
/oradata/orcl/sysaux01.dbf
/oradata/orcl/users01.dbf
/oradata/orcl/example01.dbf
|
|
|