Category Archives: Sin categoría

RMAN-08137: WARNING: archived log not deleted, needed for standby

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.

Continue reading

Advertisements

Default Profile Locks Users Accounts?

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.

Continue reading

Fast Index Creation, Save your 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.

Continue reading

RMAN Mini Guide

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?.

Continue reading

Solution to: ORA-1555/ORA-22924 on export with a LOB data 

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

Continue reading