-
I have drop one table how do I recover that table
my database is running in archive log mode this is new database so there is nothing in the archive folder
please help me what to do now?
-
I have not done it, but if you are using UNDO tablespaces and/or LOGMINER, you may be able to rollback. At least, you are supposed to be able in 9i if you have set up beforehand for it (based on what I was taught in class).
I may not be able to help beyond that, but at least I can point you in a direction.
Joseph R.P. Maloney, CSP,CDP,CCP
'The answer is 42'
-
thanks jrpm but i am usuing oracle 8.1.5 so I am not usuing the undo tablespace
if anybody have some idea please tell me
thanks in advance
-
You could usetablespace-point-in-time recovery - you're probably best to refer to the Oracle documentation for details on how to do it because its pretty complex.
-
table recovery
Do you have any backups of this database. (e.g. export, or cold) If you do is there an additional server, maybe a test server you could use to recover this backup to and extract the necessary table information.
-
No I do not have any backup
[Edited by shailendra on 03-07-2002 at 11:19 AM]
-
would you click the link and go thru it ASAP.
hope this will help you....
http://metalink.oracle.com/metalink/...T&p_id=62332.1
Thanks,
Madhu
PS: You need to have metalink access
-
I am not a registered user of this site.
-
Now you dont have any backups (incl export). Also you don't have any archive logs. This means that all your dml for that table is in the redo logs. What you can do is :-
1. Switch your logfiles so that you get your archive logs.
2. Clone your database
3. Recover your database just before you dropped your table.
4. Take an export and import it back into your production db.
Hope that helps.
Vinit
-
i think she'll be into more probs w/o an env for clone database recovery...any advice better than this??
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|