|
|
IOTN :: Field Book :: ORACLE 
|
|
ORA-16038, ORA-00354, ORA-00353, ORA-16014, Archiver process freed from errors. No longer stopped
|
|
최길호
[LIST]
|
2008-06-28 22:29:23, 조회 : 34,710 |
Linux 4U5 Linux 10.2 32bit
SQL> alter system switch logfile; [ archivelog, hang ]
alert.log
================================================================
Sat Jun 28 21:48:42 2008
ALTER DATABASE OPEN
Sat Jun 28 21:48:42 2008
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=15, OS id=11046
Sat Jun 28 21:48:42 2008
ARC0: Becoming the heartbeat ARCH
Sat Jun 28 21:48:42 2008
SMON: enabling cache recovery
Sat Jun 28 21:48:42 2008
ARC1: Log corruption near block 2 change 3740236401 time ?
Sat Jun 28 21:48:42 2008
Errors in file /tool/oracle/admin/ORA10G/bdump/ORA10G_arc1_11048.trc:
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 2 change 3740236401 time 06/28/2008 19:34:42
ORA-00312: online log 1 thread 1: '/SYSTEM/oradata/redo01.log'
ARC1: All Archive destinations made inactive due to error 354
Sat Jun 28 21:48:42 2008
ARC1: Closing local archive destination LOG_ARCHIVE_DEST_1: '/BACK/arch/1_657578465_1942.arc' (error 354)
(ORA10G)
Committing creation of archivelog '/BACK/arch/1_657578465_1942.arc' (error 354)
ARCH: Archival stopped, error occurred. Will continue retrying
Sat Jun 28 21:48:42 2008
ORACLE Instance ORA10G - Archival Error
Sat Jun 28 21:48:42 2008
ORA-16038: log 1 sequence# 1942 cannot be archived
ORA-00354: corrupt redo log block header
ORA-00312: online log 1 thread 1: '/SYSTEM/oradata/redo01.log'
Sat Jun 28 21:48:42 2008
Errors in file /tool/oracle/admin/ORA10G/bdump/ORA10G_arc1_11048.trc:
ORA-16038: log 1 sequence# 1942 cannot be archived
ORA-00354: corrupt redo log block header
ORA-00312: online log 1 thread 1: '/SYSTEM/oradata/redo01.log'
Sat Jun 28 21:48:42 2008
ARCH: Archival stopped, error occurred. Will continue retrying
Sat Jun 28 21:48:42 2008
ORACLE Instance ORA10G - Archival Error
Sat Jun 28 21:48:42 2008
ORA-16014: log 1 sequence# 1942 not archived, no available destinations
ORA-00312: online log 1 thread 1: '/SYSTEM/oradata/redo01.log'
Sat Jun 28 21:48:42 2008
Errors in file /tool/oracle/admin/ORA10G/bdump/ORA10G_arc0_11046.trc:
ORA-16014: log 1 sequence# 1942 not archived, no available destinations
ORA-00312: online log 1 thread 1: '/SYSTEM/oradata/redo01.log'
Sat Jun 28 21:48:42 2008
Successfully onlined Undo Tablespace 1.
Sat Jun 28 21:48:42 2008
SMON: enabling tx recovery
Sat Jun 28 21:48:42 2008
Database Characterset is KO16KSC5601
Opening with internal Resource Manager plan
where NUMA PG = 1, CPUs = 16
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=17, OS id=11052
Sat Jun 28 21:48:42 2008
Completed: ALTER DATABASE OPEN
--- [ SQL> alter system switch logfile; ] --
Sat Jun 28 21:49:42 2008
Thread 1 advanced to log sequence 1949 (LGWR switch)
Current log# 2 seq# 1949 mem# 0: /SYSTEM/oradata/redo02.log
Sat Jun 28 21:49:42 2008
Archiver process freed from errors. No longer stopped
Sat Jun 28 21:52:01 2008
Shutting down instance: further logons disabled
조치
================================================================
SQL> alter database noarchivelog;
SQL> alter database open;
SQL> alter system switch logfile; -- noarchive mode에서 redolog file 모두 clear
SQL> alter system switch logfile;
SQL> alter system switch logfile;
SQL> alter system switch logfile;
SQL> shutdown, startup mount;
SQL> alter database archivelog ;
SQL> alter database open;
SQL> alter system switch logfile; -- alert.log 확인, hang 확인
|
3.235.60.197
|
|
|
|
Copyright 1999-2023 Zeroboard / skin by 최길호(gilho.kr@gmail.com)
|
|
|
12/01 