Sparse files & Oracle

From: Alex Natautama <alex_at_arguus.co.nz>
Date: 1996/04/02
Message-ID: <31606DB3.567E_at_arguus.co.nz>#1/1


Hi Oracle Gurus,

Has anyone experienced / seen situations where recovery of backed up data produced "sparse" database files which then caused serious problems?

(A sparse file is a file where any "empty" O/S blocks do not actually take up a full block but have a marker to show the block is empty)

I would like to know if this is a potential problem with backup and recovery on these unix variants:
AIX 3.2.5, AIX 4.1
HP-UX 9, HP-UX 10
Solaris 2.4
DG/UX

Your advise would be very much appreciated Thanks

-- 

______________________________________________________________
Alex Natautama Oooo. Systems Engineer - Arguus Operations .oooO ( ) CONTINUUM (NZ) LTD ( ) ) / 105 Symonds Street Phone: +64 +9 3792350 \ ( (_/ Auckland 1035 Fax: +64 +9 3572200 \_) New Zealand Internet: alex_at_arguus.co.nz P.O. Box 8690 alex_at_continuum.co.nz
______________________________________________________________
Received on Tue Apr 02 1996 - 00:00:00 CEST

Original text of this message