Re: recover of single data object in oracle

Solution depends on how big the database is.

If the database size is small, restore the datafiles onto a different location ( either another directory or machine ). The safest option is to restore on another machine ( which doesn't have the same SID ). If restoring in a different dir, ensure that the controlfile you are creating has a SID different from the original SID. The datafiles/redo/control file in the create controlfile script should be all pointing to the new restored location. Open db with resetlogs option. Export the table you are interested in, import into the db that you want.

If the database size is HUGE and you cannot restore all the datafiles to another location/machine, then ..... I have done this long time back. Here's whta i can recall :

• Restore the system, rollback, online redo, arch redos files onto another area/machine.
• Also restore the tablespace which houses the table in question
• Set the sid to TEST ( say ).
• Startup nomount
• create the controlfile with the SID set to TEST and data/redo/control files pointing to the new locs
• Try opening the database. System will prompt for recovery.
• recover database .... from the location where the arch redos are located ... till the point in time when you want to export the table. You may want to do a cancel / time-based recovery
• alter database open resetlogs

Export the table and import it in the database you want it in.

The above procedure comes in pretty handy for restoring a table from a large db ( 300GB+). The restore/recovery is pretty short 'cos you are working only on a very small portion of the database. There could be somethings i have missed out on the latter approach.

Let the forum know how you went...

Sridhar Subramaniam

*

gmalika5021_at_my-dejanews.com wrote in message <6ulk4e$oh9$1_at_nnrp1.dejanews.com>...
>I have a tape backup with soltice backup for oracle 7.3.3 for unix on
solaris
>platform 2.5.1, I need to restore a single table from this backup. Can
anyone
>help me do that. please reply at the email address.
>thanks
>Ghazala Malik
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Tue Sep 29 1998 - 09:29:59 CDT