1) 정상적인 업무 수행
$sqlplus '/as sysdba'
SQL> @LABS/moreemphist

2) Failure 만든다

SQL> !rm $HOME/oradata/HUMAN/system01.dbf

SQL> shutdown immediate

$sqlplus '/as sysdba'

SQL> startup
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '/home/human/oradata/HUMAN/system01.dbf'

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

RMAN> run {host "cat $HOME/LABS/system_tbs_recovery.rmn";}

replace script system_tbs_recovery {
      restore database;
      recover database;
      sql 'alter database open';
}

RMAN> startup mount

RMAN> @/home/human/LABS/system_tbs_recovery.rmn

RMAN> run { execute script system_tbs_recovery;}

4) 정상인가 확인
SQL> select * from hr.emphist;