Oracle GoldenGate and Encrypted Tablespaces (TDE) in 11.2
To make GG work with encrypted tablespaces you have to apply database patch: Patch 10395645 for Oracle 11.2.0.2. mkstore -wrl ./ -createEntry ORACLE.SECURITY.CL.ENCRYPTION.ORACLEGG Supply shared secret for GG ( not wallet password).Last step is to supply wallet password.Copy ewallet.p12 file to other nodes ( if running RAC but not sharing wallet location ). Do not … Read more
Oracle GoldenGate version 11.1.1.1 released
After long wait Oracle finaly relesed new Oracle GoldenGate version 11.1.1.1 which supports encrypted tablespaces. To download it click on the link below: https://edelivery.oracle.com/EPD/Download/get_form?egroup_aru_number=13730870 Also there is new documentation for this release: http://download.oracle.com/docs/cd/E22355_01/index.htm About Replicating TDE-encrypted data Oracle GoldenGate supports the Transparent Data Encryption (TDE) at the column and tablespace level. ● Column-level encryption is … Read more
Role-Based Database Service
Starting with 11.2 role based services are managed by Clusterware. For previous releases we had to use after db_role_change trigger.That is no longer required. So in the past : /* Create Service */ exec DBMS_SERVICE.CREATE_SERVICE(service_name =>’taf’,network_name =>’taf’,aq_ha_notifications =>true,failover_method =>’BASIC’,failover_type =>’SELECT’,failover_retries =>180,failover_delay => 5); and have database trigger to start service in case database role switch … Read more
Manual Switchover involving RAC 11g using SQL*Plus
1. Verify that it is possible to perform a switchover operation. On the primary query the switchover_status column of v$database to verify that switchover to standby is possible. SQL> select switchover_status from v$database; SWITCHOVER_STATUS —————— TO STANDBY ( or SESSIONS ACTIVE is also ok) SESSIONS ACTIVE – Indicates that there are active SQL sessions attached … Read more
Snapshot Standby
Converting physical standby to snapshot standby Depens on Data guard configuration change protection mode: On Primary database: SQL> ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCE ; SQL> alter system archive log current; Use these queries to check synchronization between primary and standby: Primary: SQL> select thread#, max(sequence#) “Last Primary Seq Generated” from v$archived_log val, … Read more
