Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Question on Backups using OEM
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
![]() |
![]() |