OraFAQ Forum: Backup & Recovery » Deleted datafile without any backup

Home » RDBMS Server » Backup & Recovery » Deleted datafile without any backup (Oracle 10.2.0.1.0 - Linux)

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

Deleted datafile without any backup [message #355334]

Thu, 23 October 2008 14:36

danyromimd
Messages: 73
Registered: August 2008

Member

Hi!
I've deleted a datafile in a testing server, and thats why I have no backup. On top of it, I've resently made a RESETLOG and whatever I try to do to recover the datafile it doesn't let me do it due to the resetlog I've done!

I need you help!!

Thanks in advance.

Report message to a moderator

Re: Deleted datafile without any backup [message #355343 is a reply to message #355334]

Thu, 23 October 2008 15:32

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Stop playing with Oracle and start working like a professional.
Read Database Backup and Recovery Basics

Regards
Michel

Report message to a moderator

Re: Deleted datafile without any backup [message #355485 is a reply to message #355343]

Fri, 24 October 2008 07:27

danyromimd
Messages: 73
Registered: August 2008

Member

I'm "playing" with Oracle just because I'm not a DBA and because I'm learning to use it by myself. The only way to learn is to put your hands on it, not just reading.
Thanks for you help.

Report message to a moderator

Re: Deleted datafile without any backup [message #355499 is a reply to message #355485]

Fri, 24 October 2008 08:43

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

But the FIRST step is reading to know the basics.

Regards
Michel

Report message to a moderator

Re: Deleted datafile without any backup [message #355501 is a reply to message #355334]

Fri, 24 October 2008 08:50

danyromimd
Messages: 73
Registered: August 2008

Member

I belive you are right...
And I also belive you don't know how to solve my problem, or maybe it has no solution... but you told none of them.
Thanks anyway.

Report message to a moderator

Re: Deleted datafile without any backup [message #355519 is a reply to message #355501]

Fri, 24 October 2008 10:59

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You are free to think what you want.

Regards
Michel

Report message to a moderator

Previous Topic:	Clearing RMAN backup
Next Topic:	list the backup information on rman

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 12:32:16 CST 2024