Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655

    Unanswered: Do I need another RollForward

    Hi,


    We are Upgrading to V9.5 Workhgroup Server edition from V8.1.9 WSE

    It seems that on this upgrade are skipping taking Offline Backup of database POS. (To Save Time)

    I don’t really recommend that but the point was to use online backup already taken as a scheduled job.



    ONLINE backup starts at 1:00am and finishes by 2:45 am. The LOGS are included.

    We restore the database and rollforward to the END OF LOGS.

    ROLLFORWARD DATABASE POS TO end of logs and stop OVERFLOW LOG PATH (G:\POS_Daily_Backup')

    This is only for the situation if we have to rollback to 8.2.



    We are going to stop at 5:30 am whereas online backup finishes @ 2:45 am.



    So, I will copy the all the logs after the last LOG included.



    Question:

    To rollforward to last transaction committed till 5:30,
    Do I have to issue another rollforward till 5:30 am (2:45 -5:30) ??
    or the same will rollforward till 5:30am .



    Please advise me.

    DBFinder

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    You will not be able to use an Online Backup on V 8.x and restore it to V 9.5 and rollforward. V9.5 cannot read the logs from V8.x. You will have to do an offline backup. There is no other option.

    Andy

  3. #3
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    ARWinner,

    I meant tom say, just in case I need to roll back to 8.2.


    This is only for the situation if we have to rollback to 8.2.



    We are going to stop at 5:30 am whereas online backup finishes @ 2:45 am.



    So, I will copy the all the logs after the last LOG included.



    Question:

    To rollforward to last transaction committed till 5:30,
    Do I have to issue another rollforward till 5:30 am (2:45 -5:30) ??
    or the same will rollforward till 5:30am .
    Thanks

    DBFinder

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •