The database lifecycle includes database creation and resource allocation, managing the database schema and data, performing backup and recovery tasks, and decommissioning databases. Database administrators and application developers perform the database lifecycle tasks.

Create

Create and allocate resources to a new database using database configuration templates. Database templates specify sets of database parameters, including resource limits. Application developers can perform do-it-yourself database creation using the templates. See Requirements for Creating Databases.

Administrators can grant permissions to their users that enable the users to create databases from templates, but do not allow them to modify the templates or change the default resource allocations. This restriction provides resource limit enforcement and allows administrators to retain control of resource and security policies. See Managing Database Templates.

Manage schema

Manage the database schema and add data. You can create tables, designate primary and foreign keys and indexes, and create views, sequences, triggers, and other database entities.

Backup and restore

Safeguard your data by taking regular backups and testing your backups. See Safeguarding Data.

Clone

Ensure access to consistent, yet isolated databases by cloning the database for specific purposes such as development or quality assurance. See Cloning Databases.

Scale up

Dynamically increase the database size as required, during the development, test, and production phases.

Monitor performance and usage

Use the Data Director user interface to monitor tasks and events. See Monitoring the Data Director Environment.

Stop and restart the database

Stop and restart, for example, to perform maintenance tasks.

Decommission the database

Disable and then delete databases. Free up the resources when they are no longer needed.

Every database requires a database owner account that can perform all schema management operations. This account is specific to the database and cannot log in to Data Director. You can add database owner accounts after database creation. Data Director users must log in with their database-specific credentials to view the database, its entities, and its data or to perform database management tasks.

Database administrators and application developers can manage databases only if they have appropriate permissions and roles granted to them by the organization administrator. The permissions and roles must be granted on the database group or on the database, and apply only within the organization in which they are granted.