Re: single table restore w/out exports
From: Brian Graham <GrahamB_at_psac.com>
Date: 1995/03/29
Message-ID: <3lbnjf$rdj_at_nic.ott.hookup.net>#1/1
>: We are running cold backups as our backup. Shut down database, backup
>: system files, restart db. Our users want to be able to restore single
>: tables as they did before when we we using exports. Is there a way to
>: use the datafiles and a temp db to trick oracle into loading the table,
>: so we could export it from a copy of the datafile?
Date: 1995/03/29
Message-ID: <3lbnjf$rdj_at_nic.ott.hookup.net>#1/1
>Glenn Travis (gtravis_at_richmond.infi.net) wrote:
>: We are running cold backups as our backup. Shut down database, backup
>: system files, restart db. Our users want to be able to restore single
>: tables as they did before when we we using exports. Is there a way to
>: use the datafiles and a temp db to trick oracle into loading the table,
>: so we could export it from a copy of the datafile?
If you have the time available to shut down the database and before
an OS backup, why not perform exports as well. Exports can be taken with
the rdbms up, and typically they are faster and can provide more flexibility,
allowing import of a single table, and importing a single system,
for example.
At our shop we have three production applications. If one get corrupted
we just import the one user (table owner) and all the grants (to other
users) etc. The tape backup (performed only once a week) is required only
for catastrophic failures, and importing can 'roll forward' from an 'old'
tape.
Anyway, personal recommendation would be to add an extra level of backup
protection to your recovery plans.
Regards, Brian -- Brian Graham . Programmer / DBA ._______|_______. Tel: 613-560-5470 Public Service Alliance \(*)/ Fax: 613-563-3492 of Canada o/ \o Email: grahamb_at_psac.comReceived on Wed Mar 29 1995 - 00:00:00 CEST