1、恢复控制文件
RMAN> restore controlfile from '/home/oracle/bak/ctl_PROD4_20190417_116_1';
RMAN> alter database mount;
SQL> select checkpoint_change# from v$datafile_header;
CHECKPOINT_CHANGE#
------------------
922731
922731
922731
922731
922731
922731
SQL> select checkpoint_change# from v$datafile;
CHECKPOINT_CHANGE#
------------------
922668
922669
922670
922668
922670
922669
2、恢复
RMAN> recover database;
Starting recover at 17-APR-19
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=11 device type=DISK
starting media recovery
unable to fin