Re: Question regarding partial recovery

On Tue, 11 Jan 2000 22:19:33 +0100, "Sybrand Bakker" <postmaster_at_sybrandb.demon.nl> wrote:

We are under the assumption that any time we need to recover, we will lose all transactions since the last cold backup, which is done nightly. The problem with archivelog mode is that even though we can recover to any point in time, we cannot because it will put Oracle out of sync with our ERP package, which maintains its own internal database as well. Media failure will require that the ERP files be restored from the last offline, cold backup. It is a very dangerous design, but one that is beyond our control. So, my recovery scenario will be as follows:

2:00 AM Monday morning: Full backups done with Oracle and ERP down. 4:30 PM Tuesday: Some disaster requiring a full restore. We can only restore from the previous nights backup, at 2:00 AM, thus losing a day's worth of work. I know this would be insane at any other company, but ours is willing to accept this. (The data is not all that critical anyway, we are not selling anything etc...)

Any more info would be great,

Thanks,
Chuck

>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 - 16:29:49 CST