I'm Top Oracle DBA

Category Archives: HA

Step by Step to Open Physical Standby on Oracle Database 11G

|

This article shows how to open a database on Physical Standby (Read only with Apply or Active Data Guard) On Physical Standby SQL> archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination /home/oracle/arch Oldest online log sequence 64 Next log sequence to archive 0 Current log sequence 64 SQL> select DBID,NAME,LOG_MODE,OPEN_MODE,SWITCHOVER#,DATABASE_ROLE,SWITCHOVER_STATUS,DATAGUARD_BROKER,GUARD_STATUS,DB_UNIQUE_NAME […]

Step by Step to Switchover on Oracle Database 11G

|

This article shows the Step of switchover from Physical standby to primary database on Oracle Database 11G. Mention They have downtime actually do at primary first Step Check the archive and role database on both sites (Primary and Standby) Switchover (start with the primary) Test a little bit of Transaction on the New Primary Switchover […]

Data Guard Physical Standby Setup in Oracle Database 11g

|

Data guard is Technology by Oracle, used for disaster recovery and high availability so Data guard, They have many ways to implement but This article contains Manual steps and Duplicate steps. Step to set Data Guard the setting connection between primary and standby (listener.ora and tnsnames.ora) On Primary check archive log mode set up parameter […]

error: Content is protected !!