How to create a RMAN Catalog & register in Oracle Database 12c(12.2.0.0) Overview of recovery catalog The recovery catalog contains metadata about RMAN operations for each registered target database. therefore when RMAN is connected to a recovery catalog, the RMAN obtains its metadata exclusively from the catalog db, to perform this operation you need to Read More

How to delete the backup which is no longer needed or obsolete in Oracle database using RMAN Note: You can delete the backup which is not needed as per the rman configuration policy set Check the RMAN Configuration policy RMAN> show all; using target database control file instead of recovery catalog RMAN configuration parameters… Read Read More

How to backup Individual Database files like Tablespace, Datafiles, Archivelogs, Spfile, Controlfile by using RMAN BACKUP OF ALL ARCHIVELOG RMAN> backup archivelog all; Starting backup at 20-JUL-20 current log archived using channel ORA_DISK_1 channel ORA_DISK_1: starting archived log backup set channel ORA_DISK_1: specifying archived… Read more..

RMAN Backup of Container Database (CDB) & Pluggable Database (PDB), Partial PDB Connect to the CDB Database Connect to the RMAN Root Container Database (CDB) by using rman target sys/<password>@<dbname> or rman target / Example: rman target sys/******@ora18c or rman target /  – The result will be same Connect… Read more..

RMAN database restore from lower version (11.2.0.1) to 11.2.0.4 by using upgrade in Oracle database 11gR2 Copy the datafiles, archivelog files and controlfile from real database to restore backup location by using the NC or Winscp or any suitable method First verify the real database version: [oracle@realdb backup]$ !sq sqlplus… Read more..

Block Change Tracking for Incremental Backups in Oracle database 11gR2 The Block change tracking is mainly used in Incremental backup of the database as it has to scan each block of the datafile to find weather it has any changes or not & it also consume more time, to reduce this we can enable the Read More