rman映象備份全庫的時候報ora-00600錯誤。

使用RMAN進行映象拷貝，但是卻報錯了。
首先檢視本資料庫RMAN設定引數：
RMAN> show all;                                                                                                        

using target database control file instead of recovery catalog
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/app/oracle/temp/%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/dbbackup/%U' MAXPIECESIZE 20 M;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_orcl.f'; # default

進行備份：
RMAN> backup as copy database;                                                                                         

Starting backup at 28-JUN-10
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=147 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=148 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=140 devtype=DISK
channel ORA_DISK_1: starting datafile copy
input datafile fno=00001 name=/u01/app/oracle/oradata/orcl/system01.dbf
channel ORA_DISK_2: starting datafile copy
input datafile fno=00003 name=/u01/app/oracle/oradata/orcl/sysaux01.dbf
channel ORA_DISK_3: starting datafile copy
input datafile fno=00005 name=/u01/app/oracle/oradata/bwdasic/SICDATA01.ora
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 06/28/2010 20:53:09
ORA-00600: internal error code, arguments: [ksfdfetch1], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [ksfdfetch1], [], [], [], [], [], [], []
channel ORA_DISK_1 disabled, job failed on it will be run on another channel
RMAN-03009: failure of backup command on ORA_DISK_2 channel at 06/28/2010 20:53:09
ORA-00600: internal error code, arguments: [ksfdfetch1], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [ksfdfetch1], [], [], [], [], [], [], []
channel ORA_DISK_2 disabled, job failed on it will be run on another channel
RMAN-03009: failure of backup command on ORA_DISK_3 channel at 06/28/2010 20:53:13
ORA-00600: internal error code, arguments: [ksfdfetch1], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [ksfdfetch1], [], [], [], [], [], [], []
channel ORA_DISK_3 disabled, job failed on it will be run on another channel
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03009: failure of backup command on ORA_DISK_3 channel at 06/28/2010 20:53:13
ORA-00600: internal error code, arguments: [ksfdfetch1], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [ksfdfetch1], [], [], [], [], [], [], []
RMAN-03009: failure of backup command on ORA_DISK_2 channel at 06/28/2010 20:53:09
ORA-00600: internal error code, arguments: [ksfdfetch1], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [ksfdfetch1], [], [], [], [], [], [], []
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 06/28/2010 20:53:09
ORA-00600: internal error code, arguments: [ksfdfetch1], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [ksfdfetch1], [], [], [], [], [], [], []

出現報錯。

 

最後查閱metlink發現是oracle內部的一個bug。以下是網上原文摘錄：

Solution

Choose from one of the following solutions:

1. Apply the 10.2.0.4 patchset. At the time this article was written this patchset was not available (July 2007).

2. Apply the one-off Patch 4541506 if available for your platform. and version.

3. Use the workaround:

    If channels are allocated manually then do not specify MAXPIECESIZE when producing image copies.

    If channels are conf

If channels are configured with MAXPIECESIZE and image copies are being produced there are two options:
      a). Reconfigure the channels without MAXPIECESIZE
      b). Allocate manual channels to produce the image copies.

最終使用的解決方法是:

a). Reconfigure the channels without MAXPIECESIZE

RMAN>configure channel device type disk format '/dbbackup/%U';

不再限制maxpiecesize的大小於是再次映象備份全庫，成功。

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/9390331/viewspace-667598/，如需轉載，請註明出處，否則將追究法律責任。