Physical Standby Database and v$Recover_file Query
Date: Fri, 5 Feb 2010 09:11:24 -0800 (PST)
Message-ID: <f8397e2c-7b70-4a03-9b38-b245bdb71833_at_n7g2000yqb.googlegroups.com>
Hi
I have created a traditional physical standby instance from a hot backup using a standby controlfile etc. from the primary db (10.2.0.4). Not using dataguard but there were no issues during creation.
In standby mode if I querry v$recover file I receive the following.
FILE# ONLINE ONLINE_STATUS ERROR CHANGE# TIME 1 ONLINE ONLINE 8185278196312 05/02/2010 14:11:55 2 ONLINE ONLINE 8185278196312 05/02/2010 14:11:55 3 ONLINE ONLINE 8185278196312 05/02/2010 14:11:55 4 ONLINE ONLINE 8185278196312 05/02/2010 14:11:55 5 ONLINE ONLINE 8185278196312 05/02/2010 14:11:55 6 ONLINE ONLINE 8185278196312 05/02/2010 14:11:55 7 ONLINE ONLINE 8185278196312 05/02/2010 14:11:55 8 ONLINE ONLINE 8185278196312 05/02/2010 14:11:55 9 ONLINE ONLINE 8185278196312 05/02/2010 14:11:55
If I bring up the instance in read-only mode executing the same query returns nothing and there are no datafiles etc offline.
Is it normal to receive this output from v$recover_file when an instance is running in standby mode. I need to have confidence that it can be activated in the event of a primary instance failure.
I'm wondering if its because I used a standby controlfile and applied about 40-50 archive logs that were generated after it was created from primary.
There is no archive gap either.
Thanks in advance
John Received on Fri Feb 05 2010 - 11:11:24 CST