Re: Point-in-Time Recovery on a Tablespace

From: Dean Mah <dmah_at_acs.ucalgary.ca>
Date: Mon, 04 May 1998 08:44:32 -0600
Message-ID: <6ikk99$qc8@ds2.acs.ucalgary.ca>

Problem is/was that I wanted to only recover one tablespace to a point-in-time and not the whole database. Not to worry though, Oracle support phoned me back with the procedure. This consisted of cloning the tablespace in a new database (with the old datafiles) and then exporting the data from the new database and importing back into the production database.

Thanks though,
Dean

rok wrote:

> 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
Received on Mon May 04 1998 - 09:44:32 CDT