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
Below is the error while I was upgrading my test environment. SQL> alter pluggable database application CODDY begin upgrade ‘1.3’ to ‘1.4’; alter pluggable database application CODDY begin upgrade ‘1.3’ to ‘1.4’ ORA-65011: Pluggable database F3094217277_21_4 does not exist. ORA-65169: error encountered while attempting to copy file /opt/app/oracle/prd/coddy/users.dbf ORA-19502: write error on file “/opt/app/oracle/prd/coddy/datafile/o1_mf_users_gc8xyz9o_.dbf”, block … Read more
When you are taking backups regularly to a specified disk then after some period of time the backup disk will get full and you will need to delete old backups to make space for new backups. Usually you delete the old backups manually by following a particular rule like, deleting all the backups taken before … Read more
A checkpoint is an operation that Oracle performs to ensure data file consistency. When a checkpoint occurs, Oracle ensures all modified buffers are written from the data buffer to disk files. Frequent checkpoints decrease the time necessary for recovery should the database crash, but may decrease overall database performance. A checkpoint performs the following three … Read more
Sometimes the DBA requires to create the read-only user for a particular schemas.While creating the user,one should always keep in mind that the user should have minimum privileges. There is no any direct command to create the read-only user in oracle. Sometimes I find people grants “read any table ” privileges to create the read-only … Read more