Steve,
No, it's not neccessary to restore the entire db to
recover a specific table. All you need to restore are
the system and rbs datafiles along with the datafiles
for the tablespace in which the table(s) reside. Of
course you'll need the archived logs for the PITR too.
Brief summary of steps:
- Restore files.
- Mount db and backup controlfile to trace (or you
can do this from the prod instance).
- Edit script removing all the datafiles not
restored and any recovery commands. You may also
want to reduce the number of redo logs to two groups
of one member each to reduce the time to open the db
since the redo logs will have to be created.
- Recreate controlfile.
- Perform PITR to before table was dropped.
- Open resetlogs
- Export table(s)
Of course if you're restoring on the same machine as
the prod db you'll need to change the db_name and sid,
location of controlfiles in the init.ora, location of
datafiles and logfiles, etc... Just be VERY careful
so you don't inadvertently overwrite anything
belonging to the prod db.
You can find the full details in the following doc on
MetaLink:
Note 96197.1 - "Recovering a Dropped Table from a Full
Database Backup"
HTH,
- Anita
- Stephen Dance <steved_at_capbankcf.co.uk> wrote:
>
> Can someone do a sanity check please. Oracle 7.3.3
> on NT 4.0 (SP5)
>
> If a user has dropped an important table which MUST
> be restored the only
> way this can be done (without use of an up to date
> export) is to
>
> 1) Restore the WHOLE database from the last backup
> with all archived
> redo logs
>
> 2) Roll the database forward to a point in time just
> before the user
> fouled up
>
> 3) Open the database with RESETLOGS
>
>
> Am I correct in thinking there is no way to restore
> just the affected
> tablespace without touching the rest of the
> database.
>
> Thanks
> STEVE
> --
> Author: Stephen Dance
> INET: steved_at_capbankcf.co.uk
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: 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).
Do You Yahoo!?
Received on Sun May 14 2000 - 20:30:19 CDT
