3D Journey Inside Axxana’s Phoenix Black Box

3D Journey Inside Axxana’s Phoenix Black Box

If you’ve wondered about the nuts and bolts that set Axxana’s Phoenix Black Box apart from any other disaster recovery solution, now’s your chance to find out. Axxana’s new animated video provides an insider’s view of the extensive, multi-layered protection that Axxana employs to ensure zero data loss and rapid recovery in worst-case scenarios. It’s a thrilling, two-minute ride that will leave you convinced that Axxana has covered all the contingencies of disaster recovery.

read more »

Change Listener Ports in RAC Environment

Look at the current port configured for the scan_listener: $ srvctl config scan_listener SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521 SCAN Listener LISTENER_SCAN2 exists. Port: TCP:1521 SCAN Listener LISTENER_SCAN3 exists. Port: TCP:1521 $ lsnrctl status LISTENER_SCAN1 LSNRCTL for Solaris: Version 11.2.0.4.0 – Production on 01-JAN-20** 21:26:16 Copyright (c) 1991, 2013, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1))) STATUS of the LISTENER

read more »
Starting the Oracle Data Guard Broker Observer in the Background

Starting the Oracle Data Guard Broker Observer in the Background

            Prior to Oracle 12.2, we had to find some homemade tricks to run the Observer in the background this way: $ nohup dgmgrl -silent sys/P@$$w0rd@prmy_db “start observer” & Finally, starting with Oracle 12.2, the Observer can run in the background using wallet authentication to connect to primary and standby databases and the Far Sync instance. For configuring the wallet, use the steps described in my post, Creating a wallet – secure external password store.

read more »
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 »
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 »