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

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

Thanks Mujeeb for the info. I could complete the restore.

" 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 .

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