Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

rman cannot take backup properly

shipon_97Nov 10 2008 — edited Nov 16 2008
Dear Friends ,

I m taking the RMAN backup incrementally every 5 days and take full backup one day of the week . But yesterday suddenly my RMAN incremental backup cannot complete succesfully . It shows the follwoing error :


connected to target database: ABABIL (DBID=1077970889)
using target database control file instead of recovery catalog
allocated channel: t1
sql statement: alter system switch logfile
channel t1: sid=379 devtype=SBT_TAPE
channel t1: Data Protection for Oracle: version 5.4.1.0


Starting backup at 09-NOV-08
input datafile fno=00006 name=/dbfs/oradata/ababil/ts_ababil_image01.DBF
input datafile fno=00004 name=/dbfs/oradata/ababil/users01.dbf
channel t1: specifying datafile(s) in backupset
channel t1: starting incremental level 1 datafile backupset
input datafile fno=00005 name=/dbfs/oradata/ababil/ts_ababil01.DBF
channel t1: starting piece 1 at 09-NOV-08
input datafile fno=00003 name=/dbfs/oradata/ababil/sysaux01.dbf
input datafile fno=00002 name=/dbfs/oradata/ababil/undotbs01.dbf
input datafile fno=00001 name=/dbfs/oradata/ababil/system01.dbf
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on t1 channel at 11/09/2008 22:57:45
ORA-19502: write error on file "uejva5n8_1_1", blockno 661505 (blocksize=512)

ORA-19511: Error received from media manager layer, error text:


ANS1017E (RC-50) Session rejected: TCP/IP connection failure
ORA-27030: skgfwrt: sbtwrite2 returned error



I m using oracle10g with AIX 5.3 unix server as production server . I m using Library tape for rman backup purpose and my rman incremental script is :



run
{
allocate channel t1 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
sql "alter system switch logfile";
backup incremental level 1 database;
backup archivelog all delete input;
}.


Can u plz tell me whay is the problem ?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 14 2008
Added on Nov 10 2008
6 comments
1,004 views