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’; […]
Articles Tagged: RECOVER
Restore and Backup the current OLR
Backup current OLR and all available OLR backups # ocrconfig -local -manualbackup rac1 2017/03/01 20:52:12 /u01/app/grid/cdata/rac1/backup_20170301_205212.olr Verify available backups # ocrconfig -local -showbackup rac1 2017/03/01 20:52:12 /u01/app/grid/cdata/rac1/backup_20170301_205212.olr Verify available backups from OS # ls -l /u01/app/grid/cdata/rac1/* -rw——-. 1 root root 6803456 Feb 12 13:04 /u01/app/grid/cdata/rac1/backup_20170212_130457.olr -rw——-. 1 root root 7016448 Mar 01 09:08 /u01/app/grid/cdata/rac1/backup_20170301_090842.olr […]