Determine run mode of database instance

SQL> select status from v$instance;


STATUS
------------------------------------
OPEN

May be OPEN, UPGRADE, OPEN MIGRATE, etc.