; 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] 没有相关教程
|