Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: applying from archive log

Re: applying from archive log

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Thu, 27 Apr 2000 13:39:00 -0400
Message-Id: <10480.104336@fatcity.com>


I know that with rman a tablespace point in time recovery is the smallest unit. I don't think you can recover a single table except from an export. HTH
Ruth
----- Original Message -----
From: Indra Harimurti <indra_at_sofrecom.co.id> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Thursday, April 27, 2000 7:58 AM
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 - 12:39:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US