oracle11g 控制文件和数据文件损坏恢复

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