| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ************Urgent Help me !!!**************
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: 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 the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 - 10:25:09 CST
 |
 |