RE: RMAN Sizing - Anomaly?
Date: Mon, 16 Feb 2009 15:58:15 -0600
Message-ID: <565F609E6D736D439837F1A1A797F34101C6F3EC_at_ADMINMAIL1.ui.uillinois.edu>
Hello,
Is it possible that you have your BACKUP OPTIMIZATION on and it's skipping the full database backup because of this? Just a thought.
- Chris
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bellows, Bambi
(Comsys)
Sent: Monday, February 16, 2009 3:45 PM
To: Weatherman, John
Cc: oracle-l_at_freelists.org
Subject: RE: RMAN Sizing - Anomaly?
John --
This was a very good suggestion. Looks like the database plus archivelog is just doing the archivelog, which is weird but explains the numbers. When I break out database and archivelog, the numbers are consistent with database only. Has anyone else seen this type of behaviour?
Thanks!
Bambi.
-----Original Message-----
From: Weatherman, John [mailto:John.Weatherman_at_asurion.com]
Sent: Monday, February 16, 2009 1:49 PM
To: Bellows, Bambi (Comsys); oracle-l_at_freelists.org
Subject: RE: RMAN Sizing - Anomaly?
Bambi,
Have you done a "RMAN> list backupset;" to verify what is in each set? Are all the files really in the "...plus archivelog" backup? How does a "RMAN> backup as compressed backupset archivelog all;" look?
What version is this coming off of?
Thanks,
John
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bellows, Bambi
(Comsys)
Sent: Monday, February 16, 2009 1:32 PM
To: oracle-l_at_freelists.org
Subject: RMAN Sizing - Anomaly?
Friends --
I'm at a loss to explain why two nearly identical scripts -- one to backup the database only and one to backup the database plus archivelog should have this particular sizing anomaly. First, here are the scripts...
1)
$ORACLE_HOME/bin/rman <<EOF
connect target;
connect catalog $RMANID/$RMAN_at_$RMAN_CATDB;
backup as compressed backupset database; EOF And
2)
$ORACLE_HOME/bin/rman <<EOF
connect target;
connect catalog $RMANID/$RMAN_at_$RMAN_CATDB;
backup as compressed backupset database plus archivelog;
EOF
Now the results...
Database only: 48 minutes - 39.1GB
Database plus archivelog: 63 minutes - 15.2GB
Why should the database plus archivelog be 40% smaller than the database without? I've run this test a bunch of different times, sometimes setting the incremental level to 0, sometimes not; sometimes running the db+arch first, sometimes second. But consistently, the db+arch is appreciably smaller than the db without. How come?
Thanks!
Bambi.
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Feb 16 2009 - 15:58:15 CST