Talk:Data Guard implementation for Oracle 10gR2
From Oracle FAQ
hi,
i want to know status of database it's in recovery mode so how can i find out is there any other way then below query
select name,open_mode,protection_mode,database_role,log_mode from v$database;