Posted inDataGuard Oracle

De-configure MRP in Standby

On Source, as Oracle user: export ORACLE_SID=<source_sid> sqlplus '/as sysdba' alter system set log_archive_dest_state_<whatever_#_used>='DEFER' scope=both sid='*'; alter system set log_archive_dest_<whatever_#_used>='' scope=both sid='*'; alter system set log_archive_config='dg_config=(<only the db_unique_name's needed>)' scope=both…
No Comments
Posted inDataGuard Oracle

RollForward Standby Database using rman service

Overview:As we are already aware that the rolling forward an physical standby database via an incremental SCN based backup method is one of the easiest way of getting your standby database with lag into sync with the primary database.The lag can be due to missing archives on the primary which haven’t been shipped or applied on the standby.In 12c, this…
No Comments
Posted inOracle

Recover Block Corruption

What is a data block corruption? Data block corruptions occur whenever data is not in its expected state. The block may have contents that are not internally consistent, or it…
No Comments
Posted inOracle SQL

ROWNUM Pseudocolumn

The ROW_NUMBER built-in SQL function provides superior support for ordering the results of a query. ROW_NUMBER is an analytic function. It assigns a unique number to each row to which…
No Comments