Point-in-Time Recovery on a Tablespace

From: Dean Mah <dmah_at_acs.ucalgary.ca>
Date: Fri, 01 May 1998 09:13:57 -0600
Message-ID: <6icose$mnc@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 Fri May 01 1998 - 10:13:57 CDT