Home » RDBMS Server » Server Administration » data file lost
data file lost [message #191974] Sat, 09 September 2006 08:34 Go to next message
barjunreddy
Messages: 8
Registered: August 2006
Location: Hyderabad
Junior Member
Hi Gurus,
I am new user of oracle and i dono how to recover the database when u lost a datafile accidentally. Could any one help me out what are the necessary steps that i need to take so that the database is up and running.

Thanks in advance!!

Regards,
Nagarjun.
Re: data file lost [message #191976 is a reply to message #191974] Sat, 09 September 2006 08:43 Go to previous messageGo to next message
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
Senior Member
Read the backup and recovery documentation.
Re: data file lost [message #191978 is a reply to message #191974] Sat, 09 September 2006 08:45 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://www.orafaq.com/forum/m/189931/42800/#msg_189931
Re: data file lost [message #191979 is a reply to message #191974] Sat, 09 September 2006 08:46 Go to previous message
email.sandeepnaik
Messages: 121
Registered: August 2006
Senior Member
backups are key for any recovery efforts.

http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14220.pdf

Read backup and recovery from this guide.

Hope this helps
Sandeep
Previous Topic: partition key modification
Next Topic: can't install 8i in Windows Server2003
Goto Forum:
  


Current Time: Sat Dec 03 10:09:08 CST 2016

Total time taken to generate the page: 0.05318 seconds