From oracle-l-bounce@freelists.org Thu Oct 14 13:23:31 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i9EINVK29251 for ; Thu, 14 Oct 2004 13:23:31 -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 i9EINVI29246 for ; Thu, 14 Oct 2004 13:23:31 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F1D6C72DA23; Thu, 14 Oct 2004 13:29:38 -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 25881-58; Thu, 14 Oct 2004 13:29:38 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 632FE72DA22; Thu, 14 Oct 2004 13:29:38 -0500 (EST) Message-ID: X-Sybari-Trust: 471f6748 d5d84915 675447c4 0000013d From: "Mercadante, Thomas F" To: "'joelgarry@anabolicinc.com'" , oracle-l@freelists.org Subject: RE: RMAN-NetBackup without an RMAN Catalog Date: Thu, 14 Oct 2004 14:27:55 -0400 MIME-Version: 1.0 Content-type: text/plain Content-Transfer-Encoding: 8bit X-archive-position: 11103 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 at freelists.org Joel, He wasn't talking about a converted system. He was talking specifically about restoring an Oracle backup from 5 years ago. We are speaking specifically about an Oracle database. When we migrate the database to the apply new version, there is no copy of the old version around - it has been migrated. And the old backups become obsolete. And typically, the old Oracle home gets removed. So restoring an older version of the database would require keeping the Oracle software around for that amount of time. Not very likely. The correct answer is a properly designed database that can produce reports of what the database looked like 5 years ago - like specific account balances. That would be the ticket! Tom Mercadante Oracle Certified Professional -----Original Message----- From: Joel Garry [mailto:joelgarry@anabolicinc.com] Sent: Thursday, October 14, 2004 2:20 PM To: oracle-l@freelists.org Subject: RE: RMAN-NetBackup without an RMAN Catalog >From: "Mercadante, Thomas F" > >Hemant, > >You have to admit that this may never be available. Think about it. You >will be migrating to new releases about 4 times between now and 5 years from >now. Rman version 13x would probably choke and puke anyway when it tried to >restore the version 9i controlfile! :) > >Tom Mercadante >Oracle Certified Professional Tom: I see stuff all the time where people have 5+ year old systems that have been converted, but they still keep the old boat anchor around so they can look at stuff - sometimes to say "The old system did this, make the new system do it!". Between legal requirements and archival requirements, I don't think it is strange at all that someone might want to restore to 5 years ago. I think it is very strange that a major database vendor might not be able to with their primary restoration tool. http://www.garry.to -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l