Home 2022 October

Monthly Archives: October 2022

man holding ice cream cone under cloud

Azure : Create Gateway Subnet

0
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...
man holding ice cream cone under cloud

Protected: AZURE MONITORING – VIA LOG ANALYTICS

0
CONFIGURE LOG ANALYTICS PORTAL > CREATE > SEARCH LOG ANALYTICS> SELECT LOG ALALYTICS WORKSACE >CREATE> LOG ANALYTICS NAME- AZURE MONITORING EXISTING RESOURCE GROUP > PERGB LICENCE...
Landsat Data Continuity Mission Environmental Testing is Underway

Protected: Step by Step Data Guard Configuration in 19c

0
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...
yellow scrabble tiles

Undo Tablespace & ORA-01555 snapshot too old error..!!

0
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...

Create Duplicate Database Using RMAN

0
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...
black internal hdd on black surface

Migrate Non-ASM to ASM instance in 12c

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

Protected: 2 node RAC with Dataguard Configuration (DGMGRL)

0
This guide will take you through the steps configure Oracle Grid Infrastructure 12c and Database 12c including RAC to RAC Data Guard and Data...
NASA Prepares for Green Run Testing, Practices Lifting SLS Core Stage

How To Run SQL Tuning Advisor For A Sql_id

0
When we run SQL tuning advisor against a SQL statement or sql_id, it provides tuning recommendations that can be done that query to improve...
people space apple industry

Protected: Fixing Corrupted Grid Home

0
--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...

Protected: srvctl related configurations

0
--add database to GRID and create the service, for example: srvctl add database -d cm1919 -i cm19191 -o $ORACLE_HOME -p "+M1919_DG1/m1919/spfilecm1919.ora" -a "M1919_DG1,M1919_DG_FLASH" -m world...
a close up shot of a command key

Protected: Monitor Standby Database with Lag Time Report

0
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 -...
person writing on notebook

Protected: Configure MRP in Standby

0
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...
a close up shot of a command key

Protected: De-configure MRP in Standby

0
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...

RollForward Standby Database using rman service

0
Overview:As we are already aware that the rolling forward an physical standby database via an incremental SCN based backup method is one of the easiest way of getting your standby database with lag into sync with the primary database.The lag can be due to missing archives on the primary which...
a close up shot of a command key

Protected: Performance Tuning Scripts.

0
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...
a close up shot of a command key

GGSCI Command for GoldenGate

0
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...
black internal hdd on black surface

Recover Block Corruption

0
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...

Resync Standby Database Using RMAN Incremental Backups

0
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...
black blue and red graph illustration

RMAN Recovery Catalog in Oracle

0
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...
white ruled notebook

ROWNUM Pseudocolumn

0
The ROW_NUMBER built-in SQL function provides superior support for ordering the results of a query. ROW_NUMBER is an analytic function. It assigns a unique number...
yellow scrabble tiles

ORA-16525: DGMGRL Create Configuration Failing

0
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...
yellow scrabble tiles

How to fix ‘ORA-01000 maximum open cursors exceeded’ issue in Oracle database

0
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...
a close up shot of a command key

RMAN Basic Commands

1
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,...
a close up shot of a command key

RAC Basic Commands

0
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...
a close up shot of a command key

Oracle Dataguard Scripts

0
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...