Time for action – enabling force logging

Perform the following steps on the primary database:

1. Check the force logging status as follows:

   SQL> select name, force_logging from v$database;
   NAME      FOR
   --------- ---
   ORCL      NO
   

2. Enable the force logging mode as follows:

   Enabling Force Logging on Primary Database is mandatory. 
   SQL> alter database force logging;
   Database altered.
   

3. Check the force logging status again as follows:

   SQL> select name,force_logging from v$database;
   NAME      FOR
   --------- ---
   ORCL      YES
   

   In the alert log, you'll see following lines:

   alter database force logging
   ALTER DATABASE FORCE LOGGING command is waiting for existing direct writes to finish. This may take a long time.
   Completed: alter database force logging
   

What just happened?

We've put the primary database in the force logging mode, which is required for the Data Guard physical standby database to work properly.

Standby redo logs

Standby redo logfiles are used by a standby database to store the redo...