Problems with RMAN backup

From: chris <rees_chris_at_hotmail.com>
Date: 18 Feb 2002 06:54:06 -0800
Message-ID: <bd665550.0202180654.1e9327ad@posting.google.com>

Hi All,

First let me give you the history

We were running on an IBM SP node running AIX 4.3.3. Over the weekend we moved this environment to a IBM B80 server. The rootvg was moved using a NIM image.

Thus the B80 runs the same level of OS as the old system

AIX 4.3.3 Maintenance Level 09
Oracle 8.1.7
TSM client 3.7.2
Oracle TDPO 2.1.10.0

The TSM server is running 4.1.5.

The problem.... since the move we have been unable to backup our 8.1.7 database. It connects to TSM and backs up 29 of the 34 .dbf files in backupsets, then it just stops. No sessions can be seen in TSM and the backup processes are still running on the B80. The rman trace file shows the following

krmxr: xc=539436504 chid=t1 calling peicnt krmxrpc: xc=539436504 kpurpc2 rc=0 db=target proc=DBMS_BACKUP_RESTORE.BACKUPPIECECREATE krmxrpc: xc=539436504 finishing RPC #68 to target RMAN-08013: channel t1: piece 1 created
RMAN-08503: piece handle=df_t454171339_s193_p1 comment=API Version 1.1,MMS Version 2.1.10.0
krmxrpc: xc=539436504 kpurpc2 rc=3123 db=target proc=DBMS_BACKUP_RESTORE.BACKUPPIECECREATE krmxrpc: xc=539436504 starting longrunning RPC #69 to target: DBMS_BACKUP_RESTORE.BACKUPPIECECREATE
krmxr: xc=539436504 started long running rpc krmxpoq: xc=539436504, action="0000069 STARTED", col_l=15, ind=0, sid=21

The normal backup log file shows

RMAN-08008: channel t1: starting full datafile backupset
RMAN-08502: set_count=193 set_stamp=454171339 creation_time=18-FEB-02
RMAN-08010: channel t1: specifying datafile(s) in backupset
RMAN-08522: input datafile fno=00007

name=/ORA/oradata/IGRL/data01/gmsdataIGRLaab.dbf RMAN-08522: input datafile fno=00013
name=/ORA/oradata/IGRL/index01/gmsindexIGRLaac.dbf RMAN-08522: input datafile fno=00031
name=/ORA/oradata/IGRL/data01/gmsdataIGRLaaf.dbf RMAN-08522: input datafile fno=00015
name=/ORA/oradata/IGRL/index02/gmsindex2IGRLaba.dbf RMAN-08522: input datafile fno=00025
name=/ORA/oradata/IGRL/index04/dmsindexIGRLada.dbf RMAN-08522: input datafile fno=00018
name=/ORA/oradata/IGRL/rep01/gmsrepIGRLaaa.dbf RMAN-08013: channel t1: piece 1 created
RMAN-08503: piece handle=df_t454171339_s193_p1 comment=API Version 1.1,MMS Version 2.1.10.0

Intersetingly, when you query the backupsets within TSM you can see df_t454171339_s193_p2 even though the oracle logs show this as not complete.

None of the usual files, e.g the actlog on TSM, or the oracle backup logs show any errors.

Has anyone seen this / got any ideas?

TIA Chris Received on Mon Feb 18 2002 - 08:54:06 CST