Home » RDBMS Server » Backup & Recovery » stored RMAN script
stored RMAN script [message #247489] Tue, 26 June 2007 02:03 Go to next message
Messages: 57
Registered: February 2007
Location: Netherlands
Hello All,

I have to manager about 30 oracle 10 and 9 databases.
Right now I'm setting up a recovery catalog and I would like to use stored scripts.

unfortunaly not all the scripts I use for backing up the databases are the same, they are oracle 9 and oracle 10 specific and also the paths (backup locations) in the scripts differ.

What would be best/easiest to manage:
-use global stored scripts for the rman stuff that is the same for all databases and use local stored scripts for database specific options like the backup challel.
-use only local stored scripts, so every database gets it's own backup script.

Re: stored RMAN script [message #247634 is a reply to message #247489] Tue, 26 June 2007 10:59 Go to previous message
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
A local stored script is associated with the target database to which RMAN is connected when the script is created, and can only be executed when you are connected to that target database. A global stored script can be run against any database registered in the recovery catalog, if the RMAN client is connected to the recovery catalog and a target database.

now decide which is better for you.
Previous Topic: Table Recovery with RMAN.
Next Topic: Choosing 3-rd party backup software for Oracle
Goto Forum:

Current Time: Wed Aug 23 05:13:16 CDT 2017

Total time taken to generate the page: 0.31173 seconds