Current group ie. on which LGWR is currently writing and it gets corrupted or dropeed by mistake then do recover as mentioned below:
1) check the status of redo group by v$log.
2) shut immediate
3) copy that missing redo from backup location
4) startup mount
5) recover database until cancel
6) alter database open resetlogs
7) check the sequence it started from zero.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment