查看:7349|回复：2
今天我安装Dataguard 物理备库之Duplicate
报错如下：
(12.84 KB)
高级工程师
从报错的信息来看，建议检查辅助库（auxiliary)上的监听是否工作正常。
谢谢你 现在搞定了！监听的问题RMAN-05502: the target database must be mounted when issuing a DUPLICATE command-OERR-Oracle高手之路—Orasql.Com！
&&&&&&&&&当前位置&&&&OERR&
【RMAN-05502】
Description：
the target database must be mounted when issuing a DUPLICATE command
A DUPLICATE command was issued, but the target database control file is not mounted.
Mount the target database control file by issuing ALTER DATABASE MOUNT via Enterprise Manager or Server Manager.
谷歌搜索：
& & & &&站内搜索：
用手机扫描下方的二维码，关注Oracle高手之路微信，可以随时随地查询ORA、CRS、OGG等错误信息～
&|E-Mail:|Phone:|Copyright&&&2011|All Rights Reserved|RMAN-06470: DEVICE TYPE is supported only when automatic channels are used-OERR-Oracle高手之路—Orasql.Com！
&&&&&&&&&当前位置&&&&OERR&
【RMAN-06470】
Description：
DEVICE TYPE is supported only when automatic channels are used
The DEVICE TYPE option was specified with a BACKUP, RESTORE, RECOVER, DUPLICATE, CHANGE, VALIDATE, CROSSCHECK, or DELETE EXPIRED command. This option is allowed only when automatically allocated channels are used.
Remove the DEVICE TYPE option and re-run the command. Or Remove all ALLOCATE commands and re-run the script so that channels are automatically allocated.
谷歌搜索：
& & & &&站内搜索：
用手机扫描下方的二维码，关注Oracle高手之路微信，可以随时随地查询ORA、CRS、OGG等错误信息～
&|E-Mail:|Phone:|Copyright&&&2011|All Rights Reserved|RMAN-05503: at least one auxiliary channel must be allocated to execute this command-OERR-Oracle高手之路—Orasql.Com！
&&&&&&&&&当前位置&&&&OERR&
【RMAN-05503】
Description：
at least one auxiliary channel must be allocated to execute this command
No auxiliary channels were allocated.
Allocate an auxiliary channel.
谷歌搜索：
& & & &&站内搜索：
用手机扫描下方的二维码，关注Oracle高手之路微信，可以随时随地查询ORA、CRS、OGG等错误信息～
&|E-Mail:|Phone:|Copyright&&&2011|All Rights Reserved|rman备份时报错，请高手指点 - Oracle专题深入讨论 - ITPUB论坛－中国专业的IT技术社区
后使用快捷导航没有帐号？
查看: 2894|回复: 10
rman备份时报错，请高手指点
论坛徽章:3
1、我的平台 rhel4u4 上装的9204
2、我的脚本，
rman nocatalog target / log=/opt/rmanbak/rmanlog/backupall_`date +&%Y%m%d%H%M%S&`.log&&EOF
allocate channel ch1
allocate channel ch2
allocate channel ch3
allocate channel ch4
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'
backup current controlfile format '/opt/rmanbak/dbbak/ctl_%s_%p_%T';
release channel ch1;
release channel ch2;
release channel ch3;
release channel ch4;
3、日志文件里面的信息
Recovery Manager: Release 9.2.0.4.0 - Production
Copyright (c) , Oracle Corporation.&&All rights reserved.
connected to target database: ORADB (DBID=)
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_tjh39md_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_ujh39md_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_vjh39me_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_jh39me_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--a 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=
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=
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=
channel ch3: starting piece 1 at 23-MAY-08
channel ch1: finished piece 1 at 23-MAY-08
piece handle=/opt/rmanbak/arcbak/arc_ 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=
channel ch2: finished piece 1 at 23-MAY-08
piece handle=/opt/rmanbak/arcbak/arc_ 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=
channel ch3: finished piece 1 at 23-MAY-08
piece handle=/opt/rmanbak/arcbak/arc_ 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=
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_ 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--b 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/:50
RMAN-06091: no channel allocated for maintenance (of an appropriate type)
Recovery Manager complete.
论坛徽章:3
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of crosscheck command at 05/23/:50
RMAN-06091: no channel allocated for maintenance (of an appropriate type)
日志后面抱了这一堆错误。
不分配管道的时候可以正常运行
论坛徽章:3
分配管道的时候只要在脚本中删除下面的语句也可以正常运行：
所以我怀疑是crosscheck引起的，但是问题出在哪呢？
论坛徽章:3
没有人回答啊
论坛徽章:2
delete noprompt obsolete
执行这些的时候只能用单个channel，这些命令是没有办法在多个channel情况下执行的！
论坛徽章:2
你可以写成这样：
rman nocatalog target / log=/opt/rmanbak/rmanlog/backupall_`date +&%Y%m%d%H%M%S&`.log&&EOF
allocate channel ch1
allocate channel ch2
allocate channel ch3
allocate channel ch4
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'
backup current controlfile format '/opt/rmanbak/dbbak/ctl_%s_%p_%T';
release channel ch1;
release channel ch2;
release channel ch3;
release channel ch4;
论坛徽章:3
回复 #6 randylin2006 的帖子
多谢 达人，这是个解决的好办法
招聘 : 论坛徽章:7
以前没有注意过这个
今天又学了点
下班后请大家吃饭
论坛徽章:1
如果CHANGE, CROSSCHECK, DELETE执行的是磁盘操作（DISK），不必手工分配维护同道（maintenance channel），以为ORACLE已经预配置了维护通道
论坛徽章:3
回复 #8 mang003 的帖子
我也是偶然发现的，在10g上试的时候没有问题，在9i上死活都过不去。 照 zerocool 的理解，那10g没有出现过问题呢？难道10g和9i的rman管理机制上有变化。
itpub.net All Right Reserved. 北京盛拓优讯信息技术有限公司版权所有　　　　
　北京市公安局海淀分局网监中心备案编号：10　广播电视节目制作经营许可证：编号（京）字第1149号