1) 정상적인 업무수행

RMAN> run {execute script backup_database;}

$sqlplus '/as sysdba'

SQL> @/home/human/LABS/moreemphist

2) failure를 만든다

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

SQL>
SQL> @$HOME/LABS/datafileerror

3) Recovery

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

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

replace script user_tbs_recovery {
        sql 'alter tablespace users offline immediate';
        restore tablespace users;
        recover tablespace users;
        sql 'alter tablespace users online';
}

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

RMAN> run { execute script user_tbs_recovery;}

4) 정상인가 확인