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

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值