Oracle study--rman enable block change tracking error
System environment:
Operating system: RedHat EL6
Oracle:oracle 11g R2
Target Db:prod
Catalog DB:ORCL
After making an incremental backup using Rman Backup, a ORA-600 error occurred while starting "Block change tracking"!
Case Analysis:
1. Enable block change tracking
11:23:43 [email protected] Prod>alter Database enable block change tracking using file '/HOME/ORACLE/BLK.TRC ' reuse;
Database altered.
Alarm log:
ALTER DATABASE enable block change tracking using file '/HOME/ORACLE/BLK.TRC '
Block change tracking file was 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. Create a backup script via Rman
[email protected] dbs]$ Rman target/catalog rman/[email protected]
Recovery manager:release 11.2.0.1.0-production on Tue APR 7 11:29:41 2015
Copyright (c) 1982, the Oracle and/or its affiliates. All rights reserved.
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 the 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
Alarm log:
[[email protected] ~]$ tail-f/u01/app/oracle/diag/rdbms/prod/prod/ Trace/alert_prod.log
Tue Apr 11:27:16
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/inci DENT/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 0 7 11:27:19
Ora-1092:opitsk aborting process
Instance terminated by CTWR, PID = 4912
from the log you can see that the CTRW process is closed instance!
3. Stop using block change tracking
11:31:33 [email protected] Prod>alter Database disable block change tracking;
Database altered.
elapsed:00:00:01.13
Alarm Log :
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
Then create a backup script via Rman:
[email protected] dbs]$ Rman target/catalog rman/[email protected]
Recovery manager:release 11.2.0.1.0-production on Tue APR 7 11:29:41 2015
Copyright (c) 1982, the Oracle and/or its affiliates. All rights reserved.
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 the days;
7> release channel CH1;
8>}
This is the backup script built successfully!
Note:
In the back of the same error, after the operating system deleted the trace file "Blk.trc", and back to normal, and now have not figured out the specific cause of the problem is what?
This article is from the "Tianya blog," Please make sure to keep this source http://tiany.blog.51cto.com/513694/1629649
Oracle study--rman enable block change tracking error