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: recovery

Re: recovery

From: Yechiel Adar <adar76_at_inter.net.il>
Date: Thu, 27 Mar 2003 02:13:54 -0800
Message-ID: <F001.0057411F.20030327021354@fatcity.com>


Just my 2 cents:

Last backup from 03-Feb is way too long. Data check on one of the tapes, that you backed the archive logs to, and you can not recover.

Yechiel Adar
Mehish
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Thursday, March 27, 2003 12:33 AM

> Hi,
>
> I have to recover my database back to 23-MAR-03.There was some changes to
the data yesterday and cannot be reverted.
> We want to recover the data as of 23-MAR-03.Database is running on archive
log mode and I have the hot backup datafiles
> of Feb 3 and all the archive logs since then till today.I know how to
recover but to make sure that I don't miss anything i am
> posting this here.
>
> 1.Restore the data tablespace datafiles from the Feb 3rd backup.
> 2.Startup the database in MOUNT mode.
> 3.recover database until time "2003-03-23-12:00:00"
> 4.All the archive logs will get applied
> 5.Open the database with reset logs.I should go back by 3 days wrt to
data.
> Am I missing anything.
> My questions:
> Should I restore the control files(of FEb 3) before starting the
recovery.?
> Should i restore redo log files?.I donot want the recent changes to be
applied to my database after restoring till 23-MAR-03.
> Thanks
>
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Basavaraja, Ravindra
> INET: Ravindra.Basavaraja_at_T-Mobile.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Yechiel Adar
  INET: adar76_at_inter.net.il

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Thu Mar 27 2003 - 04:13:54 CST

Original text of this message

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