From oracle-l-bounce@freelists.org Sat Oct 16 19:08:18 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i9H08Ig27222 for ; Sat, 16 Oct 2004 19:08:18 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i9H08II27217 for ; Sat, 16 Oct 2004 19:08:18 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4451072C4F7; Sat, 16 Oct 2004 19:14:26 -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 12022-52; Sat, 16 Oct 2004 19:14:26 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4EE7D72C54B; Sat, 16 Oct 2004 19:14:25 -0500 (EST) Message-ID: <6BA0194B4809D9118361000F1F6C95100133C212@exchmn4.lifetouch.com> From: DENNIS WILLIAMS To: oracle-l@freelists.org Subject: RE: Responses : About Older Backups -- was Re : RMAN-NetBackup w ithout an RMAN Catalog Date: Sat, 16 Oct 2004 19:11:33 -0500 MIME-Version: 1.0 Content-type: text/plain Content-Transfer-Encoding: 8bit X-archive-position: 11198 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: DWILLIAMS@LIFETOUCH.COM Precedence: normal Reply-To: DWILLIAMS@LIFETOUCH.COM X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Hemant I think you have raised some important issues here. Your requirements are not unreasonable. Today I don't believe the computer industry is much concerned about long-term retrieval of data. Vendors stay in business by responding to customer demand and today customers are not demanding long-term data retrieval. As computers become more important to our society, this issue will soon be treated more importantly. In my reading of this topic, here are some ideas I have heard: 1. Keep the data on-line. Our ERP system has every record since it was started 7 years ago, which ensures all that data is accessible. 2. Move the data into a data warehouse. This is exactly what a DW is designed to do. Capture data with the proper context. 3. Store the data in a format and medium that is most resistant to obsolescence. Oracle has kept the export format compatible over many major version releases. I haven't seen any commitment with respect to RMAN formats. Therefore export would be favored over RMAN. As someone pointed out, ASCII flat files are even more resistant to obsolescence. 4. Periodically test the recoverability of old data. For example, reload all backups annually. If a problem is found, you are more likely to successfully resolve a problem that has occurred in the last year than if you allow a decade to elapse. 5. Carefully determine the specific purposes for maintaining access to old data and develop tests to ensure that access is still maintained. 6. Upgrade old data sets. For example, if you upgrade your Oracle version, restore all archived data sets and convert them to the newer Oracle version. Same with a new hardware platform or O.S. upgrade. Then re-save them on fresh media. Expensive, but effective. 7. Consider purchase of a product specifically designed for data archiving. 8. The computer industry is volatile. Do not assume that any vendor will be in business 5 years from now or that they are still producing products compatible with those you use today. As to RMAN itself, I regularly conduct disaster recovery tests. You can recover RMAN backup sets written to tape if you have a copy of the controlfile taken immediately after the backup. My practice is to separately copy the controlfile to tape to ensure its availability. You can also extract the controlfile from the RMAN backup itself, but since I haven't tested this I don't rely on it. All that is required is that you have the same Oracle version that you used to create the backup. Nothing in this method depends on time except the availability of that same Oracle version. Dennis Williams DBA Lifetouch, Inc -- http://www.freelists.org/webpage/oracle-l