Oracle Control 파일 백업 및 복구

1. Control 파일 SQL 형식으로 백업 (/tmp/backup.trc)

$ sqlplus / as sysdba

 SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE
   AS '/tmp/backup.trc';



2. /tmp/backup.trc 파일에서 필요한 부분만 추출해서 /tmp/resotre.sql로 저장

CREATE CONTROLFILE REUSE DATABASE "GATEONE" NORESETLOGS  NOARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 2336
LOGFILE
  GROUP 1 '/opt/gate1/Engine/oracle/oradata/GATEONE/redo01.log'  SIZE 50M BLOCKSIZE 512,
  GROUP 2 '/opt/gate1/Engine/oracle/oradata/GATEONE/redo02.log'  SIZE 50M BLOCKSIZE 512,
  GROUP 3 '/opt/gate1/Engine/oracle/oradata/GATEONE/redo03.log'  SIZE 50M BLOCKSIZE 512
DATAFILE
  '/opt/gate1/Engine/oracle/oradata/GATEONE/system01.dbf',
  '/opt/gate1/Engine/oracle/oradata/GATEONE/sysaux01.dbf',
  '/opt/gate1/Engine/oracle/oradata/GATEONE/system02.dbf',
  '/opt/gate1/Engine/oracle/oradata/GATEONE/users01.dbf',
  '/opt/gate1/Engine/oracle/oradata/GATEONE/example01.dbf',
  '/opt/gate1/Engine/oracle/oradata/GATEONE/undotbs02.dbf'
CHARACTER SET AL32UTF8



3. /tmp/restore.sql 실행

SQL> @/tmp/restore.sql