Re: Backup best practice
Date: Thu, 20 Oct 2011 10:37:10 -0700 (PDT)
Message-ID: <1319132230.59011.yint-ygo-j2me_at_web113211.mail.gq1.yahoo.com>
Actually, when you use a recovery catalog (which I recommend) the backup metadata is still guaranteed to be contained in the control file until control_file_record_keep_time expires. This is why controlfile auto backups are an important part of your strategy.
Also in 11g and later (maybe 10gr2 can't recall for sure), worst case, you can catalog backup set pieces from disk. Thus if you loose everything, you can still restore.
All covered in my oracle press rman book.
Rf
On Thu Oct 20th, 2011 1:25 PM EDT Storey, Robert (DCSO) wrote:
>Okay, looking at a best practices kind of question.
>
>
>I am setting up a machine to hold the catalog/repository for RMAN
>backups of my dbs. And, I even will schedule the backups of the backup
>machine to be done by RMAN.
>
>
>
>However, what is the best practice for storing this machines backup
>metadata? It would seem that you have to store it in the controlfile
>and use other methodologies to safeguard the information. To me, you
>can't use the catalog because if it dies, how do you do a restore of
>your backup machine if your metadata and such about the backup....is in
>the dead machine?
>
>
>
>A suggestion in my class to day was that you could still use RMAN to
>restore the backup machine using the DUPLICATE command, as long as you
>had access to the the proper backup set pieces.
>
>
>
>Thanks.
>
>
>--
>http://www.freelists.org/webpage/oracle-l
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 20 2011 - 12:37:10 CDT