RAC BASIC

Posted on 1 CommentPosted in Uncategorized

RAC 11g useful commands Check the status of the cluster [oracle@rac1 ~]$ crsctl check crs CRS-4638: Oracle High Availability Services is online CRS-4537: Cluster Ready Services is online CRS-4529: Cluster Synchronization Services is online CRS-4533: Event Manager is online [oracle@rac1 ~]$ crsctl check cluster CRS-4537: Cluster Ready Services is online CRS-4529: Cluster Synchronization Services is […]

Partitioned Table Purging Live Steps

Posted on 1 CommentPosted in Uncategorized

create table archive.archive_tasks partition by range (TIME) (partition ARC_Pdefault values less than (to_date(’01-10-2008′, ‘DD-MM-YYYY’)) ) as select * from tasks where 1=2 ; create table archive.partition_holder_tasks as select * from TASKS where 1=2; alter table TASKS exchange partition Pdefault with table archive.partition_holder_tasks; alter table archive.archive_tasks exchange partition arc_pdefault with table archive.partition_holder_tasks; — Adding Partition alter […]

Table Partition Purging

Posted on 3 CommentsPosted in Uncategorized

sql> create table source_partitioned ( a number, b varchar2(1), c date) partition by range (c) ( partition p1 values less than (date ‘2017-01-01’) , partition pmax values less than (maxvalue) ); sql> create table target_partitioned ( a number, b varchar2(1), c date) partition by range (c) ( partition p1 values less than (date ‘2017-01-01’) , […]

Oracle Golden Gate

Posted on Leave a commentPosted in Uncategorized

GoldenGate enables us to extract and replicate data across a variety of topologies as shown the diagram below as well as the exchange and manipulation of data at the transactional level between a variety of database platforms like Oracle, DB2, SQL Server, Ingres, MySQL etc. It can support a number of different business requirements like: […]

Oracle 12c New Features

Posted on Leave a commentPosted in Uncategorized

Top 12 Features of Oracle 12C Summarized. Summary: The Oracle 12C means different things to different people. It all depends on which areas you are looking at, as there are improvements in many areas. Summarized below is the list of Top 12 Features of Oracle 12C as I see it. I have summarized below, the […]

Golden Gate

Posted on Leave a commentPosted in Uncategorized

Oracle GoldenGate is a comprehensive software package for real-time data integration and replication in heterogeneous IT environments. The product set enables high availability solutions, real-time data integration, transactional change data capture, data replication, transformations, and verification between operational and analytical enterprise systems. Oracle GoldenGate 12c brings extreme performance with simplified configuration and management, tighter integration […]