From oracle-l-bounce@freelists.org Thu Oct 13 08:05:22 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j9DD5MpH000998 for ; Thu, 13 Oct 2005 08:05:22 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j9DD5EvX000960 for ; Thu, 13 Oct 2005 08:05:14 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F20271FD66C; Thu, 13 Oct 2005 08:05:06 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 28008-08; Thu, 13 Oct 2005 08:05:06 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3780A1FD361; Thu, 13 Oct 2005 08:05:06 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5CFF6.704CDC49" Subject: RE: Methods for testing RMAN backups? Date: Thu, 13 Oct 2005 09:03:00 -0400 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Methods for testing RMAN backups? thread-index: AcXP9K9+9+dbrIvwRDqEvLVqajFd2AAAJxqg From: "Mercadante, Thomas F (LABOR)" To: , X-OriginalArrivalTime: 13 Oct 2005 13:03:01.0259 (UTC) FILETIME=[70E075B0:01C5CFF6] X-archive-position: 26904 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Thomas.Mercadante@labor.state.ny.us Precedence: normal Reply-To: Thomas.Mercadante@labor.state.ny.us X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-3.4 required=5.0 tests=AWL,BAYES_00,HTML_60_70, HTML_FONTCOLOR_UNKNOWN,HTML_MESSAGE autolearn=no version=2.63 ------_=_NextPart_001_01C5CFF6.704CDC49 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Vanessa, =20 A good first test is to validate your backup. Simply allocate a channel and issue a "restore database validate;". This does everything that a restore would do except it does not touch the database. Validate both your database and archivelog backups. This will prove that you can get the backups off of tape or from disk, depending on the type of backup you are doing. I run a validate backup every week for all of our databases. =20 After this, I would insist on performing a complete restore just so that you know it can be done. =20 Good Luck! =20 Tom =20 =20 =20 ________________________________ From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Vanessa A. Simmons Sent: Thursday, October 13, 2005 8:50 AM To: oracle-l@freelists.org Subject: Methods for testing RMAN backups? =20 I am getting ready to apply a patch to our databases and before doing so I need to test our RMAN backups to make sure I can get them all back in case there's a problem. Plus, it's just good practice to test the backups regularly anyway (BEFORE a disaster occurs). However, I haven't ever tested my backups before and want to see how others have done this. Thanks in advance, Vanessa ------_=_NextPart_001_01C5CFF6.704CDC49 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Vanessa,

A good first test is to validate = your backup. Simply allocate a channel and issue a “restore = database validate;”. This does everything that a restore would do except it does not = touch the database. Validate both your database and archivelog = backups. This will prove that you can get the backups off of tape or from disk, = depending on the type of backup you are doing. I run a validate backup every = week for all of our databases.

After this, I would insist on = performing a complete restore just so that you know it can be = done.

Good = Luck!

Tom

From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] = On Behalf Of Vanessa A. = Simmons
Sent: Thursday, October = 13, 2005 8:50 AM
To: = oracle-l@freelists.org
Subject: Methods for = testing RMAN backups?

I am getting ready to apply a patch to our databases = and before doing so I need to test our RMAN backups to make sure I can get = them all back in case there's a problem. Plus, it's just good practice to = test the backups regularly anyway (BEFORE a disaster occurs). However, I = haven't ever tested my backups before and want to see how others have done = this.

Thanks in advance,

Vanessa

------_=_NextPart_001_01C5CFF6.704CDC49-- -- http://www.freelists.org/webpage/oracle-l