OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » data file lost

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

data file lost [message #191974]

Sat, 09 September 2006 08:34

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.

Report message to a moderator

Re: data file lost [message #191976 is a reply to message #191974]

Sat, 09 September 2006 08:43

JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland

Senior Member

Read the backup and recovery documentation.

Report message to a moderator

Re: data file lost [message #191978 is a reply to message #191974]

Sat, 09 September 2006 08:45

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

http://www.orafaq.com/forum/m/189931/42800/#msg_189931

Report message to a moderator

Re: data file lost [message #191979 is a reply to message #191974]

Sat, 09 September 2006 08:46

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

Report message to a moderator

Previous Topic:	partition key modification
Next Topic:	can't install 8i in Windows Server2003

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 08:30:23 CDT 2024