Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Question on Backups using OEM

Question on Backups using OEM

From: Rajesh Kapur <rkapur_at_mpr.org>
Date: Thu, 3 Nov 2005 17:22:19 -0600
Message-ID: <11ml6tc9av5s240@corp.supernews.com>


Background:
I am running Oracle 10g V2 on RHEL3. I am in the process of setting up database backups for my production environment. I want to take complete database backups every morning at 2:00 am. I also want to archive my logs in flash recovery area. I want to keep by full backups and the archive logs for a period of 4 days. My /opt/oracle/flash_recovery_area is a file system of 20GB. The archive logs are going to
flash_recovery_area/{SID}/archivelog/YYYY_MM_DD directories. My system generates about 300 MB of archive logs every day. The complete backup set is 2GB in size.

On OEM, Disk Backup Settings, I have set up disk backup location to point to the flash_recovery_area directory. I have set up Tape Backup Type to 'Backup Set'. The backup policy has been setup to backup the control file and the SPFILE and retain backups that are necessary for a recovery to any time within 4 days.

Archive logs are created properly during the day. A 2 GB backup set is generated every day at 2:00 am.

Question:
The 'Flash Recovery Area Usage' pie chart under 'Recovery Settings' only shows the 300MB taken up by the archive logs. It does not reflect the 2GB Backup Sets every day. The file system filled up to 100% and Oracle did not reuse the archive logs and backups older than 4 days. The system halted because of pending archives. What am I doing wrong?

Thanks!
- Rajesh Kapur Received on Thu Nov 03 2005 - 17:22:19 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US