Oracle Database Administration Cloud Backup and Recovery

Learn the differences between complete recovery and incomplete (point in time) recovery, and how to restore to the present or a precise past time using backups and archived redo logs.

Explore the role of archived redo logs in Oracle database backups, enabling point-in-time recovery by applying archived logs with full backups to restore to an exact moment.

Learn how Oracle database point-in-time recovery uses regular backups plus archive logs to roll forward transactions and recover data up to a specific moment.

Prepare for point-in-time recovery by enabling archive log mode and configuring archived log destinations. Restore using a prior full backup plus the corresponding archived logs to the desired time.

Explore database failure scenarios, including human error, machine failure, disk failure, and complete data center loss. Learn how Oracle backup and recovery technologies address each failure type.

Learn physical backups, which copy Oracle data files, logs, and control files, and logical backups, which export objects with data pump for flexible restoration.

Explore Oracle backup technologies, including user-managed hot backups, Armon, Automan, data pump, and Oracle flashback for time-based recovery.

Download the Oracle App Development Virtual Machine from Oracle, install VirtualBox, import the appliance, and start the VM to run a complete Oracle 12c environment for hands-on backup and recovery.

Enable archivelog mode in an Oracle database by shutting down, mounting, enabling archive logs, and configuring archive destinations to prepare for cloud backup and recovery with pluggable databases opened.

Configure the fast recovery area by setting its destination and size to centralize storage for backups, archived redo logs, flashback logs, and backup sets in the Oracle database.

Explore how user-managed backups work without the recovery manager, perform online backups with OS or storage tools, copy data files, control files, and archived redo logs, and leverage storage snapshots.

Learn how to perform user-managed backups of data files for a pluggable database by listing files, enabling backup mode, and copying files to a safe location or storage snapshots.

Perform manual backups of control files and archived redo logs, alongside data files, and store them safely off the server for reliable database recovery.

Master RMAN concepts for backing up and recovering Oracle databases, including online backups, full and incremental backups, level zero and level one backups, backup sets, and recovery operations.

View and configure RMAN options, including retention policy to redundancy and default device type. Learn to create a disk backup channel and enable auto backup of the control file.

Execute full backups with RMAN by connecting to the local Oracle database and backing up the container database plus all pluggable databases, including archivelogs, in a multitenant environment.

Use RMAN to run incremental backups by level (zero or one) and back up archived redo logs, while differential and cumulative backups guide the restore that starts with level zero.

Learn how RMAN backups are managed in the admin interface, listing and deleting backups, viewing status, date, size, destination, and backup pieces (physical files) for databases and pluggable databases.

Explore how RMAN uses a retention policy to mark backups as obsolete and delete them, keeping only required copies. Use report obsolete and delete obsolete commands.

Understand how RMAN detects missing backups by cross-checking and listing expired backups, and purge them with delete expired backup to ensure accurate recovery options.

Use RMAN to safely delete backup sets or all backups for a target database, using delete no prompt, avoiding OS-level deletions and keeping backups in sync with RMAN.

Learn how to use RMAN to back up archived redo logs, list backups, and delete archive log backups with no prompt, ensuring effective archive log management.

Learn to orchestrate RMAN to delete archived redo logs safely after they are backed up, manage archive logs by age, and reduce space in the fast recovery area.

Use RMAN to scan your database for physical and logical corruption and verify backup integrity, ensuring reliable recovery by validating data files and backup sets.

Learn how to automate Oracle database backups with rman scripts, including archivelog handling, control file backups, and destination customization, using run blocks in rman, and channels, and backup sets.

Perform RMAN recovery concepts by preparing the database (close pdb or mount CDB), executing incomplete point-in-time recovery with set until, restoring files, applying archived logs, and opening with reset logs.

Recover a pluggable database from a full backup, restore the system data file, and reopen the PDB to its fully operational state at the most recent point in time.

Learn how to perform point in time recovery of a PDB using Automan, including retrieving the current timestamp, preparing a recovery script, and restoring to a precise moment.

Learn to perform a full container database restore in a multitenant Oracle environment, including all pluggable databases, using a single restore script in mount mode.

Perform point-in-time recovery of the CDB and all PDBs with an Amen script after capturing the current timestamp and mounting the instance in mount mode.

Learn how to export data from an Oracle database using the export data pump utility, creating a dump file for one or more schemas.

Create a directory object in the Oracle database aliased to a filesystem path, then reference it in the expdp command to export data. Grant read and write permissions to users.

Export a single pluggable database from an Oracle 12c multitenant container using datapump export, including creating a pdb and generating a dump file for backup and recovery.

View the data pump log files to diagnose export and import errors. The logs mirror on-screen output and record table names, sizes, row counts, and job status.

Learn to use Oracle Data Pump to export and import data via dump files between compatible Oracle databases, with remap_schema to avoid overwriting objects.

Filter data pump imports and exports by using include and exclude parameters to load only tables and indexes (excluding views) and to remap schemas and grants.

Use advanced filtering in data pump export to select specific objects by name, using the include parameter and optional parameter files to export only chosen tables and views.

Use parameter files to drive Oracle Data Pump export and import, storing options like dump location, log file, schemas, and filters in a reusable text file for repeatable jobs.

Monitor data pump export and import jobs in real time, track progress with a data pump view query, and attach to or terminate a full pdb export with kill_job.

Explore how Oracle flashback uses the undo retention parameter to set lookback time for reverse changes, with prerequisites varying by feature and undo space implications shown in a demo.

Enable flashback database to restore the Oracle database to a previous point by configuring archive mode, flashback logs, and a fast recovery area, then set retention and enable flashback.

Learn how to use Oracle's flashback query to view past data states, using as of timestamp, and create new tables from historical data for point-in-time analysis.

Learn how to use flashback table to restore an individual Oracle database table to a prior point in time, recover dropped tables via the recycle bin, and handle common limitations.

Learn how Oracle flashback database restores an entire database to a past time with a timestamp, using a single command, with pluggable databases and flashback logs in fast recovery area.

Create and use restore points with flashback database to recover a multitenant Oracle database to a point in time, manage the fast recovery area, and clean up restore points.

Practice Oracle database backup and recovery techniques, including container and pluggable database restoration, flashback recovery for error handling, and logical backups to enable data portability across Oracle databases.

Learn how Automan automates Oracle database backup and recovery, covering target database, Automan client, media manager, fast recovery area, and optional recovery catalog; start and connect to a database hands-on.

Learn to back up an Oracle database with RMAN in archivelog and no archive mode, using backup sets or copies, and ensure a consistent backup via shutdown immediate and mount.

Oracle RMAN incremental backups cover level zero full backups and level one backups of modified blocks, explain cumulative versus differential approaches, with hands-on commands and recovery scenarios.