Home » Server Options » Data Guard » How to resolve ORA-16401: archivelog rejected by RFS (rdbms 10.2.0.4, windows xp)
How to resolve ORA-16401: archivelog rejected by RFS [message #521768] Thu, 01 September 2011 20:50 Go to next message
kytemanaic
Messages: 45
Registered: February 2009
Member
Hi,

initial configuration:

cta: physical standby
ctastd: primary

I cancel my failover at cta half way,

from http://download.oracle.com/docs/cd/B193 ... m#i1026491

Quote:

Step 4 Initiate a failover on the target physical standby database.

Issue the following statement to initiate the failover:

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH FORCE;





during the above process it took too long so I opened up another session and cancel the above process


SQL>alter database recover managed standby database cancel;


the data guard configuration is left as it is, i.e.

cta: physical standby
ctastd: primary

I discover the following findings in the alertcta.log, i.e. in cta database,


Primary database is in MAXIMUM PERFORMANCE mode
RFS[8]: Successfully opened standby log 4: 'D:\ORA102\CTA\REDO04.LOG'
Thu Sep 01 10:38:08 2011
Errors in file d:\ora102\cta\udump\cta_rfs_536.trc:
ORA-16401: archivelog rejected by RFS


I've googled around and find the following
from http://dbaforums.org/oracle/lofiversion ... 12859.html

Quote:


ORA-16401: archivelog rejected by RFS

Cause: An attempt was made to re-archive an existing archivelog. This usually happens because either a multiple primary database or standby database(s) or both are trying to archive to this standby database.

Action: See alert log and trace file for more details. No action is necessary; this is an informational statement provided to record the event for diagnostic purposes.



it seems to be that there are multiple primary database, but it is not based on the information from v$database

Right now the physical standby database cannot received any archive logs from the primary.

I've checked the database_role in both servers, they are as they are designated.

from the physical standby database



    SYS@cta>select db_unique_name, database_role, switchover_status from v$database;


    DB_UNIQUE_NAME                 DATABASE_ROLE    SWITCHOVER_STATUS
    ------------------------------ ---------------- --------------------
    CTA                            PHYSICAL STANDBY NOT ALLOWED

    SYS@cta>alter database  recover managed standby database disconnect from session
    ;

    Database altered.

    SYS@cta>select db_unique_name, database_role, switchover_status from v$database;


    DB_UNIQUE_NAME                 DATABASE_ROLE    SWITCHOVER_STATUS
    ------------------------------ ---------------- --------------------
    CTA                            PHYSICAL STANDBY SESSIONS ACTIVE



from the primary database



    SYS@ctastd>startup nomount
    ORACLE instance started.

    Total System Global Area  167772160 bytes
    Fixed Size                  1295632 bytes
    Variable Size              83888880 bytes
    Database Buffers           79691776 bytes
    Redo Buffers                2895872 bytes
    SYS@ctastd>alter database mount;

    Database altered.

    SYS@ctastd>select db_unique_name, database_role, switchover_status from v$databa
    se;

    DB_UNIQUE_NAME                 DATABASE_ROLE    SWITCHOVER_STATUS
    ------------------------------ ---------------- --------------------
    CTASTD                         PRIMARY          TO STANDBY

    SYS@ctastd>alter database open;

    Database altered.

    SYS@ctastd>select db_unique_name, database_role, switchover_status from v$databa
    se;

    DB_UNIQUE_NAME                 DATABASE_ROLE    SWITCHOVER_STATUS
    ------------------------------ ---------------- --------------------
    CTASTD                         PRIMARY          TO STANDBY

    SYS@ctastd>





the standby is always busy, i.e. SESSIONS ACTIVE

so how do I resolve the above issue, i.e make sure the archived logs are shipped and apply over to physical standby.

I'm using Oracle 10.2.0.4 and os is windows.

thanks a lot!

[Updated on: Fri, 02 September 2011 00:52] by Moderator

Report message to a moderator

Re: How to resolve ORA-16401: archivelog rejected by RFS [message #521777 is a reply to message #521768] Fri, 02 September 2011 01:01 Go to previous messageGo to next message
John Watson
Messages: 4081
Registered: January 2010
Location: Global Village
Senior Member
You can't start applying redo again after initiating a failover. You probably need to flash back the standby to a time/scn before you started all this, and try again. You do have database flashback enabled, don't you?
Re: How to resolve ORA-16401: archivelog rejected by RFS [message #521875 is a reply to message #521777] Fri, 02 September 2011 14:11 Go to previous messageGo to next message
kytemanaic
Messages: 45
Registered: February 2009
Member
hi discover that my cta, i.e my physical standby database don't have flashback enable.

what should I do next?

thanks
Re: How to resolve ORA-16401: archivelog rejected by RFS [message #521883 is a reply to message #521875] Fri, 02 September 2011 17:36 Go to previous messageGo to next message
John Watson
Messages: 4081
Registered: January 2010
Location: Global Village
Senior Member
Delete it and start again.
Re: How to resolve ORA-16401: archivelog rejected by RFS [message #522244 is a reply to message #521883] Wed, 07 September 2011 10:12 Go to previous messageGo to next message
babuknb
Messages: 1703
Registered: December 2005
Location: NJ
Senior Member

John, You mean to say rebuild the DR database?

- Babu
Re: How to resolve ORA-16401: archivelog rejected by RFS [message #522245 is a reply to message #522244] Wed, 07 September 2011 10:26 Go to previous messageGo to next message
John Watson
Messages: 4081
Registered: January 2010
Location: Global Village
Senior Member
Exactly.
It is broken. Brown bread. Pushing up the daisies. Gone to the great bit bucket in the sky.
Re: How to resolve ORA-16401: archivelog rejected by RFS [message #523299 is a reply to message #522245] Fri, 16 September 2011 10:53 Go to previous message
babuknb
Messages: 1703
Registered: December 2005
Location: NJ
Senior Member

Thank you John.
Previous Topic: How to add both online and redo log files to standby databas
Next Topic: why did the current configuration produces a temporary 10M archive log
Goto Forum:
  


Current Time: Thu Apr 17 05:23:40 CDT 2014

Total time taken to generate the page: 0.11726 seconds