1 min read
Hey Folks , As a DBA, performing routine checks for fast recovery are (FRA) monitoring is a fundamental task. Here...
Scripts
1 min read
6 min read
Hey Folks, As a DBA, performing routine checks for tablespace monitoring is a fundamental task. Here are some scripts that...
2 min read
A symlink is a symbolic Linux/ UNIX is a special kind of file that points to another file on your...
2 min read
To start a physical standby database, follow these steps using SQL*Plus with administrator privileges: Start the database in NOMOUNT mode:...
6 min read
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...
1 min read
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...
2 min read
Oracle databases maintain a detailed history of all changes made to the database through archived redo logs, commonly known as...
1 min read
In case if we want to identify duplicates rows of a table and want to remove them from a table. ...
4 min read
SAR is used to collect, report or save system activity. SAR stands for System Activity Report. SAR is used to...
1 min read
Automate RMAN Backup using Shell Script In a real environment, you will not manually trigger all the Oracle database backups....
2 min read
Backup of the Oracle home can be taken using any preferred method. You can use any tool such as zip,...
5 min read
A profile is a collection of attributes that apply to a user.The profile is used to enable a single point...
6 min read
Many people ask these Questions, Q. How to identify which column is candidate for Index creation? Q. How to determine...
2 min read
This content is password protected. To view it please enter your password below: Password:
1 min read
RMAN> show all; CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS; RMAN> CONFIGURE RETENTION POLICY TO NONE; The REDUNDANCY...
8 min read
Oracle Recovery Manager (RMAN) satisfies the most pressing demands of performance, manageable backup and recovery, for all Oracle data formats....
9 min read
Check the status of the cluster $ crsctl check crs CRS-4638: Oracle High Availability Services is online CRS-4537: Cluster Ready...
4 min read
1) Information of database (Primary & Standby). SQL> SELECT DATABASE_ROLE, DB_UNIQUE_NAME INSTANCE, OPEN_MODE, PROTECTION_MODE, PROTECTION_LEVEL, SWITCHOVER_STATUS FROM V$DATABASE; 2) To...
2 min read
Oratop is a text based user interface tool similar to top command for monitoring basic database operations in real time...
Adding partitions 11g/12c -- SYNTAX : ALTER TABLE <SCHEMA_NAME>.<TABLE_NAME> ADD PARTITION <PARTITION_NAME> VALUES LESS THAN < HIGH_VALUE> TABLESPACE <TABLESPACE_NAME >...
2 min read
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 to check Index on a...
