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 within the database. Hope it helped !! 
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. Track all Tablespaces with free space < 10% Check Tablespace Utilization in Multitenant Database Hope it helped !!
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 shortcut in WindowsOS. Unlike a hard link, a symbolic link does not contain the data in the target file. It simply points to another entry … Read more
To start a physical standby database, follow these steps using SQL*Plus with administrator privileges: Start the database in NOMOUNT mode: Mount the standby database: Start managed recovery (optional): Start the DB with SRVCTL commands– SYNTAX FOR START DBsrvctl start database -d db_name [-o start_options] where start_option is nomount/mount/open(default)e.gsrvctl start database -d CERTDB -o nomountsrvctl start … Read more
Primary Get standby redo log info: Monitor lag in standby including RAC Monitor recovery progress in standby DB Hope it helped !!
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 2. Check the datafiles size and path present in respective tablespace: 4. Give a Log Switch and monitor the Alert Log:
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 often managed by database administrators. Monitoring the size of archivelogs is essential to ensure optimal database performance and sufficient storage capacity. Here are some ways … Read more
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 duplicare rows from a Table. 1.) Identify duplicates Here 251 duplicates exist – these can be deleted with command below : 2.) Removing the Rows … Read more
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. It uses a proc file system to collect the information. The sar command writes to standard output the contents of selected cumulative activity counters in … Read more
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 directory On your database server, create a directory to hold RMAN backups and all related files. All the RMAN backups, logs and backup scripts are … Read more