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...
Creating a User Account Suppose you want to create a user account for a database application developer named Nick. Because Nick is a developer, you want to grant him the database privileges and roles that he requires to build and test his applications. You also want to give Nick a 10 MB quota on...
Creating and Managing a Database with DBCA Unless you specified that only the Oracle Database software should be installed, Oracle Universal Installer automatically runs Database Configuration Assistant (DBCA) after software installation...
Creation Mode This window enables you to create a database with default configuration or to use Advanced Mode to create a database. If you choose Advanced Mode, you can customize storage locations, initialization parameters, management options, database options, and different passwords for Admi...
Cross-Checking Backups Cross-checking a backup synchronizes the physical reality of backups with their logical records in the RMAN repository. For example, if a backup on disk was deleted with an operating system command, then a cross-check detects this condition. After the cross-check, the RMAN...
Current ADDM Findings If there are Real-Time ADDM findings for the past 5 minutes, these are listed on the Current ADDM Findings tab in the Performance Hub when both of the following are true: ■ Real-Time Data - Last Hour is selected in the...
Database Backup and Recovery Concepts To back up your database means to make copies of your data files, control file, and archived redo log files (if your database runs in ARCHIVELOG mode). Restoring a database means copying the physical files ...
