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 2The idea is to make an adequate configuration that does not present problems when performing the role change (switchover).
Thanks for the support.
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.