練習使用list failure,advise failure; repair failure;
1 首先備份測試資料檔案
RMAN> backup datafile 5;
Starting backup at 06-NOV-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=43 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00005 name=/data/oracle/oradata/aaron/example01.dbf
channel ORA_DISK_1: starting piece 1 at 06-NOV-14
channel ORA_DISK_1: finished piece 1 at 06-NOV-14
piece handle=/data/oracle/flash_recovery_area/AARON/backupset/2014_11_06/o1_mf_nnndf_TAG20141106T001531_b5pck41v_.bkp tag=TAG20141106T001531 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:16
Finished backup at 06-NOV-14
Starting Control File and SPFILE Autobackup at 06-NOV-14
piece handle=/data/oracle/flash_recovery_area/AARON/autobackup/2014_11_06/o1_mf_s_862877747_b5pcknj2_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 06-NOV-14
2 刪除測試資料檔案
SYS@aaron> !rm /data/oracle/oradata/aaron/example01.dbf
3 重新啟動資料庫檢視錯誤資訊
SYS@aaron> shutdown abort
ORACLE instance shut down.
SYS@aaron> startup
ORACLE instance started.
Total System Global Area 422670336 bytes
Fixed Size 1336960 bytes
Variable Size 314575232 bytes
Database Buffers 100663296 bytes
Redo Buffers 6094848 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 5 - see DBWR trace file
ORA-01110: data file 5: '/data/oracle/oradata/aaron/example01.dbf'
4 重新連線RMAN 並執行 List Failure
RMAN> list failure;
using target database control file instead of recovery catalog
List of Database Failures
=========================
Failure ID Priority Status Time Detected Summary
---------- -------- --------- ------------- -------
522 HIGH OPEN 06-NOV-14 One or more non-system datafiles are missing
using target database control file instead of recovery catalog
List of Database Failures
=========================
Failure ID Priority Status Time Detected Summary
---------- -------- --------- ------------- -------
522 HIGH OPEN 06-NOV-14 One or more non-system datafiles are missing
5 檢視建議指令碼
RMAN> advise failure;
List of Database Failures
=========================
Failure ID Priority Status Time Detected Summary
---------- -------- --------- ------------- -------
522 HIGH OPEN 06-NOV-14 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=17 device type=DISK
analyzing automatic repair options complete
Mandatory Manual Actions
========================
no manual actions available
Optional Manual Actions
=======================
1. If file /data/oracle/oradata/aaron/example01.dbf was unintentionally renamed or moved, restore it
Automated Repair Options
========================
Option Repair Description
------ ------------------
1 Restore and recover datafile 5
Strategy: The repair includes complete media recovery with no data loss
Repair script: /data/oracle/diag/rdbms/aaron/aaron/hm/reco_780979516.hm
[oracle@localhost alert]$ more /data/oracle/diag/rdbms/aaron/aaron/hm/reco_780979516.hm
# restore and recover datafile
restore datafile 5;
recover datafile 5;
6 執行恢復操作
RMAN> restore datafile 5;
Starting restore at 06-NOV-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=18 device type=DISK
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00005 to /data/oracle/oradata/aaron/example01.dbf
channel ORA_DISK_1: reading from backup piece /data/oracle/flash_recovery_area/AARON/backupset/2014_11_06/o1_mf_nnndf_TAG20141106T001531_b5pck41v_.bkp
channel ORA_DISK_1: piece handle=/data/oracle/flash_recovery_area/AARON/backupset/2014_11_06/o1_mf_nnndf_TAG20141106T001531_b5pck41v_.bkp tag=TAG20141106T001531
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
Finished restore at 06-NOV-14
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/28719055/viewspace-1324389/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Failure is not fatal, but failure to change might be.AI
- Oracle IZ0-053 Q285(Rman Repair Failure)OracleAI
- Assertion failure 錯誤AI
- Ext success failure 呼叫AI
- DRIVER_POWER_STATE_FAILUREAI
- Vagrant:NS_ERROR_FAILUREErrorAI
- Assertion failure in -[UICollectionViewData validateLayoutInRect:]AIUIView
- Error: Debug Failure at typeToStringErrorAI
- Preferred Read Failure GroupsAI
- [Linux] kernel: page allocation failureLinuxAI
- ORA-29516: Aurora assertion failure: Assertion failure at joez.c:3311AI
- ASM Failure Group的一點理解ASMAI
- datafilecopy header validation failure problemHeaderAI
- Failure at scls_scr_create with code 1AI
- Oracle ASM (10) - ASM中優先讀failure group配置ASM_PREFERRED_READ_FAILURE_GROUPSOracleASMAI
- Oracle ASM (11) - ASM中優先讀failure group配置ASM_PREFERRED_READ_FAILURE_GROUPSOracleASMAI
- mysql 報錯 Communications link failureMySqlAI
- Assertion failure in -[UITableView -configureCellForDisplay:forIndexPath:]AIUIViewIndex
- Failure at final check of Oracle CRS stack.AIOracle
- ORA-00704: bootstrap process failurebootAI
- 轉:Assertion failure in -[UITableView _configureCellForDisplay:forIndexPath:]AIUIViewIndex
- Temporary failure resolving ‘archive.ubuntu.com‘AIHiveUbuntu
- 經常報錯:Communications link failureAI
- ORA-27302 “failure occurred at skgxpvfymmtu” in RACAI
- Http failure response 0 Unknown error 錯誤分析HTTPAIError
- 紅米note3 Failure [INSTALL_CANCELED_BY_USER]AI
- ORA-27302: failure occurred at: skgpwinit6AI
- TNS-12570 TNS:packet reader failureAI
- ORA-27302: failure occurred at: sskgxprcv1AI
- failure in css initialization opening OCR 問題處理AICSS
- name server cannot be used, reason: Temporary failure in name resolutionServerAI
- Linux 出現 su: Authentication failure 解決辦法LinuxAI
- Resolving archive.cloudera.com... failed: Temporary failure in nameHiveCloudAI
- Maven:Non-resolvable parent POM: Failure to find錯誤MavenAI
- Agent admitted failure to sign using the key解決MITAI
- 11g ASM asm_preferred_read_failure_groupASMAI
- Accelerated Failure Time Models加速失效時間模型AFTAI模型
- ORA-01078: failure in processing system parametersAI