RMAN

Basic RMAN Commands

RMAN is a backup and recovery manager supplied for Oracle databases created by the Oracle Corporation. It provides database backup, restores, and recovery capabilities addressing high availability and disaster recovery concerns. RMAN can also help in-migration from on-prem to cloud. Below are some of the basic RMAN commands, useful for daily usage. RMAN show all

Basic RMAN Commands Read More »

PL/SQL package SYS.DBMS_BACKUP_RESTORE Version is Not Current | PL/SQL package SYS.DBMS_RCVMAN version in TARGET database is not current

Post applying the database patch sometimes you may get below error in the alert log or RMAN prompt. PL/SQL package SYS.DBMS_BACKUP_RESTORE version 19.05.00.00 in TARGET database is not currentPL/SQL package SYS.DBMS_RCVMAN version 19.05.00.00 in TARGET database is not current Recent Changes The above-mentioned errors were reported post applying the database patch. Cause Might be that these

PL/SQL package SYS.DBMS_BACKUP_RESTORE Version is Not Current | PL/SQL package SYS.DBMS_RCVMAN version in TARGET database is not current Read More »

RMAN Restoration Failed with Error Code – RMAN-06100: no channel to restore a backup or copy of datafile n

Problem Description While restoring from an RMAN backup it’s failing with the following error.  RMAN-06100: no channel to restore a backup or copy of datafile  Example : – Connect target / RMAN> restore database;  RMAN-03002: failure of restore command at 01/23/2022 12:29:17 RMAN-06026: some targets not found – aborting restore RMAN-06100: no channel to restore

RMAN Restoration Failed with Error Code – RMAN-06100: no channel to restore a backup or copy of datafile n Read More »