Re: mirroring database storage
Date: Fri, 24 Jun 2011 12:05:24 -0400
> Does anyone use, or see any problems with, mirroring database files to provide
> a quick way to recover in case of a disk problem?
> We aren't yet using RAC, we do have a standby database set up at our disaster
> recovery site and we do weekly cold backups of the database. We're thinking
> that mirroring the database storage disks would be another layer of protection.
Mirroring your database files is indeed a good idea. That's one of the basic Best Practices of data protection. You might want to read on the « Oracle Maximum Availability Architecture » (MAA)
Consider mirroring your OS disk drives too.
If you're looking for a quick way to recover your database, check the RMAN « backup as copy » command and the « incrementally updated backup ». Once this is in place and a datafile is broken, you can switch to the copy. It's fast and easy, but requires a lot of disk space. A bit more than twice what your database would use in fact.
Let me know if you need more info on that. I do have quite a long list of DocID on that topic at work and could send you those next monday along with the exact RMAN configuration and syntax.
-- Mobile: +1 514 966 0122 Linkedin: http://www.linkedin.com/in/davidrobillard Blog: http://itdavid.blogspot.com/ -- http://www.freelists.org/webpage/oracle-lReceived on Fri Jun 24 2011 - 11:05:24 CDT