Skip to content

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

  • by
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

Leave a Reply

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