ADSM-L

[no subject]

1994-06-30 09:39:08
From: Amadeus Forums <dehtpnmk AT IBMMAIL DOT COM>
Date: Thu, 30 Jun 1994 09:39:08 EDT
From: Amadeus Forums AT MUCVM1 <dehtpnmk AT ibmmail DOT com>
Organization: AMADEUS Global travel - Erding - DE
Subject: sysback & ORACLE (or other database) files

Amadeus FORUMS for LEO URLAUB :


 Anyone using SYSBACK on volume groups that contain database files?


 I have an AIX3.2.4, which runs an ORACLE database.
 The system consists of two VGs, rootvg with 5 LVs and  sapr3vg with 11
 LVs.

 I took a sysback of the complete system and booted this tape on a second
 (identical) machine.
 Everything worked fine, also the database came up properly.
 When I made a   df   I saw that 12 out of 15 lv's still had the same
 figures (concerning free and used%), only the three (biggest) filesystems
 which make up the database data files had completely different figures:
 The Total size was still the same; the %used, however, had significantly
 gone down from 99%, 99% and 97% to 72, 38 and 63%.

 The way ORACLE database had been set up, was that the complete fs were to
 be given to ORACLE, which meant, give it 99% even though all this space
 had not been consumed yet. ORACLE would then internally allocate the
 space.

 I read in the documentation that sysback would shrink down fs to the
 minimum size required, yet in my case the fs size is still the same.
 Just the number of free space has significantly gone up.
 Remarkable is that there has not taken place a database reorganization
 (in which case I would have understanden that there is fragmentation).
<Prev in Thread] Current Thread [Next in Thread>
  • [no subject], Amadeus Forums <=