BW Standby Db not in sync

[former_member186066]

Hello Guys,

The standby Db is not in sync with the primary Db.

the alert file on the standby Db side has:

Media Recovery Waiting for thread 1 sequence 71551 (in transit)

Thu Aug 09 18:16:44 2012

Archived Log entry 2261 added for thread 1 sequence 71552 rlc 751133708 ID 0xa1c9978c dest 2:

Thu Aug 09 18:16:45 2012

Primary database is in MAXIMUM PERFORMANCE mode

RFS[6]: Assigned to RFS process 7099

RFS[6]: No standby redo logfiles created

RFS[6]: Opened log for thread 1 sequence 71553 dbid -1580659572 branch 751133708

I do not see any kind of error.

Please suggest as to what could be the issue.

Thanks and Regards,
Ankit Mishra

[Former Member]

Hi Ankit,

On your production server run the following query at database level:

select dest_id, dest_name, status, error from v$archive_dest;

The result of this query returns the archive locations along with their status. Check if your archive location is VALID which you have setup in your production database to transport archive logs to standby.

If its gives ERROR, then paste it. I will guide you in resolving this issue.

Regards,

Yasir

[Former Member]

Ankit,

also add destination column in the above query,

select dest_id, dest_name, destination, status,error from V$archive_dest;