Skip to content
Home » Oracle » Building a Physical Standby Database (04/14) - Enable force logging and archivelog on primary database

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

Building a Physical Standby Database (03/14) - Prepare pfile for both primary and standby database
For 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 ~]$ sqlplus / as sysdba
...
SQL> ALTER DATABASE FORCE LOGGING;

Database altered.

SQL> ALTER DATABASE ARCHIVELOG;

Database altered.
Building a Physical Standby Database (05/14) - Create standby redo logs on primary database
Tags:

Leave a Reply

Your email address will not be published. Required fields are marked *