Oracle故障處理Rman-06207&Rman-06214的方法

2022-11-03 14:02:31

1、在給客戶系統巡檢時通過rman維護紀錄檔發現有rman維護紀錄檔報錯：

RMAN-06207: WARNING: 3 objects could not be deleted for DISK channel(s) due

RMAN-06208: to mismatched status. Use CROSSCHECK command to fix status

RMAN-06210: List of Mismatched objects

RMAN-06211: ==========================

RMAN-06212: Object Type Filename/Handle

RMAN-06213: --------------- ---------------------------------------------------

RMAN-06214: Datafile Copy D:ORADATASYSTEM01.DBF

RMAN-06214: Datafile Copy D:APPADMINISTRATORPRODUCT11.2.0DBHOME_1DATABASESNCFDB.ORA

RMAN-06214: Datafile Copy /u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_db1.f

2、進入rman檢視模式，進行交叉校驗備份資訊，未發現異常，如下：

[root@db1 rman]# su - oracle
[oracle@db1 ~]$ rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Tue Nov 1 13:38:38 2022
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
cconnected to target database: HISDB (DBID=1732211111)
RMAN> crosscheck backup;
backup piece handle=/dbbak/rman/ctl_DB_20221031_16719_1 RECID=14479 STAMP=1119556333
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/dbbak/rman/DB_ag1bm4nl_1_1.spfile RECID=14480 STAMP=1119556334
Crosschecked 2 objects

3、根據提示路徑發現系統近期是從windows環境遷移至linux環境的，在遷移之前沒有對控制檔案記錄的資訊進行維護導致，通過crosscheck copy命令進行校驗檢查，發現存在檢查失敗的內容，如下：

RMAN> crosscheck copy;
validation failed for datafile copy
datafile copy file name=D:ORADATASYSTEM01.DBF RECID=1 STAMP=1108073097
validation failed for control file copy
control file copy file name=/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_db1.f RECID=18 STAMP=1108406674
validation failed for control file copy
control file copy file name=D:APPADMINISTRATORPRODUCT11.2.0DBHOME_1DATABASESNCFDB.ORA RECID=10 STAMP=1108209845
Crosschecked 3 objects

4、使用report obsolete命令報告過時的物件，如下：

RMAN> report obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Datafile Copy        1   22-JUN-2022 22:04:57 D:ORADATASYSTEM01.DBF
Control File Copy 10 24-JUN-2022 12:04:05 D:APPADMINISTRATORPRODUCT11.2.0DBHOME_1DATABASESNCFDB.ora
Control File Copy  18 26-JUN-2022 18:44:34 /u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_hisdb1.f

5、使用delete obsolete命令刪除存在問題的物件，如下：

RMAN> delete obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
Deleting the following obsolete backups and copies:
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Datafile Copy        1      22-JUN-2022 22:04:57 D:ORADATASYSTEM01.DBF
Control File Copy     10     24-JUN-2022 12:04:05 D:APPADMINISTRATORPRODUCT11.2.0DBHOME_1DATABASESNCFDB.ORA
Control File Copy     18     26-JUN-2022 18:44:34 /u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_db1.f
Do you really want to delete the above objects (enter YES or NO)? yes
deleted datafile copy
datafile copy file name=D:ORADATASYSTEM01.DBF RECID=1 STAMP=1108073097
deleted control file copy
control file copy file name=D:APPADMINISTRATORPRODUCT11.2.0DBHOME_1DATABASESNCFDB.ORA RECID=10 STAMP=1108209845

6、至此，rman在維護資料庫的時候不在出現Rman-06207&Rman-06214報錯。

總結

到此這篇關於Oracle故障處理Rman-06207&Rman-06214的文章就介紹到這了,更多相關Oracle Rman-06207&Rman-06214內容請搜尋it145.com以前的文章或繼續瀏覽下面的相關文章希望大家以後多多支援it145.com！

Oracle故障處理Rman-06207&Rman-06214的方法

熱門文章