RE: Alternatives to RMAN cleartext password in batch file for backups?

  • From: Michael Dinh <mdinh@xxxxxxxxx>
  • To: "bwmyers@xxxxxxxxx" <bwmyers@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Sat, 23 Apr 2011 18:30:33 -0700

Take a look at

Oracle’s secure external password store

http://martincarstenbach.wordpress.com/2009/11/23/oracles-secure-external-password-store/

________________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] On Behalf 
Of Bill Myers [bwmyers@xxxxxxxxx]
Sent: Saturday, April 23, 2011 6:05 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Alternatives to RMAN cleartext password in batch file for backups?

Hi all,
I have the following commands in a batch file scheduled for daily execution:

set oracle_sid=mydatadb
rman target / catalog mycatusr/mycatpwd@mycatdb script Daily_Backup >> 
backup.log

My organization requires the catalog password (mycatpwd) above to be encrypted 
and not stored as clear text in any other file or environment variable. How can 
I still use this batch file for scheduled backups without providing a clear 
text password?

The only option I can think of is to compile the commands into a binary 
executable. Any other ideas besides that?

Thanks in advance.
Bill
--
//www.freelists.org/webpage/oracle-l


Other related posts: