[ORA11g] Recovery with Data files ONLY except Control file, Redo log files

/******************************************************************************************************
-- Title : [ORA11g] Restore DB with Data files ONLY except Control file & Redo log files
-- Reference : promaster.tistory.com 박0훈 흑풍전설
-- Key word : oracle 오라클 복구
******************************************************************************************************/

/*****************************************

-- 1. DATA FILE 만 빼고 나머지 전부 삭제.

*****************************************/

-- control/log file 확인/삭제

select name from v$controlfile;

select member from v$logfile;

-- shutdown db

shutdown immediate;

-- file 삭제

# rm -rf /home/oracle/oracle/oradata/INFRAORA/control01.ctl

# rm -rf /home/oracle/oracle/flash_recovery_area/INFRAORA/control02.ctl

# rm -rf /home/oracle/oracle/oradata/INFRAORA/redo03.log

# rm -rf /home/oracle/oracle/oradata/INFRAORA/redo02.log

# rm -rf /home/oracle/oracle/oradata/INFRAORA/redo01.log

/*****************************************

-- 2. nomount 로 들어가서 control file 작성하고 , resetlogs 처리로 open

*****************************************/

-- startup db until nomount

startup nomount;

-- execte script as below:

CREATE CONTROLFILE

DATABASE INFRAORA

LOGFILE

  GROUP 1 '/home/oracle/oracle/oradata/INFRAORA/redo01.log'  SIZE 50M,

  GROUP 2 '/home/oracle/oracle/oradata/INFRAORA/redo02.log'  SIZE 50M,

  GROUP 3 '/home/oracle/oracle/oradata/INFRAORA/redo03.log'  SIZE 50M

resetlogs

DATAFILE

  '/home/oracle/oracle/oradata/INFRAORA/system01.dbf',

  '/home/oracle/oracle/oradata/INFRAORA/sysaux01.dbf',

  '/home/oracle/oracle/oradata/INFRAORA/undotbs01.dbf',

  '/home/oracle/oracle/oradata/INFRAORA/users01.dbf',

  '/home/oracle/oracle/oradata/INFRAORA/example01.dbf'

;

-- db open

alter database open resetlogs;