With this command you transfer the database to the ONLINE operational state.
You can determine which database kernel should be started and /or the content of the database when reaching the ONLINE operational state. This content can be specified using a time stamp or the log sequence number.
Also use this DBM command when the database was not stopped correctly because the computer was shut down by a power outage. If the volumes of the database are undamaged, the system uses the information still available within the system to repeat completed transactions and roll back incomplete transactions.
If you enter a point in time in the DBM command, only the transactions completed up to that time are repeated.
You can also configure a database so that it starts automatically when the database computer is started.
In a hot standby system, use this command to transfer the standby database from the STANDBY to the ONLINE operational state. This way the standby database takes over operation and becomes the new master database in the hot standby system.
You have the server permission DBStart.
db_online [<kernel_option>] [<until_option>]
<kernel_option> :: = -fast | -slow | -test
<until_option> :: = -until (<time_spec> | <log_sequence_spec>)
<time_spec> :: = <date> <time>
<date> ::= <yyyymmdd>
<time> ::= <hhmmss>
<log_sequence_spec> :: = logsequencenumber <nnnn>
Options |
Description |
---|---|
-f | -fast |
The kernel variant fast is started. This option takes effect only if the database is in the OFFLINE operational state. |
-s | -slow |
The kernel variant slow is started. This option takes effect only if the database is in the OFFLINE operational state. |
-t | -test |
The kernel variant test is started. This option takes effect only if the database is in the OFFLINE operational state. |
-u | -until |
Time stamp ( <yyyymmdd>: year, month, day, <hhmmss>: hour, minutes, seconds) or log sequence number ( logsequencenumber <nnnn>) which defines the content of the database when reaching the ONLINE operational state up to which the log entries still available in the database are to be imported. This option takes effect only if the database is in the ADMIN or OFFLINE operational state. |
OK
In the event of errors, see Reply Format.
Commands for Managing Hot Standby Systems
Database Administration, Activating Automatic Database Start, Hot Standby System