walunj11ganesh DATAGUARD, ORACLE

Convert Protection Mode in Dataguard

Changing protection mode in datagurad from MaxPerformance to MaxAvailability do not require bounce of database. To convert protection mode to MaxProtection there is requirement to take bounce of primary database so make sure you are doing it with planned downtime Make sure we have standby redo logfiles available at standby site before converting protection mode. … Continue reading Convert Protection Mode in Dataguard

walunj11ganesh DATAGUARD

ORA-19909: datafile 1 belongs to an orphan incarnation

Today when i am roll forwarding the Physical standby database came accross new issue for me. I followed the steps which required to roll forward. when doing switch database to copy after restoring control file getting error as system file require more recovery. Since it was not happenig i tried with alter database rename datafile, … Continue reading ORA-19909: datafile 1 belongs to an orphan incarnation

walunj11ganesh DATAGUARD

How to convert physical standby to snapshot standby database

1. on primary database select status,instance_name,database_role,open_mode from v$database,v$Instance; STATUS       INSTANCE_NAME    DATABASE_ROLE    OPEN_MODE ------------ ---------------- ---------------- -------------------- OPEN         DB11G_PRIM           PRIMARY          READ WRITE select thread#,max(sequence#) from v$archived_log group by thread#; THREAD# MAX(SEQUENCE#) ---------- -------------- 1            1135 2. on physical standby database select status,instance_name,database_role,open_mode from v$database,v$Instance; STATUS       INSTANCE_NAME    DATABASE_ROLE    OPEN_MODE ------------ ---------------- ---------------- ---------------- OPEN         DB11G_STND             PHYSICAL STANDBY … Continue reading How to convert physical standby to snapshot standby database