OraFAQ Forum: Backup & Recovery » Recovery from the missing Current Redo Log Group

Home » RDBMS Server » Backup & Recovery » Recovery from the missing Current Redo Log Group

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Recovery from the missing Current Redo Log Group [message #234557]

Wed, 02 May 2007 02:38

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..

Report message to a moderator

Re: Recovery from the missing Current Redo Log Group [message #234559 is a reply to message #234557]

Wed, 02 May 2007 02:47

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Recovery from the missing Current Redo Log Group [message #234562 is a reply to message #234559]

Wed, 02 May 2007 02:56

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

Dipali Vithalani
Messages: 278
Registered: March 2007
Location: India

Senior Member

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

Regards...

Report message to a moderator

Re: Recovery from the missing Current Redo Log Group [message #234575 is a reply to message #234574]

Wed, 02 May 2007 10:09

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And how did you solve it?

Regards
Michel

Report message to a moderator

Re: Recovery from the missing Current Redo Log Group [message #234578 is a reply to message #234575]

Wed, 02 May 2007 10:14

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

Report message to a moderator

Re: Recovery from the missing Current Redo Log Group [message #234889 is a reply to message #234578]

Thu, 03 May 2007 07:13

sriram717
Messages: 48
Registered: February 2007
Location: UNITED KINGDOM

Member

Yes
OPEN RESETLOGS is valid only if you perform a cancel based recovery.

Report message to a moderator

Re: Recovery from the missing Current Redo Log Group [message #234895 is a reply to message #234889]

Thu, 03 May 2007 07:19

saibal
Messages: 111
Registered: March 2007
Location: India

Senior Member

OPEN RESETLOGS is valid whenever you make an incomplete recovery!

Report message to a moderator

Re: Recovery from the missing Current Redo Log Group [message #234957 is a reply to message #234895]

Thu, 03 May 2007 09:43

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..

Report message to a moderator

Previous Topic:	create standby database from RMAN
Next Topic:	export failing

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 21:36:31 CST 2024