Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Recovery

Re: Recovery

From: Torsten Borchert <T.Borchert_at_DeutschePost.de>
Date: Tue, 04 Aug 1998 12:54:15 +0200
Message-ID: <35C6E857.15C6275B@DeutschePost.de>


On Oracle 7 you have to build a duplicate database on another machine, recover until time you want, open database with reset logs and then export the tables you want.
For the duplicate - dummy - database you need only datafiles of system tablespace, rollback tablespaces and datafiles of the tablespace you want to recover. All other datafiles set offline (immediate). During recovering Oracle will ignore all offline datafiles.

hagemang_at_my-dejanews.com wrote:
>
> I want to recover a tablespace from a tape backup, however, I do not want
> Oracle to use the logfiles to roll foward any changes. I am happy with the
> state of the tablespace as per the tape backup. How do I do this?
>
> Gary Hagemann
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Tue Aug 04 1998 - 05:54:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US