RE: High disk capacity dangers
- To: <jhn.it@xxxxxx>, <fred_fred_1@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 6 Jun 2006 10:45:36 -0700
1 more item to add...it's better to look at the amount of free space then the
percentage used of the filesystem.
If you extend your filesystem online (fsadm command) then you will need
approximately 1MB of free space in the filesytem to perform this expansion.
--Somckit
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Khemmanivanh, Somckit
Sent: Tuesday, June 06, 2006 10:28 AM
To: jhn.it@xxxxxx; fred_fred_1@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: High disk capacity dangers
You are using online JFS correct? Then it's not that big of a concern.
Here's something from HP's Engineer's on the subject:
· I have been assured by several engineers that OnlineJFS will NOT
corrupt data as the file system fills up
· The file system may begin to report failed writes due to lack of space
(more relevant on a typical file system where new files are constantly being
created)
· The Admin Guide suggests keeping a minimum of 10% free for an JFS file
system
· The available storage is equal to the requested/configured. Additional
storage for the metadata of OnlineJFS is added outside of the configured
storage. The amount of space allocated for metadata is a percentage of the
configured storage so varies by capacity
· File systems can be extended online or offline, depending on underlying
physical storage.
· File system extension WILL NOT cause data corruption
· File system extension could have problems IF the file system is
excessively full
· VxVM can extend the volume online
· OnlineJFS can extend the file system after one of the above volume
extensions is performed, online
· There are a number of performance and tuning commands available for
OnlineJFS. Please refer to the Administration Guide.
Thanks!
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Jesper Haure Norrevang
Sent: Tuesday, June 06, 2006 6:25 AM
To: fred_fred_1@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: SV: High disk capacity dangers
Fred,
In my shop we have 40 databases on HP-UX. I have dedicated file systems for
the Oracle databases. I see no problem in filling them 99 %, as long as no
datafiles are running in AUTOEXTEND mode.
I usually reserve a little space for the control files to grow. Yes I want
them to grow, because I have set CONTROL_FILE_RECORD_KEEP_TIME = 30 in order
to keep information about RMAN-backup in the control file for one month, if
I should be unlucky and loose my recovery catalog.
Many years ago I had a case on Digital Unix/SAP R3 with tar making sparse
files when restoring datafiles from tape. It was dangerous, when the
datafiles started to grow physically as new blocks were formatted, but it is
quite another story.
Regards
Jesper Norrevang
-----Oprindelig meddelelse-----
Fra: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] På
vegne af Fred Smith
Sendt: 6. juni 2006 14:05
Til: oracle-l@xxxxxxxxxxxxx
Emne: High disk capacity dangers
Just wanted to run this by everyone here, I have a 9.2.0.6 database on
HP-UX. Some of my read only tablespaces are on a physical disk that I keep
at about 99% capacity (it's not going to grow obviously, it's read-only).
The new Unix SA is saying that it's unacceptable and dangerous to keep a
disk at 98,99, or 100% capacity. I always thought it could be even at 100%
capacity without any problems.
Is there any reason that anyone knows of as to why a disk should not be at
99% or 100% capacity?
Thank you!
_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Other related posts: