Operating System - HP-UX
1833882 Members
3458 Online
110063 Solutions
New Discussion

How safe to Kill fsadm -d -v -e /oracle----- URGENT

 
$t!$-
Advisor

How safe to Kill fsadm -d -v -e /oracle----- URGENT

I Have started defragmentation of a large file system wthout time frame. Can anyone suggest me , is there any possibility of data loss to kill fsadm -d -v -e /oracle.
5 REPLIES 5
spex
Honored Contributor

Re: How safe to Kill fsadm -d -v -e /oracle----- URGENT

Hello,

There is always the possibility of data loss with any disk-related administrative task. This is why good backups are essential. This is also why it's important to schedule such operations during the off-hours.

Chances are, there will be no data loss, but there is no guarantee. I recommend letting the defrag operation finish.

In the future, set a time limit with the '-t ' switch to 'fsadm', or a passes limit with the '-p ' switch. 'man 1m fsadm_vxfs' for more information.

PCS
A. Clay Stephenson
Acclaimed Contributor

Re: How safe to Kill fsadm -d -v -e /oracle----- URGENT

Unless you have a compelling reason to stop it, I would let it run. When you phrase the question "is there any possibility of data loss", there can be but one answer: YES. If you change "any possibility" to "any probability" then the answer becomes: Yes, but it is very small. I certainly would not throw a kill -9 at it but you could try a kill -15.

In general, I have found it very difficult to measure any gains (much less significant gains) from the defragging operation and especially on Oracle filesystems where the files tend to be pre-allocated.
If it ain't broke, I can fix that.
skt_skt
Honored Contributor

Re: How safe to Kill fsadm -d -v -e /oracle----- URGENT

I would never recommend a defrag on a PROD file system.if at all you wanted try "kill -15" you take one more backup before that..
Yogeeraj_1
Honored Contributor

Re: How safe to Kill fsadm -d -v -e /oracle----- URGENT

hi,

Unless this is impacting on your performance, it would be wise to wait for the process to complete.

Otherwise, you can kill the process. At most, the Oracle instance will crash. But then on the restart of the database, it will recover automatically.


good luck!

kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
$t!$-
Advisor

Re: How safe to Kill fsadm -d -v -e /oracle----- URGENT

Thanks for all useful suggestion.