Oracle Study之--RMAN启用block change tracking错误

爱被打了一巴掌 2022-08-05 13:13 168阅读 0赞

**Oracle Study之--RMAN启用block change tracking错误**

**系统环境：**

**  操作系统： RedHat EL6**

**  Oracle:         Oracle 11g R2**

**Target DB:     prod**

**Catalog DB:   orcl**

在使用rman备份做增量备份后，启动“block change tracking” 出现了ORA-600错误！

**案例分析：**

**1、启用block change tracking**

11:23:43 SYS@ prod>alter database enable block change tracking using file '/home/oracle/blk.trc' reuse;

Database altered.

告警日志：  
alter database enable block change tracking using file '/home/oracle/blk.trc'  
Block change tracking file is current.  
Starting background process CTWR  
Tue Apr 07 11:36:55 2015  
CTWR started with pid=33, OS id=5576  
Block change tracking service is active.

**2、通过rman建立备份脚本**

\[oracle@rh6 dbs\]$ rman target / catalog [rman/rman@orcl][rman_rman_orcl]

Recovery Manager: Release 11.2.0.1.0 - Production on Tue Apr 7 11:29:41 2015

connected to target database: PROD (DBID=239333010)  
connected to recovery catalog database

RMAN> create global script global\_del\_obso comment 'A script for obsolete backup and delete it'  
\{  
2> 3>  crosscheck archivelog all;  
4>  delete noprompt expired archivelog all;  
5>  allocate channel ch1 device type disk;  
6>  delete noprompt obsolete recovery window of 15 days;  
7>  release channel ch1;  
8>  \}

RMAN-00571: ===========================================================  
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============  
RMAN-00571: ===========================================================  
RMAN-03002: failure of create script command at 04/07/2015 11:29:58  
RMAN-06004: ORACLE error from recovery catalog database: ORA-03114: not connected to ORACLE

**告警日志：**

**\[oracle@rh6 ~\]$ tail -f /u01/app/oracle/diag/rdbms/prod/prod/trace/alert\_prod.log**  
Tue Apr 07 11:27:16 2015  
Errors in file /u01/app/oracle/diag/rdbms/prod/prod/trace/prod\_ctwr\_4912.trc  (incident=39841):  
ORA-00600: internal error code, arguments: \[krccacp\_badfile\], \[1513065\], \[0\], \[624054\], \[0\], \[\], \[\], \[\], \[\], \[\], \[\], \[\]  
Incident details in: /u01/app/oracle/diag/rdbms/prod/prod/incident/incdir\_39841/prod\_ctwr\_4912\_i39841.trc  
Errors in file /u01/app/oracle/diag/rdbms/prod/prod/trace/prod\_ctwr\_4912.trc:  
ORA-00600: internal error code, arguments: \[krccacp\_badfile\], \[1513065\], \[0\], \[624054\], \[0\], \[\], \[\], \[\], \[\], \[\], \[\], \[\]  
CTWR (ospid: 4912): terminating the instance due to error 487  
Tue Apr 07 11:27:19 2015  
ORA-1092 : opitsk aborting process  
Instance terminated by CTWR, pid = 4912

**从日志可以看到CTRW进程关闭了Instance！**

**3、停止使用block change tracking**

11:31:33 SYS@ prod>alter database disable block change tracking;

Database altered.

Elapsed: 00:00:01.13

**告警日志**：

alter database disable block change tracking  
Tue Apr 07 11:31:50 2015  
Block change tracking service stopping.  
Stopping background process CTWR  
Deleted file /home/oracle/blk.trc  
Completed: alter database disable block change tracking  
Tue Apr 07 11:34:36 2015

**再通过rman建立备份脚本：**

\[oracle@rh6 dbs\]$ rman target / catalog [rman/rman@orcl][rman_rman_orcl]

Recovery Manager: Release 11.2.0.1.0 - Production on Tue Apr 7 11:29:41 2015

connected to target database: PROD (DBID=239333010)  
connected to recovery catalog database

**这是备份脚本建立成功！**

** 注：**

**       在后面又出现了一样的错误，在操作系统下删除了trace文件“blk.trc”后，又恢复正常，现在还没有搞清楚造成这个问题的具体原因是什么？**

[rman_rman_orcl]: mailto:rman/rman@orcl