Flash recovery area full? Backups fail in delete archives after backup?
with this error
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
The root problem is in standby or oracle streams not working properly
you should check first if you can investigate because the problem not yet rise
a urgent service problem with any outage of resources.
For default since orcale 11 lot of UNLIMITED configurations of profile have change. Beyond version 10 FAILED_LOGIN_ATTEMPTS is set 10 as default value. In Oracle 11g onwards for DEFAULT profile PASSWORD_LOCK_TIME,PASSWORD_GRACE_TIME,PASSWORD_LIFE_TIME parameters are limited. Maybe you have suffered from and aplication that often lock user account or maybe new instalation or upgrade make some users account locked over time.
One day you face to create a very big table index, the creation time nearly 5-6 hours, but can we do something to speed up this index creation in Oracle database? yes, we can. Lets see some tips that help to speed up the task
and save lot of time.
One question: whats the most important task
for a DBA Administrator? three words, BACKUP,BACKUP,BACKUP.
Lets put hands of the most important task of a DBA …
Export/import? NO. this isnt the backup.
So lets take a look on Recovery Manager, normal called RMAN.
If you dont know what is that, how you do the backup?.
May occur when accessing LOB columns, even when the LOB RETENTION seems to be sufficient.
This may occur when LOB column resides in a MSSM (Manual Segment Space Management) tablespace.
But if no, because is AUTO, maybe undo_retention not good? no, LOBS no use that parameter and no use undo tablespace! more….