Auditing in Oracle Database

Auditing in Oracle Database

Auditing in Oracle Database: In this article we will discuss about Auditing in Oracle Database. Here we use our Oracle 19c database. Auditing is a default feature in Oracle Database to monitoring and recording of configured database actions, from both database users and nondatabase users. Below are the initialization parameters that can be displayed and … Read more

Convert Non-CDB to a PDB in Oracle 19c

Convert Non-CDB to a PDB in Oracle 19c

Convert Non-CDB to a PDB in Oracle 19c : In this article we are going to explain about how to Convert a Non-Container Database (CDB) to a Pluggable Database (PDB) or plugin a Non-Container Database (CDB) into a Container Database (CDB) as a Pluggable Database (PDB) in Oracle 19c. Below are steps for Convert Non-CDB … Read more

Recover Standby Database from Primary using Service in Oracle

Recover Standby Database from Primary using Service in Oracle

Recover Standby Database from Primary using Service in Oracle: In this article we will discuss about how to Recover Standby Database from Primary using Service in Oracle 19c. If your standby database is out of sync from primary. Or some archive logs got deleted before it is being shipped or applied to standby. Then, you … Read more

Manual Data Guard switchover in Oracle

Manual Data Guard switchover in oracle

Manual data guard switchover in Oracle: In this article we will explain about how to perform Manual Data Guard switchover in Oracle from primary to physical standby database manually. In a Data Guard environment two types of roles primary database and physical standby database are there we can altered these roles without any data lose … Read more

Create Container Database (CDB) in Oracle 19c using DBCA

Create Container Database (CDB) in Oracle 19c using DBCA

Create Container Database (CDB) in Oracle 19c using DBCA:. In this article we will explain about how to Create Container Database (CDB) in Oracle 19c using DBCA. CDB PDB database features is started from Oracle 12c onwards. A cdb database is the root database in multitenant architecture which contains zero, one or multiple pdbs. Steps … Read more

How to create a Pluggable Database in Oracle 19c using dbca

How to create a new Pluggable Databases in Oracle 19c using dbca

How to create a new Pluggable Database in Oracle 19c using dbca.- In this article we will explain about How to create a Pluggable Database in Oracle 19c using dbca. From Oracle 12c oracle started Multitenant Architecture. In multitenant architecture you could create multiple PDBs and PDBs are created in CDB. Before we create a … Read more

ORA-01274 cannot add data file that was originally created as

ORA-01274_ cannot add data file that was originally created as

ORA-01274: cannot add data file that was originally created as: In this paragraph i will discuss about ORA-01274 database error. When you getting ORA-01274 error follow below steps to resolve the issue. Problem: After adding a datafile in primary database, recovery process in standby database stopped with below error. Primary Side: After adding a datafile … Read more

OLR (Oracle Local Registry) in RAC

OLR (Oracle Local Registry) in RAC

In this paragraph OLR (Oracle Local Registry) in RAC contains node-specific information required by OHASD. Every node has its own dedicated OLR file (not shared between the nodes). From Oracle Clusterware 11g Release 2 onwards an additional component related to the OCR called the Oracle Local Registry (OLR) is installed on each node in the … Read more

Transparent Data Encryption In Oracle 11g (11.2.0.4) RAC Database

Transparent Data Encryption In Oracle 11g (11.2.0.4) RAC Database

Transparent Data Encryption In Oracle: In this article we will discuss about configuring and enabling Transparent Data Encryption In Oracle 11g (11.2.0.4) RAC Database. Let’s see steps how to configure TDE. Take full database RMAN backup: Take full database RMAN backup before starting the TDE implementation activity. Use below script to take full Database RMAN … Read more