| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Re: RMAN question
Hi, Everyone,
I intend to side with Volker against Rman Catalog DB, which I believe
is a stupid idea from Oracle. How can you explain to a small company
you will need another catalog Database to just backup this database,
preferably
the catalog database is located on another machine? I think a formated text
file
will better serve this purpose.
Regarding control file size: I have a DB generating 700 + logs a day with
keep_time=15
has control file size around 40M, so if you have 2000 archive logs a day
with keep_time=30
the control file size should be around 200M, I think it's managable.
Actually control file
size or recovery window is NOT a concern if you also backup control file in
Rman like me:
" Backup current controlfile channel disk4 tag='rman_control_file' " for
each backup(
they are tiny compared to datafile).
sean chang
> If I need to recover something outside the recovery window I simply
> had it set up the wrong way. Since the recovery window isn't set according
> to the whim of the dba but is agreed upon with the customers, what's the
problem?
> And if we really need an old backup for some monstrous archaeological
purpose I
> can always set up a db and recover an old controlfile from an old backup.
However,
> there's definitely no guarantee for the customers that the tapes are still
there. He
> *did* specify a recovery window, remember? If he wanted a longer one he
only
> had to say.
>
> Lots of Greetings!
> Volker
-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 100,000 Newsgroups - 19 Different Servers! =----- Received on Thu Oct 02 2003 - 15:12:04 CDT
![]() |
![]() |