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).
|