Question:
I need to automate a script that allows me to sign-on to RMAN
via a batch script. I can easily sign-on to SQL*Plus as SYSDBA but I
cannot use the same syntax with RMAN.
Answer: The trick for
signing-on to the RMAN command interpreter is to use the following
set-up for the environment and commands. You can use bash,
ksh, csh or sh.
Also see these related
RMAN scripts, including RMAN backup scripts from
Windows DOS scripts for RMAN automated backups. Here is yet another RMAN script that will
monitor the progress of your RMAN script.
#!/bin/sh
. /u01/app/oracle/.profile1
${ORACLE_HOME}/bin/rman <<EOF
connect target sys/syspassword@cricprod_prim
connect
auxiliary sys/syspassword@cricprod_logstdby
show all;
EOF
 |
Oracle Backup & Recovery:
Expert secrets for using
RMAN and Data Pump
Kamran Agayev Agamehdi & Aman Sharma
Only $35.95 with code download of working
scripts.
|
|
|
 |
|
Guarantee your Success!
Oracle is the
world's most complex, robust and flexible database, considered
impossible to master without a mentor.
That's why all BC
Oracle trainers are working professionals, experts in Oracle who
share their tips and secrets. |
|
| |
|
Burleson is the American Team
Note:
This Oracle
documentation was created as a support and Oracle training reference for use by our
DBA performance tuning consulting professionals.
Feel free to ask questions on our
Oracle forum.
Verify
experience!
Anyone
considering using the services of an Oracle support expert should
independently investigate their credentials and experience, and not rely on
advertisements and self-proclaimed expertise. All legitimate Oracle experts
publish
their Oracle
qualifications.
Errata?
Oracle technology is changing and we
strive to update our BC Oracle support information. If you find an error
or have a suggestion for improving our content, we would appreciate your
feedback. Just
e-mail:
 and include the URL for the page.
Copyright © 1996 - 2012
All rights reserved.
Oracle ©
is the registered trademark of Oracle Corporation.
|
|
