Re: Bringing up a database sans certain datafiles

First thoughts......I'm packing for my next assignment so my SQL Quick Ref isn't handy (and exact SQL syntax seems to be escaping me)

• Restore what you need.
• Startup mount the database.
• Save the controlfile to trace (this puts a text (sql commands) copy of the control file (which can be used to re-create the controlfile) into the trace directory..
• Edit the trace file, removing the datafiles which aren't going to be restored. Remove other appropriate entries relating to recovery......save it when you're done(give it a name you can remember).
• use the edited controlfile to open the database.
• Do what you have to.

Hope this helps. John

joes_at_access.com wrote:

> Hi -
>
> I'm in a situation and looking for feedback. Assume this is a large
> database (~500gb) with many different tablespaces. The data in each
> tablespace is independent of the other tablespaces (ie - there are no
> views defined that depend on data from multiple tablespaces, etc).
>
> This entire database is on tape and needs to be restored in order to get
> a very small subset of the data out. I can identify exactly which
> tablespaces I need to restore and all the related datafiles to get that
> small subset.
>
> Oracle 7.2.2.3, Solaris 2.5.1
>
> Not wanting to restore every single file for many reasons...would the
> following work:
>
> Restore SYSTEM, ROLLBACK, TEMP and all the other datafiles associated with
> the tablespaces I care about.
>
> % svrmgrl
> SVRMGRL> connect internal
> SVRMGRL> startup mount
> SVRMGRL> alter database datafile '/full/path/to/file' offline drop;
> <repeat above step for every non-restored file>
> SVRMGRL> alter database open;
>
> Once I get the desired data out, I will just delete all the files. Again,
> this is not a production database. I'm just trying to cut down on the
> restore time and disk space requirements. BTW, this works for a very small
> database I tested it on.
>
> Opnions? Caveats? Flames?
>
> Feel free to reply to the group or backchannel. I will summarize backchannel
> responses.
>
> thanks,
> joe
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Fri Aug 21 1998 - 12:35:12 CDT