ORA-00322, ORA-00312 troubleshooting

 
** Finance Bureau database Problems
Problem description
I received a call from **, saying that their database couldn't get up,
This error was reported from remote connection to his machine.
 

Log on to the database server remotely and view alert. Log
This error message is displayed.
Fri Oct 24 12:34:20 2008
Restarting dead background process qmn0
Qmn0 started with PID = 9
Shutting down instance: Further logons disabled
Shutting down instance (immediate)
License high water mark = 3
All dispatchers and shared servers Shutdown
Fri Oct 24 12:37:16 2008
Alter database close normal
ORA-1109 signalled during: Alter database close normal...
Fri Oct 24 12:37:16 2008
Alter database dismount
Completed: Alter database dismount
Arch: archiving is disabled
Shutting down archive Processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Arch: archiving is disabled
Shutting down archive Processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Fri Oct 24 12:41:07 2008
Starting Oracle instance (normal)
License_max_session = 0
License_sessions_warning = 0
SCN scheme 2
Using log_archive_dest parameter Default Value
License_max_users = 0
Sys auditing is disabled
Starting up Oracle RDBMS version: 9.2.0.4.0.
System Parameters with non-default values:
Processes = 150
Timed_statistics = true
Shared_pool_size = 83886080
Large_pool_size = 16777216
Java _ pool_size = 83886080
Control_files =/Oracle/oradata/yscz/control01.ctl,/Oracle/oradata/yscz/control02.ctl,/Oracle/oradata/yscz/control03.ctl
DB _ block_size = 8192
DB _ cache_size = 33554432
Compatible = 9.2.0.0.0
Db_file_multiblock_read_count = 16
Fast _start_mttr_target = 300
Undo_management = auto
Undo_tablespace = undotbs1
Undo_retention = 10800
Remote_login_passwordfile = exclusive
Db_domain =
Instance_name = yscz
Dispatchers = (Protocol = TCP) (Service = ysczxdb)
Job_queue_processes = 10
Hash_join_enabled = true
Background_dump_dest =/Oracle/admin/yscz/bdump
User_dump_dest =/Oracle/admin/yscz/udump
Core_dump_dest =/Oracle/admin/yscz/cdump
Sort_area_size = 524288
Db_name = yscz
Open_cursors = 300
Star_transformation_enabled = false
Query_rewrite_enabled = false
Pga_aggregate_target = 25165824
Aq_tm_processes = 1
Pmon started with PID = 2
Dbw0 started with PID = 3
Lgwr started with PID = 4
Ckpt started with PID = 5
SMON started with PID = 6
Reco started with PID = 7
Cjq0 started with PID = 8
Qmn0 started with PID = 9
Fri Oct 24 12:41:09 2008
Starting up 1 shared server (s )...
Starting up 1 dispatcher (s) for network address '(address = (partial = yes) (Protocol = TCP ))'...
Fri Oct 24 12:41:09 2008
Alter database Mount
Fri Oct 24 12:41:14 2008
Successful mount of redo thread 1, with the Mount ID 677969253.
Fri Oct 24 12:41:14 2008
Database mounted in exclusive mode.
Completed: Alter database Mount
Fri Oct 24 12:41:14 2008
Alter database open
Fri Oct 24 12:41:14 2008
Errors in file/Oracle/admin/yscz/bdump/yscz_lgwr_5281.trc:
ORA-00322: log 2 of thread 1 is not current copy
ORA-00312: Online log 2 thread 1: '/Oracle/oradata/yscz/redo02.log'
Fri Oct 24 12:41:14 2008
Errors in file/Oracle/admin/yscz/bdump/yscz_lgwr_5281.trc:
ORA-00322: log 2 of thread 1 is not current copy
ORA-00312: Online log 2 thread 1: '/Oracle/oradata/yscz/redo02.log'
ORA-322 signalled during: Alter database open...
Fri Oct 24 12:42:09 2008
Restarting dead background process qmn0
Qmn0 started with PID = 9
Fri Oct 24 12:44:57 2008
Starting Oracle instance (normal)
Fri Oct 24 12:45:04 2008
Shutting down instance: Further logons disabled
Shutting down instance (immediate)
License high water mark = 3
All dispatchers and shared servers Shutdown
Fri Oct 24 12:45:07 2008
Alter database close normal
ORA-1109 signalled during: Alter database close normal...
Fri Oct 24 12:45:07 2008
Alter database dismount
Completed: Alter database dismount
Arch: archiving is disabled
Shutting down archive Processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Arch: archiving is disabled
Shutting down archive Processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Fri Oct 24 12:46:36 2008
Starting Oracle instance (normal)
License_max_session = 0
License_sessions_warning = 0
SCN scheme 2
Using log_archive_dest parameter Default Value
License_max_users = 0
Sys auditing is disabled
Starting up Oracle RDBMS version: 9.2.0.4.0.
System Parameters with non-default values:
Processes = 150
Timed_statistics = true
Shared_pool_size = 83886080
Large_pool_size = 16777216
Java _ pool_size = 83886080
Control_files =/Oracle/oradata/yscz/control01.ctl,/Oracle/oradata/yscz/control02.ctl,/Oracle/oradata/yscz/control03.ctl
DB _ block_size = 8192
DB _ cache_size = 33554432
Compatible = 9.2.0.0.0
Db_file_multiblock_read_count = 16
Fast _start_mttr_target = 300
Undo_management = auto
Undo_tablespace = undotbs1
Undo_retention = 10800
Remote_login_passwordfile = exclusive
Db_domain =
Instance_name = yscz
Dispatchers = (Protocol = TCP) (Service = ysczxdb)
Job_queue_processes = 10
Hash_join_enabled = true
Background_dump_dest =/Oracle/admin/yscz/bdump
User_dump_dest =/Oracle/admin/yscz/udump
Core_dump_dest =/Oracle/admin/yscz/cdump
Sort_area_size = 524288
Db_name = yscz
Open_cursors = 300
Star_transformation_enabled = false
Query_rewrite_enabled = false
Pga_aggregate_target = 25165824
Aq_tm_processes = 1
Pmon started with PID = 2
Dbw0 started with PID = 3
Lgwr started with PID = 4
Ckpt started with PID = 5
SMON started with PID = 6
Reco started with PID = 7
Cjq0 started with PID = 8
Qmn0 started with PID = 9
Fri Oct 24 12:46:38 2008
Starting up 1 shared server (s )...
Starting up 1 dispatcher (s) for network address '(address = (partial = yes) (Protocol = TCP ))'...
Fri Oct 24 12:46:39 2008
Alter database Mount
Fri Oct 24 12:46:43 2008
Successful mount of redo thread 1, with the Mount ID 677927087.
Fri Oct 24 12:46:43 2008
Database mounted in exclusive mode.
Completed: Alter database Mount
Fri Oct 24 12:46:43 2008
Alter database open
Fri Oct 24 12:46:43 2008
Errors in file/Oracle/admin/yscz/bdump/yscz_lgwr_5323.trc:
ORA-00322: log 2 of thread 1 is not current copy
ORA-00312: Online log 2 thread 1: '/Oracle/oradata/yscz/redo02.log'
Fri Oct 24 12:46:43 2008
Errors in file/Oracle/admin/yscz/bdump/yscz_lgwr_5323.trc:
ORA-00322: log 2 of thread 1 is not current copy
ORA-00312: Online log 2 thread 1: '/Oracle/oradata/yscz/redo02.log'
ORA-322 signalled during: Alter database open...
Shutting down instance: Further logons disabled
Shutting down instance (immediate)
License high water mark = 3
All dispatchers and shared servers Shutdown
Fri Oct 24 12:46:54 2008
Alter database close normal
ORA-1109 signalled during: Alter database close normal...
Fri Oct 24 12:46:54 2008
Alter database dismount
Completed: Alter database dismount
Arch: archiving is disabled
Shutting down archive Processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Arch: archiving is disabled
Shutting down archive Processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Fri Oct 24 13:43:17 2008
Starting Oracle instance (normal)
License_max_session = 0
License_sessions_warning = 0
SCN scheme 2
Using log_archive_dest parameter Default Value
License_max_users = 0
Sys auditing is disabled

From the code above, it is found that the red part of the formal error source, the error number is ORA-00322 and ORA-00312;

View related documents from the Internet and provide a solution:

 

| | |

Today, an Oracle9i instance cannot be started and the following error occurs:
Ora-00322: log 1of thread 1 is not current copy
Ora-00312: Online log 1 thread 1: 'opt/Oracle/oradata/oradb/redo02.log'

The solution is as follows:
1. Shutdown immediate;
2. startup Mount;
3. Alter database clear logfile 'opt/Oracle/oradata/oradb/redo02.log ';
4. Alter database open;
5. Select status from V $ instance;
Oracle can be started normally;

| | |

After similar operations, the problem was solved.

Metalink

Problem description:
================================

You have a media failure, which causes the database to crash.

 
Problem explanation:
================================

At startup, the database will mount, but gives the following errors at open:

ORA-00312: "online log % s thread % s: '% S '"
Cause: This message reports the filename for details of another message.
Action: other messages will accompany this message. See
Associated messages for the appropriate action to take.

ORA-00322: "log % s of thread % s is not current copy"
Cause: Check of Log File Header at database open found that an online log
Appears to be an incorrectly restored backup.
Action: restore correct file or reset logs.

Search words:
==================

Hardware, recover

Solution description:
==================================

First check that ORACLE_HOME and oracle_sid are set correctly, and if not, do
So and re-start. Else, continue as follows.

Recover the loss of an inactive, online redo log group.

Alter database clear logfile 'filename ';

If there is more than one logfile in the redo log group then you must
Specify all the log files.

For example, the following fails:

Svrmgr> alter database clear logfile '/vobs/Oracle/dbs/log3.log ';
Alter database clear logfile '/vobs/Oracle/dbs/log3.log'
*
The ORA-1514: Error in log specification: no such log
ORA-1517: log Member: '/vobs/Oracle/dbs/log3.log

But, specifying all the log files in the group works:
Svrmgr> alter database clear logfile ('/vobs/Oracle/dbs/t4.log','/vobs/Oracle /;
Statement processed.

For more information Ref: Bug 763186

 
Solution explanation:
==================================
 
The database, at open, does a check of log file headers and
Found an online log that appears to be an incorrected restored file.
In this case it was not incorrect, but inactive. By issuing
The clear logfile, you can avoid going through an uneccessary
Open resetlogs when applicable.