Re: Question regarding partial recovery

In article <387b8a32.246141546_at_client.nw.news.psi.net>,   chuck_at_phi.org (Chuck) wrote:
>
> 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
>

Chuck, to recover a single table from a hot or cold backup you use the tablespace point in time recovery process described in the Backup and Recovery manual. It would be much more straight forward to use export, exp, to backup as many as your tables as space allows. I realize that with an MRP some of the tables may be large, but exp can write to tape on most UNIX systems so that might be an option.

Also you can apply archived redo logs to a cold backup to perform forward recovery so I suggest you consider switching to archivelog mode so that you have this option should a recovery from media failure be required at some point.

--
Mark D. Powell -- The only advice that counts is the advice that  you follow so follow your own advice --

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Jan 11 2000 - 15:56:11 CST