Tom - I can do either a cold or hot backup. It is all scripted.
I prefer cold backups. IBM did try to sell us TDP for Oracle, get this, to
open the db on the backup server to back it up using RMAN. The files on
the backup server are just that files, no need for Oracle utilities to back them
up.
High Level Events of a Flash Copy Backup:
- Backup Server exports volume group, umounts filesystems backed up.
- Backup Server executes begin hot/cold backup script on remote production
server.
- Backup Server executes FlashCopy Establish Tasks.
- Backup Server executes end hot/cold backup script on remote production
server.
- Backup Server recreates volume group, mounts filesystems.
- Backup Server backs up filesystems to tape.
Advantages:
- Online Backup of Production DB on Backup Server.
- Datafiles can used for partial restore or FlashCopy Reverse can be used
for full restore.
- Copy of Production DB can be used for testing, data warehouse, web
purposes.
- Resources used for VLDB is on Backup Server not Production DB
Server.
hth,
Gene
P.S. If you need more details, feel free to call me.
>>> "Mercadante, Thomas F" <[EMAIL PROTECTED]> 10/09/03 08:08AM >>> Gene,
What happens when you need to perform a
recovery from the Flashcopy backup?
Is Flashcopy done while the database is open
or closed?
If the database is open, then I assume that
you would need to perform an incomplete recovery?
Just curious. I am in the middle of setting up new IBM/AIX boxes, and we will using either EMC or IBM Shark disk. Flashcopy was mentioned as a possible solution for backups. But I don't like being boxed in to performing an incomplete recovery. Tom Mercadante
Oracle Certified Professional
|
- EMC Snapshot Technology jwiegand
- Re: EMC Snapshot Technology Matthew Zito
- Re: EMC Snapshot Technology Gene Sais
- RE: EMC Snapshot Technology Mercadante, Thomas F
- RE: EMC Snapshot Technology Gene Sais
- RE: EMC Snapshot Technology Grabowy, Chris