Received: (qmail 26810 invoked from network); 3 Mar 2010 17:43:16 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-85-25-126-90.inaddr.intergenia.de with SMTP; 3 Mar 2010 17:43:02 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 91851CD9512; Wed, 3 Mar 2010 18:42:59 -0500 (EST) X-Virus-Scanned: Debian amavisd-new at localhost.localdomain Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id j1HYsuPbX5qj; Wed, 3 Mar 2010 18:42:59 -0500 (EST) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4DC30CD947C; Wed, 3 Mar 2010 18:42:17 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 03 Mar 2010 18:41:35 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 98ECDCD9414 for ; Wed, 3 Mar 2010 18:41:35 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id smmxjhlxQmMx for ; Wed, 3 Mar 2010 18:41:35 -0500 (EST) Received: from web35603.mail.mud.yahoo.com (web35603.mail.mud.yahoo.com [66.163.179.142]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id A393ECD91A3 for ; Wed, 3 Mar 2010 18:41:34 -0500 (EST) Received: (qmail 24677 invoked by uid 60001); 3 Mar 2010 23:41:33 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1267659693; bh=9wFBDDj5hRguRobU2CDEkkxg96ckG8JaKxVIFElvcA4=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=TubnisYRpAcQZlPeMRRYYq+oMpsaFdhqzRYsjhCs3tUi7tzDLajRJg/g/9mbneMrqWl2mlB7izfP9MPuvR6Idsj12spljDbmj+pZMEFDqRM7jzKi4dJi1gGNau46uVucuJ18O304fsWB4vL3SdcN+yHr4nfTDWcXgIjnWLzr1og= DomainKey-Signature:a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=f47dhmFOZRciG5Yf+YHvitpXPaqtvhJ3BZbpgIC6xR9ErfFFjvO6eObp18LCR5cA2B4jWecH55kwi3neAX4WGGhaUQzIjzJEgMjRN6/WgsV/SRPKIHn9X/npmGaOVx+HmA+hio8pD0MIXC2U9kWqo7TdqEXpGGE/XY67VAK4dnk=; Message-ID: <304006.24530.qm@web35603.mail.mud.yahoo.com> X-YMail-OSG: MXBlA8MVM1lbhm1aIY8pDXp9FWaWQp_y7jVs8MHVWzf4Vw. L3Yb1JBxpd074zczOsVVioxtiO.ijmpnpCSVa965Bfd9gtlVXi7lf9IjW9pt 2.12y4q7GqIkLzP10kZp5w.US6TSTei9pO8xzw4tJzRt2z4owzwxZj_Zc7uh HRApzh3mSwUr4WFkAIJ2ADiRpEhQLc69.mCf0xcLgG54bACnAUygy.kXZrzy aXq3YRlTQpvXJAxmsssJcV6OxjeN95BHlVOIg_ARM2lhvTRpPfyGowU3gxZ4 2SOSAP5.tV_s1N8yMeZQJmSIU07uo10px_ySDWL0pUVuy9f59vcC3ahD63DU t3OOTguOmVzL.UIo- Received: from [167.154.52.17] by web35603.mail.mud.yahoo.com via HTTP; Wed, 03 Mar 2010 15:41:33 PST Date: Wed, 3 Mar 2010 15:41:33 -0800 (PST) From: patrick obrien Subject: RE: flash it back then roll it forward(pitr) To: "pobrien@controller.state.nv.us" , ORACLE-L , "Lee.Robertson@acxiom.com" , D'Hooge Freek In-Reply-To: <4814386347E41145AAE79139EAA398980DC8495DC1@ws03-exch07.iconos.be> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1452702472-1267659693=:24530" X-archive-position: 26278 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: po04541@yahoo.com Precedence: normal Reply-To: po04541@yahoo.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l --0-1452702472-1267659693=:24530 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable ALTER DATABASE OPEN READ ONLY thank you! --- On Wed, 3/3/10, D'Hooge Freek wrote: From: D'Hooge Freek Subject: RE: flash it back then roll it forward(pitr) To: "po04541@yahoo.com" , "pobrien@controller.state.nv.u= s" , "ORACLE-L" , "= Lee.Robertson@acxiom.com" Date: Wednesday, March 3, 2010, 2:32 PM Patrick, Jason and I already told you that you can't do a rollforward when you have = opened the database in r/w because you then need to open the database with = resetlogs (the same as with an incomplete restore). You can however open the flashbacked database in read only mode, shutdown i= t again, mount it and then do a rollforward. =C2=A0 Freek D'Hooge Uptime Oracle Database Administrator email: freek.dhooge@uptime.be tel +32(0)3 451 23 82 http://www.uptime.be=0A disclaimer: www.uptime.be/disclaimer ________________________________________ From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] = On Behalf Of patrick obrien Sent: woensdag 3 maart 2010 19:06 To: pobrien@controller.state.nv.us; ORACLE-L; Lee.Robertson@acxiom.com Subject: RE: flash it back then roll it forward(pitr) Lee, I had to do a reset unless I wanted to use a backup control file which, I d= id not want to go there... SQL> FLASHBACK DATABASE TO TIMESTAMP timestamp'2010-03-02 10:13:40'; Flashback complete. SQL> alter database open; alter database open * ERROR at line 1: ORA-01589: must use RESETLOGS or NORESETLOGS option for database open SQL> alter database open noresetlogs; alter database open noresetlogs * ERROR at line 1: ORA-01610: recovery using the BACKUP CONTROLFILE option must be done SQL> alter database open resetlogs; Database altered. --- On Wed, 3/3/10, Robertson Lee - lerobe wrote= : From: Robertson Lee - lerobe Subject: RE: flash it back then roll it forward(pitr) To: pobrien@controller.state.nv.us, "ORACLE-L" Date: Wednesday, March 3, 2010, 9:16 AM I am thinking you shouldn=E2=80=99t have issued your resetlogs, however my = knowledge of flashback stuff is limited to say the least =E2=98=B9=C2=A0 ?? ________________________________________ From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] = On Behalf Of Patrick O'Brien Sent: 03 March 2010 16:42 To: ORACLE-L Subject: Re: flash it back then roll it forward(pitr) =C2=A0 Jason, Good to know about the flash forward until; thanks! What commands/processes did you use?=20 This is what I did and I had problems. Any thoughts?=C2=A0=20 Shutdown immediate; startup mount; FLASHBACK DATABASE TO TIMESTAMP timestamp'2010-03-01 09:41:49'; alter database open resetlogs; SQL> RECOVER database until time '2010-03-01:09:42:38'; ORA-00283: recovery session canceled due to errors ORA-19907: recovery time or SCN does not belong to recovered incarnation =C2=A0 =C2=A0 =C2=A0 --- On Wed, 3/3/10, jason arneil wrote: From: jason arneil Subject: Re: flash it back then roll it forward(pitr) To: pobrien@controller.state.nv.us Cc: "ORACLE-L" Date: Wednesday, March 3, 2010, 8:02 AM Hello Patrick, Been testing flashback a bit recently so when I saw your email thought I would test. Tested this with 10.2.0.4 on linux, and yep you definitely can flashback and then roll forward, I did a recover database until change to roll forwards again. As Freek pointed to open read-write a flashed back database you need a resetlogs, but of course you can open read-only without this. Once you have flashed back you can even use flashback database to "flash forward" and undo your flashback. jason. -- http://jarneil.wordpress.com=0A On 3 March 2010 15:29, Patrick O'Brien wro= te: > Hello Oracle users, > > is it possible to flashback a database then turn around and roll it forwa= rd > using a pitr process? > > thank you! > > -- http://www.freelists.org/webpage/oracle-l=0A *************************************************************************** The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. ***************************************************************************= * =0A=0A=0A --0-1452702472-1267659693=:24530 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable 
ALTER DATABASE OPEN READ ONLY

tha=
nk you!




--- On Wed, 3/3/10, D'Hooge Freek &l= t;Freek.DHooge@uptime.be> wrote:
From: D'Hooge Freek <Freek.DHooge@uptime.be>
Subject: RE: flash i= t back then roll it forward(pitr)
To: "po04541@yahoo.com" <po04541@ya= hoo.com>, "pobrien@controller.state.nv.us" <pobrien@controller.state.= nv.us>, "ORACLE-L" <oracle-l@freelists.org>, "Lee.Robertson@acxiom= .com" <Lee.Robertson@acxiom.com>
Date: Wednesday, March 3, 2010, 2= :32 PM

Patrick,

Jason and I already = told you that you can't do a rollforward when you have opened the database = in r/w because you then need to open the database with resetlogs (the same = as with an incomplete restore).
You can however open the flashbacked database i= n read only mode, shutdown it again, mount it and then do a rollforward.
 
Freek D'Hooge
Uptime
Oracle Database Administrator
= email: freek.dhooge@uptime.be
tel +32(0)3 451 23= 82
http://www.uptime= .be=0A
disclaimer: www.uptime.be/disclaimer


_____________= ___________________________
From: oracl= e-l-bounce@freelists.org [mailto:oracl= e-l-bounce@freelists.org] On Behalf Of patrick obrien
Sent: woensdag= 3 maart 2010 19:06
To: pobrien@contr= oller.state.nv.us; ORACLE-L; Lee.Robertson@acxio= m.com
Subject: RE: flash it back then roll it forward(pitr)

L= ee,
I had to do a reset unless I wanted to use a backup control file whi= ch, I did not want to go there...

SQL> FLASHBACK DATABASE TO TIME= STAMP timestamp'2010-03-02 10:13:40';

Flashback complete.

SQL> = alter database open;
alter database open
*
ERROR at line 1:
ORA= -01589: must use RESETLOGS or NORESETLOGS option for database open

<= br>SQL> alter database open noresetlogs;
alter database open noresetl= ogs
*
ERROR at line 1:
ORA-01610: recovery using the BACKUP CONTRO= LFILE option must be done


SQL> alter database open resetlogs;=

Database altered.




--- On Wed, 3/3/10, Robertson = Lee - lerobe <Lee.Robertson@acxiom.com> wr= ote:

From: Robertson Lee - lerobe <Lee.Rob= ertson@acxiom.com>
Subject: RE: flash it back then roll it forwar= d(pitr)
To: pobrien@controlle= r.state.nv.us, "ORACLE-L" <oracle-l@freelists.org= >
Date: Wednesday, March 3, 2010, 9:16 AM
I am thinking you sh= ouldn=E2=80=99t have issued your resetlogs, however my knowledge of flashba= ck stuff is limited to say the least =E2=98=B9  ??
________________= ________________________
From: oracle-l= -bounce@freelists.org [mailto:oracle-l= -bounce@freelists.org] On Behalf Of Patrick O'Brien
Sent: 03 March 2= 010 16:42
To: ORACLE-L
Subject: Re: flash it back then roll it forwar= d(pitr)
 
Jason,
Good to know about the flash forward until; = thanks!

What commands/processes did you use?
This is what I did and I had problems.= Any thoughts? 


Shutdown immediate;
startup mount;
F= LASHBACK DATABASE TO TIMESTAMP timestamp'2010-03-01 09:41:49';
alter dat= abase open resetlogs;


SQL> RECOVER database until time '2010-= 03-01:09:42:38';
ORA-00283: recovery session canceled due to errors
O= RA-19907: recovery time or SCN does not belong to recovered incarnation
=  
 
 

--- On Wed, 3/3/10, jason arneil <jason.arneil@gmail.com> wrote:

From: jason arn= eil <jason.arneil@gmail.com>
Subject: Re: f= lash it back then roll it forward(pitr)
To: pobrien@controlle= r.state.nv.us
Cc: "ORACLE-L" <oracle-l@freelis= ts.org>
Date: Wednesday, March 3, 2010, 8:02 AM
Hello Patrick,=

Been testing flashback a bit recently so when I saw your email thou= ght
I would test. Tested this with 10.2.0.4 on linux, and yep you
def= initely can flashback and then roll forward, I did a recover
database un= til change to roll forwards again.

As Freek pointed to open read-wri= te a flashed back database you need a
resetlogs, but of course you can o= pen read-only without this.

Once you have flashed back you can even = use flashback database to
"flash forward" and undo your flashback.
jason.

--
http://jarneil.wordpress.com=0A



On 3 March 2010 15= :29, Patrick O'Brien <pobrien@control= ler.state.nv.us> wrote:
> Hello Oracle users,
>
> = is it possible to flashback a database then turn around and roll it forward=
> using a pitr process?
>
> thank you!
>
>--
http://www.freelists.org/webpage/oracle-l=0A
******************= *********************************************************
The informatio= n contained in this communication is confidential, is
intended only for = the use of the recipient named above, and may be legally
privileged.
=
If the reader of this message is not the intended recipient, you arehereby notified that any dissemination, distribution or copying of thiscommunication is strictly prohibited.

If you have received this com= munication in error, please resend this
communication to the sender and = delete the original message or any copy
of it from your computer system.=

Thank You.
*****************************************************= ***********************


=0A= =0A --0-1452702472-1267659693=:24530-- -- http://www.freelists.org/webpage/oracle-l