Home » RDBMS Server » Backup & Recovery » loss of current redo-log group.
loss of current redo-log group. [message #400222] Mon, 27 April 2009 03:47 Go to next message
tridentadm
Messages: 142
Registered: March 2006
Senior Member
what is the scenario if the current redo-log is got corrupted.


I was checking the B&R guide/doc and found only scenario :
Losing an Active Online Redo Log Group

but nothing for 'Losing an Current Online Redo Log Group' ??

any suggestions or links.



--
Also 1 more question : In RMAN do we have a limit to the number of channels ?

[Updated on: Mon, 27 April 2009 04:20]

Report message to a moderator

Re: loss of current redo-log group. [message #400235 is a reply to message #400222] Mon, 27 April 2009 04:14 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Recovering After the Loss of Online Redo Log Files: Scenarios

Regards
Michel
Re: loss of current redo-log group. [message #400328 is a reply to message #400222] Mon, 27 April 2009 11:47 Go to previous messageGo to next message
tridentadm
Messages: 142
Registered: March 2006
Senior Member
Yes I found that it was :
SQL> alter database clear logfile group <num>;


But there is a possibility the database could be hung if the current loggroup is damaged ?
So, in that case whats the way ?

SQL> startup mount;
SQL> restore database;
SQL> recover database;
sql> alter database open;


is this correct ?

Re: loss of current redo-log group. [message #400329 is a reply to message #400328] Mon, 27 April 2009 11:54 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You didn't read the link, the answer is CLEARLY mentioned you just have to read it.

Regards
Michel
Previous Topic: make a copy/backup without setting in hot backup mode. ?
Next Topic: recovering after loss of rman catalog
Goto Forum:
  


Current Time: Fri Dec 09 15:26:01 CST 2016

Total time taken to generate the page: 0.08516 seconds