Perform the following steps on the primary database:
SQL> select name, force_logging from v$database; NAME FOR --------- --- ORCL NO
Enabling Force Logging on Primary Database is mandatory. SQL> alter database force logging; Database altered.
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
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 logfiles are used by a standby database to store the redo received from the primary database. The redo received by a standby database via redo transport is written to the current SRL group by the Remote File Server (RFS) background process. When a log switch occurs on the primary database, RFS writes the redo to the next standby redo log group and the previously used standby redo log group is archived on the standby database by an ARCn
process.
Configuring the standby redo logfiles on the primary database is optional. After a switchover, the primary database role will be changed to standby; if SRLs were configured, the new standby will be ready to receive redo data and write them into the standby redo logfiles.
The SRL files must be the same size as your online redo log (ORL) files. You also need to have enough SRL groups; that is, one more than the number of ORL groups. Let's suppose you have three ORL groups in the primary database; then, n+1
(that is, four) SRL groups should be configured. On RAC databases you should create n+1
SRL groups for each thread. For example, in an RAC primary database with two instances and three ORL groups per instance, we should create 2*(3+1)
SRL groups (that is, 8 groups).
Some other considerations on creating SRL groups are as follows: