| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Backup for VLDB
We have a ~500Gb database on Compaq/Alpha HW and we use the multiple-mirror break technique with a couple of varients. 1) We leave the database up but put all of the tablespaces in backup mode for the mirror break. The mirror set is then mounted on our failover system for the write to tape which takes ~4 hours. 2) We use two backup mirror sets, alternating so that one mirror set is always ready for a recovery from disk. This recovery technique proves itself daily as we have an additional mirror set which we break, mount, and recover to act as a reporting instance.
Mike Hand
Polaroid Corp.
-----Original Message-----
Sent: Friday, April 06, 2001 6:26 AM
To: Multiple recipients of list ORACLE-L
The 'normal' way of operation I have seen is either
Use a 3 way mirror, shut down the database, start up then shutdown normal,
then split one mirror. The database can then be restarted (total outage less
than 20 minutes)
The backup then takes place against the 3rd mirror and is a cold backup and
can be written to tape. The 3rd mirror is then synced or re-silvered at your
convenience after the backup is complete (5 hours later?).
One advantage of using this method is that the 3rd mirror is kept un-synced
all day until just before the backup ( we used EMC BCVs) and then merged.
Therefore there is a good copy of the database almost immediately available
that only needs 1 day's set of archive log applying in the event of a
recovery.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hand, Michael T
INET: HANDM_at_polaroid.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Apr 06 2001 - 10:23:30 CDT
 |
 |