How to Get ddl of any Object in Oracle: In this article we will explain about How to Get ddl of any Object in Oracle using DBMS_METADATA.GET_DDL. Use of DBMS_METADATA: Every time all DBAs and Developers required to create scripts of objects like Tables, Indexes, Packages, Packages Body etc. In Oracle database has a package … Read more
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:. 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 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: 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
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: 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
Change AWR snapshot Retention period and Interval in Oracle: In this article we will discuss about how to Change AWR snapshot Retention period and Interval in Oracle. About AWR Report: Oracle MMON background process collect the AWR statistics and generate the snapshot based on retention period, which violates the threshold metric. You can enable this … Read more
How to create a password file using ORAPWD Utility in oracle: In this post we will discuss about how to create a password file using ORAPWD Utility in oracle. What is password file in ORACLE ? The password file stores a list of usernames and passwords that are allowed to remotely authenticate as SYSDBA over … Read more
Oracle 19c 2 node RAC to single instance standby database setup: In this article we will discuss about how to setup Oracle 19c 2 node RAC to single instance standby database step by step. Environment Details for both (Primary and Standby): Primary Server side Configurations:- Make sure primary is in archivelog mode: Check FORCE LOGGING … Read more
