RE: !!**** Urgent HELP (Table Deleted In Production )

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infy.com>
Date: Tue, 13 Feb 2001 00:29:48 -0800
Message-ID: <F001.002B2353.20010212233027@fatcity.com>

When Attempting point in time recovery :-

Let Control File & Online Redo Logfiles be the Latest ( Current ) Ensure that you have WRITE Permission to the Online Redo logfiles so that In case When the Database is Opened with RESETLOGS After Completion of Recovery , the Online Redo Logfiles will be Written to.
Extract ONLY the Datafiles from the Backup , NOT the Online Redo Logfiles from the Backup
The Database should be in MOUNT Condition (NOT Open) When Issuing the RECOVER DATABASE UNTIL TIME Command ?
After Completing the Roll forward by Applying the Archived ( Online Redo logs , if required ) Issue Command ALTER DATABASE OPEN RESETLOGS

MISCELLANEOUS - Check v$backup to see if STATUS = ACTIVE for the respective Datafiles

> -----Original Message-----
> From: Rocky Welch [SMTP:rockyw_99_at_yahoo.com]
> Sent: Friday, February 09, 2001 11:19 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: !!**** Urgent HELP (Table Deleted In Production )
>
> Hi Saroj,
>
> If the table data isn't updated too often you can go back to an older
> export and import the table. If not, are you in archive log mode? Check
> your alert.log file for errors on the system datafile and let us know the
> status of your database to provide an accurate answer.
>
> -Rocky
>
>
> "Dash, Saroj (CAP,CEF)" <Saroj.Dash_at_gecapital.com> wrote:
>
>
> Dear Friends
> In product databace one of the developer had deleted a table and
> commited it
> ,
> database is in online backup but no export backup or table backup
> Please tell me how can the table be recovered
> please guide me the exact detaied steps torecover the table
> After getting the reply i will start it
>
> Thanks and Best regards
>
> I tried this command
> recover database until time '2001-02-09:22:00:00' ;
>
> it gived the following error
> recovery session canceled due to errors
> ORA-01124: cannot recover data file 1 - file is in use or recovery
> ORA-01110: data file 1: '/db/oracle/oradata/tlisuser/system01.dbf'
> SVRMGR> recover database
> ORA-00283: recovery session canceled due to errors
> ORA-01124: cannot recover data file 1 - file is in use or recovery
> ORA-01110: data file 1: '/db/oracle/oradata/tlisuser/system01.dbf'
> SVRMGR> rec! ! over database until time '2001-02-09:22:00:00' ;
> ORA-00283: recovery session canceled due to errors
> ORA-01124: cannot recover data file 1 - file is in use or recovery
> ORA-01110: data file 1: '/db/oracle/oradata/tlisuser/system01.dbf'
> SVRMGR> select * from v$backup ;
>
> then again i shut down the database then up it again i tried but
> same errors
>
>
> Plese reply soon
> saroj dash
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Dash, Saroj (CAP,CEF)
> INET: Saroj.Dash_at_gecapital.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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 t! ! he name of mailing list you want to be removed from). You
> may
> also send the HELP command for other information (like subscribing).
>
>
>
> _____
>
> Do You Yahoo!?
> - Get personalized email addresses from Yahoo! Mail Personal Address
> <http://personal.mail.yahoo.com/> - only $35 a year!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: VIVEK_SHARMA
  INET: VIVEK_SHARMA_at_infy.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 Tue Feb 13 2001 - 02:29:48 CST