Data Guard

Building a Physical Standby Database (13/14) – Configure data guard broker

Posted on
Building a Physical Standby Database (12/14) – Recover managed standby databaseIf you have ever used the broker to switchover, failover, switch apply instance, on and off transportation service or apply service, or fast-start failover, you would never miss the manual command. Therefore, the data guard broker is a nice-to-have function.Before configuring the data guard broker, […]
Data Guard

Building a Physical Standby Database (11/14) – Create spfile for both primary and standby database

Posted on
Building a Physical Standby Database (10/14) – Create standby redo logs on standby databaseSince the two pfiles are ready in the step 3, we can use them to create spfiles for the primary and standby database.On primary database.[oracle@primary01 ~]$ srvctl stop database -d compdb[oracle@primary01 ~]$ sqlplus / as sysdba…SQL> create spfile=’+data/compdb/spfileprimdb.ora’ from pfile=’/tmp/init-prim.ora’;File created.SQL> exit;…[oracle@primary01 […]
Data Guard

Building a Physical Standby Database (10/14) – Create standby redo logs on standby database

Posted on
Building a Physical Standby Database (09/14) – Copy standby controlfile into standby databaseBefore we create standby redo logs, lets restart the standby database to mount and check the current database role.[oracle@standby01 ~]$ srvctl stop database -d compdb[oracle@standby01 ~]$ srvctl start database -d compdb -o mount[oracle@standby01 ~]$ sqlplus / as sysdba…SQL> select inst_id, open_mode, database_role from […]
Data Guard

Building a Physical Standby Database (09/14) – Copy standby controlfile into standby database

Posted on
Building a Physical Standby Database (08/14) – Copy data files into standby databaseCopying a standby controlfile into the standby database is the same as copying individual data files into a standby database. So here we introduce only RMAN operations.Copy the standby controlfile from the primary server to either node of the standby RAC.[oracle@primary01 ~]$ scp […]
Data Guard

Building a Physical Standby Database (06/14) – Prepare standby controlfile on primary database

Posted on
Building a Physical Standby Database (05/14) – Create standby redo logs on primary databaseYou cannot copy a control from the primary database directly, it does not work, you can only generate a controlfile dedicated for a standby database from a primary database.Three methods can get the file.Generate manually.[oracle@primary01 ~]$ sqlplus / as sysdba…SQL> alter database […]
Data Guard

Building a Physical Standby Database (04/14) – Enable force logging and archivelog on primary database

Posted on
Building a Physical Standby Database (03/14) – Prepare pfile for both primary and standby databaseFor reflecting and tracking all the changes on the primary database and transport these changes to the standby database, FORCE LOGGING and ARCHIVELOG mode must be enabled.[oracle@primary01 ~]$ srvctl stop database -d compdb[oracle@primary01 ~]$ srvctl start database -d compdb -o mount[oracle@primary02 ~]$ […]