archive log maintenance on physical standby

From: EdStevens <quetico_man_at_yahoo.com>
Date: 2 Aug 2006 15:06:55 -0700
Message-ID: <1154556415.811299.257910@i42g2000cwa.googlegroups.com>

Platform: Oracle 10.2.0.1.0 on Solaris 5.10

DataGuard with physical standby. Daily backups of the primary are keeping archivelogs cleaned out and usage of recovery_file_dest constant.

On the physical standby db, archives are being received and applied, but no housekeeping seems to be done. Usage of v$recovery_file_dest keeps climbing.

I queried v$archived_log on the standby to determine oldest known (to the db) archivelog, then manually deleted all the older stuff from the recovery file dest. (nearly a month's worth), but the value of v$recovery_file_dest.space_used continues to climb.

What is best practice for keeping the recovery file dest from filling up and stalling the archiver process on the physical standby? Received on Wed Aug 02 2006 - 17:06:55 CDT