Yearly Archives: 2023

Backup & Restore

Resolve PL/SQL package SYS.DBMS_BACKUP_RESTORE version is not current PL/SQL package SYS.DBMS_RCVMAN version is too old

SOLUTION Recompile the RMAN packages and procedures by connecting to the target database as SYSDBA and execute: $ sqlplus / as sysdba SQL> @$ORACLE_HOME/rdbms/admin/dbmsrman.sqlSQL> @$ORACLE_HOME/rdbms/admin/dbmsbkrs.sqlSQL> @$ORACLE_HOME/rdbms/admin/prvtrmns.plbSQL> @$ORACLE_HOME/rdbms/admin/prvtbkrs.plb

Comments Off on Resolve PL/SQL package SYS.DBMS_BACKUP_RESTORE version is not current PL/SQL package SYS.DBMS_RCVMAN version is too old
December 30, 2023
Data Guard

How to recreate Oracle Data Guard Broker configuration

In an Oracle Data Guard setup, sometimes it is necessary to recreate the broker configuration. We will look at how to do that in this article. The following steps were…

Comments Off on How to recreate Oracle Data Guard Broker configuration
April 29, 2023
General

ORA-38774 whiles disabling archivelog mode

I got the following error while disabling archivelog mode on a database. SQL> alter database noarchivelog;alter database noarchivelog*ERROR at line 1: ORA-38774: cannot disable media recovery - flashback database is…

Comments Off on ORA-38774 whiles disabling archivelog mode
February 12, 2023
Data Guard

How to resolve ORA-01111 ORA-01110 ORA-01157 on a physical standby database.

Recovery process on a standby database terminated with the following error in the alert log. PR00 (PID:1200024): Managed Standby Recovery starting Real Time Apply2022-12-29T23:12:39.387793+00:00PR00 (PID:1200024): MRP0: Background Media Recovery terminated…

Comments Off on How to resolve ORA-01111 ORA-01110 ORA-01157 on a physical standby database.
January 5, 2023