ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

Temporary tablespace is needed when Oracle needs to perform sorting, and doing so is not possible in the memory, therefore it utilizes temporary tablespace. ORA-01652 means that oracle needs to allocate space from temp tablespace and it is not able to do so because temp tablespace is full. Alert log file would log error as follows.

RMAN-08138: WARNING: archived log not deleted

Usually we do not need a backup of archived logs on standby site if backup is already configured on the primary database. In such scenario, if we try to delete old archived logs which have already been applied on the standby database my return “RMAN-08138: WARNING: archived log not deleted - must create more backups” if archive deletion policy is not properly set in the standby database.

ORA-01654 and ORA-03234 for index tablespace

When tables grow in size because of new data coming in, indexes also grow, and sometime indexes can grow even bigger as compare to table itself. There is a possibility that you see ORA-01654 while inserting/updating data because tablespace holding the index cannot be further extended and needs manual intervention to extend the tablespace so that index could further grow. Error would be returned to the application as well as reported in the alert log file.