Re: Question regarding partial recovery

Don't want you to look like silly, but there are some misconceptions in your post that need to be straightened out before it is getting dangerous. 1 Offline backup does not preclude archivelog. You should use archivelog all the time
2 As you are not running in archive log you didn't do complete recovery (as that would involve applying archive log files), you only restored from a backup. This will only work fine if nothing happened since the last complete backup
3 You are making physical backups. For Oracle the database is a conceptual whole. Hence, from a backup you can't recover individual tables. What you want is a logical backup. Logical backups are usually made through export. The restore/import from an export will definitely take less time compared to the procedure you describe.

Hth,

--
Sybrand Bakker, Oracle DBA
Chuck <chuck_at_phi.org> wrote in message
news:387b8a32.246141546_at_client.nw.news.psi.net...
>
> I hope this question is not as stupid as it may seem to me.
>
> I do nightly cold backups for an 805 database that is not running is
> archive log mode. (I have too since the ERP suite it supports must be
> backed up offline)
>
> I have two main tablespaces for data and indexes. (in additional to
> rollback, temp, system). What is the procedure to recover a single
> table, for example, from a cold offline backup?) I have done complete
> recoveries where I simply restore the control files, redo logs, and
> datafiles from tape, but what if I need to recover data from a single
> table.
>
> I thought about a separate instance that I could use to restore
> everything to different locations, mount and open the restored files
> to this second instance, export the table and then import into the
> production database. Is this the easiest method? This procedure would
> take longer than I desire it to. (I an pull from tape somewhat
> quickly, I am using a DLT loader)
>
>
> Thanks greatly,
> Chuck
>
Received on Tue Jan 11 2000 - 15:19:33 CST