01-02-2008 01:36 PM
Your help please.
Using snapclone for Oracle hot backups. I want to make absolutely sure I am getting a consistent backup of the production system for data integrity.
Process: Put the database in hot backup mode, take a snapclone to a container, take database out of hot backup mode.
The snapclone process takes about 20 minutes to complete in the background until it is "normalized".
1) Does the snapclone copy the data from the time the database was in online backup mode or does it continue to copy data after the database is taken out of hot backup mode until it is fully normalized?
2) What is meant by normalization? I have found nil in the documentation.
01-02-2008 02:19 PM
Normalization is the process of completing the copy.
In new versions of the EVA firmware there is the possibility of making mirrorclones. This starts like a snapclone, but keeps being sincronized to the main vdisk until you stop the sincronization (fracture).
Then you perform backup and when finished, let the mirrorclone sincronize again. This way you only copy the modified data since the last backup, not the whole disk always.
01-02-2008 09:11 PM
For an absolutely consistent backup you have to do two things...
1. Make sure your Data and redo log volumes are on separate volumes.
2. Hot Backup.
3. Snap the data volume.
4. Rotate logs..
5. snap redo log volume.
6. Wait for Normalizing to complete.
7. Get database out of hot backup mode,
8. Backup the SNAP clones.
Hope this helps.
01-03-2008 05:16 AM
Also can you explain "rotate the logs"?
01-03-2008 10:14 AM
It sounds like I should wait until the copy is finished or normalized and then take the database out of hot backup mode in order to ensure a consistent backup - that could be used for database recovery.
01-03-2008 11:33 AM
01-03-2008 02:03 PM
To further answer your questions, the snapclone backups will be on a seven day retention on the EVA. The OS is Solaris. The UNIX SAs will use BakBone, Net Vault, to perform the SUN server and EVA nightly backups. I assume DP ZDB is a licensed product which is currently not in the budget.
Thanks for your input,