run it on the primary then On 2/9/06, Sandeep Dubey <dubey.sandeep@xxxxxxxxx> wrote: > > 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.