Re: rman centralized backup server

  • From: Peter Gram <peter.gram@xxxxxxxxxxxx>
  • To: dwagoner@xxxxxxxxxxxxxxxxxx
  • Date: Wed, 15 Sep 2004 19:53:35 +0200

Hi David
There are always a trade-offs in life. I have worked with RMAN since 
8.0.4 and
I think this is one of the greatest features Oracle have enhanced the 
database with.
In the battle regarding multible catalogs vs. one catalog for databases 
my experience
with customers is that one catalog per database is the best for the 
following reasons :

1)     Upgrade of the catalog does not influence other databases
2)     It is possible to backup (export) a single database
3)     You don't get performance problems since the catalog will not be 
4)      It is easy to play with the catalog when doing advanced recovery 
5)      Selecting with Sql*plus (or other tools) are simpler
6)      Security administration is possible.
7)      Moving of a single database repository is easy
8)      Deleting databases from a repository is easy
9)      Patching of repositories takes less consideration
10)   The downside is more administration :-(


David Wagoner wrote:

>I've heard of another suggestion- to create a separate RMAN schema for each
>Oracle version that connects to the repository DB.
>I'd be interested to hear your opinions on that option and if anyone has
>experience using this approach.
>Best regards,
>David B. Wagoner
>Database Administrator


Best regards / Venlig hilsen

/*Peter Gram*/
Miracle A/S <>
Kratvej 2
DK - 2760 Måløv

Cell:  (+45) 2527 7107
Phone: (+45) 4466 8855
Fax:   (+45) 4466 8856
Home:  (+45) 3874 5696
Skype:  peter_gram
Email: peter.gram@xxxxxxxxxxxx

 17 Sep 2004     DECUS-fest i Pederstrup 
 18-20 Oct 2004          RAC-kursus med Jonathan Lewis 
 29 oct 2004     Special SQLserver day with Kimberly Tripp at DBF,Lalandia 
 28-30 Oct 2004          The Last Database Forum at Lalandia 
 22-24 Nov 2004          RMAN-kursus med Tuomas Pystynen 
 17-19 Jan 2005          Miracle Master Class with Tim Gorman 
 28 feb - 2.mar 2005     Database Master Class with Chris Date 
 2-4 May 2005    SQL Server Master Class with Kimberly Tripp 


Other related posts: