Posted inASM Oracle

Migrate Non-ASM to ASM instance in 12c

Check the status of ASM instance . SQL> SELECT INSTANCE_NAME,VERSION,STATUS FROM V$INSTANCE; INSTANCE_NAME VERSION STATUS ------------- -------- ---------------- +ASM 12.1.0.2.0 STARTED Check the database version and its status. SQL> SELECT NAME,OPEN_MODE…
No Comments
Posted inDataGuard Oracle

Monitor Standby Database with Lag Time Report

vi /home/oracle/scripts/lag_time_report_and_diskgroup_space.ksh #!/bin/ksh export ORACLE_SID=<Target_ORACLE_SID> export ORACLE_HOME=/u01/oracle/product/11.2.0.4/db /u01/oracle/product/11.2.0.4/db/bin/sqlplus -s / as sysdba << NACHO > /tmp/standbylag.log set feedback off select 'Standby thread '|| thread# || ' is '|| round((sysdate -…
No Comments
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