Home » RDBMS Server » Server Administration » redologfile
redologfile [message #239604] Tue, 22 May 2007 13:48 Go to next message
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 #239608 is a reply to message #239604] Tue, 22 May 2007 13:52 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
do you have any other member of that group??
Re: redologfile [message #239616 is a reply to message #239608] Tue, 22 May 2007 14:36 Go to previous messageGo to next message
bksrisai
Messages: 30
Registered: May 2007
Location: hyderabad
Member

no, iam not having any other member
Re: redologfile [message #239645 is a reply to message #239616] Tue, 22 May 2007 23:17 Go to previous messageGo to next message
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 #239768 is a reply to message #239645] Wed, 23 May 2007 04:49 Go to previous messageGo to next message
bksrisai
Messages: 30
Registered: May 2007
Location: hyderabad
Member

thanks i will try and i will give u the reply
Re: redologfile [message #240458 is a reply to message #239645] Thu, 24 May 2007 22:43 Go to previous messageGo to next message
bksrisai
Messages: 30
Registered: May 2007
Location: hyderabad
Member

but i deleted both the logfiles no backup is there, if i deleted one logfile i will recover, but i lost both the logfiles
Re: redologfile [message #240459 is a reply to message #239604] Thu, 24 May 2007 22:51 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
Without a recent GOOD backup, you are in a place that I hope I never find myself.
At a minimum you should take a complete COLD backup of what you have now.
There is an "undocumented parameter" that just might allow you to open the database & take an export.
Re: redologfile [message #240469 is a reply to message #240458] Fri, 25 May 2007 00:16 Go to previous messageGo to next message
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
Re: redologfile [message #240475 is a reply to message #240469] Fri, 25 May 2007 00:28 Go to previous message
bksrisai
Messages: 30
Registered: May 2007
Location: hyderabad
Member

thanks for your reply, i will get back to you

regards
kiran...
Previous Topic: sqlplus
Next Topic: user to user grant
Goto Forum:
  


Current Time: Fri Dec 02 18:37:09 CST 2016

Total time taken to generate the page: 0.30906 seconds