Home » RDBMS Server » Server Utilities » The best way to restore or ecover a datafile
The best way to restore or ecover a datafile [message #72276] Wed, 30 April 2003 09:58 Go to next message
pb
Messages: 18
Registered: December 2000
Junior Member
Hi,
My db size is 200 Go . No caold backup is available.
I 've a full export of my database. How to recover a lost of datafile ?

Report message to a moderator

Re: The best way to restore or ecover a datafile [message #72277 is a reply to message #72276] Wed, 30 April 2003 10:05 Go to previous message
Anand
Messages: 161
Registered: August 1999
Senior Member
You can't recover a lost datafile using an export backup. Export backup is a logical backup which backs-up all the objects inside the database.

A datafile is a physical entity that can be only recovered if you have a valid cold backup or hot backup with archive log files.

The most probable solution for your problem is to import using the export file you have and start off from that stage. Nothing more can be done. All changes to the database done after the export was taken would be lost.

Report message to a moderator

Previous Topic: Reg. Importing DMP files
Next Topic: Loading two tables - master/detail problem- HELP!!
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 24 07:41:27 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.