RE: Backup best practice
- From: D'Hooge Freek <Freek.DHooge@xxxxxxxxx>
- To: "RStorey@xxxxxxxxxxxxxxxxxx" <RStorey@xxxxxxxxxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 20 Oct 2011 19:45:40 +0200
Robert,
When taking backups of your rman repository, you can safeguard the backup
metadata (located in the controlfiles) by using the controlfile autobackup
feature.
When enabled (configure command in rman) it will make automatically create
backup of the controlfile after backing up the database and use a "predictable"
generated name for it.
When restoring, you only need the dbid of the rman catalog to allow rman to
restore it from backup.
Once the controlfile is restored, you have access again to the metadata of the
backups of your recovery catalog and you can restore the rest of the database
as usual.
Regards,
Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge@xxxxxxxxx
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Storey, Robert (DCSO)
Sent: donderdag 20 oktober 2011 19:25
To: oracle-l@xxxxxxxxxxxxx
Subject: Backup best practice
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.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
