Re: RMAN backup hangs

From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Mon, 05 Feb 2007 16:11:25 +0100
Message-ID: <52ovofF1pd7snU1@mid.individual.net>

On 05.02.2007 15:41, Robert Klemme wrote:
> 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.

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 Received on Mon Feb 05 2007 - 09:11:25 CST