Find out the state of database from sql plus

[Knarayan]

select database_status from v$instance
select * from v$database

Hope this helps