Monthly Archives: October 2022
Azure : Create Gateway Subnet
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...
Protected: AZURE MONITORING – VIA LOG ANALYTICS
CONFIGURE LOG ANALYTICS
PORTAL > CREATE > SEARCH LOG ANALYTICS> SELECT LOG ALALYTICS WORKSACE >CREATE> LOG ANALYTICS NAME- AZURE MONITORING
EXISTING RESOURCE GROUP > PERGB LICENCE...
Protected: Step by Step Data Guard Configuration in 19c
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...
Undo Tablespace & ORA-01555 snapshot too old error..!!
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
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...
Migrate Non-ASM to ASM instance in 12c
Check the status of ASM instance .
SQL> SELECT INSTANCE_NAME,VERSION,STATUS FROM V$INSTANCE;
INSTANCE_NAME VERSION STATUS
------------- -------- ----------------
+ASM ...
Protected: 2 node RAC with Dataguard Configuration (DGMGRL)
This guide will take you through the steps configure Oracle Grid Infrastructure 12c and Database 12c including RAC to RAC Data Guard and Data...
How To Run SQL Tuning Advisor For A Sql_id
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...
Protected: Fixing Corrupted Grid Home
--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
--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...
Protected: Monitor Standby Database with Lag Time Report
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 -...
Protected: Configure MRP in Standby
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...
Protected: De-configure MRP in Standby
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
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...
Protected: Performance Tuning Scripts.
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...
GGSCI Command for GoldenGate
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...
Recover Block Corruption
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
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 in Oracle
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...
ROWNUM Pseudocolumn
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...
ORA-16525: DGMGRL Create Configuration Failing
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...
How to fix ‘ORA-01000 maximum open cursors exceeded’ issue in Oracle database
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...
RMAN Basic Commands
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,...
RAC Basic Commands
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...
Oracle Dataguard Scripts
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...