Re: ************Urgent Help me !!!**************

[SHAIBAL TALUKDER]

Ruth gave you the best suggession. First make sure the time, until when you had the data in the table. Clone the database; you can do it by restoring HOT BACK UP of your original datbase in another database. You can do so by restoring all the files including rbs and archive logs in the target database. Create a controlfile in the original database by ALTER DATABASE BACKUP CONTROL FILE TO TRACE. ftp this control file from the trace directory to the target database and edit it to make a SQL script to create controlfile. Edit it means reflect the path name in this control file, as you have restored them in target database. Edit the the CREATE CONTROLFILE line to read CREATE CONTROLFILE SET DATABASE "NEW DATABASE NAME" RESETLOGS. Recober database using backup contol file until "time". By the way while restoring files in the target database, get rid of the control files if there is any in the target database.

IF you are not sure of it yet, take Ruth's suggession - CALL ORACLE SUPPORT. If yor production is up you can perhaps let it run with appropriate concents and then if you can successfully clone the database, take an export of the table. Then import it in your original database.

Hope this helps.

Thanks

Shaibal

N:B: General disclaimer applies.

  Ruth Gramolini <[EMAIL PROTECTED]> wrote:

If possible, you can do a point in time recovery back to before the table
was dropped. If that is not possible you can do a point in time recovery to
a clone database then export the table in question and import it back to the
'real' database.

If you are not familiar with the concept I would advise you call Oracle
Support and have them help you

HTH,
Ruth


----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, February 13, 2001 6:45 AM


> Dear All,
>
> In one of database 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 I recover the the table .
> please guide me the exact detailed ed steps to recover the table .
>
> We have online backup ! ! .Archive log mode.
>
> We don`t have coldbackup.!!!
>
> I tried with shutdown the database.
>
> Strtup mount
> recover database until time '2001-02-09:22:00:00';
> media recovery completed.
> alter database open
> it says noresetlogs or resetlogs.
>
> I tried with norestelog then no data found i that table.
>
> after that I tried with resetlogs.
>
> still then no rows select from that table.
>
> send me the possible way to recover the table.please send me thesteps to
> be done to recover the table.
>
> Regards,
> Saroj.
> --
> 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 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.com
--
Author: Ruth Gramolini
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).

---

Do You Yahoo!?
- Get personalized email addresses from Yahoo! Mail Personal Address - only $35 a year!