Networker

Re: [Networker] Oracle 9i Backup Problem ----- Resolved

2003-04-30 23:40:19
Subject: Re: [Networker] Oracle 9i Backup Problem ----- Resolved
From: Pat Higgins <Pat.Higgins AT CHAPMANTRIPP DOT COM>
To: NETWORKER AT LISTMAIL.TEMPLE DOT EDU
Date: Thu, 1 May 2003 15:40:14 +1200
Stefan et al,

Thanks for your comments.
I got it working.

The main problem was a windows "Program Files" path problem....

in nsrnmo.bat, the path to C:\Program Files\nsr\bin\nsrnmostart was getting
broken up into two arguments:
(1760) argv[ 0] = c:\"Program
(1760) argv[ 1] = Files\nsr\bin\nsrnmostart -s
wgnmessage01.chapmantripp.co.nz........

So I took out the C:\Program Files\nsr\bin..... and suddenly
started getting output in nwadmin.

Also, I modified the paths in nsrnmo.bat, for the message and
log file destinations.

Finally I remmed out some pre/post processing commands ( which I had put in
nsrnmo.bat ) and
suddenly it was working.

Thanks
Pat

-----Original Message-----
From: Stefan Kapitza [mailto:k AT PITZA DOT DE]
Sent: Thursday, 17 April 2003 23:02
To: NETWORKER AT LISTMAIL.TEMPLE DOT EDU
Subject: Re: [Networker] Oracle 9i Backup Problem ( CMD Line backups
run, Legato GUI jobs do not )


Hi,

Im not familar with rman backups without catalog
(personaly I dont like them), but I think when you
run via GUI, your nocatalog Information is missing
as you give it on commandline.

Possibly enabling debugging in nsrmo.bat would
give more hints.

hth

Stefan Kapitza

On Thu, 17 Apr 2003 16:14:27 +1200, Pat Higgins
<Pat.Higgins AT CHAPMANTRIPP DOT COM> wrote:

>Hello
>Can anyone help with this problem?
>Heres the environment details first of all.
>
>The Backup Server:
>
>Hostname is wgnmessage01
>Legato Server: V6.2 Build 109
>Operating System: NT Server 4.0 (Build 1381 Service Pack 6a )
>Two DLT Tape Drives ( in the same Pool )
>
>The Backup Client:
>
>Hostname is wgnoracletest
>Networker Module for Oracle: V3.5
>Operating System: Win2K ( Service Pack 2 )
>Oracle Database: Oracle 9i ( 9.0.1.1.1 )
>
>The Problem:
>On the Oracle server,when I run,
> rman nocatalog cmdfile D:\backup\backup_df.txt
>on the command line, it successfully writes the data to tape on the Legato
>server.
>
>I can monitor the job in Nwadmin and it reports:
>Thur 14:59:22 write completion notice:Writing to volume Oracle_Test.002
>complete.
>While the backup  is running I can see RMAN sessions starting up and
closing
>on the oracle server ( v$session ).
>
>However , I cannot get manual or scheduled Oracle backup jobs to run from
>the Legato Admin program.
>I have been through the NMO Admin Guide ( and will be going through it
again
>).
>I have configured the Backup Command for the client on the Remote tab as
>nsrnmo.bat
>I have configured the saveset for the client as d:\backup\backup_df.txt
>The schedule for the client specifys to do a level "Full".
>
>When the job is started:
>A nsrsbtcn.exe starts on the Legato client, visible in Task Manager.
>No RMAN sessions appear in v$session.
>
>On the Legato Backup server, Nwadmin reports:
> Thur 14:22:05 savegroup info: starting Oracle_Backup1 ( with 1 client(s))
>But thats all. nothing else happens , it all just sits there, till I abort
>it.
>
>The contents of the RMAN script ( d:\backup\backup_df.txt ) is shown below.
>
>connect target system/"systems-password"@oracle9i # I'am just not showing
>you the password here :-)
>run {
>set command id to 'Obk1';
>allocate channel t1 type 'SBT_TAPE';
>send
>'NSR_ENV=
(NSR_DATA_VOLUME_POOL=WGNDefault,NSR_SERVER=wgnmessage01.chapmantri
>pp.co.nz)';
>backup datafile 3 format 'df_%d_%u';
>release channel t1;
>}
>
>
>If someone can help/advise I would be grateful.
>
>Pat Higgins
>Network Administrator
>CTSY
>Wellington N.Z.
>
>--
>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.
>=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=

--
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.
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=

--
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>
  • Re: [Networker] Oracle 9i Backup Problem ----- Resolved, Pat Higgins <=