Hi,

We have a very large Oracle database running on 32 bit SLES9 SP3
with Oracle version 10.1.0.4. We are getting new hardware and I'd
like to just clone the current database onto the new hardware. The
database is currently on two RAID arrays partitioned such that
each filesystem is less than 2TB and the filesystems on these
partitions are EXT3. Some of the tablespaces in this database
are BIGFILE tablespaces and one of those tablespaces is approaching
2TB in size. The two new RAID arrays will be 3TB in size. We are
thinking of using XFS on the filesystems on the new RAID arrays.
From reading the XFS project page it *appears* that we should be
able to create a 3 TB filesystem and have files larger than 2TB.
I'd like to avoid installing 64 bit SLES9 and Oracle and then
converting the database from 32 bit to 64 bit.

My questions are:

Can we create file systems of 3TB and individual files larger than
2TB on a 32 bit version of SLES9 SP3 using XFS? Can Oracle work
with tablespace datafiles larger than 2TB in this environment? Has
anyone tried something like this?


--

----- Stephan