使用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/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/9390331/viewspace-667598/