After data guard configuration in oracle database version 19.22, I realized that redo logs were not being shipped to the standby database and the RFS process was also not running…
Sometimes it is necessary to exclude data for some tables in a datapump import. In this post we will look at how to do that. SOLUTION We will do this…
While performing incrementally updated backup on a RAC database with the script below : rman target "'name/password as SYSBACKUP'" run { allocate channel c01 device type disk connect='name/password@RACDB1 as SYSBACKUP';…
This article demonstrates how to stop a running datapump (expdp/impdp) job started in the background. Assuming a job was started in the background on Linux this way: $ nohup ./imp_SCHEMAS_script.sh…
While performing Data pump export (expdp) the following errors were seen in the log file. The Oracle RDBMS version was 19.3.0.0.0 BEGIN "SYS"."DBMS_CUBE_EXP".SCHEMA_CALLOUT(:1,0,1,'19.00.00.00.00'); END; ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86 ORA-06550:…
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
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…
