RESTORE DATABASE

RMAN> SET DBID 914610606;
RMAN> STARTUP NOMOUNT;
RMAN> RESTORE CONTROLFILE FROM "/oradb/zfra/iis/ctl_sp/a20160615_634_1_1_914610606.ctl

тут должен быть startup mount

RMAN> RESTORE DATABASE;
RMAN> RECOVER DATABASE;
внезапно не нашелся файл лога
RMAN> run {
2> SET UNTIL SEQUENCE 3047;
 # SET UNTIL SCN 1000;  
 # SET UNTIL TIME 'Nov 15 2004 09:00:00';
 # SET UNTIL SEQUENCE 9923;
 # RESTORE DATABASE;
 # RECOVER DATABASE;
3> RECOVER DATABASE;
4> }
RMAN> ALTER DATABASE OPEN RESETLOGS;