In this below tutorial, we will enable DDL replication for a table, which is already part of goldengate replication and currently, only DML transactions are getting replicated. TABLE_NAME = APPLIANCE.CLASSTAB1 To enable DDL replication, We need to run few SQL scripts(provided under $GG_HOME) on the source database. and update the extract parameter file. 1. Run role_setup.sql where […]
Monthly Archives: November 2017
Obey Command In Goldengate
Like we execute .sql file against SQL, we can write multiple golden gate commands inside a .oby file and execute it against GGSCI prompt using OBEY command. Use OBEY to process a file that contains a list of Oracle GoldenGate commands. OBEY is useful for executing commands that are frequently used in sequence. EXAMPLE: In the below […]
Defgen Utility In Oracle Goldengate
Let’s have look at the Defgen Utility In Oracle Goldengate. If the source and target table structures are different from source has then we need to use definition file in replicate file. Example: Here we will generate definition file of a table DBACLASS.EMPLOYEE from the source database and use it in target db. 1. Create defgen […]
ASM – (ACFS commands for multiple environments)
Overview of ACFS:- Oracle ACFS is designed as a general-purpose, single-node and cluster-wide file system that delivers support for customer file system application data maintained outside of Oracle Database. Users and applications can access and manage Oracle ACFS using native operating system file system application programming interfaces (APIs) and command-line interface (CLI) tools. Users can also […]
ASM Clients
Being an Oracle DBA we have learned about ASM and its qualities. Today we are going to learn about ASM Clients. We all are aware that Oracle ASM is a volume manager and file system for Oracle database files. Let’s start to have knowledge of ASM Client. Clients that connect directly to ASM. Oracle Database:- This is […]
Open Wallet Automatically After Starting The Database
This article about Open Wallet Automatically After Starting The Database. If encryption wallet is enabled, then every time we start the database, we have to open the wallet manually. So to avoid this, we can create one trigger which will open the wallet automatically, once you start the database. Below is the trigger: CREATE or replace […]
How To Use DBMS_PRIVILEGE_CAPTURE To Capture Privs In Oracle 12c
Introduction:- Oracle 12c introduced the DBMS_PRIVILEGE_CAPTURE package, which helps us in doing privilege analyze and find a report on used and unused privileges.In order to use the DBMS_PRIVILEGE_CAPTURE package, you must be granted the CAPTURE_ADMIN role. One of the most important Security Principals while maintaining your Enterprise Database Landscape is implementing the “least privilege” principle. The […]
How To Move AUD$ Table To Another Tablespace Using DBMS_AUDIT_MGMT
Auditing is always about accountability, and is frequently done to protect and preserve privacy for the information stored in databases. Concern about privacy policies and practices has been rising steadily with the ubiquitous use of databases in businesses and on the Internet. Oracle Database provides a depth of auditing that readily enables system administrators to […]
ENABLE_DDL_LOGGING In Oracle 12c
This ENABLE_DDL_LOGGING parameter has been introduced in Oracle 12c. If this ENABLE_DDL_LOGGING is enabled, then DDL records are written to the ADR. All DDL operations like alter/create/drop/truncate objects. Only drop user will be logged, But create user will not be. Enable the parameter: SQL> show parameter enable_ddl_logging NAME TYPE VALUE ———————————— ———– —————————— enable_ddl_logging boolean FALSE SQL> alter system […]
Purge AUD$ Table Using DBMS_AUDIT_MGMT
Introduction:- Oracle 11gR2 introduced DBMS_AUDIT_MGMT for managing audit trails. The growth of AUD$ can impact the performance of the database. So purging it regularly is the best practice followed by DBA’s and DBMS_AUDIT_MGMT makes it easier. Follow below steps for purging aud$ table. 1. Make sure AUD$ table is not in SYSTEM table tablespace. […]