Re: How do you test your backups?
From: Justin Mungal <justin_at_n0de.ws>
Date: Thu, 30 Jan 2014 07:37:34 -0600
Message-ID: <CAO9=aUzJZFN5VAGJQ_-1OqRV6S1BuBYFr+yhSQ34aRkKgMODRQ_at_mail.gmail.com>
Some customer's periodically duplicate their databases from an RMAN backup (ie. the most recently taken "tape" backup) to another system. Some do this on their actual production systems, which I strongly recommend against. We just use the standard duplicate database procedure, and use SET NEWNAME or *_FILE_NAME_CONVERT depending on what seems to be preference. This doesn't at all seem "clever" to me, but we've done it for years and it works.
Date: Thu, 30 Jan 2014 07:37:34 -0600
Message-ID: <CAO9=aUzJZFN5VAGJQ_-1OqRV6S1BuBYFr+yhSQ34aRkKgMODRQ_at_mail.gmail.com>
Some customer's periodically duplicate their databases from an RMAN backup (ie. the most recently taken "tape" backup) to another system. Some do this on their actual production systems, which I strongly recommend against. We just use the standard duplicate database procedure, and use SET NEWNAME or *_FILE_NAME_CONVERT depending on what seems to be preference. This doesn't at all seem "clever" to me, but we've done it for years and it works.
On Thu, Jan 30, 2014 at 7:02 AM, Howard Latham <howard.latham_at_gmail.com>wrote:
> Oracle 11g Linux 4.
>
> I'm reviewing my backup strategy and wondered if anyone had any clever
> ideas for backup testing.
> I was thinking of trashing my standby and trying to reinstate it from my
> RMAN backup on tape. I think this would prove
> a serviceable database can be built from tape.
>
>
> --
> Howard A. Latham
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 30 2014 - 14:37:34 CET