This article describes all the database states (db_state) used by Dbvisit Standby.
Problem Details
Problem Statement
N/A
Applicable Error Code
N/A
Affected Versions
v8
Affected Platforms
Platform-independent
Description
Below is the list of db_state options and what each state corresponds to. Please note this is for informational purpose only and might change over time.
# Database states can be as follows:
# db_state=50 - Normal database open in read write mode
# db_state=51 - Normal database open in restricted mode
# db_state=52 - Normal database mounted
# db_state=53 - Normal database BUT NOT open in read write mode
# db_state=60 - Standby Database in recovery mode
# db_state=63 - Standby Database in READ ONLY mode
# db_state=65 - Standby Database but unknown mode
# db_state=70 - Newly created database in mounted mode
# db_state=73 - Newly created database unknown mode
# db_state=84 - Sqlplus usage error. Not connecting correctly
# db_state=85 - Unknown state for non-standby database
# db_state=86 - Indicates the database is being recovered using a backup or created control file.
# db_state=95 - Database is down
# db_state=94 - Something wrong with database. Needs investigation - check Oracle alert log.
# db_state=93 - Database not mounted
# db_state=99 - Database instance started nomount without spfile
Primary database in failover state needs to be failback.
Primary database in failover state needs to be failback.
Need urgent solution.