Oracle 18c – Preplugin Backups including restore and recovery test

Preplugin backups are backups taken of a non-CDB or a PDB before they are plugged into a target CDB. You can relocate the PDB by unplugging it from a source CDB or NON-CDB and plugging it into target CDB. RMAN can perform PDB restore and recovery operations on the target CDB by using preplugin backups. From 18c, RMAN now supports use of the PREPLUGIN for commands like CATALOG, CROSSCHECK, LIST, CHANGE etc. Here is a complete explanantion of preplugin PDB backup on source CDB and restore/recovery on target CDB after plugging in.

Source: CDB18 and PDB18 ( PDB Backup and unplug from source CDB)

Destination: CDB_dest and PDB18 ( plug-in to dest CDB and restore/recover test)

Creating Preplugin Backups of PDBs Using RMAN On source CDB:

Connect to the PDB as a local or common user with SYSDBA/SYSBACKUP privilege. Continue reading → Oracle 18c – Preplugin Backups including restore and recovery test

ORA-20079: full resync from primary database is not done with ORA-17627, RMAN-20051

Whenever a structural change is made on the primary, attempts to resync from the primary using db_unique_name during the standby RMAN backups, it fails with following error.
Db-unique-name for all databases participating in the Data Guard configuration has been configured. Continue reading → ORA-20079: full resync from primary database is not done with ORA-17627, RMAN-20051

Oracle Cloud – Backup Service

Oracle database  backup service is cloud Storage Solution for your Oracle Database Backups. Oracle Database Backup Service provides a low-cost alternative for storing backups in an offsite location. It is an Oracle Public Cloud object-based storage offering that enables you to store your on-premises or cloud-deployed database backups.

If you are familiar with Oracle Recovery Manager (RMAN), it should take only a few minutes for you to start backing up your database to the cloud. Here’s all you need to do:

  • Download Oracle Database Cloud Backup Module from OTN Site
  • Unzip opc_installer.zip file.

Continue reading → Oracle Cloud – Backup Service