online database

Marks a database available for public use after a normal load sequence; if needed, upgrades a loaded database to the current version of SAP ASE; brings a database online after loading a transaction log dumped with the for standby_access option. You can also use online database to bring an archive database online.

Syntax

online database database_name [for standby_access]

Parameters

database_name – specifies the name of the database to be brought online.
for standby_access – brings the database online on the assumption that the database contains no open transactions.

Examples

Example 1 – Makes the pubs2 database available for public use after a load sequence completes:
```
online database pubs2
```
Example 2 – Brings the database inventory_db online. Used after loading inventory_db with a transaction-log dump obtained through dump tran...with standby_access:
```
online database inventory_db for standby_access
```

Usage

online database brings a database online for general use after a normal database or transaction log load sequence.
When load database is issued, the database’s status is set to “offline.” The offline status is set in the sysdatabases system table and remains set until online database completes.
Do not issue online database until all transaction logs are loaded. The command sequence is:
- load database
- load transaction (there may be more than one load transaction)
- online database
If you execute online database against a currently online database, no processing occurs and no error messages are generated.
You can only use online database...for standby_access with a transaction log that was dumped using dump transaction...with standby_access. If you use online database...for standby_access after loading a transaction log that was dumped without using dump transaction...with standby access, online database generates an error message and fails.
You can use sp_helpdb to find out whether a database is currently online, online for standby access, or offline.

When upgrading databases:

online database initiates, if needed, the upgrade of a loaded database and transaction log dumps to make the database compatible with the current version of SAP ASE. After the upgrade completes, the database is made available for public use. If errors occur during processing, the database remains offline.
online database is required only after a database or transaction log load sequence. It is not required for new installations or upgrades. When you upgrade SAP ASE to a new version, all databases associated with that server are automatically upgraded.
online database upgrades only version 12.5.4 or later user databases.
After you upgrade a database with online database, dump the newly upgraded database to create a dump that is consistent with the current version of SAP ASE. You must dump the upgraded database before you can issue a dump transaction command.

For archive databases:

The online database database_name command performs undo recovery during which modified and allocated pages may be remapped to the modified pages section.
You do not need to bring a database online if it has been loaded with norecovery, since the load automatically brings the database online without running the recovery undo pass.

See also sp_helpdb in Reference Manual: Procedures.

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

The permission checks for online database differ based on your granular permissions settings.

Setting	Description
Enabled	With granular permissions enabled, you must be the database owner, or a user with `online database` privilege or `own database` privilege on the database.
Disabled	With granular permissions disabled, you must be the database owner, or a user with any of these roles: sa_role, or, replication_role, or, oper_role

Auditing

Values in event and extrainfo columns of sysaudits are:

Information	Values
Event	83
Audit option	security
Command or access audited	online database
Information in `extrainfo`	Roles – current active roles Keywords or options – NULL Previous value – NULL Current value – NULL Other information – NULL Proxy information – original login name, if set proxy is in effect