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

jbj2

--

Jamey Johnston

Begin forwarded message:



> From: "jj_at_jameyj.com" <jj_at_lsualumni.com>

> Date: April 24, 2011 1:12:07 PM CDT

> To: "bwmyers_at_gmail.com" <bwmyers_at_gmail.com>, jj_at_jameyj.com

> Cc: "oracle-l_at_freelists.org" <oracle-l_at_freelists.org>

> Subject: Re: Alternatives to RMAN cleartext password in batch file for backups?

> 




> Attached is an example using Powershell. Just save the zip file contents to a directory, open a command prompt and go to that directory and type "powershell". Then type ".\rman_test.ps1". (Be sure to change the info to match your stuff!).

>  

> Enjoy!

>  

>  

>  

>  

>  

> 

> On April 24, 2011 at 1:30 PM Jamey Johnston <jj_at_jameyj.com> wrote:

> 

> > Looks like you are using Windows. Might be able to use Powershell - http://bittangents.com/2010/03/20/powershell-script-encrypting-decrypting-a-string-function-encrypt-string/

> >

> >

> >

> >

> > jbj2

> >

> > --

> >

> > Jamey Johnston

> >

> > On Apr 23, 2011, at 8:05 PM, Bill Myers <bwmyers_at_gmail.com> wrote:

> >

> > > 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-l

> >

> >

> 


--
http://www.freelists.org/webpage/oracle-l