Scripts Archives - ASRblogger

How to check FRA ( Fast Recovery area) Utilization in Oracle ?

Hey Folks , As a DBA, performing routine checks for fast recovery are (FRA) monitoring is a fundamental task. Here are some scripts that can assist in monitoring tablespace usage…

asrblogger November 18, 2024No Comments

Oracle Scripts

How to check Tablespace Utilization in Oracle ?

Hey Folks, As a DBA, performing routine checks for tablespace monitoring is a fundamental task. Here are some scripts that can assist in monitoring tablespace usage within the database. set…

asrblogger November 17, 2024No Comments

Oracle Scripts

How to Create & Delete Symbolic Link (Symlink)?

A symlink is a symbolic Linux/ UNIX is a special kind of file that points to another file on your machine/server, or a connected file system. It similar to a…

asrblogger September 14, 2024No Comments

DataGuard Oracle Scripts

Steps to Startup & Shutdown Oracle Data Guard !

To start a physical standby database, follow these steps using SQL*Plus with administrator privileges: Start the database in NOMOUNT mode: Use the STARTUP NOMOUNT command to initialize the standby database.…

asrblogger September 14, 2024No Comments

DataGuard Oracle Scripts

How to Check Sync between Primary & Standby DB ??

Primary --Check DB role (PRIMARY/STANDBY) SELECT DATABASE_ROLE, DB_UNIQUE_NAME AS INSTANCE, OPEN_MODE, PROTECTION_MODE, PROTECTION_LEVEL, SWITCHOVER_STATUS FROM V$DATABASE; DATABASE_ROLE INSTANCE OPEN_MODE PROTECTION_MODE PROTECTION_LEVEL SWITCHOVER_STATUS ---------------- ------------------------------ -------------------- -------------------- -------------------- -------------------- PRIMARY pvtnddb…

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

Core DBA DataGuard Oracle

Command to Check Archivelog Size

Oracle databases maintain a detailed history of all changes made to the database through archived redo logs, commonly known as archivelogs. These archivelogs are crucial for data recovery and are…

asrblogger July 9, 2024No Comments

Oracle Scripts SQL

How to Identify and Remove the duplicate rows in a Table?

In case if we want to identify duplicates rows of a table and want to remove them from a table. Below are the command which will identify and remove the…

asrblogger October 15, 2023No Comments

Linux Oracle Scripts

Monitoring System Performance Using SAR

SAR is used to collect, report or save system activity. SAR stands for System Activity Report. SAR is used to check Memory, CPU, system load, network, swap space utilization, etc.…

asrblogger September 15, 2023No Comments

Linux Oracle Scripts

Crontab : RMAN Backup

Automate RMAN Backup using Shell Script In a real environment, you will not manually trigger all the Oracle database backups. You need an automated mechanism to trigger RMAN backups. Create…