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
=========================