Talk:Data Guard implementation for Oracle 10gR2

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;