Networker

[Networker] Module for Oracle : No matching devices (long)

2004-05-19 11:27:15
Subject: [Networker] Module for Oracle : No matching devices (long)
From: "Scott D. Clemons" <scott.clemons AT MERCYIC DOT ORG>
To: NETWORKER AT LISTMAIL.TEMPLE DOT EDU
Date: Wed, 19 May 2004 10:16:57 -0500
Within the last 3 weeks we have successfully implemented two (2) Module for
Oracle (NMO) however the third and last NMO implementation has gone awry
with the error message "nwora_open_backup: unable to start save session
with server lawson: no matching
 devices; check storage nodes, devices or pools"  The two successful
implementations are in groups and backup nightly without error.

Please see following the rman output of my first attempt at a manual NMO
backup.

The script is known to be good, as I ftp-ed it from a successful
implementation and edited the NSR_CLIENT.

I have walked through the Troubleshooting Tips (pg 201) from the NMO Admin
Guide (v4.1):
1) Versions match and are supported.
Oracle OS HP-UX B.11.11
Oracle v. 8.1.7 64 bit
Networker Client v. 7.1.1
Networker Server v. 7.1.1
NMO v. 4.1

2) rman 'type disk' backup is successful.

3) Networker server is live and in production.  The Oracle server's
Networker client (saveset all) backs up nightly within a group.

4) NMO v 4.1 is installed and linked correctly.

5) Manual NMO backup fails.

The Admin Guide (v4.1) pg 210 directs that for the 'reason' see the Legato
Networker Error Message Guide and follow the instructions there.

The Error Message Guide (pg 299) suggests an issue with the storage node
which in our case is the nsrserverhost - the only storage
node.  Never-the-less, I've followed the resolution instructions:
1) The path to the device does match between the Pool Device attribute and
the devices themselves.  The Pool functions correctly globally.

2) The devices are enabled.  The devices function correctly globally.

3) The Client (saveset rman_script) has nsrserverhost as it's storage node
and it's devices are enabled.  Identical to the two functioning NMO clients.

Then I started thrashing around.  I tried the script without NSR_CLIENT.  I
tried the script the NSR_DEBUG_LEVEL=2, no output.  I checked the
nmo.messages: "SBT-17375 05/17/04 19:44:12 nwora_open_backup: unable to
start save session with server lawson: no matching devices; check storage
nodes, devices or pools"  I verified that user oracle@lawson was a
Networker administrator and could bring up nwadmin.  I deleted the
rman_script client, tried the manual NMO backup.  I recreated the
rman_script client.  I re-typed the script by hand.  I ftp-ed a different
copy of a known good script.  I verified that user oracle could issue a
client-side save of a file.  I've tried different
NSR_DATA_VOLUME_POOLs.  I've mounted the correct target volume before
trying the manual.

Thanks in advance for your consideration and assistance -Scott

------------------------------------------------
Recovery Manager: Release 8.1.7.0.0 - Production

RMAN-06005: connected to target database: PROD (DBID=4177802999)
RMAN-06008: connected to recovery catalog database

RMAN> run {
2>      set command id to 'track';
3>      allocate channel t1 type 'SBT_TAPE';
4>      send 'ENV=(NSR_SERVER=legato2,
5>                      NSR_CLIENT=lawson,
6>                      NSR_DATA_VOLUME_POOL=Default)';
7>      backup
8>              full
9>              filesperset 4
10>             format '/FULL_%d_%s_%p/'
11>             (database);
12>     release channel t1;
13> }
14>
RMAN-03022: compiling command: set
RMAN-03023: executing command: set command id

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: t1
RMAN-08500: channel t1: sid=14 devtype=SBT_TAPE
RMAN-08526: channel t1: NMO v4.1.0.0

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

RMAN-03022: compiling command: backup
RMAN-03023: executing command: backup
RMAN-08008: channel t1: starting full datafile backupset
RMAN-08502: set_count=27 set_stamp=526555728 creation_time=19-MAY-04
RMAN-08010: channel t1: specifying datafile(s) in backupset
RMAN-08522: input datafile fno=00010 name=/u05/oradata/prod/data03.dbf
RMAN-08522: input datafile fno=00008 name=/u01/oradata/prod/tf60.dbf
RMAN-08522: input datafile fno=00005 name=/u01/oradata/prod/users01.dbf
RMAN-08522: input datafile fno=00002 name=/u01/oradata/prod/tools01.dbf
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03007: retryable error occurred during execution of command: backup
RMAN-07004: unhandled exception during command execution on channel t1
RMAN-10035: exception raised in RPC: ORA-19506: failed to create sequential
file, name="/FULL_PROD_27_1/", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: nwora_open_backup: unable to start save session with server
lawson: no matching
 devices; check storage nodes, devices or pools
RMAN-10031: ORA-19624 occurred during call to
DBMS_BACKUP_RESTORE.BACKUPPIECECREATE

Recovery Manager complete.

--
Note: To sign off this list, send a "signoff networker" command via email
to listserv AT listmail.temple DOT edu or visit the list's Web site at
http://listmail.temple.edu/archives/networker.html where you can
also view and post messages to the list.
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=

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