I'm running Oracle EE 11.2 on Sun Solaris.
I'm not understanding a peculiar phenomenon and was hoping someone might be able to help.
I have a database that is approx. 563G, which, for reference, contains approx. 400G of CLOBs.
Our redo logs are 1G each and we accumulate approx. 18 archive logs each day.
I run a nightly Lvl-0 (full backup) and archive logs beginning at 1:00am.
From the log file, I see that it completes backing up the database by approx. 2:30.
But then it backs up the archive logs which take from 2:30 until approx. 5:00am.
I don't understand why it would take only 1-1/2 hours to backup 563 of actual data in datafiles, and it takes 2-1/2 hours to back up approx. 18G of archivelogs.
Any ideas?
For reference:
Total database footprint...
=============================
All DATA files (GB)
-------------------
619.9
Total Space used (GB)
---------------------
563
TEMP Space (GB)
---------------
42
Total UNDO Space
----------------
22
Count of DATA FILES
-------------------
28
Count of REDO LOGS
------------------
13
Database and archive logs reside on a SAN and backups are being written to an NFS mount that is also on the SAN.