Restore and Recovery of Redo log files complete loss in 11gR2

1.. Check name , open mode and log mode of database

100.png

2..  Check online redo log file group, redo log file name and size

101.png

3..  To simulate go to redo log location and delete redo log file

102.png

4..  Check Archive log is enabled or not

103.png

5.. Alter switch syntax will hang

104.png

Error in Alert log will be appearing like given below

105.png

6.. Archive log generated prior to loss of redo log file

106

7.. To recover loss of redo log files connect to rman shutdown the database and startup in mount mode

107.png

109.png

8.. Using set until sequence restore,recover and open database resetlogs;

110.png

9.. Once restore and recovery of redo log file is complete,navigate to the directory of redo log file and check redo log file which were deleted are restored and recovered at OS level also

111.png

Happy Learning !!!!

 

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s