Online Rego-log

[vbaskar]

NEED AN URGENT HELP BOSS..

These are the setups and error messages and it is not in archive mode.

NOS : Novel Netware 5.1

Oralce : version no is 8.1.7

Message :

00314 : log 1 of thread 1 , expected sequence # 40683 doesn't match # 40685

00312 : online log 1 thread 1 : '%path%' log2orcl.ora

system is asking for a immediate recovery of the logfile


i could able to issue STARTUP MOUNT...



My alter log..

Fri Mar 14 19:54:40 2003 -
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
archiving is disabled
Starting up ORACLE RDBMS Version: 8.1.7.2.0.
System parameters with non-default values:
processes = 600
timed_statistics = FALSE
shared_pool_size = 67108864
control_files = ORABACK:\OraHome1\ORADATA\ORACLE\ctl1orcl.ora
db_block_buffers = 2000
db_block_size = 2048
compatible = 8.1.0.0.0
log_buffer = 8192
log_checkpoint_interval = 10000
db_files = 1024
db_file_multiblock_read_count= 8
remote_login_passwordfile= SHARED
global_names = TRUE
db_name = oracle
open_cursors = 400
os_authent_prefix =
job_queue_processes = 1
parallel_max_servers = 5
background_dump_dest = ORABACK:\OraHome1\ADMIN\ORACLE\BDUMP
user_dump_dest = ORABACK:\OraHome1\ADMIN\ORACLE\UDUMP
max_dump_file_size = 10240
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
SNP0 started with pid=8
Sat Mar 15 10:44:32 2003 -
alter database mount
Sat Mar 15 10:44:36 2003 -
Successful mount of redo thread 1, with mount id 1361783764.
Sat Mar 15 10:44:36 2003 -
Database mounted in Exclusive Mode.
Completed: alter database mount
Sat Mar 15 10:44:36 2003 -
alter database open
Beginning crash recovery of 1 threads
Sat Mar 15 10:44:36 2003 -
Thread recovery: start rolling forward thread 1
Sat Mar 15 10:44:36 2003 -
Errors in file ORABACK:\OraHome1\ADMIN\ORACLE\UDUMP\00000248.TRC:
ORA-00314: log 1 of thread 1, expected sequence# 40683 doesn't match 40685
ORA-00312: online log 1 thread 1: 'ORABACK:ORAHOME1\ORADATA\ORACLE\LOG2ORCL.ORA'

ORA-314 signalled during: alter database open ...

Rgds

[nagarjuna]

Try this,

Query using

select first_change#, member from v$log a, v$logfile b
where a.Group#=b.Group#
order by 1
/

From the output of the query, you can findout which logfile contains the required sequence #. Supply this logfile at the prompt of media recovery. (recover database).

Pls do follow the requierd steps before starting the activity, like taking a backup of the database, backup controlfile to trace etc.

[chao_ping]

If he can clear the logfile , it should be ok.
Or, try recreate the controlfile, if it is just because controlfile and redo log are inconsistent.

If neither of the above steps work, he have to restore full db and do incomplete recovery, and open resetlogs that database.

[pando]

quoted from asktom.oracle.com for your same post

Reviewer: Vj from india

These are the setups and error messages and it is not in archive mode.

NOS : Novel Netware 5.1
Oracle : version no is 8.1.7

Message :

00314 : log 1 of thread 1 , expected sequence # 40683 doesn't match # 40685

00312 : online log 1 thread 1 : '%path%' log2orcl.ora

system is asking for a immediate recovery of the logfile

PLEASE HELP


i could able to startup mount.

Rgds


Followup:
contact support. insufficient data -- don't panic, file a tar.