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

Catalog Database Configure

Description:    RDB1 as TARGET SERVER                         RDB2 as CATALOG SERVER  create a database using DBCA on catalog server as catalog database i.e. RDB create a service in target server for the catalog server connection. check service alias using TNSPING servicename(EX:TNSPING RDB2) in terminal […]

Read More