how to configure Auto delete of logs in Logical standby database

  • From: nilesh kumar <nileshkum@xxxxxxxxx>
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 22 Jul 2015 20:51:12 +0530

Hello Gurus,

Hope everyone is doing good!!

My current db version and OS details are as below.

database version : 10.2.0.4
OS : Linux.
There is no flash recovery configured on the production database and I also
checked LOG_AUTO_DELETE is set to TRUE in logical standby database.

I have built a logical standby database on a reporting server, How can we
configure to auto delete the archive logs after they get applied on the
logical standby database ?

Logical standby is manily used for the reporting purpose.
standby archive destination : /data05/xxxx/archive_standby/ and
log_archive_Dest_1= /data05/xxxxx/archive ( both are pointing to same mount
point /data05).
/data05 location gets filled up and I want to configure it in a way where
the logs gets cleared once they are applied.

Please advise.


--
Thanks & Regards
Nilesh


"As our circle of knowledge expands, so does the circumference of darkness
surrounding it."--Einstein
"All men die, few men ever truly live" -- Braveheart
"You can get help from teachers, but you are going to have to learn a lot
by yourself, sitting alone in a room." --Dr. Seuss
"Know me for what I do and for not what I am. Judge me for what I can do
and not for what I have done."-Unknown
"Don't walk in front of me, I may not follow. Don't walk behind me, I may
not lead. Just walk beside me and be my friend."- Albert Camus
"Never argue with an idiot. They drag you down to their level and then beat
you with experience." - Unknown

Other related posts: