RE: applying from archive log

Yes, you can. But not using the 20 in the arc1_20.dbf.  

Use until cancel and stop the recovery once the arc1_20.dbf is applied.  

HTHY.   Regards.  

Bhat

-----Original Message-----
From: Indra Harimurti [mailto:indra_at_sofrecom.co.id] Sent: Thursday, April 27, 2000 7:59 PM
To: Multiple recipients of list ORACLE-L Subject: applying from archive log

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.dbf
3. accidently delete 2 rows from table client

question is can I recover the missing 2 rows by doing : recover database until change 20 ? Please advise. Thanks Received on Thu Apr 27 2000 - 20:36:17 CDT