rman备份时报错,请高手指点
1、我的平台 rhel4u4 上装的9204
2、我的脚本,
rman nocatalog target / log=/opt/rmanbak/rmanlog/backupall_`date +"%Y%m%d%H%M%S"`.log<<EOF
run
{
allocate channel ch1 device type disk;
allocate channel ch2 device type disk;
allocate channel ch3 device type disk;
allocate channel ch4 device type disk;
sql 'alter system archive log current';
backup database format '/opt/rmanbak/dbbak/db_%d_%T_%U';
sql 'alter system archive log current';
backup archivelog all format '/opt/rmanbak/arcbak/arc_%T_%s' delete all input;
backup current controlfile format '/opt/rmanbak/dbbak/ctl_%s_%p_%T';
crosscheck backup;
crosscheck archivelog all;
report obsolete;
delete noprompt obsolete;
release channel ch1;
release channel ch2;
release channel ch3;
release channel ch4;
}
EOF
3、日志文件里面的信息
Recovery Manager: Release 9.2.0.4.0 - Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
connected to target database: ORADB (DBID=2407010394)
using target database controlfile instead of recovery catalog
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20>
allocated channel: ch1
channel ch1: sid=17 devtype=DISK
allocated channel: ch2
channel ch2: sid=12 devtype=DISK
allocated channel: ch3
channel ch3: sid=16 devtype=DISK
allocated channel: ch4
channel ch4: sid=22 devtype=DISK
sql statement: alter system archive log current
Starting backup at 23-MAY-08
channel ch1: starting full datafile backupset
channel ch1: specifying datafile(s) in backupset
input datafile fno=00010 name=/opt/ora9/oradata/oradb/xdb01.dbf
input datafile fno=00006 name=/opt/ora9/oradata/oradb/indx01.dbf
input datafile fno=00009 name=/opt/ora9/oradata/oradb/users01.dbf
channel ch1: starting piece 1 at 23-MAY-08
channel ch2: starting full datafile backupset
channel ch2: specifying datafile(s) in backupset
input datafile fno=00005 name=/opt/ora9/oradata/oradb/example01.dbf
input datafile fno=00003 name=/opt/ora9/oradata/oradb/cwmlite01.dbf
input datafile fno=00004 name=/opt/ora9/oradata/oradb/drsys01.dbf
channel ch2: starting piece 1 at 23-MAY-08
channel ch3: starting full datafile backupset
channel ch3: specifying datafile(s) in backupset
input datafile fno=00002 name=/opt/ora9/oradata/oradb/undotbs01.dbf
input datafile fno=00007 name=/opt/ora9/oradata/oradb/odm01.dbf
input datafile fno=00008 name=/opt/ora9/oradata/oradb/tools01.dbf
channel ch3: starting piece 1 at 23-MAY-08
channel ch4: starting full datafile backupset
channel ch4: specifying datafile(s) in backupset
input datafile fno=00001 name=/opt/ora9/oradata/oradb/system01.dbf
channel ch4: starting piece 1 at 23-MAY-08
channel ch1: finished piece 1 at 23-MAY-08
piece handle=/opt/rmanbak/dbbak/db_ORADB_20080523_4tjh39md_1_1 comment=NONE
channel ch1: backup set complete, elapsed time: 00:00:08
channel ch2: finished piece 1 at 23-MAY-08
piece handle=/opt/rmanbak/dbbak/db_ORADB_20080523_4ujh39md_1_1 comment=NONE
channel ch2: backup set complete, elapsed time: 00:00:33
channel ch3: finished piece 1 at 23-MAY-08
piece handle=/opt/rmanbak/dbbak/db_ORADB_20080523_4vjh39me_1_1 comment=NONE
channel ch3: backup set complete, elapsed time: 00:00:57
channel ch4: finished piece 1 at 23-MAY-08
piece handle=/opt/rmanbak/dbbak/db_ORADB_20080523_50jh39me_1_1 comment=NONE
channel ch4: backup set complete, elapsed time: 00:01:04
Finished backup at 23-MAY-08
Starting Control File and SPFILE Autobackup at 23-MAY-08
piece handle=/opt/rmanbak/autoctlbak/c-2407010394-20080523-0a comment=NONE
Finished Control File and SPFILE Autobackup at 23-MAY-08
sql statement: alter system archive log current
Starting backup at 23-MAY-08
current log archived
channel ch1: starting archive log backupset
channel ch1: specifying archive log(s) in backup set
input archive log thread=1 sequence=59 recid=59 stamp=655468237
channel ch1: starting piece 1 at 23-MAY-08
channel ch2: starting archive log backupset
channel ch2: specifying archive log(s) in backup set
input archive log thread=1 sequence=60 recid=60 stamp=655468305
channel ch2: starting piece 1 at 23-MAY-08
channel ch3: starting archive log backupset
channel ch3: specifying archive log(s) in backup set
input archive log thread=1 sequence=61 recid=61 stamp=655468305
channel ch3: starting piece 1 at 23-MAY-08
channel ch1: finished piece 1 at 23-MAY-08
piece handle=/opt/rmanbak/arcbak/arc_20080523_162 comment=NONE
channel ch1: backup set complete, elapsed time: 00:00:02
channel ch1: deleting archive log(s)
archive log filename=/opt/ora9/oradata/oradb/archive/1_59.dbf recid=59 stamp=655468237
channel ch2: finished piece 1 at 23-MAY-08
piece handle=/opt/rmanbak/arcbak/arc_20080523_163 comment=NONE
channel ch2: backup set complete, elapsed time: 00:00:02
channel ch2: deleting archive log(s)
archive log filename=/opt/ora9/oradata/oradb/archive/1_60.dbf recid=60 stamp=655468305
channel ch3: finished piece 1 at 23-MAY-08
piece handle=/opt/rmanbak/arcbak/arc_20080523_164 comment=NONE
channel ch3: backup set complete, elapsed time: 00:00:02
channel ch3: deleting archive log(s)
archive log filename=/opt/ora9/oradata/oradb/archive/1_61.dbf recid=61 stamp=655468305
Finished backup at 23-MAY-08
Starting backup at 23-MAY-08
channel ch1: starting full datafile backupset
channel ch1: specifying datafile(s) in backupset
including current controlfile in backupset
channel ch1: starting piece 1 at 23-MAY-08
channel ch1: finished piece 1 at 23-MAY-08
piece handle=/opt/rmanbak/dbbak/ctl_165_1_20080523 comment=NONE
channel ch1: backup set complete, elapsed time: 00:00:01
Finished backup at 23-MAY-08
Starting Control File and SPFILE Autobackup at 23-MAY-08
piece handle=/opt/rmanbak/autoctlbak/c-2407010394-20080523-0b comment=NONE
Finished Control File and SPFILE Autobackup at 23-MAY-08
released channel: ch1
released channel: ch4
released channel: ch2
released channel: ch3
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of crosscheck command at 05/23/2008 10:31:50
RMAN-06091: no channel allocated for maintenance (of an appropriate type)
RMAN>
Recovery Manager complete.
|