Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2004
    Posts
    29

    Unanswered: Redirected restore using incremental images

    Hi,

    I am having a tough time performing redirected restore using the incremental images. Please advice what I am doing wrong here. Here's what I have:

    1) 1 Offline Backup Image
    2) 1 incremental backup image
    3) 2 incremental delta images

    My logic is to first restore the latest delta image followed by offline, incremental and then both incremental delta images.

    Here's what I performed:

    create database tdb on /test/db;

    restore db mydb incremental from /test/back taken at 20050208120003 into tdb newlogpath /test/log/ redirect without prompting;

    set tablespace containers for 0 using (......);
    ....
    ....
    restore db mydb incremental taken at 20050208120003;


    when I run the above steps, it errors out on the last step
    " SQL2008N The callerac parameter is not within valid range or the requested
    action is out of sequence."

    I am not sure what I am doing wrong here. Please suggest how do I implement the backup strategy I referred earlier using redirected restore approach.

    DB version is 7.2 running on AIX.

    Thanks

    - RJ

  2. #2
    Join Date
    Mar 2004
    Posts
    448
    Dont use without prompting.

    Start with the last delta backup.Then go to full backup and apply all the backup till you reach the first restore you applied.
    You can also use db2ckrst to find the exact sequence of backup.

    restore db mydb incremental from /test/back taken at <last backup> into tdb newlogpath /test/log/ redirect without prompting;

    set tablespace containers for 0 using (......);
    ....
    ....
    restore..... continue.

    restore db .... <from full backup>

    ...

    restore ... < last backup>

    Also make it simple , you can easialy change the newlogpath.

    I usually starts in the same directory where I put all my backups.

    db2 restore db <database_alias> incremental taken at 3 redirect

    .....



    regards

    Mujeeb

  3. #3
    Join Date
    Oct 2004
    Posts
    29
    Thanks Mujeeb for the info. I could complete the restore.

  4. #4
    Join Date
    Nov 2003
    Posts
    121

    but what is cause of callerac

    " SQL2008N The callerac parameter is not within valid range or the requested
    action is out of sequence."

    We also see is sometimes and have to restore back from the scratch.
    Mujeed:
    Do you know the actuall cause of sql2008.

    BTW, we get it sometimes not while rollforward .

  5. #5
    Join Date
    Mar 2004
    Posts
    448
    All the incremental backup should be applied with correct sequence.
    Any time you applied a wrong sequence or wrong backup you will get this error.
    Starting with the last one, this will create the structure/history file, but no data.You complete your backup when you reapplied the first restore.
    Never use prompt.I always find the db2ckrst gives you the correct sequence.
    Rollforward has nothing to do with this error.
    What you are doing first you design the skeleton, then you add wood etc.
    rollforward means you are adding the furniture etc.just an analogy.
    Always document the steps


    Mujeeb

Posting Permissions

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