| loss of current redo-log group. [message #400222] |
Mon, 27 April 2009 03:47  |
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 #400328 is a reply to message #400222] |
Mon, 27 April 2009 11:47  |
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 ?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
