Networker

Re: [Networker] can i avoid use of SYS password for RMAN scripts?

2008-01-11 10:26:52
Subject: Re: [Networker] can i avoid use of SYS password for RMAN scripts?
From: Szymon Madej <szymon.madej AT BRE-LEASING.COM DOT PL>
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Date: Fri, 11 Jan 2008 10:13:53 -0500
Hello!

I'm new to this list (and to the NetWorker too), so I say 'Hello' to
everybody.  I was using TSM previously, but my current employee uses NetWorker.


The answer for your question Mark is yes, you can avoid SYS password in
scripts, but you can't avoid password to Recovery Catalog user if you are
using it. 
I'm assuming that you want to backup Oracle databases in UNIX environment
(you mentioned 'root' user). NetWorker uses a root account to run scripts,
but you can write a wrapper script ie:

#!/bin/bash

### Run RMAN backup script as oracle user.
su - oracle -c /nsr/rman/backup_rman.sh

### If script returns OK, call save.
SCRIPT_RESULT=$?
if [ ${SCRIPT_RESULT} -eq 0 ]; then
  save $@
fi


In my environment /nsr/rman/backup_rman.sh script call RMAN with:

rman target / catalog rman/catalog_pass@RMANCATALOG cmdfile
/nsr/rman/backup.rman

In my case I use Recovery Catalog, so I must provide a user/password to
Recovery Catalog database, but If you use control files instead Recovery
Catalog there is no need to put it there.

Best regards
Szymon Madej

To sign off this list, send email to listserv AT listserv.temple DOT edu and 
type "signoff networker" in the body of the email. Please write to 
networker-request AT listserv.temple DOT edu if you have any problems with this 
list. You can access the archives at 
http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER

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