Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2005
    Posts
    23

    Unanswered: onbar restore failed

    Hi, i am having headaches since yesterday trying to solve this problem.

    TSM 5.1 + TDP FOR INFORMIX V521

    onbar -b -w backup was successful

    but when restore with onbar -r,failed.

    bar_act.log

    "unable to write restore data to the database server:restore reserved pages failed"

    thank you for you help.
    Last edited by neilqiu; 08-23-06 at 03:19.

  2. #2
    Join Date
    Aug 2006
    Location
    Riga, Latvia
    Posts
    17
    Hi,

    If you used for backup: onbar -b -w,

    for restore you must do: onbar -r -w

  3. #3
    Join Date
    Jul 2005
    Posts
    23
    hi,
    used onbar -r -w also failed.(database is shutdown)

    when database is online , onbar -r datadbs is successful(but just restore datadbs,the data can't used,must resotore other datadbs,rootdbs,logdbs,phydbs,etc?).

    Regards
    Last edited by neilqiu; 08-25-06 at 12:47.

  4. #4
    Join Date
    Aug 2006
    Location
    Riga, Latvia
    Posts
    17
    Hi,
    1. Please carefully look at your $INFORMIXDIR/etc/ixbar.0, make a copy of it and create additional version of file that consists only of required entries of backup information or publish file content here on this topic I will look at it. Also check bar_act.log file to check status of last performed backup, you must find evicdence of fact that backup was completed without any errors. If errors exists, possible alternative is to find last completed without errors Level 0 backup and rollforward logigal log information till the necessary time stamp.

    2. Salvaging of existing logical logs must be performed, if it is possible to save latest transactions that resides on logical log and is not backuped by onbar. You can check it by looking in $INFORMIXDIR/etc/ixbar.0

    3. When you performing restore of rootdbs and other critical dbsapces (rootdbs, dbspace that includes plog and llogs) it always must be a cold restore, it means that onbar -r -w must be executed when Informix is completely shutted down (no of oninit processes is running - you can check it by executing "ps -efa | grep oninit" ). By the way, are you running Informix on Windows or Unix operating system?

    4. If you create backup by "onbar -b -w" command, to restore database instance to online mode you must perform also logical restore and you must have logical log that was created at least after backup was finished

    5. If in this case database restore procedure is very critical, please contact your Informix support staff or specialists who can provide you a competent support.

    I hope it will help a bit.
    Last edited by intarsplienis; 08-27-06 at 16:27.

  5. #5
    Join Date
    Jul 2005
    Posts
    23
    Thanks intarsplienis,
    you replied is very important to me !

    I will try again.
    Regards

Posting Permissions

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