Home » RDBMS Server » Backup & Recovery » Recovery from the missing Current Redo Log Group
Recovery from the missing Current Redo Log Group [message #234557] Wed, 02 May 2007 02:38 Go to next message
Dipali Vithalani
Messages: 278
Registered: March 2007
Location: India
Senior Member

Hi friends,

oracle 10g, release 1.
OS RHEL 4.0
Archiving is disabled.

I had 3 redo log groups as listed following

group members status
---------------------------------------------------
1 redo01.log Active
2 redo02.log, redo22.log Clearing
3 redo03.log, redo13.log Current

I lost all the member logfiles of all the 3 groups.

Using ALTER TABLE.. CLEAR LOGFILE command, i recover group 1 and 2 members.

now, i have,

group members status
---------------------------------------------------
1 redo01.log Unused
2 redo02.log, redo22.log Unused
3 redo03.log, redo13.log Current

But, when i am trying to recover the third group using,
Alter database open resetlogs;
Got the error:
ORA-01139 : RESETLOGS options only valid after an incomplete database recovery..

When trying
Alter database open,
Errors returned are ORA-00313, ORA-00312 For log group 3 (which is current log group).

Please help me to get the database open..

Thanking you..
Re: Recovery from the missing Current Redo Log Group [message #234559 is a reply to message #234557] Wed, 02 May 2007 02:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ora-00312: online log %s thread %s: '%s'
 *Cause:  This message reports the filename for details of another message.
 *Action: Other messages will accompany this message. See the
          associated messages for the appropriate action to take.

ora-00313: open failed for members of log group %s of thread %s
 *Cause:  The online log cannot be opened. May not be able to find file.
 *Action: See accompanying errors and make log available.

So what were the "accompanying errors"?

Instead of saying what you did, post your session, then we will see.

Regards
Michel
Re: Recovery from the missing Current Redo Log Group [message #234562 is a reply to message #234559] Wed, 02 May 2007 02:56 Go to previous messageGo to next message
Dipali Vithalani
Messages: 278
Registered: March 2007
Location: India
Senior Member

I lost the current redo log files and not able to open the database because of it. Trying to recover or recreate it. But can't..

I read the error code description and try to google them but it didn't help..

So i am looking for the help here..

Please guide me how should i recover from this missing current redo log files..

(I read the documentation, previous posts of this forum and try to follow the steps as listed in previous message, but at the point of current redo log file, i am not getting it)

Thanks..

[Updated on: Wed, 02 May 2007 02:59]

Report message to a moderator

Re: Recovery from the missing Current Redo Log Group [message #234574 is a reply to message #234562] Wed, 02 May 2007 10:08 Go to previous messageGo to next message
Dipali Vithalani
Messages: 278
Registered: March 2007
Location: India
Senior Member

Hi,
I solved my problem, and get my database up...

Regards...
Re: Recovery from the missing Current Redo Log Group [message #234575 is a reply to message #234574] Wed, 02 May 2007 10:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And how did you solve it?

Regards
Michel
Re: Recovery from the missing Current Redo Log Group [message #234578 is a reply to message #234575] Wed, 02 May 2007 10:14 Go to previous messageGo to next message
Dipali Vithalani
Messages: 278
Registered: March 2007
Location: India
Senior Member

1)Using V$LOG, got the status of each group
In mount mode,
2) Clear the log groups which are not current,
3) recover database until cancel (This is what i missed and looking for the help)
4) Alter database open resetlogs;

Without doing step 3, i did step 4 and so was getting error
ORA-01139..

now, every thing is fine..

Regards...

Dipali
Re: Recovery from the missing Current Redo Log Group [message #234889 is a reply to message #234578] Thu, 03 May 2007 07:13 Go to previous messageGo to next message
sriram717
Messages: 48
Registered: February 2007
Location: UNITED KINGDOM
Member
Yes
OPEN RESETLOGS is valid only if you perform a cancel based recovery.
Re: Recovery from the missing Current Redo Log Group [message #234895 is a reply to message #234889] Thu, 03 May 2007 07:19 Go to previous messageGo to next message
saibal
Messages: 111
Registered: March 2007
Location: India
Senior Member
OPEN RESETLOGS is valid whenever you make an incomplete recovery!
Re: Recovery from the missing Current Redo Log Group [message #234957 is a reply to message #234895] Thu, 03 May 2007 09:43 Go to previous message
Dipali Vithalani
Messages: 278
Registered: March 2007
Location: India
Senior Member

dear, if you know that, then why didn't you tell.. I could sleep quitely..
Any ways, By finding it myself, i also got other concepts clear..


Regards..
Previous Topic: create standby database from RMAN
Next Topic: export failing
Goto Forum:
  


Current Time: Wed Dec 07 14:50:53 CST 2016

Total time taken to generate the page: 0.15777 seconds