Re: login.sql equivalent for RMAN

From: <>
Date: Wed, 29 Apr 2009 18:20:26 -0400
Message-ID: <>

How about putting it in a shell script and getting the password from an external file and put unix variables in the script, I have some examples, if u email me direct tomorrow I will send some.

Sent from the crackberry, so please excuse the typos and terseness.

Thanks, joe

  • Original Message ----- From: William Wagman [] Sent: 04/29/2009 02:25 PM MST To: Oracle-L Freelists <> Subject: login.sql equivalent for RMAN


I am running Oracle EE. Is there an equivalent to login.sql for RMAN such that I don't have to store passwords in my scripts? I have looked but am unable to find a solution. What I would like to be able to do, as I can do with SQL is something like create a file like RMAN_LOGIN.SQL -

define rman_user=usera
define rman_password=password

And then do something like

RMAN> connect target &&rman_user/&&rman_password_at_remote_db

Does anyone know how if this is possible and if so can you point me to the documentation?


Bill Wagman
Univ. of California at Davis
IET Campus Data Center
(530) 754-6208


-- Received on Wed Apr 29 2009 - 17:20:26 CDT

Original text of this message