|
-
First of all, let me thank you guys for your responses. All of them are good and I feel more intelligent than ever after reading them... 
jmodic is right that no recovery whatsoever is needed, no backup controlfile to trace.
I don't even need to recreate RBS and TEMP tablespace.
Here is what I did:
We had a clean cold backup on tape.
Basically you need to create a temporary instance to contain the affected table the least of anything else.
1. copy the following files from tape to a different server:
(1)all redo log files.
(2)all control files
(3)the datafile that has the table
(4)system tablespace files
(5)user tablespace files
2. edit the init.ora file to update the control file path, remove the rollback_segments entry (because there is no user created rollback segments, only system rollback segment), and change shared_pool_size, buffers (because the production database is very large so I need to shrink the SGA for this tempoarary database).
3. mount the database
4. offline drop all other datafiles that have nothing to do the affected table.
5. rename redo log files to the current name
6. rename system tablespace file to the current name
7. rename user tablespace file to the current name.
8. open the database
9. export the table
10. import the table
Done!
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
|