Thanks for the reply. The standby database will be in mounted state and can't use scn_to_timestamp(). I was wondering if there is a way to know the latest timestamp of transaction/SCN based on last archive log applied to the database in mounted mode. Regards Sandeep -- //www.freelists.org/webpage/oracle-l