Monthly Archives: October 2022

STEP-1- Create Gateway Subnet Resource Group > VNET>SUBNETS> GATEWAY SUBNETS>ADD – 10.0.1.0/24 (Available Free Subnet). STEP-2 Create Gateway Create. SEARCH > VIRTUAL NETWORK GATEWAY> SELECT VIRTUAL NETWORK...

CONFIGURE LOG ANALYTICS PORTAL > CREATE > SEARCH LOG ANALYTICS> SELECT LOG ALALYTICS WORKSACE >CREATE> LOG ANALYTICS NAME- AZURE MONITORING EXISTING RESOURCE GROUP > PERGB LICENCE...

1) PREREQUISITES: Requirements before starting the DATA GUARD CONFIGURATION. NOTE: 1) In PRIMARY SERVER DG11 we need to install the BINARIES OF ORACLE 19c and then...

As an “Oracle DBA ” normally interviewer ask about ORA-01555 snapshot too old error.   What is Undo? Oracle Database maintain information that is used to roll back, or undo. Such...

Source Database Name is PRODDB Target (duplicate) Database name is MYDB  Source  Host Name     : server1.localdomain Target Host Name       : server2.localdomain Put Database in archivelog mode. SQL> archive log list; Database...

Check the status of ASM instance . SQL> SELECT INSTANCE_NAME,VERSION,STATUS FROM V$INSTANCE; INSTANCE_NAME VERSION STATUS ------------- -------- ---------------- +ASM ...

This guide will take you through the steps configure Oracle Grid Infrastructure 12c and Database 12c including RAC to RAC Data Guard and Data...

--Detach home /u01/grid/oracle/product/11.2.0.4/grid export ORACLE_HOME=/u01/grid/oracle/product/11.2.0.4/grid cd /u01/grid/oracle/product/11.2.0.4/grid/oui/bin ./detachHome.sh --Validate the home are detached cat /u01/oracle/product/oraInventory/ContentsXML/inventory.xml --Take a backup of below files cd /u01/grid/oracle/product/11.2.0.4/grid/crs/install cp s_crsconfig_enabl11_env.txt /home/oracle/s_crsconfig_enabl11_env_bkp.txt cp crsconfig_params /home/oracle/crsconfig_params_bkp.txt --Remove the files...

vi /home/oracle/scripts/lag_time_report_and_diskgroup_space.ksh #!/bin/ksh export ORACLE_SID=<Target_ORACLE_SID> export ORACLE_HOME=/u01/oracle/product/11.2.0.4/db /u01/oracle/product/11.2.0.4/db/bin/sqlplus -s / as sysdba << NACHO > /tmp/standbylag.log set feedback off select 'Standby thread '|| thread# || ' is '|| round((sysdate -...

Add the Target Database TNS entry to the Source's tnsnames.ora file(s) (all of them if it's a clustered Source) Set the log_archive_dest_<#> parameter on the...

On Source, as Oracle user: export ORACLE_SID=<source_sid> sqlplus '/as sysdba' alter system set log_archive_dest_state_<whatever_#_used>='DEFER' scope=both sid='*'; alter system set log_archive_dest_<whatever_#_used>='' scope=both sid='*'; alter system set log_archive_config='dg_config=(<only the db_unique_name's...

Top Wait Events: col EVENT format a60 select * from ( select active_session_history.event, sum(active_session_history.wait_time + active_session_history.time_waited) ttl_wait_time from v$active_session_history active_session_history where active_session_history.event is not null group by active_session_history.event order by 2 desc) where...

INFO INFO MANAGER Provides details of the Manager process INFO MGR Also provides details of the Manager process STATUS MANAGER This command also display the info of manager REFRESH REFRESH MANAGER Reloads from...

What is a data block corruption? Data block corruptions occur whenever data is not in its expected state. The block may have contents that are...

Normally in DR setup, the archives from primary shipped to standby and applied there. Suppose some of the archives hasn’t been shipped to secondary...

RMAN recovery catalog is separate DB/ Server and which will save only the details of your backups in terms of metadata of the backup. Whenever...

PROBLEM: When DGMGRL is used to create DG broker configuration it fails with below error : DGMGRL> connect sys Password: Connected to "<DB_UNIQUE_NAME>" Connected as SYSDBA. DGMGRL> Create configuration...

OPEN_CURSORS specifies the maximum number of open cursors (handles to private SQL areas) a session can have at once. You can use this parameter to...

Oracle Recovery Manager (RMAN) satisfies the most pressing demands of performance, manageable backup and recovery, for all Oracle data formats. RMAN  provides a common interface,...

Check the status of the cluster $ crsctl check crs CRS-4638: Oracle High Availability Services is online CRS-4537: Cluster Ready Services is online CRS-4529: Cluster...

1) Information of database (Primary & Standby). SQL> SELECT DATABASE_ROLE, DB_UNIQUE_NAME INSTANCE, OPEN_MODE, PROTECTION_MODE, PROTECTION_LEVEL, SWITCHOVER_STATUS FROM V$DATABASE; 2) To display current status for Physical Standby...