Configuring Automatic Backups for the Control File and Server Parameter File You can configure RMAN to automatically backup the control file and server parameter file with every backup. This is referred to as an autobackup. The server parameter file and control file are critical to the database a...
Configuring Backup Device Settings For disk-based backups, you can configure the default format for backups, the location on disk where backups are stored, whether backup tasks run in parallel, and whether backups are compressed. For tape backups, you can configure settings such as the number of...
Configuring the Automatic SQL Tuning Advisor The following are some configuration tasks that you might want to perform for the Automatic SQL Tuning Advisor: ■ Enable automatic implementation of SQL profile recommendations. Automatic implementation is disabled by default. ■ Change the maximum nu...
Configuring the Fast Recovery Area If you did not specify a location for the fast recovery area during installation, the installation process automatically configures a fast recovery area in the Oracle base directory. Oracle recommends, however...
Configuring the HTTPS Port for EM Express The steps in this section need to be performed only if DBCA did not provide you with the EM Express URL when configuring your database, or if you need to change the EM Express port later on. Otherwise, you can start EM Express by following the instructio...
Connect Descriptors The client uses a connect descriptor to specify the database to which it wants to connect. This connect descriptor contains a protocol and a database service name. A database can have multiple service names defined, so a specific service name must be specified for the connect...
Connecting to the Target Database To perform backup or recovery operations or to configure backup and recovery settings, you must start the RMAN client and connect to the target database. A target database is the Oracle database that must be backed up or restored using RMAN. Connections to the t...
Consistent and Inconsistent Backups A backup is either consistent or inconsistent. To make a consistent backup, your database must have been shut down cleanly and remain closed for the duration of the backup. All committed changes are written to the data files during the shut down process, so th...
Creating a New User Account by Duplicating an Existing User Account To create a user account that is similar in attributes to an existing user account, you can duplicate the existing user account. To create a new user account by duplicating an existing user account: 1. Go to the Users page, as d...
Creating a Role Suppose you want to create a role called APPDEV for application developers. Because application developers must be able to create, modify, and delete the schema objects that their applications use, you want the APPDEV role to incl...
