Posted inOracle

Create Duplicate Database Using RMAN

Source Database Name is PRODDB Target (duplicate) Database name is MYDB  Source  Host Name     : server1.localdomain Target Host Name       : server2.localdomain Put Database in archivelog mode. SQL> archive log list; Database…
No Comments
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