From oracle-l-bounce@freelists.org Tue Dec 13 09:41:52 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id jBDFfpCg026178 for ; Tue, 13 Dec 2005 09:41:51 -0600 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 jBDFfoAX026171 for ; Tue, 13 Dec 2005 09:41:50 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F3C45254B74; Tue, 13 Dec 2005 10:41:46 -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 16032-02; Tue, 13 Dec 2005 10:41:46 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6BD8F254AB4; Tue, 13 Dec 2005 10:41:46 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 13 Dec 2005 10:41:45 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E250B254B53 for ; Tue, 13 Dec 2005 10:41:44 -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 16032-01 for ; Tue, 13 Dec 2005 10:41:44 -0500 (EST) Received: from mx2.state.vt.us (mx2.state.vt.us [170.222.64.130]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7C47A254AB4 for ; Tue, 13 Dec 2005 10:41:44 -0500 (EST) Received: from TAX132 ([159.105.88.151]) by mx2.state.vt.us (Post.Office MTA v3.5.4 release 224 ID# 0-0U10L2S100V35) with SMTP id us; Tue, 13 Dec 2005 10:41:39 -0500 From: "Ruth Gramolini" To: "oracle-l" , Subject: RE: rman incomplete recovery Date: Tue, 13 Dec 2005 10:41:39 -0500 Message-ID: <010d01c5fffb$b551ac70$bb59000a@vttaxnet.tax.state.vt.us> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 In-Reply-To: X-archive-position: 29124 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: rgramolini@tax.state.vt.us Precedence: normal Reply-To: rgramolini@tax.state.vt.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: Not scanned: please contact your Internet E-Mail Service Provider for details X-MailScanner-From: oracle-l-bounce@freelists.org If you have controlfile autobackup on you don't need to specify the control file. The controlfile you need cannot be the one you take right before restoring the database. Rman knows by the set until time which one to use from your controlfile autobackup destination. Here are the steps I would use: 1. in the OS, export the NLS_DATE_FORMAT as yyyy-mm-dd:hh24:mi:ss 2. in sqlplus, shutdown the database and open it nomount 3. >rman, connect target, connet rcvcat 4. in a run block: run { set until time 'your until time in the NLS_DATE_FORMAT' above allocate the channels if you don't have them preconfigured restore database; recovery database; } This should take care of everything for you. The format for the snapshot controlfile is not usable by recovery, as far as I know. I preconfigure everything, here is a sample script for accomplishing this. This is for a database named rptcacs2. You can adjust the format specs to your particular needs. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS; CONFIGURE BACKUP OPTIMIZATION OFF; CONFIGURE DEFAULT DEVICE TYPE TO DISK; CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/orasys/control/rptcacs2/%F'; CONFIGURE DEVICE TYPE DISK PARALLELISM 4; CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; CONFIGURE CHANNEL DEVICE TYPE DISK DEBUG 5; CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/dbback/db_%srptcacs2_%p'; CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT '/dbback/db_%srptcacs2_%p'; CONFIGURE CHANNEL 3 DEVICE TYPE DISK FORMAT '/dbback/db_%srptcacs2_%p'; CONFIGURE CHANNEL 4 DEVICE TYPE DISK FORMAT '/dbback/db_%srptcacs2_%p'; CONFIGURE MAXSETSIZE TO UNLIMITED; CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/usr/oracle/9i/dbs/snapcf_rptcacs2.f'; If you have any concerns or questions about this, please don't hesitate to contact me off list. Good luck, Ruth rgramolini@tax.state.vt.us -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Joe Smith Sent: Tuesday, December 13, 2005 9:56 AM To: oracle-l@freelists.org Subject: rman incomplete recovery List, I am trying to do an incomplete recovery of my 9iRel2 db on Solaris 8. I am in archive log mode. This is a test environment. I autobackup my control file and snapshot the control file. The basis of the backup is: backup database plus archivelog delete all input; My RMAN backup script works fine, it has been running on multiple boxes for months now. I have tested different situations and now working on a new one. I can do an incomplete recovery with the current control file and redo logs. I am trying to simulate the situation of losing my controlfiles and redo logs. When I try to do an incomplete recovery with a backup controlfile and no redo logs I get an RMAN error. So, I rename my controlfiles and redo logs and try to recover to a time before my redo logs. I am using this run block: run { set controlfile autobackup format for device type disk to ‘/backup/location/control_%F'; set until time "to_date(‘12-12-05 19:00:00’,’MM-DD-YY HH24:MI:SI’)"; restore controlfile from autobackup; alter database mount; restore database; recover database; alter database open resetlogs; } I get an RMAN error about database not mounted. I don't think that is the whole problem. Any help is highly appreicated. thanks. _________________________________________________________________ Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l