Offline Redo log files won't apply automatically.

[Former Member]

Hi Experts,

     I am currently building a standby database for backup purposes. The primary server is suppose to send the log file to the standby server via FTP and the log file will automatically apply to the standby DB. But i am having issues with the applying automatically part. The log file transfer is working but the log files wont apply.  It says that it is waiting for the next redo log file but the file is already in the directory. Any help would be appreciated. Thank you in advance.

[Reagan]

Hello

It depends on how the log shipment is configured.

If you have an Oracle database then dataguard is the best option for this.

As long as the configuration is right then the logs will be transferred to the standby node.

Regards

RB

[Former Member]

Hi Experts,

This is working now. I restored a more recent copy of my primary db and it seemed to work. Thanks for taking the time to help me.

[former_member206552]

Hi Rosendo

Please try the following

A.1.1 The Standby Archive Destination Is Not Defined Properly

If the STANDBY_ARCHIVE_DEST initialization parameter is not defined as a valid directory name on the standby site, the Oracle database server will not be able to determine the directory in which to store the archived redo logs. Check the DESTINATION and ERROR columns in the V$ARCHIVE_DEST view. For example, enter:

SQL> SELECT DESTINATION, ERROR FROM V$ARCHIVE_DEST;  

Make sure the destination is valid.

source : http://docs.oracle.com/cd/B10501_01/server.920/a96653/troubleshooting.htm

Best Regards

Marius

[Former Member]

hi,

how are you applying the logs . using brtools. If yes then you should get some error logs .

Please past what do you see as the error code.

Thanks

Rishi Abrol