High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

Standby Redo logs

Hi,

I have an Oracle12c database (non-RAC). I am trying to create a new Physical Standby database. On the Primary database, I have 3 redo groups with 3 members each and all members are 10 MB each. Redo group # are 1,2,3.

As per Oracle doc https://docs.oracle.com/database/121/SBYDB/create_ps.htm#SBYDB00200, (Step 3.1.3) I should create Standby Redo logs on the Primary database, using

SQL> ALTER DATABASE ADD STANDBY LOGFILE ('/oracle/dbs/slog1.rdo') SIZE 500M;
 
SQL> ALTER DATABASE ADD STANDBY LOGFILE ('/oracle/dbs/slog2.rdo') SIZE 500M;

I also read on the web that "In order to avoid any wait in reuse of standby redo logs, it is recommended that one more standby redo log group be retained than the number of online redo log groups configured on the primary database

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center