| redologfile [message #239604] |
Tue, 22 May 2007 13:48  |
bksrisai
Messages: 30
Registered: May 2007
Location: hyderabad
|
Member |
|
|
hi i got a problem?
i deleted my logfile after that at startup nomount i given recover database using backup controlfile until cancel at this point it is showing error that media recovery required for system.dbf, then i given recover database but still it is showing error that more media recovery needed to maintain database consistent,
plz can anyone help me in this matter?
|
|
|
|
|
|
|
|
| Re: redologfile [message #239645 is a reply to message #239616] |
Tue, 22 May 2007 23:17  |
Dipali Vithalani
Messages: 278
Registered: March 2007
Location: India
|
Senior Member |
|
|
hi,
Oracle needs atleast two logfiles to be opened..
You have to recover the deleted logfile,
If the deleted logfile was not the current logfile, then clear it, using
alter dtabase clear logfile group <groupno>
(Db should be in mount mode)
Then apply
Recover database until cancel
Alter database open resetlogs..
(this is required to recover the loss of current redo log file)
May this helps you..
Regards..
[Updated on: Tue, 22 May 2007 23:17] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: redologfile [message #240469 is a reply to message #240458] |
Fri, 25 May 2007 00:16 |
Dipali Vithalani
Messages: 278
Registered: March 2007
Location: India
|
Senior Member |
|
|
hi,
It's ok, even if you have deleleted all the redo log files..
Don't worry, be patient and try the following steps. i had try them for the same case study. so i hope this might be useful to you too..
1) Shutdown the database if it's open.
If possible, use 'shutdown immediate' else do it with ' shutdown abort'.
2) startup mount
3)select * from v$log;
Fire this query to find which group is current.
Suppose we found following from the result.
Group 1 - inactive
group 2 - current
group 3 - unused
4)Clear all the groups which are not current using 'alter database...' command.
In our case,
alter database clear logfile group 1;
alter database clear logfile group 3;
4)Apply following command :
recover database until cancel;
5)Next, apply following command :
Alter database open resetlogs;
Follow this five steps. I have tried them many times for such case study, and successfully solve the case. and i hope your problem will also be sloved..
Try this and don't forget to tell the result..
Regards..
Dipali
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
