ASM Archives - ASRblogger

Reinstate or Recreate Standby DB after Failover

Reinstate Previous Primary DB as standby after Failover completed Fast_start failover initiated by Oracle: Oracle will try to reinstate old primary db as new standby. In case of failure (corrupted…

Anish Kumar January 29, 2026No Comments

ASM DataGuard Oracle

Approach for Troubleshooting Oracle Database Unavailability in a Production Environment

Quickstart When an Oracle Database becomes unavailable in a production (PRD) environment, troubleshooting should follow a structured and non-destructive approach to preserve evidence and avoid data loss. 1. Capture the…

Anish Kumar January 29, 2026No Comments

ASM

Optimizer Statistics in Oracle 19c

Introduction Oracle optimizer cost model relies on statistics collected about the objects involved in a query. The query optimizer uses these statistics to choose the execution plan with the lowest cost, so up-to-date optimizer…

Anish Kumar January 29, 2026No Comments

ASM Oracle

How to Rename ASM Diskgroup ??

Hey Folks, Today I faced an issue while configuring Oracle DR setup which was due to different diskgroup present in primary (DGDATA) and standby (DATA). While running Active duplicate command…

asrblogger September 14, 2024No Comments

ASM Core DBA Oracle

ORA-1654: unable to extend index in tablespace

From Alert logs ORA-1654: unable to extend index SCHEMA.IN021S1 by 128 in tablespace TBS_012024-03-23T16:26:11.156475+05:30ORA-1654: unable to extend index SCHEMA.IN021S1 by 128 in tablespace TBS_012024-03-23T16:26:19.194628+05:30 Find the status of tablespace details…

asrblogger July 9, 2024No Comments

ASM Oracle

INS-30502 No ASM Disk Group Found.

After successfully installing Grid Infrastructure with the "grid" user, I attempted to install Oracle Database 19c Release 3 using the "oracle" user. However, during the installation process, I encountered an…

asrblogger April 5, 2024No Comments

ASM Oracle

Background Processes in Oracle ASM

Once the ASM instance is started, all the basic background processes, as well as some that are specific to the operation of ASM, are started. On Linux, the ASM processes…

asrblogger March 13, 2023No Comments

ASM Oracle RAC

Step by Step ASM/ Grid Installation in Oracle RAC

Grid-Installation-ASRBLG-1Download Hope it helped !! :)

asrblogger December 30, 2022No Comments

ASM Oracle RAC

Step by Step ASM/ Grid Installation in Oracle Standalone

Prerequisite. Add below OS groups Add asmdba as secondary group to Oracle user Create Grid User [root@dg11 /]# useradd -u 54331 -g oinstall -G dba,asmdba,asmoper,asmadmin,racdba grid Change the password for…

asrblogger November 19, 2022No Comments

ASM Oracle

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 12.1.0.2.0 STARTED Check the database version and its status. SQL> SELECT NAME,OPEN_MODE…

asrblogger October 19, 2022No Comments

thank your for this article, keep up the good work

Thank you! I’m glad you found the articles and reviews informative, it motivates me to keep sharing quality content.

Really appreciate your feedback!

Thank you for taking the time to read it! I’m glad you found it helpful.

I really appreciate that! I believe detailed reviews help the community most, so happy it resonated.

Reinstate or Recreate Standby DB after Failover

Approach for Troubleshooting Oracle Database Unavailability in a Production Environment

Optimizer Statistics in Oracle 19c

How to Rename ASM Diskgroup ??

ORA-1654: unable to extend index in tablespace

INS-30502 No ASM Disk Group Found.

Background Processes in Oracle ASM

Step by Step ASM/ Grid Installation in Oracle RAC

Step by Step ASM/ Grid Installation in Oracle Standalone

Migrate Non-ASM to ASM instance in 12c

Trending Topics.

Get the Latest Blogging Tips Straight to Your Inbox!