Environment Details Server Name : primegg.localdomain OS Version : Oracle Linux Server release 7 Database Version : 19.0.0.0 GoldenGate Version : 19.1.0.0.4 for oracle Oracle Home : /u01/app/oracle/product/19.0.0/dbhome_1 GoldenGate…
Read MoreStep-1: Check the SCN of Standby ( Data guard ) database and Find the lowest SCN from the following Queries. SQL> SELECT CURRENT_SCN FROM V$DATABASE; CURRENT_SCN -------------- 1165261 SQL> select…
Read MoreDescription: The backups feature of the Oracle Cloud Infrastructure Block Volume service lets you make a crash-consistent backup, which is a point in time snapshot of a boot volume without application interruption…
Read MoreDescription: This query used to check the generation of all redo during the time period. Script: select to_char(begin_interval_time,'YYYY_MM_DD HH24:MI') snap_time, dhsso.object_name, sum(db_block_changes_delta) from dba_hist_seg_stat dhss, dba_hist_seg_stat_obj dhsso, dba_hist_snapshot dhs where…
Read MoreIntroduction Usually to install database software we will use ./runInstaller graphical user interface. Some times we may not have access to a graphical user interface. Silent mode installation allows to…
Read MoreIntroduction: By default RMAN takes the backup as BACKUPSETS i.e. it combines of multiple datafiles into one or more backupsets.If you want to take the backup of datafiles as it…
Read MoreIntroduction: There are different methods to upgrade an Oracle database from a lower version to a higher version. Oracle provides multiple methods to upgrade based on the version. A few…
Read MoreDESCRIPTION This article we are going to see steps to apply the latest Oracle 19c Database Release Update Patch 32218454 DOWNLOAD THE PATCH FROM ORACLE SUPPORT CHECK THE CURRENT OPTACH…
Read MoreDESCRIPTION: In this blog,we are going to learn Oracle Database Cloning. INTRODUCTION: The cloning operation creates a copy of the database data files, and creates new online redo log files…
Read MoreDESCRIPTION: In this blog,we are going to resolve ORA-01157 error in database. Cause: The background process was either unable to find one of the data files or failed to lock…
Read More