From oracle-l-bounce@freelists.org Thu Jul 15 11:44:03 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i6FGhm610349 for ; Thu, 15 Jul 2004 11:43:58 -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 i6FGhb610312 for ; Thu, 15 Jul 2004 11:43:47 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3A03E72CC8B; Thu, 15 Jul 2004 11:23:49 -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 28554-87; Thu, 15 Jul 2004 11:23:49 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7FAC772C9E1; Thu, 15 Jul 2004 11:23:48 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 15 Jul 2004 11:22:25 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7F99072CA12 for ; Thu, 15 Jul 2004 11:22:24 -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 29564-05 for ; Thu, 15 Jul 2004 11:22:24 -0500 (EST) Received: from mx1.state.vt.us (ns1.state.vt.us [159.105.23.130]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 023D472C9AF for ; Thu, 15 Jul 2004 11:22:24 -0500 (EST) Received: from TAX132 ([159.105.89.132]) by mx1.state.vt.us (Post.Office MTA v3.5.4 release 224 ID# 0-0U10L2S100V35) with SMTP id us for ; Thu, 15 Jul 2004 12:47:28 -0400 From: "Ruth Gramolini" To: Subject: RE: rman nocatalog - point in time recovery Date: Thu, 15 Jul 2004 12:47:28 -0400 Message-ID: <006301c46a8b$69dbafe0$8459699f@vttaxnet.tax.state.vt.us> MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook 8.5, Build 4.71.2173.0 In-Reply-To: <80D4A99A2715674EB2D256DAD89219F6044E8999@dohsmail02.doh.ad.state.fl.us> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 Importance: Normal X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 5244 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: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Paula, What version of Oracle? Was this an rman restore from an rman backup? Is this a production instance? and lastly, if you can tell, did the incarnation change when you did the open resetlogs? Regards, Ruth -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Paula_Stankus@doh.state.fl.us Sent: Thursday, July 15, 2004 12:39 PM To: oracle-l@freelists.org Subject: RE: rman nocatalog - point in time recovery Guys,=20 I did the following: execute script alloc_all_tapes; restore database UNTIL TIME "TO_DATE('07/01/07 12:00:00','MM/DD/YY = HH24:MI:S S')"; recover database UNTIL TIME "TO_DATE('07/01/07 12:00:00','MM/DD/YY = HH24:MI:S S')"; Then I did an alter database open resetlogs As developer mentioned he needed objects that were there on the 7th or = the 8th. He says they still aren't there and there were no changes between until the 9th. Is this not recovery and restoring the database up till the UNTIL = TIME????? -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Ruth Gramolini Sent: Wednesday, July 14, 2004 8:41 AM To: oracle-l@freelists.org Subject: RE: rman nocatalog - point in time recovery Sometimes I find it is just expedient to use sqlplus to open the = database. Sometimes, there is no other way. Rman is still a work in progress and = it has been seriously improved since the 8.0.5... days but when you are = doing incomplete recovery and it seems to want a redo log instead of an = archived log, then I have found, sqlplus recover the way you did it is the = easiest way. Even Oracle support has told me this. HTH, Ruth -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Schauss, Peter Sent: Tuesday, July 13, 2004 4:44 PM To: oracle-l@freelists.org Subject: RE: rman nocatalog - point in time recovery This may not be the cleanest solution, but it worked: rman run { set until logseq=3D1235 thread =3D1; allocate channel ch1 type disk; allocate channel ch2 type disk; allocate channel ch3 type disk; restore database; } exit; sqlplus internal sqlplus> recover database until cancel using backup controlfile; sqlplus> alter database open resetlogs; sqlplus> exit; Is there a better way to do this? thanks, Peter Schauss -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Schauss, Peter Sent: Tuesday, July 13, 2004 4:12 PM To: Oracle-L (E-mail) Subject: rman nocatalog - point in time recovery Enviroment: Oracle 8.1.7.4 / AIX 5.2 Scenario: - I have an rman backup (nocatalog) and a separate control file backup done at 11:00 pm. - The database is in archivelog mode. - At 11:00 am the next morning I have a failure which causes loss of the entire database. - Archivelogs through 10:45 are intact. The last archive log is = sequence 1234. - I have the backup files created from the 11:00 pm rman backup in the directory to which they were backed up. - I want to restore the database to the state it was in at 10:45 am by applying the redo logs through number 1234. I restore my control files by copying them to the appropriate = directories on the disk (e.g. /ora1/oradata/sid/control01.ctl ... /ora2/... = /ora3/...). I run the following commands in rman run { set until logseq=3D1234 thread=3D1; allocate channel ch1 type disk; allocate channel ch2 type disk; allocate channel ch3 type disk; restore database; recover database; alter database open resetlogs; } Oracle says: RMAN-03002: failure during compilation of command RMAN-03013: command type: set RMAN-06003: ORACLE error from target database: RMAN-20206: log sequence = not found in the recovery catalog What am I missing here? Thanks, Peter Schauss ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- BEGIN-ANTISPAM-VOTING-LINKS ------------------------------------------------------ Teach CanIt if this mail (ID 4586007) is spam: Spam: = https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Ds&i=3D4586007&m=3Ddd09e= d4dec9a Not spam: = https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Dn&i=3D4586007&m=3Ddd09e= d4dec9a Forget vote: = https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Df&i=3D4586007&m=3Ddd09e= d4dec9a ------------------------------------------------------ END-ANTISPAM-VOTING-LINKS ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------