컨트롤 파일복구 3-1

redo log file까지 손상이 있을 경우 resetlogs 모드로 재생성

SYS>startup

ORACLE instance started.

Total System Global Area  422670336 bytes

Fixed Size                  1344616 bytes

Variable Size             293604248 bytes

Database Buffers          121634816 bytes

Redo Buffers                6086656 bytes

Database mounted.

ORA-01122: database file 1 failed verification check

ORA-01110: data file 1: '/data/temp7/system01.dbf'

ORA-01207: file is more recent than control file - old control file

SYS>alter database backup controlfile to trace as '/app/oracle/back.sql';

Database altered.

SYS>shut immediate

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.