ADSM-L

Oracle client and ANR0534W

2000-01-24 10:29:44
Subject: Oracle client and ANR0534W
From: Thiha Than <thiha AT US.IBM DOT COM>
Date: Mon, 24 Jan 2000 08:29:44 -0700
hi Steve,

Oracle agent cannot get the size estimate from EBU catalog.  You will have
to use DSMO_AVG_SIZE environment variable to specify the size estimate.
Default estimate size is 50MB.

reagards,
Thiha

>Hi all,

>I'm running AIX 4.3.2, ADSM 3.1.2.40 and the oracle agent with EBU against
an
>Oracle 7.3.3.4 Database.

>I'm trying to speed up the backup a bit so I've changed compress yes to
compress
>no in the system opts file for this client. Mission is accomplished and
things
>are running much faster. I was previously running with 3 parallel EBU
streams
>before copmpression and still am after compression.

>The problem is that  I'm now getting
>01/23/00   01:48:11 ANR0534W Transaction failed for session 26988 for node
>CERNER_PROD_ORA (Agnt for Orc Bkp) - size estimate exceeded and server is
unable
>to obtain additional space in storage pool BACKUPPOOL.
>01/23/00   01:48:11 ANR0534W Transaction failed for session 26972 for node
>CERNER_PROD_ORA (Agnt for Orc Bkp) - size estimate exceeded and server is
unable
>to obtain additional space in storage pool BACKUPPOOL.
>01/23/00   01:48:11 ANR0534W Transaction failed for session 26976 for node
>CERNER_PROD_ORA (Agnt for Orc Bkp) - size estimate exceeded and server is
unable
>to obtain additional space in storage pool BACKUPPOOL.

>I have reduced my migration threshhold in backuppool to avoid this
problem, but
>wonder why it could happen. The Oracle agent should know the size of the
>tablespaces that it is backing up quite precisely from the Oracle catalog
so it
>should never  send a wrong estimate to ADSM.  Does anyone know for sure
how this
>works in detail?

>Thanks

>Steve Harris
>AIX/ADSM/Oracle/HACMP and soon to be Lotus-Domino Guy
>The Wesley Hospital, Brisbane Australia
<Prev in Thread] Current Thread [Next in Thread>