Oracle GoldenGate features can be demonstrated using a single computer and a single database instance. In this case, Oracle GoldenGate replication occurs between two different database schemas running on the same database instance. To make this arrangement possible, the Oracle GoldenGate software must be installed twice on the same computer/VM, in different directories, one dedicated […]
Articles Tagged: ORACLE 12C
Creation of Physical Standby in Oracle One Node
Introduction:- Data plays an important role in business operations on a day to day life. Without data, we can not perform our business operations. Data helps to generate business reports, With the help of data, all kind of business’s departments( Hr, Top management, Technical Departments, Accounts Departments etc.) can achieve their goals on time. Loss of data […]
Oracle RAC: Applying and Removing PSU in Database Home with Conflict Detection on Oracle 12c
In this article we will present how to apply and reverse a PSU applied to Database Home on a node with the conflict resolution method. To do this you need to have at least a 2-node RAC Database. If you want to patch on Grid Infrastructure Home in Oracle 12c then click here Our test environment: Grid […]
Oracle RAC – Applying and Removing PSUs in Grid Infrastructure Home with Conflict Detection (12.1.0.2.0)
In this article we will present how to apply and remove PSU in Grid Infrastructure Home on only one node using the conflict resolution method with roll forward method. To do this we need a RAC of at least 2 nodes. If you want to patch on Database Home in Oracle 12c then click here […]
Monitoring changes to Oracle tables
I must thank my fellow DBA Franky Weber Faust for his publication in his blog. The main purpose of this type of monitoring, in my opinion, is to know the most altered tables, the amount of changes in these tables since the last collection of statistics. Why since the last collection of statistics? Because every time a […]
Procedure for authorizing and disallowing users in Oracle Database Vault Realm
I must thank my fellow DBA Franky Weber Faust for his publication in his blog. Introduction: – In this article, we have look at the document the procedure required to authorize a user as a participant in the Oracle Database Vault Realm and then disallow it. All this procedure is possible through Enterprise Manager, but as it is […]
Rebuilding / Moving MGMTDB on Grid Infrastructure 12c
I must thank my fellow DBA Franky Weber Faust for his publication in his blog. In this article, we are going to know about how to rebuilding/moving MGMTDB on grid infrastructure 12c. Stop the ora.crf resource on each node in your cluster and disable it so that it does not start automatically: [root@rac1 ~]# crsctl […]
Deleting diskgroup via asmcmd
I must thank my fellow DBA Franky Weber Faust for his publication in his blog. The goal here is to show that via asmcmd it is also possible to remove a disk group. Let’s briefly see how to do this. We list the disk groups: [oracle@london1 ~]$ asmcmd ASMCMD> lsdg State Type Rebal Sector Logical_Sector Block […]
Rolling Forward Standby Database When Archives Missing In Primary In 12c
There can be situation , in dataguard setup, where archive logs are missing from primary , before it was being shipped to standby . Till 11g , we can make standby db sync with primary by taking an incremental backup from primary and apply the same in standby . But with 12c , a new […]
Move Datafile From File System To ASM Disk In 11g
Below steps need to be followed to move the datafile to ASM disk group. SOLUTION: 1. Make the datafile offline; SQL> select file_name from dba_data_files; FILE_NAME ——————————————————————————– +DATA/RAC2/DATAFILE/system.260.934026715 +DATA/RAC2/DATAFILE/sysaux.261.934026717 +DATA/RAC2/DATAFILE/undotbs1.262.934026719 +DATA/RAC2/DATAFILE/undotbs2.264.934026727 +DATA/RAC2/DATAFILE/users.265.934026729 /export/home/oracle/user02.dbf alter database datafile ‘/export/home/oracle/user01.dbf’ offline; 2. Connect to RMAN and copy datafile to ASM DISKGROUP RMAN> copy datafile ‘/export/home/oracle/user02.dbf’ to ‘+DATA/RAC2/DATAFILE/user02.db’; Starting backup […]