Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Recovery
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
![]() |
![]() |