Re: login.sql equivalent for RMAN
- From: Jared Still <jkstill@xxxxxxxxx>
- To: wjwagman@xxxxxxxxxxx
- Date: Wed, 29 Apr 2009 16:07:34 -0700
On Wed, Apr 29, 2009 at 2:25 PM, William Wagman <wjwagman@xxxxxxxxxxx>wrote:
> Greetings,
>
> I am running Oracle 9.2.0.8.0 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 -
>
>
This works.
=== script ====
export RCAT=rcat
export DB=orcl
export RCAT_USERNAME=rman
export DB_USERNAME=bkup
export RCAT_PASSWORD=password
export DB_PASSWORD=password
$ORACLE_HOME/bin/rman <<-EOF
connect target $DB_USERNAME/$DB_PASSWORD@$DB
connect catalog $RCAT_USERNAME/$RCAT_PASSWORD@$RCAT
show all;
EOF
====================
Recovery Manager: Release 10.2.0.4.0 - Production on Wed Apr 29 16:04:36
2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
RMAN>
connected to target database: ORCL (DBID=57145378)
RMAN>
connected to recovery catalog database
RMAN>
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 31 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
...
RMAN>
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Other related posts: