Skip to Content
0
Former Member
Feb 20, 2009 at 04:44 PM

SQL1651N - during Redirect Restore

482 Views

Hello Gurus,

Two months ago, I installed a SAP SCM system in the sandbox server using R3Load method ( Export files were created via SAPinst from the production SCM system ).

Both servers are on AIX 5.3 with DB2 V8.1 fixpack 10.

The sandbox SR1 database has log-retain mode turn off.

The production PR1 database has log-retain mode turn on.

I wanted to restore a new copy of production database PR1 to the sandbox database SR1 without re-installing the whole SAP SR1 system in sandbox server.

I created an offline backup of production database PR1, and copied the backup file to the sandbox server.

I shut down the sandbox SAP SR1 system, and perform offline backup of SR1 database.

When executed a restore redirect script in the sandbox server:

the step 1 had a warning message:

RESTORE DATABASE PR1 FROM '/dbexport/scmdb' TAKEN at 20080215203024 INTO SR1 REP

LACE EXISTING REDIRECT

SQL2529W Warning! Restoring to an existing database that is different from the backup image database, and the alias name "SR1" of the existing database does not match the alias name "PR1" of the backup image, and the database name "SR1" of the existing database does not match the database name "PR1" of the backup image. The target database will be overwritten by the backup version. The Roll-forward recovery logs associated with the target database will be deleted.

SQL1277N Restore has detected that one or more table space containers are inaccessible, or has set their state to 'storage must be defined'.

DB20000I The RESTORE DATABASE command completed successfully.

the step 2 - set tablespace container for # had executed successfully with

DB20000I The SQL command completed successfully.

the step 3 - had the error message:

RESTORE DATABASE PR1 CONTINUE

SQL1651N The request cannot be executed because the DB2 server version does

not support this functionality.

At this point, I can not execute db2 restore database PR1 continue or db2 restore database PR1 abort or db2 restore database SR1 abort.

I have to drop my database SR1, and successfully restore from the SR1 backup taken before I start the redirect restore.

Is the sandbox database need to have the same LOG RETAIN mode as the production database?

Is the redirect restore work in my database version?

According to DB2 version 8, I should be able to perform the redirect restore.

What is the proper way to refresh the content of the sandbox database?

Thanks in advance!