-
Redo Log Error
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
Rgds
Vijay.s
-
Re: Redo Log Error
Any other messages in Oracle database alert log ? If not, why do you care anyway its NOT in ARCHIVE MODE.
Reddy,Sam
-
sdreddy,
IN MY alter log also it is showing the same..
I COULD start the database in STARTUP MOUNT...But if i issue ALTER DATABASE OPEN it is throwing this error, also if i issue SWITCH also it is throwing same error..
can you give me a steps of what i should i do to bring back my database.
urgent pls.
Rgds
Vijay.s
-
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 ...
Vijay.s
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
|