"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:<3fd19331$0$13498$afc38c87_at_news.optusnet.com.au>...
> "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
you cant detect block corruption with exp/imp. No dbverify for .dmp
files. Not ideal. Id consider, but I really think Id go with 2 RMAN
repositories or maybe even three to be super anal.
Received on Mon Dec 08 2003 - 13:33:41 CST
