asrblogger, Author at ASRblogger

Voting Disk in Oracle RAC

Voting disks manage information about node membership. Each voting disk must be accessible by all nodes in the cluster for nodes to be members of the cluster1. You can store…

asrblogger February 18, 2026No Comments

Oracle RAC

Oracle Local Registry (OLR) in RAC

Oracle Clusterware includes three components: voting disks, Oracle Cluster Registry (OCR), and Oracle Local Registry (OLR). ■ Voting disks manage information about node membership. Each voting disk must be accessible…

asrblogger February 18, 2026No Comments

Oracle

Cursor Sharing in Oracle

Private SQL area holds information about a parsed SQL statement and other session specific information for processing. When a server process executes SQL or PL/SQL code, the process uses the…

asrblogger February 1, 2026No Comments

DataGuard Oracle RAC

Resizing redo logs and standby Redologs in Dataguard

IN PRIMARY DATABASE :- 1) Check Instance details :- select status,instance_name,database_role from v$database,v$instance; ------------------------------------------------------------------------------------------------------------------------------------ 2) Check redo log and standby redo log size in Primary and standby :- Redo log…

asrblogger March 22, 2025No Comments

DataGuard Oracle

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 .But due to intermittence error or…

asrblogger March 21, 2025No Comments

DataGuard Oracle

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 then create only 1 PRIMARY…

asrblogger March 20, 2025No Comments

DataGuard Oracle

Switchover to Physical Standby Database in Oracle !!

Once the standby database is configured and verified to be working properly, we can switch over to the standby database for testing purposes. This helps to minimize downtime for the…

asrblogger March 15, 2025No Comments

DataGuard Oracle

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 Broker configuration in a Primary and…

asrblogger February 19, 2025No Comments

Oracle

Step by Step Oracle Database 23ai Installation on Oracle Linux 8.10 !!

Oracle Database 23ai is the next long-term support release of Oracle Database. It includes over 300 new features with a focus on artificial intelligence (AI) and developer productivity. Oracle Database…

asrblogger January 14, 2025No Comments

Oracle

Create Pluggable Database (PDB) Manually Using SQL Prompt Oracle 19c !!

Use the CREATE PLUGGABLE DATABASE statement to create a pluggable database (PDB). This statement enables you to perform the following tasks: Create a PDB by using the seed as a template. Use the create_pdb_from_seed clause to…