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 10.2.0.3 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 10.2.0.4 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.

Solution

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 SESSION WHICH TOOK ORA-600*/

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 10.2.0.3.0 – 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

Theme: Silver is the New Black. Get a free blog at WordPress.com

Follow

Get every new post delivered to your Inbox.

Join 205 other followers