| 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: Backup and Recovery Question
Build a new database.. recover over there.. from backups+arch logs until
table was dropped
..
export there, import to the original database..
-bruce
"Sanjay Kumar" <ora_user_at_hotmail.com>@fatcity.com on 02/01/2001 11:16:10 AM
Please respond to ORACLE-L_at_fatcity.com
Sent by: root_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:
Hi,
I have a situation like this.
I found a user dropping a table today at 9 AM but I came to know about that only at 2 PM the same day. I have a backup which was taken the previous day at 4 PM. My database runs in Archivelog mode.
I want to restore the table. If I put the database in recovery mode and recover using until time option then I may loose all the transactions that happened between 9 to 2. But I dont want to loose that.
I donot have a export.
How do I accomplish this?
Help Appreciated.
Vinay
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: bruce.taneja_at_mcd.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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 Thu Feb 01 2001 - 13:47:14 CST
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |