RMAN備份時出現RMAN-06056: could not access datafile 6 錯誤，解決方法！！
用rman備份資料庫時出現以下錯誤：
[oracle@mzl orcl]$ rman target/
Recovery Manager: Release 10.2.0.1.0 - Production on Wed Feb 13 15:36:06 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: ORCL (DBID=1172558471)
RMAN> backup database;
Starting backup at 13-FEB-08
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=137 devtype=DISK
could not read file header for datafile 6 error reason 1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 02/13/2008 15:36:14
RMAN-06056: could not access datafile 6
也就是說不能訪問資料6的檔案。
1 檢視資料6檔案是什麼
SQL> select file#,name from v$datafile;
FILE#
----------
NAME
--------------------------------------------------------------------------------
1
/u01/app/oracle/oradata/orcl/system01.dbf
2
/u01/app/oracle/oradata/orcl/undotbs01.dbf
3
/u01/app/oracle/oradata/orcl/sysaux01.dbf
FILE#
----------
NAME
--------------------------------------------------------------------------------
4
/u01/app/oracle/oradata/orcl/users01.dbf
5
/u01/app/oracle/oradata/orcl/example01.dbf
6
/u01/app/oracle/product/10.2.0/db_1/dbs/MISSING00006
6 rows selected.
看來是MISSING00006檔案，不是系統，也不是使用者的資料。
2 看MISSING00006基於那個表空間，然後刪除該表空間
SQL> select TS#,name from v$tablespace;
TS# NAME
---------- ------------------------------
0 SYSTEM
1 UNDOTBS1
2 SYSAUX
4 USERS
6 EXAMPLE
3 TEMP
7 TS_RMAN
7 rows selected.
SQL> drop tablespace TS_RMAN;
Tablespace dropped.
3 進行rman備份
RMAN> backup database;
Starting backup at 13-FEB-08
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/u01/app/oracle/oradata/orcl/system01.dbf
input datafile fno=00003 name=/u01/app/oracle/oradata/orcl/sysaux01.dbf
input datafile fno=00005 name=/u01/app/oracle/oradata/orcl/example01.dbf
input datafile fno=00002 name=/u01/app/oracle/oradata/orcl/undotbs01.dbf
input datafile fno=00004 name=/u01/app/oracle/oradata/orcl/users01.dbf
channel ORA_DISK_1: starting piece 1 at 13-FEB-08
channel ORA_DISK_1: finished piece 1 at 13-FEB-08
piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2008_02_13/o1_mf_nnndf_TAG20080213T154843_3v586w6h_.bkp tag=TAG20080213T154843 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:55
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
channel ORA_DISK_1: starting piece 1 at 13-FEB-08
channel ORA_DISK_1: finished piece 1 at 13-FEB-08
piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2008_02_13/o1_mf_ncnnf_TAG20080213T154843_3v588n15_.bkp tag=TAG20080213T154843 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 13-FEB-08
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1 Full 581.19M DISK 00:00:52 13-FEB-08
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20080213T154843
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/backupset/2008_02_13/o1_mf_nnndf_TAG20080213T154843_3v586w6h_.bkp
List of Datafiles in backup set 1
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 726487 13-FEB-08 /u01/app/oracle/oradata/orcl/system01.dbf
2 Full 726487 13-FEB-08 /u01/app/oracle/oradata/orcl/undotbs01.dbf
3 Full 726487 13-FEB-08 /u01/app/oracle/oradata/orcl/sysaux01.dbf
4 Full 726487 13-FEB-08 /u01/app/oracle/oradata/orcl/users01.dbf
5 Full 726487 13-FEB-08 /u01/app/oracle/oradata/orcl/example01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2 Full 7.08M DISK 00:00:01 13-FEB-08
BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20080213T154843
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/backupset/2008_02_13/o1_mf_ncnnf_TAG20080213T154843_3v588n15_.bkp
Control File Included: Ckp SCN: 726506 Ckp time: 13-FEB-08
4 關閉資料庫，模擬丟失資料，刪除users資料檔案
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> !
[oracle@mzl orcl]$ ls
control01.ctl example01.dbf sqlnet.log undotbs01.dbf
control02.ctl redo01.log sysaux01.dbf users01.dbf
control03.ctl redo02.log system01.dbf
create.sql redo03.log temp01.dbf
[oracle@mzl orcl]$ rm users01.dbf
5 啟動資料庫到mount狀態
[oracle@mzl orcl]$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Feb 13 15:58:37 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 268435456 bytes
Fixed Size 1218868 bytes
Variable Size 88082124 bytes
Database Buffers 171966464 bytes
Redo Buffers 7168000 bytes
Database mounted.
6 用rman恢復資料
SQL> !
[oracle@mzl orcl]$ rman target/
Recovery Manager: Release 10.2.0.1.0 - Production on Wed Feb 13 15:59:12 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: ORCL (DBID=1172558471, not open)
RMAN> restore database;
Starting restore at 13-FEB-08
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=155 devtype=DISK
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /u01/app/oracle/oradata/orcl/system01.dbf
restoring datafile 00002 to /u01/app/oracle/oradata/orcl/undotbs01.dbf
restoring datafile 00003 to /u01/app/oracle/oradata/orcl/sysaux01.dbf
restoring datafile 00004 to /u01/app/oracle/oradata/orcl/users01.dbf
restoring datafile 00005 to /u01/app/oracle/oradata/orcl/example01.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/flash_recovery_area/ORCL/backupset/2008_02_13/o1_mf_nnndf_TAG20080213T154843_3v586w6h_.bkp
channel ORA_DISK_1: restored backup piece 1
piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2008_02_13/o1_mf_nnndf_TAG20080213T154843_3v586w6h_.bkp tag=TAG20080213T154843
channel ORA_DISK_1: restore complete, elapsed time: 00:00:57
Finished restore at 13-FEB-08
7 需要recover database之後才能開啟資料庫
RMAN> recover database;
Starting recover at 13-FEB-08
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=154 devtype=DISK
starting media recovery
media recovery complete, elapsed time: 00:00:01
Finished recover at 13-FEB-08
RMAN> exit
Recovery Manager complete.
[oracle@mzl orcl]$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Feb 13 16:02:30 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> alter database open;
Database altered.
SQL> select * from test;
A
----------
1
2
5
3
4
8
6 rows selected.
用rman備份與恢復完畢！！
[oracle@mzl orcl]$ rman target/
Recovery Manager: Release 10.2.0.1.0 - Production on Wed Feb 13 15:36:06 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: ORCL (DBID=1172558471)
RMAN> backup database;
Starting backup at 13-FEB-08
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=137 devtype=DISK
could not read file header for datafile 6 error reason 1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 02/13/2008 15:36:14
RMAN-06056: could not access datafile 6
也就是說不能訪問資料6的檔案。
1 檢視資料6檔案是什麼
SQL> select file#,name from v$datafile;
FILE#
----------
NAME
--------------------------------------------------------------------------------
1
/u01/app/oracle/oradata/orcl/system01.dbf
2
/u01/app/oracle/oradata/orcl/undotbs01.dbf
3
/u01/app/oracle/oradata/orcl/sysaux01.dbf
FILE#
----------
NAME
--------------------------------------------------------------------------------
4
/u01/app/oracle/oradata/orcl/users01.dbf
5
/u01/app/oracle/oradata/orcl/example01.dbf
6
/u01/app/oracle/product/10.2.0/db_1/dbs/MISSING00006
6 rows selected.
看來是MISSING00006檔案，不是系統，也不是使用者的資料。
2 看MISSING00006基於那個表空間，然後刪除該表空間
SQL> select TS#,name from v$tablespace;
TS# NAME
---------- ------------------------------
0 SYSTEM
1 UNDOTBS1
2 SYSAUX
4 USERS
6 EXAMPLE
3 TEMP
7 TS_RMAN
7 rows selected.
SQL> drop tablespace TS_RMAN;
Tablespace dropped.
3 進行rman備份
RMAN> backup database;
Starting backup at 13-FEB-08
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/u01/app/oracle/oradata/orcl/system01.dbf
input datafile fno=00003 name=/u01/app/oracle/oradata/orcl/sysaux01.dbf
input datafile fno=00005 name=/u01/app/oracle/oradata/orcl/example01.dbf
input datafile fno=00002 name=/u01/app/oracle/oradata/orcl/undotbs01.dbf
input datafile fno=00004 name=/u01/app/oracle/oradata/orcl/users01.dbf
channel ORA_DISK_1: starting piece 1 at 13-FEB-08
channel ORA_DISK_1: finished piece 1 at 13-FEB-08
piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2008_02_13/o1_mf_nnndf_TAG20080213T154843_3v586w6h_.bkp tag=TAG20080213T154843 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:55
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
channel ORA_DISK_1: starting piece 1 at 13-FEB-08
channel ORA_DISK_1: finished piece 1 at 13-FEB-08
piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2008_02_13/o1_mf_ncnnf_TAG20080213T154843_3v588n15_.bkp tag=TAG20080213T154843 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 13-FEB-08
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1 Full 581.19M DISK 00:00:52 13-FEB-08
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20080213T154843
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/backupset/2008_02_13/o1_mf_nnndf_TAG20080213T154843_3v586w6h_.bkp
List of Datafiles in backup set 1
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 726487 13-FEB-08 /u01/app/oracle/oradata/orcl/system01.dbf
2 Full 726487 13-FEB-08 /u01/app/oracle/oradata/orcl/undotbs01.dbf
3 Full 726487 13-FEB-08 /u01/app/oracle/oradata/orcl/sysaux01.dbf
4 Full 726487 13-FEB-08 /u01/app/oracle/oradata/orcl/users01.dbf
5 Full 726487 13-FEB-08 /u01/app/oracle/oradata/orcl/example01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2 Full 7.08M DISK 00:00:01 13-FEB-08
BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20080213T154843
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/backupset/2008_02_13/o1_mf_ncnnf_TAG20080213T154843_3v588n15_.bkp
Control File Included: Ckp SCN: 726506 Ckp time: 13-FEB-08
4 關閉資料庫，模擬丟失資料，刪除users資料檔案
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> !
[oracle@mzl orcl]$ ls
control01.ctl example01.dbf sqlnet.log undotbs01.dbf
control02.ctl redo01.log sysaux01.dbf users01.dbf
control03.ctl redo02.log system01.dbf
create.sql redo03.log temp01.dbf
[oracle@mzl orcl]$ rm users01.dbf
5 啟動資料庫到mount狀態
[oracle@mzl orcl]$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Feb 13 15:58:37 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 268435456 bytes
Fixed Size 1218868 bytes
Variable Size 88082124 bytes
Database Buffers 171966464 bytes
Redo Buffers 7168000 bytes
Database mounted.
6 用rman恢復資料
SQL> !
[oracle@mzl orcl]$ rman target/
Recovery Manager: Release 10.2.0.1.0 - Production on Wed Feb 13 15:59:12 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: ORCL (DBID=1172558471, not open)
RMAN> restore database;
Starting restore at 13-FEB-08
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=155 devtype=DISK
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /u01/app/oracle/oradata/orcl/system01.dbf
restoring datafile 00002 to /u01/app/oracle/oradata/orcl/undotbs01.dbf
restoring datafile 00003 to /u01/app/oracle/oradata/orcl/sysaux01.dbf
restoring datafile 00004 to /u01/app/oracle/oradata/orcl/users01.dbf
restoring datafile 00005 to /u01/app/oracle/oradata/orcl/example01.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/flash_recovery_area/ORCL/backupset/2008_02_13/o1_mf_nnndf_TAG20080213T154843_3v586w6h_.bkp
channel ORA_DISK_1: restored backup piece 1
piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2008_02_13/o1_mf_nnndf_TAG20080213T154843_3v586w6h_.bkp tag=TAG20080213T154843
channel ORA_DISK_1: restore complete, elapsed time: 00:00:57
Finished restore at 13-FEB-08
7 需要recover database之後才能開啟資料庫
RMAN> recover database;
Starting recover at 13-FEB-08
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=154 devtype=DISK
starting media recovery
media recovery complete, elapsed time: 00:00:01
Finished recover at 13-FEB-08
RMAN> exit
Recovery Manager complete.
[oracle@mzl orcl]$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Feb 13 16:02:30 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> alter database open;
Database altered.
SQL> select * from test;
A
----------
1
2
5
3
4
8
6 rows selected.
用rman備份與恢復完畢！！
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/12778571/viewspace-170172/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- oracle rman備份時出現ORA-19502錯誤解決案例Oracle
- 解決Centos7 yum 出現could not retrieve mirrorlist 錯誤CentOS
- 【RMAN】Oracle12c之後，rman備份Dataguard備端恢復可能出現邏輯錯誤Oracle
- ant構建時出現錯誤解決方案
- rman duplicate出現PLS-00201錯誤解決
- SqlServer NBU備份出現錯誤程式碼2SQLServer
- Go:錯誤 could not launch process: EOF 解決Go
- DBV驗證ASM裡的datafile,出現錯誤ASM
- rman映象備份全庫的時候報ora-00600錯誤。
- NFS掛載時出現”access denied by server while mounting”的解決方法NFSServerWhile
- netbakcup備份時遇到 status 59: access to the client was not allowed 問題解決client
- Nginx出現413 Request Entity Too Large錯誤解決方法Nginx
- 隨身碟出現防寫錯誤的解決方法
- apache出現 403 permission 和404 not fund錯誤（解決方法）Apache
- 恢復備份例項時出現ORA-01659的解決方法UA
- 工程make時出現"時鐘錯誤的問題"的解決方案
- Python: 安裝 sklearn 包出現錯誤的解決方法Python
- php抓取https網址出現錯誤的解決方法PHPHTTP
- 手動刪除了歸檔日誌後，rman備份出現問題解決
- TSM備份ANS0326E錯誤及解決
- Rman增量壓縮備份來解決備份空間不足
- nginx過一段時間出現400 Bad Request 錯誤的解決方法Nginx
- /initrd目錄的作用和當刪除時出現的錯誤解決方法(轉)
- win10系統登入Origin Access遊戲時出錯了的解決方法Win10遊戲
- 錯誤 qt.qpa.plugin: Could not find the Qt platform plugin “windows“ in ““ 的解決方法QTPluginPlatformWindows
- Rman 定時備份crontab
- RMAN 備份詳解
- RMAN備份詳解
- -- RMAN備份詳解
- 使用JPEGImageEncoder提示Access restriction:錯誤 解決方案REST
- RMAN-06014:RMAN-03002:錯誤解決方法
- RMAN備份時出現ORA-19809: limit exceeded for recovery filesMIT
- sql出現結果集錯誤以及出現ora-600或者ora-7445錯誤的解決方法思路SQL
- scp出現錯誤的解決辦法
- 編譯EJB出現錯誤的解決編譯
- ontape出現段錯誤（未解決篇）
- Oracle備份時出現AIX系統的3D32B80D錯誤OracleAI3D
- 一個RMAN備份時導致系統慢解決的案例