| Online Log file is damaged Urgent!!!!!! [message #52075] |
Mon, 01 July 2002 17:39  |
llz
Messages: 14
Registered: June 2002
|
Junior Member |
|
|
Hi, Could anybody help me?
My Oracle DataBase Online Log file damaged, who can tell me how to restart Oracle? (I only have one Online Log File)
with My Best Regards!
|
|
|
|
| Re: Online Log file is damaged Urgent!!!!!! [message #52076 is a reply to message #52075] |
Mon, 01 July 2002 21:04  |
Hitesh
Messages: 12
Registered: October 2000
|
Junior Member |
|
|
hi
mount u r database do not open it
add logfile group then open the database with resetlogs.
steps
1) startup mount
2) alter database add logfile group 3 '/oracledb/log1'
size 100M
3) alter database drop logfile group 2
(damaged logfile)
4) alter database open resetlogs.
5) after this whole procedure give a bounce to database
regards
Hitesh
|
|
|
|
|
|
| DON'T DO THAT !!! [message #52086 is a reply to message #52082] |
Tue, 02 July 2002 05:25 |
B
Messages: 327
Registered: August 1999
|
Senior Member |
|
|
Don't do what sai has suggested ! Except if one of your datafile is corrupted ( REDO is not a datafile ).
shutdown the database ( cleanly if possible )
startup mount
drop the corrupted REDO
open database with resetlogs option ... Hope it works !
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
