SQL> select * from v$log;    <-- current log파일정보 확인

SQL> select * from v$logfile;

SQL> !rm -f $HOME/oradata/HUMAN/redo01.log  <--current log파일 삭제

SQL> !rm -f $HOME/oradata/HUMAN/redo01b.rdo

$ ps -ef |grep human  <-- instance가 모두 죽었는지 확인

SQL> startup
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/home/human/oradata/HUMAN/redo01b.rdo'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 1 thread 1: '/home/human/oradata/HUMAN/redo01.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

SQL> select * from v$log;

-최근 Backup으로 부터 모든 datafile을 Restore
SQL> !cp $HOME/ONBACKUP/*.dbf $HOME/oradata/HUMAN/

-마지막 archived log의 file명 확인
SQL> !ls $HOME/arch/log  => 여기서는 46번
30.ARC  32.ARC  34.ARC  36.ARC  38.ARC  40.ARC  42.ARC  44.ARC  46.ARC
31.ARC  33.ARC  35.ARC  37.ARC  39.ARC  41.ARC  43.ARC  45.ARC

SQL> recover database until cancel;
ORA-00279: change 889205 generated at 07/25/2003 11:46:00 needed for thread 1
ORA-00289: suggestion : /home/human/arch/log/30.ARC
ORA-00280: change 889205 for thread 1 is in sequence #30


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel  => Return을 누르다가 위에서 확인한 Current번호에서 "cancel"을 입력

Media recovery cancelled.

2) Full backup의 수행
SQL> !rm $HOME/ARCH/*
SQL> @LABS/onlinebackup
SQL> alter sytem switch logfile;  <-- 4번 수행한다.