From oracle-l-bounce@freelists.org Mon Sep 12 04:43:45 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j8C9hjLC001731 for ; Mon, 12 Sep 2005 04:43:45 -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 j8C9hehJ001711 for ; Mon, 12 Sep 2005 04:43:40 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D9F141EB8B0; Mon, 12 Sep 2005 04:43:37 -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 24526-08; Mon, 12 Sep 2005 04:43:37 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5FC461EB5E3; Mon, 12 Sep 2005 04:43:37 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.5.6944.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Subject: RE: TSM/TDP backup of rman database nocatalog Date: Mon, 12 Sep 2005 10:42:36 +0100 Message-ID: <3D730671F3FB8C4EA73FD2E94A11F9472D8A57@tshuklonmbx02.ERF.THOMSON.COM> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: TSM/TDP backup of rman database nocatalog Thread-Index: AcWy4iFXrTlPWnbxRu6K4XScq2fPKQAFdn8QAABfgmAAIzMj8AALRv8HAPJYUfAFrom: To: , X-OriginalArrivalTime: 12 Sep 2005 09:41:46.0650 (UTC) FILETIME=[310B17A0:01C5B77E] X-archive-position: 25278 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Peter.Hitchman@thomson.com Precedence: normal Reply-To: Peter.Hitchman@thomson.com X-list: oracle-l From: oracle-l-bounce@freelists.org 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-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-4.7 required=5.0 tests=AWL,BAYES_00,NO_REAL_NAME autolearn=no version=2.63 Hi, It turns out that you can just use the tdposync command to remove the backups of the rman database. You just give it the same connection information as if connecting to the catalog, give it the date range your interested in and delete the backups. But this does not mean that tdposync is doing anything smart, it will offer to delete any backup even if they are recorded in the control file, it does not even indicate that the database is not registered in the catalog. So when in this situation you just have to work out for yourself the date range of the backups to be removed from Tivoli ,that are no longer recorded in the control file (a simple query against the tsm backups table in dsmadmc) and make sure that you use that range when asked by tdposync. Regards Pete -----Original Message----- From: Marquez, Chris [mailto:cmarquez@collegeboard.org] Sent: 07 September 2005 14:52 To: Hitchman, Peter (TS UK); oracle-l@freelists.org Subject: RE: TSM/TDP backup of rman database nocatalog >>I could try giving it the target database and see what happens. Yeah, just try it...if the query that TDPO is runing is not RMAN catalog specific (view) then maybe? >>I'll update later. Pleas do. Good luck, Chris Marquez Oracle DBA -- http://www.freelists.org/webpage/oracle-l