Re: login.sql equivalent for RMAN

  • From: TESTAJ3@xxxxxxxxxxxxxx
  • To: "wjwagman" <wjwagman@xxxxxxxxxxx>, "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 29 Apr 2009 18:20:26 -0400

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 [wjwagman@xxxxxxxxxxx]
Sent: 04/29/2009 02:25 PM MST
To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
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@remote_db

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


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



Other related posts: