1) 정상업무 수행
SQL> @LABS/moreemphist

2) Failure 를 만든다

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

3) Recovery

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

replace script user_tbs_media_recovery {
        sql 'alter tablespace users offline immediate';
        set newname for datafile '$HOME/oradata/HUMAN/users01.dbf'
                      to          '$HOME/LABS/users01.dbf';
        restore (tablespace users);
        switch datafile all;
        recover tablespace users;
        sql 'alter tablespace users online';
}

RMAN> @LABS/user_tbs_media_recovery.rmn

RMAN> run { execute script user_tbs_media_recovery;}

4) 정상인가 확인

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