Re: Point-in-Time Recovery on a Tablespace

Dean,

      If you are running your database in ARCHIVELOG mode then it should be relatively easy to do point in time recovery. Assuming you have all the archived log files up to the point in time you want to do the recovery, first you restore the data files and control files backup taken before the point in time you want to recover. Then use "Recover database until time 'YYYY-MM-DD:HH24:MI:SS' " command to do the recovery up to the point you want to recover. Hope it gives you some idea.

raghuvir

Dean Mah <dmah_at_acs.ucalgary.ca> wrote in article <6icose$mnc_at_ds2.acs.ucalgary.ca>...
> Hi,
>
> I am trying to do a point-in-time recovery on a particular tablespace.
> I've looked through Rama Velpuri's backup and recovery book and he seems
> to indicate that it is problematic. His exact words are:
> "It is possible, and might be necessary in some drastic situations, to
> start up the database in an incosistent mode -- such cases should be
> handled by an Oracle Worldwide Support Analyst."
>
> Has anybody done this? Any tips would be appreciated. I have phoned
> Oracle support and am still waiting for them to get back to me.
>
> Someone indicated to me that I should be exporting data so that I can
> import particular data on demand. Is this the only way to do the
> backup? Considering that we have gigabytes of data this doesn't seem
> feasible to do on a regular basis. Does anyone have a better backup
> plan?
>
> Thanks,
> Dean
>
>
Received on Sat May 02 1998 - 00:46:35 CDT