1、恢复控制文件
RMAN> restore controlfile from '/home/oracle/bak/data/ctl_0hv00323_1_1';
Starting restore at 12-MAY-20
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=10 device type=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/u01/app/oracle/oradata/PROD4/PROD4/control01.ctl
output file name=/u01/app/oracle/oradata/PROD4/PROD4/control02.ctl
Finished restore at 12-MAY-20
RMAN> alter database mount;
database mounted
released channel: ORA_DISK_1
2、重建数据文件
RMAN> restore database;
SQL> select checkpoint_change# from v$datafile_header;
CHECKPOINT_CHANGE#
------------------
923926
923925
923925
923926
923925
SQL> s