-
Online Rego-log
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
Vijay.s
-
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.
-nagarjuna
-
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.
www.cnoug.org
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|