Re: RMAN Question

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1070696387.809494_at_yasure...
> Ryan wrote:
>
> > ive seen posts from people who use two seperate RMAN instances. Both
backup
> > everything, including each other. What do you think fo that plan?
> > "Mladen Gogala" <mgogala_at_adelphia.net> wrote in message
> > news:pan.2003.12.05.08.44.56.79945_at_adelphia.net...
> >
> >>On Thu, 04 Dec 2003 09:29:46 -0800, Ryan Gaffuri wrote:
> >>
> >>
> >>>Is it wise to have 2 instances with RMAN repositories or just one that
> >>>is backed up a few times a day. If its an RMAN catalog, it would be a
> >>>small instance so this is highly practical.
> >>
> >>What would be the alleged purpose of the second instance?
> >>It does make sense if you have two disjoint systems of databases
> >>and two backup systems. For instance, you can use one system to
> >>back up your NT boxes and another one to backup your Unix boxes.
> >>In that case, I'd recommend two separate RMAN systems, together with
> >>two catalogs. If it's only a security measure - definitely not because
> >>you'd stand a good chance of having discrepancies, what would be an
> >>administrative nightmare.
> >>
> >>--
> >>None of us is as dumb as all of us.
> >>(http://www.despair.com/meetings.html)
>
> I think it is a horrendous waste of time, effort, and resources.
>
> Why not just implement RAC?
>

Gawd! Talk about over-reaction!! He just want to duplicate his repository, and you suggest a RAC! For an RMAN repository??! Have you started buying shares in the company??!

But Daniel is right to this extent: why on Earth back up everything twice using separate repositories? If you want two backups, a single RMAN command will do that for you, in the one backup operation. You really don't want to be I/O'ing all over your database twice, just for peace of mind's sake.

So I presume the issue is simply what backs up the RMAN repository itself? I'd suggest export/import. The repository database should be small; the repository information is smaller still (about 20MB per target database per year); and you only need to export the one RMAN schema. Will probably take about 10 minutes tops.

Regards
HJR

-- 
------------------------------------
Oracle insights at www.dizwell.com
------------------------------------