Re: spearce file on AIX 4.1.4 and Oracle7

From: Chuah Teik Chye <CHUAHTC_at_sam.po.my>
Date: 1996/11/24
Message-ID: <848832407.6924snx@sam.po.my>#1/1

In article <01bbd481$4dd205e0$29d3dc91_at_pecosal> pecosal_at_pi.net writes:
>
>I'm using Oracle7 (7.2.2.4) on a R30 (AIX v4.1.4). As backup we use 8mm
>tape drive
>and some script that uses mksysb and savevg.. My problem is that savevg
>uses
>backup/restore commands. When after restore from some Oracle tablespaces
>the
>files are smaller on disk then before.

We were told by Oracle support to use the 'tar' command. The 'backup/restore' command will cause file space to be logically allocated and your Oracle database may fail when it can't physically allocate the hdd space that it wants.

Rgds,
chuahtc Received on Sun Nov 24 1996 - 00:00:00 CST