Trigger on Logswitch

  • From: Sreejith S Nair <Sreejith.Sreekantan@xxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 10 Aug 2010 10:49:55 +0530

Hi list members,

Will it be possible to trigger some action when a log switch happens ?

I would like to start executing one of my stored procedure to audit the 
data in the last current online redo log file when a log switch happens 
using logminer.

The procedure would basically use log miner to see the redo which came in 
the last online redo and use these for audit.

Oracle Version is 10g on Linux X86 64 bit.


Thank You,

Kind Regards,
Sreejith Nair






DISCLAIMER: 

"The information in this e-mail and any attachment is intended only for 
the person to whom it is addressed and may contain confidential and/or 
privileged material. If you have received this e-mail in error, kindly 
contact the sender and destroy all copies of the original communication. 
IBS makes no warranty, express or implied, nor guarantees the accuracy, 
adequacy or completeness of the information contained in this email or any 
attachment and is not liable for any errors, defects, omissions, viruses 
or for resultant loss or damage, if any, direct or indirect."




Other related posts: