You will have to use your last Hot Backup file set and
create a new database (use the alter database backup controlfile to trace
for the create db statement). Then apply all the arch. redo files since
THAT backup, UPTO the point before
the Table was dropped. Then extract the Table data and insert it into your
existing database.
-----Original Message-----
Sent: 13 February 2001 11:46
To: Multiple recipients of list ORACLE-L
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: Martin Kendall
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).