Skip to Main Content
  • Questions
  • Configuration of redo log and standby redo log in single instance standby database for RAC primary database

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Victor.

Asked: April 11, 2019 - 5:51 pm UTC

Last updated: April 12, 2019 - 2:40 am UTC

Version: 11.2

Viewed 1000+ times

You Asked

Hello,
I would like your support to configure correctly at the level of redo log and standby redo log in a single instance standby database, whose primary base is RAC, so that there is no inconvenience when performing the change of roles.

At present:
- In the primary RAC database

GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- ---------- --- --------------
1 1 160 52428800 512 2 YES INACTIVE
2 1 161 52428800 512 2 YES INACTIVE
3 1 162 52428800 512 2 NO CURRENT
4 2 112 52428800 512 2 NO CURRENT
5 2 110 52428800 512 2 YES INACTIVE
6 2 111 52428800 512 2 YES INACTIVE


GROUP# THREAD# BYTES BLOCKSIZE ARC STATUS
---------- ---------- ---------- ---------- --- ----------
11 1 52428800 512 YES UNASSIGNED
12 1 52428800 512 YES UNASSIGNED
13 1 52428800 512 YES UNASSIGNED
14 1 52428800 512 YES UNASSIGNED
21 2 52428800 512 YES UNASSIGNED
22 2 52428800 512 YES UNASSIGNED
23 2 52428800 512 YES UNASSIGNED
24 2 52428800 512 YES UNASSIGNED


SQL> select THREAD#, STATUS, ENABLED, INSTANCE from v$thread;


THREAD# STATUS ENABLED INSTANCE
---------- ------ -------- ---------
1 OPEN PUBLIC testr1
2 OPEN PUBLIC testr2


- In the standby database (Single Instance).

GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- ---------- --- --------------
1 1 160 52428800 512 2 YES CLEARING
2 1 161 52428800 512 2 YES CLEARING
3 1 162 52428800 512 2 YES CURRENT



GROUP# THREAD# BYTES BLOCKSIZE ARC STATUS
---------- ---------- ---------- ---------- --- ----------
11 1 52428800 512 YES ACTIVE
12 1 52428800 512 NO UNASSIGNED
13 1 52428800 512 YES UNASSIGNED
14 1 52428800 512 YES UNASSIGNED


SQL> select THREAD#, STATUS, ENABLED, INSTANCE from v$thread;


THREAD# STATUS ENABLED INSTANCE
---------- ------ -------- ------------
1 OPEN PUBLIC test

Is the thread number in this database correct?


In the alert of the standby database this message is being presented:

RFS[15]: No standby redo logfiles created for thread 2


The idea is to make an adequate configuration that does not present problems when performing the role change (switchover).

Thanks for the support.

and Connor said...

For *each thread* you want to have 'n+1' standby redo logs, if you have 'n' redo logs on the primary

So you need to create some standby redo logs for thread 2 and you should be fine.

Is this answer out of date? If it is, please let us know via a Comment

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database