Veritas-bu

[Veritas-bu] ora-00020 with NBU RMAN plugin

2003-02-27 11:33:49
Subject: [Veritas-bu] ora-00020 with NBU RMAN plugin
From: Laurence.Moughan AT o2 DOT com (Moughan, Laurence)
Date: Thu, 27 Feb 2003 16:33:49 -0000
tested this agian using a sample script via NBU and still the ora processes
just continue to increment till the db is locked out.

ANyone every seen anything similar ?

-----Original Message-----
From: Moughan, Laurence 
Sent: Tuesday, February 25, 2003 5:10 PM
To: 'veritas-bu AT mailman.eng.auburn DOT edu'
Subject: ora-00020 with NBU RMAN plugin
Importance: High


Hi All,

I installed oracle plugin for netbackup and have configured a template for
full backups.

After running seemingly ok - i then seem to get a very fast escallation of
the number of in use processes and end up with ora-20. I have to kill rman
and stop/start the db to recover to normal ops.

I have tested this with no other users connected and with max procs = 350 in
my initxxx.ora still managed an ora-20


Any ideas ?


Logs

Recovery Manager: Release 8.1.7.3.0 - Production

2> 
3> # -----------------------------------------------------------------
4> # RMAN command section
5> # -----------------------------------------------------------------
6> 
7> RUN {
8> 
9> ALLOCATE CHANNEL ch00 
10>     TYPE 'SBT_TAPE';
11> SEND 'NB_ORA_CLIENT=dnem1002';
12> BACKUP
13>     INCREMENTAL LEVEL=0
14>     FORMAT 'bk_u%u_s%s_p%p_t%t'
15>     DATABASE
16>     INCLUDE CURRENT CONTROLFILE;
17> 
18> RELEASE CHANNEL ch00;
19> 
20> # Backup Archived Logs
21> sql 'alter system archive log current';
22> 
23> ALLOCATE CHANNEL ch00 
24>     TYPE 'SBT_TAPE';
25> SEND 'NB_ORA_CLIENT=dnem1002';
26> BACKUP
27>     FORMAT 'arch-s%s-p%p-t%t'
28>     ARCHIVELOG
29>         ALL;
30> 
31> RELEASE CHANNEL ch00;
32> 
33> # Control file backup
34> 
35> ALLOCATE CHANNEL ch00 
36>     TYPE 'SBT_TAPE';
37> SEND 'NB_ORA_CLIENT=dnem1002';
38> BACKUP
39>     FORMAT 'bk_u%u_s%s_p%p_t%t'
40>     CURRENT CONTROLFILE;
41> RELEASE CHANNEL ch00;
42> }
43> 
RMAN-06009: using target database controlfile instead of recovery catalog

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: ch00
RMAN-08500: channel ch00: sid=104 devtype=SBT_TAPE
RMAN-08526: channel ch00: VERITAS NetBackup for Oracle - Release 4.5GA
(00000000)

RMAN-03022: compiling command: send
RMAN-06421: sent command to channel: ch00

RMAN-03022: compiling command: backup
RMAN-03023: executing command: backup
RMAN-08008: channel ch00: starting incremental level 0 datafile backupset
RMAN-08502: set_count=4 set_stamp=486913673 creation_time=25.02.2003
RMAN-08010: channel ch00: specifying datafile(s) in backupset
RMAN-08522: input datafile fno=00003 name=/d/db/oradata/oss/rbs01.dbf
RMAN-08522: input datafile fno=00004 name=/d/db/oradata/oss/temp_sort01.dbf
RMAN-08522: input datafile fno=00085
name=/d/db/oradata/oss/uma/umafsw/fswpma/fdbpm1_index_1.dbf
RMAN-08522: input datafile fno=00048
name=/d/db/oradata/oss/uma/umabss/bsspma/sqlpm2_2.dbf
RMAN-08522: input datafile fno=00053
name=/d/db/oradata/oss/uma/umabss/bsspma/sqlpm2_7.dbf


and from here many more .dbf then just stops, with no termination, just
sites there.

The linking also seems to have worked on the install.

# more make_trace.15616
Tue Feb 25 13:11:38 GMT 2003
All Oracle instances should be shutdown before running this script.
Do you want to continue? (y/n) [n] y
LIBOBK_PATH: /usr/openv/netbackup/bin
O_HOME: /opt/oracleclient/app/oracle/product/8.1.7
O_VERSION: 8.1.7.1.0
linking Oracle v8.1.7.1.0 for hp11.00 64 bit
ln -s /usr/openv/netbackup/bin/libobk.sl
/opt/oracleclient/app/oracle/product/8.1.7/lib/libobk.s


****************************************************************************************

This E-mail is from O2. The E-mail and any files
transmitted with it are confidential and may also be privileged and intended
solely for the use of the individual or entity to whom they are addressed.
Any unauthorised direct or indirect dissemination, distribution or copying
of this message and any attachments is strictly prohibited. If you have
received the E-mail in error please notify postmaster AT O2 DOT com or 
                  telephone ++ 353 1 6095000.

*****************************************************************************************


<Prev in Thread] Current Thread [Next in Thread>