OraFAQ Forum: Backup & Recovery » Delete a datafile from physical location

Home » RDBMS Server » Backup & Recovery » Delete a datafile from physical location

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

Delete a datafile from physical location [message #190475]

Thu, 31 August 2006 00:05

nidhi_b4u
Messages: 6
Registered: July 2006

Junior Member

Hi All,
I'm workning on critical production databases.
In order to get prepared for the worst things,before those occure, i want to recover the database while datafile is missing.
But i'm not able to drop the datafile n its showing 'sharing voilation'.
Is there any other way to delete a datafile from its physical location?
or is there any way to deliberately crash a datbase apart from touching datafile?
I'm under learning process. Kindly help me out..
Thanks a lot in advance!!!!!!

Report message to a moderator

Re: Delete a datafile from physical location [message #190527 is a reply to message #190475]

Thu, 31 August 2006 03:12

Frank Naude
Messages: 4596
Registered: April 1998

Senior Member

What OS are you using? Windows normally lock the files. To crash Oracle, just kill the oracle.exe process.

Report message to a moderator

Re: Delete a datafile from physical location [message #190533 is a reply to message #190527]

Thu, 31 August 2006 03:33

nidhi_b4u
Messages: 6
Registered: July 2006

Junior Member

Yeah i'm working on Windows only n i'm supposed to crash a demo database which is on test database server. But killing oracle.exe, I guess will stop rest all test databases on the same server.N these test databases are crrently used by our developers.
Is there any other way out?

Report message to a moderator

Re: Delete a datafile from physical location [message #190682 is a reply to message #190475]

Thu, 31 August 2006 13:58

email.sandeepnaik
Messages: 121
Registered: August 2006

Senior Member

In services, you can look for service which has your SID name and try stopping that service.

Sandeep

Report message to a moderator

Re: Delete a datafile from physical location [message #190767 is a reply to message #190533]

Fri, 01 September 2006 02:58

kimant
Messages: 201
Registered: August 2006
Location: Denmark

Senior Member

Hmmm...

You want to learn how to recover etc. a database, but it is being used by someone else, so it cannot be shutdown.

I would suggest that You create Your own little test instance. Should not be a problem, since You do not really need much ram, just a little disk.

Then You could put a datafile on a device You can disconnect, fx. an USB key, remove and see what happens....
Or You could change drive letters...
Or...

Br
Kim

Report message to a moderator

Re: Delete a datafile from physical location [message #190768 is a reply to message #190682]

Fri, 01 September 2006 02:59

kimant
Messages: 201
Registered: August 2006
Location: Denmark

Senior Member

HI

Bad idea.

As he wrote, somebody is using the database, and thus he cannot stop/kill it.

Br
Kim

Report message to a moderator

Re: Delete a datafile from physical location [message #191677 is a reply to message #190475]

Thu, 07 September 2006 13:03

goudelly
Messages: 52
Registered: August 2006
Location: India

Member

Hi,

If you database is not using for your maintanance purpose. You can take dicision to make some changes in your database. Before droping or deleting the tablespace you have to make sure to offile the tablespace and remove from the OS level datafiles. This is possible. After that you can shutdown the database and restart it..

Thanks,

Mohan Reddy G

Report message to a moderator

Previous Topic:	how can asm datafile is deleted
Next Topic:	Cleaning RMAN

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 11:40:27 CDT 2025