Extract Data Guard Commands on Oracle 12.2

Extract Data Guard Commands on Oracle 12.2

  Hi, These days I’m starting to work on Oracle 12.2, leaving behind the old versions. Since my main domain is Oracle Data Guard, I posted a blog about Oracle 12c Release 2 New Features for Active Data Guard. One of the big new features I missed is that the internal Data Guard Broker configuration was changed dramatically in 12.2. Last week, I tried to Extract Data Guard Commands and realized it is not working as before, 🙁 so I sat down and adjusted it to work on 12.2. This time, I enhanced the output with some more important information.

read more »
Coloring alert.log Output via Tail and Less

Coloring alert.log Output via Tail and Less

To make my day-to-day job easier and more convenient, I like having some utilities and aliases. We, the DBA nation, need to look at the alert.log file frequently. So, basically, I did the following: Created a script to tail my alert.log file Colored the important words Added an alias to the script

read more »
Grid Autostart

Grid Autostart

Hi, Checking if the database resource is configured to restart automatically after reboot / shutdown of the host / cluster: $ crsctl stat res ora.fdb1.db -f |grep AUTO_START AUTO_START=restore Restore means that after restart

read more »
Axxana Shares Best Practices for Optimizing Disaster Recovery in Oracle 12c Environments

Axxana Shares Best Practices for Optimizing Disaster Recovery in Oracle 12c Environments

The Axxana Engineering team recently performed research to see which configurations provide the best performance in Oracle 12c disaster recovery environments. Alain Azagury, Axxana’s VP of R&D, reviewed highlights of this experimentation with colleagues at NoCOUG. The presentation, titled Squeezing the Max out of Oracle 12c Disaster Recovery, was very well received. We’re sharing the recording here so that others can take advantage of the findings.

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