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


>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.com
Received on Wed Mar 29 1995 - 00:00:00 CEST

Original text of this message