Re: applying from archive log

From: Chuck Hamilton <chuck_hamilton_at_yahoo.com>
Date: Thu, 27 Apr 2000 08:40:12 -0700 (PDT)
Message-Id: <10480.104331@fatcity.com>

--0-1804289383-956850012=:14415
Content-Type: text/plain; charset=us-ascii

What you're talking about is cancel based recovery. You'd first need to restore all database files to a backup prior to the point you want to recover too then apply logs up to and including arc1_20.dbf, then cancel the recovery. This will roll the entire database back to that point though. Not just one table.

Alternately you can create a partial clone database to recover the one table to the point in time where you want it, export it from the clone, and import it into the production database.

Indra Harimurti <indra_at_sofrecom.co.id> wrote: Dear DBA, I would like to know if : 1. I have 10 rows in table client.2. alter system switch logfile, it produced arc1_20.dbf3. accidently delete 2 rows from table client question is can I recover the missing 2 rowsby doing : recover database until change 20 ?Please advise. Thanks

Do You Yahoo!?
Talk to your friends online and get email alerts with Yahoo! Messenger. --0-1804289383-956850012=:14415
Content-Type: text/html; charset=us-ascii

<P>What you're talking about is cancel based recovery. You'd first need to restore all database files to a backup prior to the point you want to recover too then apply logs up to and including arc1_20.dbf, then cancel the recovery. This will roll the entire database back to that point though. Not just one table. </P>
<P>Alternately you can create a partial clone database to recover the one table to the point in time where you want it, export it from the clone, and import it into the production database.</P>
<P><B><I>Indra Harimurti <indra_at_sofrecom.co.id></B></I> wrote:<BR>
<BLOCKQUOTE style="BORDER-LEFT: #1010ff 2px solid; MARGIN-LEFT: 5px; PADDING-LEFT: 5px"><!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<META content='"MSHTML 4.72.3110.7"' name=GENERATOR>
<DIV><FONT color=#000000 size=2>Dear DBA,</FONT></DIV>
<DIV><FONT color=#000000 size=2></FONT> </DIV>
<DIV><FONT color=#000000 size=2>I would like to know if :</FONT></DIV>
<DIV><FONT color=#000000 size=2></FONT> </DIV>
<DIV><FONT color=#000000 size=2>1. I have 10 rows in table client.</FONT></DIV>
<DIV><FONT color=#000000 size=2>2. alter system switch logfile, it produced arc1_20.dbf</FONT></DIV>
<DIV><FONT color=#000000 size=2>3. accidently delete 2 rows from table client</FONT></DIV>
<DIV><FONT color=#000000 size=2></FONT> </DIV>
<DIV><FONT color=#000000 size=2>question is can I recover the missing 2 rows</FONT></DIV>
<DIV><FONT color=#000000 size=2>by doing : recover database until change 20 ?</FONT></DIV>
<DIV><FONT color=#000000 size=2>Please advise. Thanks</FONT></DIV>
<DIV><FONT color=#000000 size=2></FONT> </DIV></BLOCKQUOTE><p><br><hr size=1><b>Do You Yahoo!?</b><br>
Talk to your friends online and get email alerts with Yahoo! Messenger. --0-1804289383-956850012=:14415-- Received on Thu Apr 27 2000 - 10:40:12 CDT