Recent Posts

ORA-16853: apply lag has exceeded specified threshold

I got the below error in one of my standby environment. Error - ORA-16853: apply lag has exceeded specified threshold ...
Read More

ORA-16857: member disconnected from redo source for longer than specified threshold

In one of my dataguard environment I got the Error: ORA-16857: member disconnected from redo source for longer than specified ...
Read More

ORACLE error from auxiliary database: ORA-19527: physical standby redo log must be renamed

On standby side, you may encountered the Error "ORACLE error from auxiliary database: ORA-19527: physical standby redo log must be ...
Read More

ORA-19527: physical standby redo log must be renamed

On standby side, you may encountered the Error "ORA-19527: physical standby redo log must be renamed" in the alert log ...
Read More

ORA-65093: multitenant container database not set up properly

While starting a container database or mounting a standby container database you may encountered Error: ORA-65093: multitenant container database not ...
Read More

Enable Flashback Database on Oracle 12c

In this article we will describe the step by step instructions on how to enable flashback on Oracle 12c database ...
Read More

ORA-19802: cannot use DB_RECOVERY_FILE_DEST without DB_RECOVERY_FILE_DEST_SIZE

You might encounter ORA-19802 error while setting DB_RECOVERY_FILE_DEST Error: SQL> alter system set db_recovery_file_dest='/u01/app/oracle/fra'; alter system set db_recovery_file_dest='/u01/app/oracle/fra' * ERROR ...
Read More

ORA-16179: incremental changes to “log_archive_dest_1” not allowed with SPFILE

You might encounter ORA-16179 error during updating the archive log destination. Error Details: SQL> alter system set log_archive_dest_1='/u01/app/oracle/arch'; alter system ...
Read More
ASM Storage migration

Migrate ASM Diskgroup to another storage

In this post I will describe in step by step how to Migrate Oracle ASM Diskgroups to another Storage in ...
Read More
Connect to Autonomous db using sqlplus

Connect to Autonomous Database using SQLPlus

In this post I will describe how to connect to Autonomous Database using SQL*PLUS Steps: Connecting to Autonomous Database using ...
Read More