Oracle11g所有文件损坏恢复

SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/PROD4/PROD4/system01.dbf
/u01/app/oracle/oradata/PROD4/PROD4/sysaux01.dbf
/u01/app/oracle/oradata/PROD4/PROD4/undotbs01.dbf
/u01/app/oracle/oradata/PROD4/PROD4/users01.dbf
/u01/app/oracle/oradata/PROD4/PROD4/example01.dbf

SQL> show parameter spfile;

NAME                     TYPE     VALUE
------------------- ----------- ------------------------------
spfile                     string     /u01/app/oracle/product/11.2.0
                         /db_1/dbs/spfilePROD4.ora

一、方法一
1、rman开启数据库，可以通过临时文件进入到nomount状态
rman target /
startup
2、恢复参数文件
restore spfile from '/home/oracle/bak/x';
3、重启数据库
shutdown abort
startup
4、恢复控制文件
restore controlfile from '/home/oracle/bak/x';
alter database mount;
5、列出失败信息
RMAN> list failure;

list failure;
List of Database Failures
=========================

Failure ID Priority Status    Time Detected Summary
---------- -------- --------- ------------- -------
1126       CRITICAL OPEN      09-MAY-20     System datafile 1: '/u01/app/oracle/oradata/PROD4/PROD4/system01.dbf' is missing
1123       CRITICAL OPEN      09-MAY-20     Control file needs media recovery
321        HIGH     OPEN      09-MAY-20     One or more non-system datafiles are missing

6、列出失败的解决办法
RMAN> advise failure;

Starting implicit crosscheck backup at 09-MAY-20
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=134 device type=DISK
Crosschecked 14 objects
Finished implicit crosscheck backup at 09-MAY-20

Starting implicit crosscheck copy at 09-MAY-20
using channel ORA_DISK_1
Finished implicit crosscheck copy at 09-MAY-20

searching for all files in the recovery area
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: /home/oracle/flash_recovery_area/PROD4/autoback/c-1612213667-20200507-04
File Name: /home/oracle/flash_recovery_area/PROD4/autoback/c-1612213667-20200507-02
File Name: /home/oracle/flash_recovery_area/PROD4/autoback/c-1612213667-20200509-00
File Name: /home/oracle/flash_recovery_area/PROD4/autoback/c-1612213667-20200507-00
File Name: /home/oracle/flash_recovery_area/PROD4/autoback/c-1612213667-20200509-02

List of Database Failures
=========================