Disabling and removing dataguard using broker
1 – Checking if the broker is being used. sqlplus / as sysdba show parameter dg_broker; show parameter dg_broker_start; select name, value from v$parameter where name = ‘dg_broker_start’; …
1 – Checking if the broker is being used. sqlplus / as sysdba show parameter dg_broker; show parameter dg_broker_start; select name, value from v$parameter where name = ‘dg_broker_start’; …
In this blog I have explained the step by step installation of Oracle Enterprise Manager 13c on Windows server. Make sure you have sufficient resources on your laptop or server…
Hi everyone, I will start complete guide of Oracle RAC 19c lab setup. I have listed all the main points that I will cover during my up coming videos on…
Download Software Download the Oracle software from OTN or MOS depending on your support status. Hosts File The “/etc/hosts” file must contain a fully qualified name for the server. For…
Incorrect environment. ORACLE_HOME for grid should be pointing to grid directory and ORACLE_SID for ASM should be +ASM. Try this: export ORACLE_HOME=$GRID_HOME export $ORACLE_SID=+ASM export PATH=$GRID_HOME/bin:$PATH
How to resolve the error RMAN-05537: DUPLICATE without TARGET connection when auxiliary instance is started with spfile cannot use SPFILE clause ? Error:Starting Duplicate Db at 9-SEP-14RMAN-00571: ===========================================================RMAN-00569: ===============…
This error normally occur because of the INDEX or table structure is in consistent mode. Analyze the index structure and tables.If index structure is failed in analyze , drop the…
In this article, we will learn steps needed to perform recovery of User wrong operation like delete/drop/truncate action on the production table without using Restore and Recover command on PRIMARY DATABASE.…
There are various methods (RMAN, Online datafiles move 12c onwards, ASMCMD, DBMS_FILE_TRANSFER, etc) to achieve migrate databases from Non-ASM to ASM. Here we will use two types of RMAN mix…
List of target upgrade versions from supported source version along with the certificate, data source support.oracle.com. Direct Upgrade Version List: Source DB Version Target DB Version 18.1 19c 12.2.0.2 19c 12.1.0.2 19c…