RMAN backup hangs

Robert Klemme

unread,

Feb 5, 2007, 8:09:25 AM2/5/07

to

Hi,

I have a Oracle 10.2.0.1.0 on Linux. RMAN is configured to do backups
via Tivoli. This worked pretty nicely in the past but now we have a
backup job that just hangs in step "Backup" since Jan 15th (see below,
"Pre-Backup" was ok). Since there are no errors as far as I can see
(also checked syslog), is there some other place to look for diagnostic
messages?

Bonus question: is it safe to just cancel this job?

Thanks a lot!

Kind regards

robert

Recovery Manager: Release 10.2.0.1.0 - Production on Mon Jan 15 22:00:16
2007

RMAN>
connected to target database: ORCL (DBID=1105576547)
using target database control file instead of recovery catalog

RMAN>
echo set on

RMAN> set command id to 'DAILY_FULL_BACKUP_011507100005';
executing command: SET COMMAND ID

RMAN> backup device type sbt tag 'DAILY_FULL_BACKUP_011507100005' database;
Starting backup at 15-JAN-07
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: sid=450 devtype=SBT_TAPE
channel ORA_SBT_TAPE_1: Data Protection for Oracle: version 5.3.3.0
channel ORA_SBT_TAPE_1: starting full datafile backupset
channel ORA_SBT_TAPE_1: specifying datafile(s) in backupset
input datafile fno=00004 name=/opt/oradata/orcl/users01.dbf
input datafile fno=00002 name=/opt/oradata/orcl/undotbs01.dbf
input datafile fno=00005 name=/opt/oradata/orcl/users02.dbf
input datafile fno=00003 name=/opt/oradata/orcl/sysaux01.dbf
input datafile fno=00001 name=/opt/oradata/orcl/system01.dbf
channel ORA_SBT_TAPE_1: starting piece 1 at 15-JAN-07

Cristian Cudizio

unread,

Feb 5, 2007, 8:28:59 AM2/5/07

to

Are you sure that your tape is running?

Cristian Cudizio

Robert Klemme

unread,

Feb 5, 2007, 9:41:16 AM2/5/07

to

On 05.02.2007 14:28, Cristian Cudizio wrote:
> Are you sure that your tape is running?

It's not done on tape but via Tivoli's Media Manager for Oracle.
Interestingly I found out that apparently all backup sets from Jan 15th
are present in the storage and can also be validated positively. (The
datafile validation is still running.)

Also, Tivoli is running ok (which is also demonstrated by successful
validation). It seems that somehow RMAN status stopped being recorded
properly. Interestingly enough there is an rman process in the system.
But it appears to be idle.

Kind regards

robert

Robert Klemme

unread,

Feb 5, 2007, 10:11:25 AM2/5/07

to

Additional info: I found a log file apparently written by Tivoli Storage
Manager. It ends with these lines

[oracle] r1:/home/oracle: tail -4
/opt/tivoli/tsm/client/oracle/bin/dsmerror_oracle.log
15.01.2007 22:55:23 ANS0278S The transaction will be aborted.
15.01.2007 22:55:23 ANS0278S The transaction will be aborted.
15.01.2007 22:55:23 ANS1329S Server out of data storage space
15.01.2007 22:55:23 ANS1329S Server out of data storage space

So apparently there was an issue on the storage side that did not get
propagated to RMAN properly...

Cheers

robert