; 15-NOV-05 MOUNTED NO 1 STARTED
ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL
SQL> set linesize 132
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
1 1 62 2097152 1 NO INVALIDATED 658443 15-NOV-05
2 1 0 2097152 1 YES UNUSED 0 15-NOV-05
3 1 61 2097152 1 YES INACTIVE 649920 15-NOV-05
SQL> col member for a100
SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER
---------- ------- ------- ----------------------------------------------------------------------------------------------------
1 ONLINE /oracle/oradata/TSMISC02/redo01.log
2 ONLINE /oracle/oradata/TSMISC02/redo02.log
3 ONLINE /oracle/oradata/TSMISC02/redo03.log
SQL>
检查alert日志：
Tue Nov 15 11:30:13 2005
Started first pass scan
Tue Nov 15 11:30:13 2005
Errors in file /oracle/admin/TSMISC02/udump/tsmisc02_ora_29582.trc:
ORA-00316: log 1 of thread 1, type 0 in header is not log file
ORA-00312: online log 1 thread 1: ''''/oracle/oradata/TSMISC02/redo01.log''''
ORA-316 signalled during: ALTER DATABASE OPEN...
Tue Nov 15 11:31:09 2005
Restarting dead background process QMN0
QMN0 started with pid=9
Tue Nov 15 11:36:10 2005
Restarting dead background process QMN0
QMN0 started with pid=9
Tue Nov 15 11:41:11 2005
Restarting dead background process QMN0
QMN0 started with pid=9
Tue Nov 15 11:46:12 2005
Restarting dead background process QMN0
QMN0 started with pid=9
Tue Nov 15 11:51:13 2005
Restarting dead background process QMN0
QMN0 started with pid=9
Tue Nov 15 11:56:14 2005
Restarting dead background process QMN0
QMN0 started with pid=9
。。。
相关trace文件内容：
[oracle@ts01 udump]$ ll tsmisc02_ora_29582.trc
-rw-r----- 1 oracle oinstall 912 Nov 15 11:30 tsmisc02_ora_29582.trc
[oracle@ts01 udump]$ cat tsmisc02_ora_29582.trc
/oracle/admin/TSMISC02/udump/tsmisc02_ora_29582.trc
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
ORACLE_HOME = /oracle/product/920
System name: Linux
Node name: ts01
Release: 2.4.21-4.EL
Version: #1 Fri Oct 3 18:13:58 EDT 2003
Machine: i686
Instance name: TSMISC02
Redo thread mounted by this instance: 1
Oracle process number: 14
Unix process pid: 29582, image: oracle@ts01 (TNS V1-V3)
*** SESSION ID:(11.3) 2005-11-15 11:30:13.297
Thread checkpoint rba:0x00003e.00000002.0010 scn:0x0000.000a0c0b
On-disk rba:0x00003e.00000c1e.0000 scn:0x0000.000a257e
Use incremental checkpoint cache-low RBA
Thread 1 recovery from rba:0x00003e.0000095f.0000 scn:0x0000.00000000
ORA-00316: log 1 of thread 1, type 0 in header is not log file
ORA-00312: online log 1 thread 1: ''''/oracle/oradata/TSMISC02/redo01.log''''
[oracle@ts01 udump]$
SQL> alter database clear logfile group 1;
alter database clear logfile group 1
*
ERROR at line 1:
ORA-01624: log 1 needed for crash recovery of thread 1
ORA-00312: online log 1 thread 1: ''''/oracle/oradata/TSMISC02/redo01.log''''
SQL> alter database clear unarchived logfile group 1;
alter database clear unarchived logfile group 1
*
ERROR at line 1:
ORA-01624: log 1 needed for crash recovery of thread 1
ORA-00312: online log 1 thread 1: ''''/oracle/oradata/TSMISC02/redo01.log''''
SQL>
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /oracle/oradata/TSMISC02/archive
Oldest online log sequence 61
Next log sequence to archive 62
Current log sequence 62
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
1 1 62 2097152 1 NO INVALIDATED 658443 15-NOV-05
2 1 0 2097152 1 YES UNUSED 0 15-NOV-05
3 1 61 2097152 1 YES INACTIVE 649920 15-NOV-05
SQL>
断定，损坏的是current 的日志。
上一页 [1] [2] | 
