RMAN-07539: Insufficient Privileges To Create Or Upgrade The Catalog Schema

While creating a catalog for the database, received below error. RMAN-07539: insufficient privileges to create or upgrade the catalog schema RMAN> connect target sys/oracle#1234@ARCDB connected to target database: ARCDB (DBID=605774762) RMAN> connect catalog RMAN_st/rman@catlogdb connected to recovery catalog database RMAN> create catalog RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-07539: insufficient […]

Read More

ORA-19588: Archived Log RECID Is No Longer Valid

As we know each and every problem have solutions. Let’s have a solution to the Error:- ORA-19588. PROBLEM: While taking RMAN backup, got below error. RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of backup command on t4 channel at 05/01/2017 03:18:01 ORA-19588: archived log RECID 143154 STAMP 942443843 is no […]

Read More

RMAN-20035: Invalid High RECID In Rman Catalog

We are going to learn about the steps which we use to solve issues RMAN-20035.      we face RMAN-20035: invalid high RECID  after connecting to catalog database.   executing command: SET COMMAND ID starting full resync of recovery catalog RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of set command at […]

Read More

RMAN-06429: TARGET Database Is Not Compatible Version

This post is about to solve the issue RMAN-06429. While connecting to catalog and running rman script, you may face below error.  Whenever you connect to a database (rman version if different from source database version, in fact, rman version is higher than the source database) through RMAN using/without recovery catalog it fails with RMAN-06429: […]

Read More

Oracle 18c: RMAN New Features

This article was written by Skant Gupta and Joel Perez in Oracle OTN. Full Index of Oracle Cloud Articles: Sir.CloudDBaaSjoelperez Before starting to read, if you want to access others Oracle RMAN Cloud Articles, you can go here: #6 Oracle Cloud (DBaaS): Migrating Databases to Oracle Cloud Using RMAN Backup #11 Oracle Cloud (DBaaS): Migration “On-prem” database to Cloud Using […]

Read More

RMAN Active Cloning From RAC TO RAC

Being an Oracle DBA we know that what is cloning? This technical definition gives you a correct idea of the cloning. RMAN has the ability to duplicate, or clone, a database from a backup or from an active database. It is possible to create a duplicate database on a remote server with the same file structure, […]

Read More

Categories of Failures in Oracle Database

Today we are going to have look on Categories of Failures in Oracle Database.  This information helps to DBA solve the issue as soon as possible.   Statement Failure Statement failure transpires when there is a logical failure in the handling of a statement in an Oracle program. If a statement failure occurs, then the Oracle software or operating […]

Read More

Recover corrupted data blocks using DBVERIFY

As we know that SYSTEM – stores the data dictionary.  Being an Oracle DBA we all know the importance of SYSTEM tablespace.  In these below lines, we can have actual technical knowledge about system’s information. SYSTEM – a tablespace that is always used to store SYSTEM data that includes data about tables, indexes, sequences, and other objects – this metadata […]

Read More