Backup And Recovery User's Guide-從RMAN開始-使用資料恢復指導診斷和修復錯誤

# 1. 手工將users01.dbf資料檔案改名（此時資料庫處於OPEN狀態）

oracle@Redhat55.cuug.net:/u01/app/oracle/oradata/TestDB12> mv users01.dbf users01_bak.dbf

# 2. 連線到scott使用者,執行資料查詢（因為該方案中的emp表儲存在users表空間中）

sys@TESTDB12>conn scott/scott

Connected.

scott@TESTDB12>select * from emp;

select * from emp

              *

ERROR at line 1:

ORA-01116: error in opening database file 4

ORA-01110: data file 4: '/u01/app/oracle/oradata/TestDB12/users01.dbf'

ORA-27041: unable to open file

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

# 3. 在RMAN中檢視錯誤

RMAN> list failure;

using target database control file instead of recovery catalog

List of Database Failures

=========================

Failure ID Priority Status    Time Detected Summary

---------- -------- --------- ------------- -------

82         HIGH     OPEN      12-JUL-13     One or more non-system datafiles are missing

# 4. 對失敗進行指導

RMAN> advise failure;

List of Database Failures

=========================

Failure ID Priority Status    Time Detected Summary

---------- -------- --------- ------------- -------

82         HIGH     OPEN      12-JUL-13     One or more non-system datafiles are missing

analyzing automatic repair options; this may take some time

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=37 device type=DISK

analyzing automatic repair options complete

Mandatory Manual Actions

========================

no manual actions available

Optional Manual Actions

=======================

1. If file /u01/app/oracle/oradata/TestDB12/users01.dbf was unintentionally renamed or moved, restore it

Automated Repair Options

========================

Option Repair Description

------ ------------------

1      Restore and recover datafile 4 

  Strategy: The repair includes complete media recovery with no data loss

  Repair script: /u01/app/oracle/diag/rdbms/testdb12/TestDB12/hm/reco_2214128973.hm

# 5. 最後是生成的一個修復指令碼，如果你不想使用資料修復指導來自動地修復失敗，可以使用這個指令碼作為你自己恢復策略的基礎

# 5.1 檢視生成的指令碼中的內容

oracle@Redhat55.cuug.net:/home/oracle> more /u01/app/oracle/diag/rdbms/testdb12/TestDB12/hm/reco_2214128973.hm

   # restore and recover datafile

   sql 'alter database datafile 4 offline';

   restore datafile 4;

   recover datafile 4;

   sql 'alter database datafile 4 online';