When Attempting point in time recovery :-
1) 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.
2) Extract ONLY the Datafiles from the Backup , NOT the Online Redo Logfiles
from the Backup
3) The Database should be in MOUNT Condition (NOT Open) When Issuing the
RECOVER DATABASE UNTIL TIME Command ?
4) 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:[EMAIL PROTECTED]]
> 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)" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
