Coskan’s Approach to Oracle

August 10, 2007

ORA-600 [KSFD_DECAIOPC] While Taking Image Backups

Filed under: Backup/Recovery — coskan @ 8:04 am

Today I faced with ORA-600 error while trying image backups. My release is for windows. I made search on metalink and I want to share the solution for the ones who haven’t got metalink access.

The cause of this error is oracle Bug 4541506 and this bug is said to be solved with release. It is also said this error occurs when MAXPIECESIZE is set or configured in the disk channels, nevertheless I faced with the error without any MAXPIECESIZE configuration. But the second solution which is about manual channel allocation is worked for my case.


A. When channels allocated manually then do not specify MAXPIECESIZE when
producing image copies.

B. If channels are configured with MAXPIECESIZE and image copies are being
produced there are two options:

1) Reconfigure the channels without MAXPIECESIZE

2) Allocate manual channels to produce the image copies.

If you try this solution on the RMAN session which took the ORA-600 error, you may face with RMAN-06034: at least 1 channel must be allocated to execute this command, error as me. To solve the situation shown below, just create a fresh RMAN session.


RMAN> run {

2> allocate channel ch1 type disk;

3> backup as copy database;

4> release channel ch1;

5> }

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of allocate command at 08/10/2007 10:44:15

RMAN-06012: channel: ORA_DISK_1 not allocated

RMAN> exit

Recovery Manager complete.

D:\oracle\product\10.2.0\asm\database>rman target /     /*FRESH RMAN SESSION*/

Recovery Manager: Release – Production on ¤. ªÕ­ 10 10:47:15 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: DABAK (DBID=3241464088)

RMAN> run {

2> allocate channel ch1 type disk;

3> backup as copy database;

4> release channel d1;

5> }

using target database control file instead of recovery catalog

allocated channel: d1

channel d1: sid=146 devtype=DISK

Starting backup at 10.08.2007

file 3 is excluded from whole database backup

file 4 is excluded from whole database backup

channel d1: starting datafile copy

input datafile fno=00001 name=D:\ORACLE\ORADATA\DABAK\SYSTEM01.DBF


References Used.

Metalink Note: Note:401681.1

Create a free website or blog at