1) Failure를 만든다

SQL> !date
2003. 07. 30. (수) 17:53:03 KST

SQL> drop table hr.emphist;

Table dropped.

SQL> shutdown immediate;

2) Recovery 시작

$NLS_DATE_FORMAT='RRRR-MM-DD:HH24:MI:SS'; export NLS_DATE_FORMAT

$ vi LABS/incomplete_recovery.rmn
replace script incomplete_recovery {
      set until time '2003-07-30:17:52:19';
      restore database;
      recover database;
      sql 'alter database open resetlogs';
    }


$ rman target \'sys/oracle as sysdba\' catalog rmanhan/rmanhan@ora920

RMAN> startup mount

RMAN> @LABS/incomplete_recovery.rmn

RMAN> run { execute script incomplete_recovery;}

4) 정상인가 확인

SQL> select count(*) from hr.emphist;

RMAN> reset database;

RMAN> list incarnation of database;

5) whole backup을 수행

RMAN> delete noprompt backup;

RMAN> run {execute script backup_database;}

RMAN> run {host 'ls $HOME/RMANBACKUP/*';}