A buffer cache is a memory area within the Oracle database, where records are processed.
Character set
A character set defines the language character set in which the data within a database is stored.
Checkpointing
The process of writing all transactions into the redo log files.
Control file
The control file is created and maintained by Oracle. It contains information about the physical locations of all files associated with the database as well as its logical information such as, the different tablespaces within a database as well as the character set information.
Deprecated
When a certain feature or functionality is no longer advisable for use or will no longer be supported on the Oracle database server, that feature is called deprecated.
Dirty buffer
When a user changes the records within a transaction, that transaction within the buffer becomes dirty or changed.
Elapsed Time
In the context of Oracle Database Backup and Recovery, "Elapsed Time" refers to the total duration it takes for a backup or recovery operation to complete. This is a key metric for monitoring progress and identifying potential bottlenecks.
File affinity
The export file created has the role and responsibility of the user within it and when the file is imported by another user, this user must have the same set of roles and responsibility to complete an import.
Guaranteed Restore Point
A Guaranteed Restore Point in Oracle Database backup and recovery is a named point-in-time to which the database can be flashed back. Unlike regular restore points, the database guarantees the ability to flashback to a guaranteed restore point, even if a flashback log is aged out, providing a higher level of assurance for recovery operations.
Handle
A handle is a connection to the database server, which completes a transaction for the user.
Incremental Backup:
An incremental backup in Oracle Database backup recovery captures only the blocks that have changed since the last backup (either a full or another incremental backup), making the backup process faster and requiring less storage space. To perform a complete recovery using incremental backups, you typically need the initial full backup and all subsequent incremental backups up to the desired recovery point.
Journaling
In the context of Oracle Database backup and recovery, journaling refers to the process of maintaining detailed logs of changes made to the database. These logs, such as redo logs and archive logs, are crucial for point-in-time recovery and ensuring data consistency.
Metadata
The system tables and views of Oracle are metadata of the database.
NetBackup:
This is a commercial backup and recovery software often used with Oracle databases. It facilitates centralized management of backup and recovery processes, offering features like incremental backups and catalog management for Oracle environments.
Optimizer
Optimization is a process of choosing the most efficient way to execute a SQL statement. A part of Oracle called the optimizer calculates the most efficient way to execute a SQL statement. The optimizer evaluates several factors to select among alternative access paths.
Parallel rollback
Rolling back of data within multiple parallel processes.
Roll forward phase
In this process, which happens during recovery, all transactions within the redo log files are applied to the database.
Rollback
This is a process, where the Oracle server replaces the old values for a record when a transaction is not committed.
Serial rollback
Rolling back of data within a single serial process.