Core DBA Archives - ASRblogger

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

Core DBA Oracle

ORA-65011: Pluggable database does not exist.

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'…

asrblogger October 14, 2023No Comments

Core DBA Interview Questions Oracle

RMAN Retention Policy Based On Redundancy Policy

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…

asrblogger August 15, 2023No Comments

Core DBA Interview Questions Oracle

What is Checkpoint ?

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…

asrblogger February 5, 2023No Comments

Core DBA Interview Questions Oracle

Read-only user Creation.

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…