HELP RMAN Best Practices

If I have the recovery catalog database on separate server from the target database, then I have two copies of RMAN since RMAN installs as part of Oracle. What's the best practice in terms of running RMAN - 1) Run the Rman.exe that's on the catalog server 2) Run the Rman.exe that's on the target server.

Option 1 can be awkward since you have to keep a copy of the target database pfile on the catalog server in order to startup the target database. This is even more awkward if you have ten different targets on ten different servers.

Option 2 means you have to go to each target server to run RMAN. And what happens if you lose a target server. Do you lose all your RMAN scripts for that target? If not do you secure them by copying them to some other machine?

My first thought was to go with option 1. I asked Oracle support and they said they though most people used option 2, although 1 would work. What do you all do/think?

Thanks,

Van Received on Sat Feb 26 2000 - 11:34:21 CST