Database management

The users can monitor the status of databases running in OwlDB, and modify, stop, delete, and specify databases as needed. The buttons allow the users to quickly perform the desired action, and the users can adjust various settings to optimize database performance. Some information may be missing if the database operational status is not Running, or if the instance status is Recovery, Disconnect.

Note

The users can go to the database management page by clicking OwlDB Console Screen > Dashboard > DB Alias.

The database management page displays the time based on the database timezone, which may differ from the user's local system time (browser time).

---

Veiwing database information

1. Go to the OwlDB console screen > Administration > Overview menu.

2. Click the DB Alias drop-down button to pull down the database for which the users want to view information.

3. View the database details.

Database

View database details, including control files, logs, checkpoints, and whether or not it is failover.

Instance

View the configuration instance list and information.

• Click the "Instance Name" to go to the 'Instance Management' page.

• The users can restart one or more instances at the same time by clicking the ☑️ icon. Refer to 'Restarting an Instance'.

Version

View database version information, system and kernel information, and patch information.

(BYOL) Licence

Tab provided by the BYOL licensing model.

• Check the license the users are using and the assigned instance information.

• The users can also see information about expired licenses.

The database operational status is as follows.

Database operational status	Description
Provisioning	State of creating and setting up the server environment and database
Running	All resources are available for normal use
Changing	Specification changes are in progress
Migrating	Data migration is in progress
Stopping	Switching all resource usage to Stopped
Stopped	The state of temporarily disabling all resources (disabling resources)
Pending	State of transitioning from Stopped to Running
Terminating	The state of permanently deleting all resources and data (when finished, they cannot be accessed and recovered)

---

Modifying database information

1. Navigate to the OwlDB console screen > Administration > Overview menu.

2. Click the DB Alias drop-down button to pull down the database whose information the users want to modify.

3. Click the Edit button.

4. Modify the database alias and description.

5. Click the Save button.

---

Stopping and starting database

Note

The users can stop the database for up to 7 days (168 hours). If the users do not manually start it within 7 days, it will start automatically at the next time slot after 168 hours have elapsed.

1. Navigate to the OwlDB console screen > Administration > Overview menu.

2. Click the DB Alias drop-down button to pull down the databases the users want to stop and start.

3. Click the Stop or Start button.

Caution

The users will still be charged for provisioned storage when the users stop a database. The users will also be charged for backup storage, including manual snapshots and automatic backups within the specified retention period.

---

Deleting database

1. Navigate to the OwlDB console screen > Administration > Overview menu.

2. Click the DB Alias drop-down button to pull down the database the users want to delete.

3. Click the Delete button.

4. Key in 'delete' in the input box.

5. Click the Delete button again.

6. Click the OK button.

Caution

Once deleted, the database cannot be recovered and all data will be completely deleted.