Re: Alternatives to RMAN cleartext password in batch file for backups?
- From: Bill Myers <bwmyers@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Sat, 23 Apr 2011 19:36:53 -0700
How about using a DBMS_SCHEDULER job calling a wrapped stored procedure that
passes a password variable into an O/S call to the batch file? Seems like a
worthy hack.
On Sat, Apr 23, 2011 at 7:36 PM, Bill Myers <bwmyers@xxxxxxxxx> wrote:
> I forgot to mention that I cannot use Oracle Wallet.
>
>
> On Sat, Apr 23, 2011 at 6:31 PM, Bill Myers <bwmyers@xxxxxxxxx> wrote:
>
>> How about using a DBMS_SCHEDULER job calling a wrapped stored procedure
>> that passes a password variable into an O/S call to the batch file.
>>
>> On Sat, Apr 23, 2011 at 6:05 PM, Bill Myers <bwmyers@xxxxxxxxx> 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@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
>>>
>>
>>
>
Other related posts:
