Re: Physical Standby Database and v$Recover_file Query

From: vsevolod afanassiev <>
Date: Fri, 5 Feb 2010 22:38:47 -0800 (PST)
Message-ID: <>

If standby database opened in read inly mode then select from v $recoverf_file will return no rows as there is nothing to recover - all files are consistent.

What exactly is 'standby mode' - managed recovery mode?

Check V$DATABASE, you should gave

DATABASE_ROLE = 'PHYSICAL STANDBY' Are you able to test activation? Received on Sat Feb 06 2010 - 00:38:47 CST

Original text of this message