Problem: After patching an Oracle 19.8 GRID_HOME on Oracle Restart setup with 19.20 RU patch [35319490], I was not able to start up Oracle Restart HAS due to mentioned error.…
Read MoreIn this case how to open your standby database in read/write mode when you don’t have any access (Lost) on Primary database. NOTE: Currently both Primary and Standby database are…
Read MoreINTRODUCTION What is scan name for Oracle database? Single Client Access Name (SCAN) is a feature used in Oracle Real Application Clusters environments that provides a single name for clients to…
Read More1.To Display the execution plan of the last SQL statement executed by the current session SET LINESIZE 150 SET PAGESIZE 2000 SELECT * FROM table (DBMS_XPLAN.DISPLAY_CURSOR); 2.To display the execution…
Read MoreEnvironment 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 More