Scenario 1 – Recover a Member of a Multiplexed Online Redo Log Group

Please follow the below steps. Steps : 1. Shutdown immediate; 2. Physically remove redo log member(no redo log group) by using OS level command. 3. Startup; 4. SELECT GROUP#, STATUS, MEMBER FROM v$LOGFILE WHERE STATUS=’INVALID’; 5. Check alert log file. Steps for Recovery : 1. Drop the damaged member ALTER DATABASE DROP LOGFILE MEMBER ‘D:\app\admin\oradata\orcl\REDO01.LOG’; […]

Read More

Restore and Backup the current OLR

Backup current OLR and all available OLR backups

Verify available backups

Verify available backups from OS

Restore  OLR from Current Backup. Shutdown CRS and check that ohasd.bin process is not running and restore OLR

Read More