Re: Datafile lost

From: <pacificdbms_at_my-dejanews.com>
Date: Mon, 21 Sep 1998 23:23:59 GMT
Message-ID: <6u6n6e$3d7$1@nnrp1.dejanews.com>

G'day,

2 Possibilities come to mind.

Create a new database with the same tablespaces. Create your schema owners. Then run import to recreate the tables.

2)Contact Oracle, they have a product out of Oracle Netherlands called DUL which can be used to extract the data dictionary and data from a corrupted database. They will want to sell you a consultant to run it but as a last resort it works.

Regards,

Kevin.

In article <6u5kl8$sgr$1_at_nnrp1.dejanews.com>, cdoganay_at_my-dejanews.com wrote:
> Hi, I was testing some disaster recovery scenarios. The case is that
> 1) I lost 1 datafile belonging to 1 tablespace
> 2) I have no backup after RESETLOGS issues, except export of required tables
> 3) I can not open database
> 4) How can I open database and import the required tables?
>
> Cemal
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Mon Sep 21 1998 - 18:23:59 CDT