LoveUnix » ORACLE等数据库 » rman备份数据库错误求助
让LU留住您的每

一天 让LU博客留住您的每一天
2006-9-10 18:17 haomao1879
rman备份数据库错误求助

rman备份数据库错误求助

本人今天安装 配置了 tsm及其中的tdpo组件,参数文件皆正确,但是备份数据库出现个奇怪的问题,如下 :

Recovery Manager: Release 9.2.0.6.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database: ZGCDB (DBID=2176649540)
connected to recovery catalog database

RMAN> run {
2> allocate channel t1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
3> backup
4> format 'df_%t_%s_%p'
5> (database);
6> release channel t1;
7> }
8>
allocated channel: t1
channel t1: sid=18 devtype=SBT_TAPE
channel t1: Tivoli Data Protection for Oracle: version 5.2.0.0

Starting backup at 11-SEP-06
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 09/11/2006 06:25:50
ORA-00600: internal error code, arguments: [525], [0x70000000EFCEDF8], [5], [library cache], [5], [0x700000000025BF0], [device information], []
ORA-27041: unable to open file
IBM AIX RISC System/6000 Error: 25: Not a typewriter
Additional information: 16

Recovery Manager complete.

但是我备份归档日志倒成功,具体如下 :

Recovery Manager: Release 9.2.0.6.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database: ZGCDB (DBID=2176649540)
connected to recovery catalog database

RMAN> sql 'alter system archive log current';
2> run {
3> allocate channel t1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
4> allocate channel t2 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
5> sql 'alter system switch logfile';
6> backup
7> filesperset 10
8> format 'arch_%t_%s.dbf'
9> tag 'archivelog backup'
10> archivelog like '/oracle/oradata/ZGCDB/archlog/1_%.dbf'
11> delete input;
12> release channel t1;
13> release channel t2;
14> }
15>
sql statement: alter system archive log current

allocated channel: t1
channel t1: sid=18 devtype=SBT_TAPE
channel t1: Tivoli Data Protection for Oracle: version 5.2.0.0

allocated channel: t2
channel t2: sid=11 devtype=SBT_TAPE
channel t2: Tivoli Data Protection for Oracle: version 5.2.0.0

sql statement: alter system switch logfile

Starting backup at 11-SEP-06
channel t1: starting archive log backupset
channel t1: specifying archive log(s) in backup set
input archive log thread=1 sequence=43 recid=29 stamp=600848099
input archive log thread=1 sequence=44 recid=30 stamp=600848578
channel t1: starting piece 1 at 11-SEP-06
channel t2: starting archive log backupset
channel t2: specifying archive log(s) in backup set
input archive log thread=1 sequence=45 recid=31 stamp=600848579
channel t2: starting piece 1 at 11-SEP-06
channel t1: finished piece 1 at 11-SEP-06
piece handle=arch_600848579_3.dbf comment=API Version 2.0,MMS Version 5.2.0.0
channel t1: backup set complete, elapsed time: 00:00:16
channel t1: deleting archive log(s)
archive log filename=/oracle/oradata/ZGCDB/archlog/1_43.dbf recid=29 stamp=600848099
archive log filename=/oracle/oradata/ZGCDB/archlog/1_44.dbf recid=30 stamp=600848578
channel t2: finished piece 1 at 11-SEP-06
piece handle=arch_600848579_4.dbf comment=API Version 2.0,MMS Version 5.2.0.0
channel t2: backup set complete, elapsed time: 00:00:16
channel t2: deleting archive log(s)
archive log filename=/oracle/oradata/ZGCDB/archlog/1_45.dbf recid=31 stamp=600848579
Finished backup at 11-SEP-06

released channel: t1

released channel: t2

Recovery Manager complete.

我的oracle rman中的设置如下:



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;
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
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 MAXSETSIZE TO UNLIMITED; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/product/9.2.0/dbs/snapcf_ZGCDB.f'; # default

RMAN>

请大家指教是哪儿出了偏差!!!!!!!

2006-9-10 20:22 闲云
改为下面的语句试试
backup database format 'df_%t_%s_%p'  DISKRATIO=0;

2006-10-26 17:01 football2006
rman是怎么登陆的?

2006-10-26 17:08 football2006
楼主有qq号吗?我想和你交个朋友。

页: [1]


Powered by Discuz! Archiver 5.5.0  © 2001-2006 Comsenz Inc.