oracle查看onlinelog文件,Oracle 联机重做日志文件(ONLINE LOG FILE)

--9.日志异常处理

--启动时提示日志不一致

SQL> startup

Oracle instance started.

Total System Global Area251658240 bytes

Fixed Size1218796 bytes

Variable Size83887892 bytes

Database Buffers163577856 bytes

Redo Buffers2973696 bytes

Database mounted.

ORA-00341:log 1 of thread 1,wrong log # in header

ORA-00312:online log 1 thread 1:'/u01/app/oracle/oradata/orcl/redo1a.rdo'

ORA-00312:online log 1 thread 1:'/u01/app/oracle/oradata/orcl/redo1b.rdo'

SQL> ALTER DATABASE CLEAR LOGFILE GROUP 1;

Database altered.

SQL> ALTER DATABASE OPEN;

Database opened.

--日志文件丢失(非current状态日志组)

SQL> startup

ORACLE instance started.

Total System Global Area251658240 bytes

Fixed Size1218796 bytes

Variable Size88082196 bytes

Database Buffers159383552 bytes

Redo Buffers2973696 bytes

Database mounted.

ORA-00313: open failed for members of log group 1 of thread 1

ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/orcl/redo1a.rdo'

ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/orcl/redo1b.rdo'

SQL> ALTER DATABASE CLEAR LOGFILE GROUP 1;

Database altered.

SQL> ALTER DATABASE OPEN;

Database altered.

--日志文件丢失(current状态日志组)

SQL