Re: How are you backing up your V,VLDB????

> I've only worked with regular sized databases, but I've seen some
> configurations as you describe (except without RMAN) take an order of
> magnitude longer to restore than to save. So I'm curious if you've
> seen such problems?

Yes, restoration and recovery can take much longer when your database gets bigger. That's one of the reasons that I've been using RMAN with a Recovery Catalog up to this point so far. Currently, I backup a few tablespaces on one night, and then a few on another night, and repeat until I have a complete database backup. With all of these pieces floating around, manual restoration of datafiles can become a nightmare. So I let RMAN handle all of the details. With the recovery catalog, it knows what was backed up and where it is. RMAN then gets all of the pieces in place, and restores the necessary datafiles, and then applies recovery. A full database restoration can take a very long time and hopefully is never attempted. This is one of the reasons why we insist on redundancy (i.e. RAID) in our disk systems.

Thanks,
Brian Received on Mon Feb 03 2003 - 10:37:13 CST