Help - Search - Members - Calendar
Full Version: Datafile drive defragmentation
Oracle DBA Forums > Oracle > Oracle Forum
Oraclelearner
Hello,

I have a question. Our drives where all of our database files needs to be defragmented. Does Oracle needs to be shutdown or can the database remain open while disk defrag is occuring?

Thanks much,
Oraclelearner

I found the answer to my question by an article written by SteveC @ http://www.dbasupport.com/oracle/ora9i/onWindows02.shtml

Regards,
Oraclelearner
burleson
>> Our drives where all of our database files needs to be defragmented.

What, are you on a PC or something?

If you have created your I/O subsystem properly:

1 - There should be nothing other than dbf files on the Oracle partitions
2 - Oracle data files never fragment (except when extending, and you don't use defrag for that)

>> I found the answer to my question by an article written by SteveC

I'd watch out for him, but thanks for sharing . . . .
SteveC
Who is that masked stranger?

Another option is to copy the files elsewhere, reformat the disk, put files back.
Oraclelearner
QUOTE (SteveC @ Jul 30 2008, 10:13 AM) *
Who is that masked stranger?

Another option is to copy the files elsewhere, reformat the disk, put files back.


Thanks Mr. Burleson and SteveC for your timely responses!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.