Digital World Helping Hand

Hi Guys, Oracle Trace File Analyzer (TFA) is a powerful diagnostic tool which provides a number of diagnostic tools in a single bundle and making it easy to gather diagnostic information about the Oracle database and Clusterware, which in turn helps with problem resolution when dealing with Oracle Support. Download TFA Install TFA Run a TFA collection. Upload TFA collection to My Oracle Support (MOS) Download TFA. Download the latest version from here .  Install TFA This is recommended that TFA should be installed from " root " OS user which provides the most functionalities and allows it to run in a proactive manner as a daemon, or locally as the Oracle software owner. Here I did this from root to do proactive tool. Unzip the software, create a destination location and install the software using the "-local" flag (if not doing this for RAC). unzip command path is mandatory for installing the TFACTL Locating th...

Hi Guys Below major cloud service providers have following options for on-premise to cloud network connectivity. Cloud Service Network service Bandwidth up to Azure Express Route 10Gbps or more AWS Direct connect 10Gbps or more Oracle Corente 10Gbps or more Organizations are not limited to only a single cloud network provider's solution option. Furthermore, they’re not merely able to access valuable cloud resources via the Internet. Hence, a combination of the solutions to form a resilient, high-speed, high-availability, hybrid cloud network is required. In order to implement a connection from a private network space to a cloud network providers, below questions, should be asked: Will the connection be temporary or permanent? What is the capacity required? How resilient does it need to be? Where will the conne...

Hi Techies. Just a brainstorm about nologging / nologging concept in Oracle. This will help you to understand the concept and make sure you are using data guard always in FORCE logging mode, otherwise, Disaster Recover (DR) Oracle standby database may end up in data block corruption which is a serious problem in High Availability/secured databases environments. First of all, my test database is in ARCHIVE LOG mode, and not in database level FORCE LOGGING. Create a tablespace, test user, and table with default options along with inserting some records. SQL> archive log list Database log mode              Archive Mode Automatic archival             Enabled Archive destination            /oracle/SID/oraarch Oldest online log sequence     205 Next log sequence...

Hello Techies, This happens most of the time that you need to add/drop redo log groups in Oracle databases due to any administrative reasons, however, if candidate redo group is in ACTIVE status, then you can't drop it and DBA need to wait until this comes in INACTIVE status to become this group available from drop. Here is the trick. Current status of redo log groups in my test database and you can see highlighted groups in ACTIVE status. In this situation, if DBA need to modify/drop these groups he/she need to wait until this comes in INACTIVE status. SQL> select * from v$log;     GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TIME      NEXT_CHANGE# NEXT_TIME ---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------...