How to check FRA ( Fast Recovery area) Utilization in Oracle ?
Hey Folks , As a DBA, performing routine checks for fast recovery are (FRA) monitoring…
Read moreScripts
How to check Tablespace Utilization in Oracle ?
Hey Folks, As a DBA, performing routine checks for tablespace monitoring is a fundamental task.…
Read moreHow to Create & Delete Symbolic Link (Symlink)?
A symlink is a symbolic Linux/ UNIX is a special kind of file that points…
Read moreSteps to Startup & Shutdown Oracle Data Guard !
To start a physical standby database, follow these steps using SQL*Plus with administrator privileges: Start…
Read moreHow to Check Sync between Primary & Standby DB ??
Primary Get standby redo log info: Monitor lag in standby including RAC Monitor recovery progress…
Read moreORA-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…
Read moreCommand to Check Archivelog Size
Oracle databases maintain a detailed history of all changes made to the database through archived…
Read moreHow 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…
Read moreMonitoring System Performance Using SAR
SAR is used to collect, report or save system activity. SAR stands for System Activity…
Read moreCrontab : RMAN Backup
Automate RMAN Backup using Shell Script In a real environment, you will not manually trigger…
Read moreScript Repositories (All in One…)
DBA-ScriptsDownload
Read moreHow to Perform ORACLE_HOME Backup?
Backup of the Oracle home can be taken using any preferred method. You can use…
Read moreProfiles
A profile is a collection of attributes that apply to a user.The profile is used…
Read moreHow to Decide if column should be indexed?
Many people ask these Questions, Q. How to identify which column is candidate for Index…
Read moreProtected: Database Link (DB Link)
There is no excerpt because this is a protected post.
Read moreARCHIVE AND OLD RMAN BACKUP REMOVAL
***************************FOR ARCHIVELOG****************************** $ df -h Filesystem Size Used Avail Use% Mounted on /dev/mapper/VolGroup-lv_root 57G 46G…
Read moreRMAN Basic Commands
Oracle Recovery Manager (RMAN) satisfies the most pressing demands of performance, manageable backup and recovery,…
Read moreRAC Basic Commands
Check the status of the cluster Check the status of the services on the cluster…
Read moreOracle Dataguard Scripts
1) Information of database (Primary & Standby). 2) To display current status for Physical Standby…
Read moreOratop Utility
Oratop is a text based user interface tool similar to top command for monitoring basic…
Read morePARTITIONING
Adding partitions 11g/12c Dropping partition 11g/12c Truncate partitions Merge partition Make a partition ready only…
Read moreDetermining the Size of Oracle database tables and indexes
Useful views to get index details: dba_indexes dba_segments dba_ind_columns dba_ind_partitions user_indexes user_segments user_ind_columns user_ind_partitions Query…
Read more