With the help of various posts in web we have developed this scripts and posts. Code and information are provided "AS IS" without warranty of any kind.
Saturday 22 September 2012
Script to find the Database Name and Status
Database Info
select instance_name,open_mode,flashback_on from v$database;