1.查看当前日志组状态
SYS@PROD1>select group#,members,status from v$log;

GROUP# MEMBERS STATUS
---------- ---------- ----------------
1 2 CURRENT
2 2 UNUSED
3 2 UNUSED

SYS@PROD1>select group#,member from v$logfile order by 1,2;

GROUP# MEMBER
---------- --------------------------------------------------
1 /u01/app/oracle/oradata/PROD1/redo01.log
1 /u01/app/oracle/oradata/PROD1/redo01_a.log
2 /u01/app/oracle/oradata/PROD1/redo02.log
2 /u01/app/oracle/oradata/PROD1/redo02_a.log
3 /u01/app/oracle/oradata/PROD1/redo03.log
3 /u01/app/oracle/oradata/PROD1/redo03_a.log

切换一下日志组
SYS@PROD1>alter system switch logfile;

System altered.

SYS@PROD1>select group#,members,status from v$log;

GROUP# MEMBERS STATUS
---------- ---------- ----------------
1 2 ACTIVE
2 2 CURRENT
3 2 UNUSED

SYS@PROD1>alter system switch logfile;

System altered.

SYS@PROD1>select group#,members,status from v$log;

GROUP# MEMBERS STATUS
---------- ---------- ----------------
1 2 ACTIVE
2 2 ACTIVE
3 2 CURRENT

SYS@PROD1>alter system checkpoint;

System altered.

SYS@PROD1>select group#,members,status from v$log;

GROUP# MEMBERS STATUS
---------- ---------- ----------------
1 2 INACTIVE
2 2 CURRENT
3 2 INACTIVE

2.删除第3组日志组成员
[oracle@host01 PROD1]$ ls redo*
redo01_a.log redo01.log redo02_a.log redo02.log redo03_a.log redo03.log
[oracle@host01 PROD1]$ rm redo03_a.log redo03.log

3.重启数据库
SYS@PROD1>shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SYS@PROD1>startup;
ORACLE instance started.

Total System Global Area 835104768 bytes
Fixed Size 2257840 bytes
Variable Size 520096848 bytes
Database Buffers 310378496 bytes
Redo Buffers 2371584 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 22200
Session ID: 1 Serial number: 5

4.查看告警日志
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/prod1/PROD1/trace/PROD1_ora_22200.trc:
ORA-00313: open failed for members of log group 1 of thread
ORA-00312: online log 3 thread 1: '/u01/app/oracle/oradata/PROD1/redo03.log'
ORA-00312: online log 3 thread 1: '/u01/app/oracle/oradata/PROD1/redo03_a.log'

5.启动数据库到mount状态
[oracle@host01 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Fri Dec 16 16:07:51 2016

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to an idle instance.

SYS@PROD1>startup mount;
ORACLE instance started.

Total System Global Area 835104768 bytes
Fixed Size 2257840 bytes
Variable Size 520096848 bytes
Database Buffers 310378496 bytes
Redo Buffers 2371584 bytes
Database mounted.

6.clear修复日志文件
clear的动作就是在操作系统redo日志对应路径下创建日志文件，只是创建的文件是新的，且是未使用过的
SYS@PROD1>alter database clear logfile group 3;

Database altered.

[oracle@host01 PROD1]$ ls redo*
redo01_a.log redo01.log redo02_a.log redo02.log redo03_a.log redo03.log

7.打开数据库
SYS@PROD1>alter database open;

Database altered.

再次验证
SYS@PROD1>select group#,members,archived,status from v$log;

GROUP# MEMBERS ARC STATUS
---------- ---------- --- ----------------
1 2 YES INACTIVE
2 2 NO CURRENT
3 2 YES UNUSED

SYS@PROD1>col member for a50;
SYS@PROD1>select group#,member from v$logfile;

GROUP# MEMBER
---------- --------------------------------------------------
3 /u01/app/oracle/oradata/PROD1/redo03.log
2 /u01/app/oracle/oradata/PROD1/redo02.log
1 /u01/app/oracle/oradata/PROD1/redo01.log
1 /u01/app/oracle/oradata/PROD1/redo01_a.log
2 /u01/app/oracle/oradata/PROD1/redo02_a.log
3 /u01/app/oracle/oradata/PROD1/redo03_a.log

6 rows selected.

ITPub博客

恢复已归档重做日志

最新文章