Skip to Content
avatar image
Former Member

Offline Redo log files won't apply automatically.

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Dec 11, 2013 at 05:50 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 11, 2013 at 07:25 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 11, 2013 at 09:07 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 11, 2013 at 08:57 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded