DENNIS WILLIAMS wrote:
>We use RMAN on Oracle9i to back up to disk. No SAN or MML, but use an RMAN
>catalog. I use cron to initiate the backup (Unix servers). In revising the
>system, I'm trying to decide whether it is better to use the cron on each
>server, or just trigger backups centrally, from servers where the RMAN
>catalogs reside. It seems like most of the advantages go to the local
>script. You are always running the same RMAN executable as the database. Has
>anyone else looked at this issue and care to share any thoughts?
>
>
>
Dennis, RMAN is built into the oracle executable and is always executed
locally. It doesn't matter
where it is initiated from, it is always executed locally. Where will
you initiate the backup from, depends on
your scheduling method and management preferences. If you want to have
everything centralized, then
RMAN catalog server is as good place as any. I wouldn't use the
Wolfenstein and Battlezone servers
for security reasons. If, on the other hand, you are the type that likes
traveling, then having scripts
installed on each node locally will provide you with plenty of
opportunity to explore strange new nodes,
to seek the new parameters and new configurations, to boldly go where no
DBA has gone before.
--
Mladen Gogala
Oracle DBA
Ext. 121
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Feb 01 2005 - 14:33:03 CST
