How to set Oracle Pluggable Database Automatic startup

Pluggable Database Automatic startup

As you know the pluggable database concept introduce in oracle 12c and when we startup the CDB database the PDBs (Pluggable Database) will be mount stage. So that time we need to open PDBs manually using alter command. Here we are going to learn how to Oracle Pluggable Database Automatic startup step by step. To … Read more

Resolve huge archive gap between primary and standby

Resolve huge archive gap between primary and standby

Hello, friends in this tutorial I’m going to demonstrate to you how to Resolve huge archive gap between primary and standby. How do I resolve an archive gap? Suppose in between primary & standby have many archives difference like 500 archives, so we have need to recover it using incremental backup, follow me. Action ON … Read more

ORA-10456 cannot open the standby database

ORA-10456 cannot open the standby database

Here we are going to discus how to solve ORA-10456: cannot open standby database media recovery session may be in progress. The ORA-10456 is Oracle Data guard error. Note: The following error is coming at that time when you trying to open your standby database in read-only mode without stopping the archive process. ORA-10456 cannot open the standby database Solution Step-1. Stop MRP process using following … Read more

PRCR 1086 resource ora.mgmtdb is already registered

Solution PRCR 1086 resource ora.mgmtdb

In this article, I’m going to discuss the PRCR 1086 resource ora.mgmtdb resource which I was facing at the time of grid configuration on the Oracle Linux 6.7 platform. I have checked the logfile for grid configuration which is existing on the following path “/u01/app/oraInventory/logs/installActions2019-03-16_09-10-07PM.log“, and got the following information from the log. PRCR 1086 resource ora.mgmtdb … Read more