O'Reilly logo

Oracle Data Guard 11gR2 Administration Beginner's Guide by Nassyam Basha, Emre Baransel

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required