oracle -- 使用rman災難恢復

rman target sys/passwd@orcl nocatalog
startup force nomount
restore spfile from '備份檔' <--恢復spfile
shutdown
startup nomount
restore controlfile from '備份檔' ; <--恢復controlfile
rman > sql 'alter database mount';
rman > run{
restore database;
recover database;
}
rman > sql 'alter database open resetlogs';