RMAN备份RMAN-10038错误

显示全部楼层 · 2007-4-4 09:57:08

在运行备份脚本的时候出现如下错误，大家帮我看看
allocated channel: d1
channel d1: sid=98 devtype=DISK
allocated channel: d2
channel d2: sid=73 devtype=DISK
allocated channel: d3
channel d3: sid=116 devtype=DISK
Starting backup at 18-7月 -06
channel d1: starting full datafile backupset
channel d1: specifying datafile(s) in backupset
input datafile fno=00006 name=/oradata2/vodapp/MEDIA01.dbf
input datafile fno=00020 name=/oradata1/vodapp/undotbsnew01.dbf
input datafile fno=00001 name=/oracle/oradata/vodapp/system01.dbf
input datafile fno=00005 name=/oracle/oradata/vodapp/users01.dbf
input datafile fno=00004 name=/oracle/oradata/vodapp/tools01.dbf
input datafile fno=00009 name=/oradata2/vodapp/media02.dbf
channel d1: starting piece 1 at 18-7月 -06
channel d2: starting full datafile backupset
channel d2: specifying datafile(s) in backupset
input datafile fno=00010 name=/oradata2/vodapp/media03.dbf
input datafile fno=00003 name=/oradata1/vodapp/indx01.dbf
input datafile fno=00014 name=/oradata1/vodapp/indx02.dbf
input datafile fno=00007 name=/oradata1/vodapp/PREVIEW01.dbf
channel d2: starting piece 1 at 18-7月 -06
channel d3: starting full datafile backupset
channel d3: specifying datafile(s) in backupset
input datafile fno=00011 name=/oradata2/vodapp/media04.dbf
input datafile fno=00015 name=/oradata1/vodapp/indx03.dbf
input datafile fno=00008 name=/oradata1/vodapp/preview02.dbf
channel d3: starting piece 1 at 18-7月 -06
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00601: fatal error in recovery manager
RMAN-03004: fatal error during execution of command
RMAN-10038: database session for channel d3 terminated unexpectedly

千问 · 2007-4-4 09:57:08

脚本很简单
run {
allocate channel d1 type disk;
allocate channel d2 type disk ;
allocate channel d3 type disk ;
backup database;
release channel d1;
release channel d2;
release channel d3;
}

基本配置信息
RMAN> show all;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
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 '/oradata1/backup/%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/oradata1/backup/full_%U_%T_%s.bak' MAXPIECESIZE 4000 M;
RMAN configuration has no stored or default parameters
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/product/9.2.0.4/dbs/snapcf_vodapp.f'; # default

千问 · 2007-4-4 09:57:08

把脚本改一改，加上备份集路径名称试试。

千问 · 2007-4-4 09:57:08

CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # default
修改成3试一下呢

千问 · 2007-4-4 09:57:08

忘了说了，我是通过catalog来备份的

千问 · 2007-4-4 09:57:08

最初由 lakher 发布
[B]CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # default
修改成3试一下呢 [/B]
我配置和脚本都改过了，还是报这个错。有大侠再看看麽
CONFIGURE DEVICE TYPE DISK PARALLELISM 2;

run
{
allocate channel d1 type disk;
allocate channel d2 type disk;
backup database format '/oradata1/backup/full_%d_%U' filesperset=2;
release channel d1;
release channel d2;
};