primary=cdb141
standby=cdb481
1. DB Arcive-Log Mode Verification
Make sure the primary databse is archive log mode on
SQL>select name,log_mode from v$database;
NAME LOG_MODE
CBD141 ARCHIVELOG
SQL>archive log list
Database log mode: Archive Mode
Automatic archival: Enabled
Archive destination: USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence: 171
Next log sequene to archive: 172
Current log sequence: 172
2. Enable Force Logging
Keep the Primary Database in Force Logging mode
select name, inst_id, force_logging from gv$database;
NAME INST_ID FORCE_LOGGING
CDB141 2 NO
CDB141 1 NO
alter database force logging;
Database altered.
select name, inst_id, force_logging from gv$database;
NAME INST_ID FORCE_LOGGING
CDB141 2 YES
CDB141 1 YES
3.On Primary Database, Create Standby Redologs
Note 1: The size of the curretn standby redo log files must exactly match the size of the current primary database online redo log files.
Note 2:However,the recommended number of standby redo log file groups is dependent on the number of threads on the primary database. Use the following equation to determine an appropriate number of standby redo log files groups:
(Maximum number of logfiles for each thread+1)* Maximum number of threads.
Ensure we have at least 4 redo groups per each thread(instance), otherwise we will get redo sync wait events for the Large DML transactions. Please add 5(4+1) standby redo log files for each thread.
alter database add standby logfile thread 1 group 101 (‘+DATAC1′,’+RECOC1’) size 10240M;
alter database add standby logfile thread 1 group 102 (‘+DATAC1′,’+RECOC1’) size 10240M;
……………………..
alter database add standby logfile thread 1 group 109 (‘+DATAC1′,’+RECOC1’) size 10240M;
……………………..
alter database add standby logfile thread 4 group 409 (‘+DATAC1′,’+RECOC1’) size 10240M;
4.Set Primary Database Parameters
Set the below parameter in primary database.
Note 1: Setup LOG_ARCHIVE_DEST_3 OR higher for CDB(s) with ZDLRA based backups. The first ARCHIVE_DEST is set to RA local REDO Transport, the 2nd will be used for local Archive log process.
alter system set LOG_ARCHIVE_CONFIG=’DG_CONFIG=’