Log Mining a Redo Log File / Archive Log File on a Remote Database

Log Mining a Redo Log File / Archive Log File on a Remote Database

At the source site Enable the database to write to a directory you choose. In this example, I use /tmp: alter system set utl_file_dir=’/tmp’ scope=spfile;  Restart of the database is required in order for the parameter utl_file_dir to be active. Extract the LogMiner dictionary to a flat file called dictionary.ora: lEXECUTE DBMS_LOGMNR_D.BUILD(‘dictionary.ora’, ‘/tmp/’, DBMS_LOGMNR_D.STORE_IN_FLAT_FILE);  

read more »
Resolve tns Alias from the Database (DBMS_TNS.RESOLVE_TNSNAME)

Resolve tns Alias from the Database (DBMS_TNS.RESOLVE_TNSNAME)

When a given tns alias is not working via SQL*Plus, a database link, or within Data Guard, I traditionally troubleshoot connectivity via the tnsping utility—at first just to understand the target host, port, and service name. In Oracle 12.2, we have a new function called DBMS_TNS.RESOLVE_TNSNAME that enables us to query the return string as we receive it from tnsping.

read more »
Tuning Far Sync for Optimal Performance – Part 1

Tuning Far Sync for Optimal Performance – Part 1

The quest for optimal performance is never-ending. By optimizing performance, DBAs not only improve the databases’ speed of service delivery, but also positively impact the applications that run the enterprise’s core business. To that end, Axxana’s research team has just released   of a series of technical notes on tuning Oracle’s Far Sync for optimal performance with the Phoenix for Oracle Far Sync environment.

read more »

New Webinar Explains How to Improve Oracle Far Sync Performance

The Axxana Research & Development team has spent a lot of time testing Oracle Active Data Guard Far Sync and figuring out how to achieve optimal performance in Far Sync environments. A recent webinar, hosted by Alain Azagury, Axxana’s VP of Research & Development, reviews highlights of this experimentation and dives into the use of specific cache configurations to improve IO performance.

read more »
Far Sync for Oracle 12.1 – Best Practices

Far Sync for Oracle 12.1 – Best Practices

This post is a continuation of my post, Using Standby as an Alternate for Far Sync (12c): Limitations and Considerations. It is for database administrators who want to set up Far Sync for the first time. Creating a Far Sync instance requires a number of manual steps and there are many parameters to consider or set. The Axxana team recently ran numerous scenarios using Oracle™ Active Data Guard with a Far Sync instance. Our goals were to: Check Far Sync functionality and reliability Validate that Far Sync has a low footprint under heavy load

read more »
Data Guard – Changing IP Addresses

Data Guard – Changing IP Addresses

          Hi, When changing IP address of a host, we should update/recheck the following places: /etc/hosts or DNS listener.ora tnsnames.ora Database parameters (local_listener, remote_listener) Data Guard configuration This document is also relevant when changing the IP address of the connection between the hosts, other than the original IP addresses we used during the installation. When installation is done using the hostname and not the IP address, most of the changes are not relevant except for /etc/hosts. In this document, I will describe how to change the Data Guard Broker configuration.

read more »
List RMAN Backups Size

List RMAN Backups Size

SQL Script for Calculating the Total Size of RMAN Backups col TYPE for a20 Heading “Backup Type” col completion_time Heading “Completion Time” col MB for 99999999999 Heading “Size (MB)” col BCPTIME for 99999999999 Heading “Backup Time (minutes)” SELECT TO_CHAR (completion_time, ‘YYYY-MON-DD’) completion_time , TYPE , ROUND (SUM (bytes) / 1048576) MB , ROUND (SUM (elapsed_seconds) / 60) BCPTIME FROM (SELECT CASE WHEN s.backup_type = ‘L’ THEN ‘Archive Log’ — WHEN s.controlfile_included = ‘YES’ THEN ‘Control File’ WHEN s.backup_type = ‘D’ THEN ‘Full (Level ‘ || NVL (s.incremental_level, 0) || ‘)’ WHEN s.backup_type = ‘I’ THEN ‘Incemental (Level ‘ || s.incremental_level || ‘)’ ELSE s.backup_type END TYPE , TRUNC (s.completion_time) completion_time , p.tag , p.bytes , s.elapsed_seconds FROM v$backup_piece p, v$backup_set s WHERE status = ‘A’ AND p.recid = s.recid UNION ALL SELECT ‘Datafile Copy’ TYPE, TRUNC (completion_time), tag, output_bytes, 0 elapsed_seconds FROM v$backup_copy_details) GROUP BY tag, TO_CHAR (completion_time, ‘YYYY-MON-DD’), TYPE ORDER BY 1 ASC, 2, 3;

read more »
Oracle Connection Manager

Oracle Connection Manager

  Connection manager is working as oracle SQL*NET proxy and firewall. In this example, I am using Connection Manager of Oracle Database 12c Release 2 running on Linux x86_64 Footprint Storage: 1.7 G Memory: 5~28.4 MB Requires: Installation of Oracle Client in a separated folder than the database software Register the connection manager in the grid infrastructure as a cluster resource

read more »