RE: Alternatives to RMAN cleartext password in batch file for backups?
From: Michael Dinh <mdinh_at_XIFIN.Com>
Date: Sat, 23 Apr 2011 18:30:33 -0700
Message-ID: <D29F9902E534D5478F2E83FD6A44B3063AFD865A6E_at_mail02.mba.xifin.com>
Take a look at
From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] On Behalf Of Bill Myers [bwmyers_at_gmail.com] Sent: Saturday, April 23, 2011 6:05 PM
To: oracle-l_at_freelists.org
Subject: Alternatives to RMAN cleartext password in batch file for backups?
Date: Sat, 23 Apr 2011 18:30:33 -0700
Message-ID: <D29F9902E534D5478F2E83FD6A44B3063AFD865A6E_at_mail02.mba.xifin.com>
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_at_freelists.org [oracle-l-bounce_at_freelists.org] On Behalf Of Bill Myers [bwmyers_at_gmail.com] Sent: Saturday, April 23, 2011 6:05 PM
To: oracle-l_at_freelists.org
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_at_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
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Apr 23 2011 - 20:30:33 CDT