Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> Deleted datafile
Nanina
post Oct 24 2008, 11:24 AM
Post #1


Newbie
*

Group: Members
Posts: 8
Joined: 28-August 08
From: Argentina
Member No.: 33,718



Hi!
I'm working on Linux.
DB: Oracle 10g.

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.
Go to the top of the page
 
+Quote Post
SteveC
post Oct 24 2008, 11:37 AM
Post #2


Advanced Member
***

Group: Members
Posts: 2,835
Joined: 11-March 08
Member No.: 18,933



Possibly startup mount, offline the tablespace, starutp, then do whatever you want with the database. Say goodbye to the tablespace.

Without more information about your environment, who knows?

http://www.databasejournal.com/features/or...cle.php/3757371
Go to the top of the page
 
+Quote Post
aussie_dba
post Oct 26 2008, 07:44 AM
Post #3


Advanced Member
***

Group: Members
Posts: 618
Joined: 28-August 04
Member No.: 495



"I've deleted a datafile in a testing server, and thats why I have no backup."

No, that's not why.

You don't have a backup because you neglected to take one.

If the datafile maps to a tablespace wiyth referiential integrity constraints into another tablespace you could have a big mess.

Like Steve says, kiss the tablespace goodbye and drop it.

http://www.dba-oracle.com/concepts/t_admin...tablespaces.htm
Go to the top of the page
 
+Quote Post
Nanina
post Oct 27 2008, 09:07 AM
Post #4


Newbie
*

Group: Members
Posts: 8
Joined: 28-August 08
From: Argentina
Member No.: 33,718




I guess this time I've learned the lesson... "Always make a complete backup after making a structural change to a database"

Thanks to all of you...
Go to the top of the page
 
+Quote Post
burleson
post Oct 27 2008, 09:14 AM
Post #5


Advanced Member
***

Group: Members
Posts: 11,617
Joined: 26-January 04
Member No.: 13



>> "Always make a complete backup after making a structural change to a database"

You can always take a "hot" backup:

http://www.dba-oracle.com/concepts/hot_backup_script.htm



--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
SteveC
post Oct 27 2008, 11:14 AM
Post #6


Advanced Member
***

Group: Members
Posts: 2,835
Joined: 11-March 08
Member No.: 18,933



Did the missing datafile have any data in it? Probably did, but in the off chance it did not, it could be dropped. How many other datafiles are associated with the tablespace/how big are they?

If there is one and not too big, you could used bbed to scrounge data out of it. Or, for a reasonable price, it could be done for you.
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 24th October 2014 - 01:59 AM