DB21080E from RESTORE DB ... CONTINUE during redirected restore

Question

This technote provides troubleshooting methods for the situation where a RESTORE DB dbname CONTINUE command fails with the following error message: DB21080E No previous RESTORE DATABASE command with REDIRECT option was issued for this database alias, or the information about that command is lost.

Cause

During a redirected restore into a new database name, if the new database name is used within the CONTINUE command instead of the original name of the database being restored, a DB21080E error will result.

For example:

RESTORE DB PRD FROM INTO TST REDIRECT 
(...)
SET TABLESPACE CONTAINERS FOR 0 USING ... 
(...)

RESTORE DB TST CONTINUE

DB21080E No previous RESTORE DATABASE command with REDIRECT option was for this database alias.

Answer

Enure that you use the original name of the database being restored and not the name of the new database in the RESTORE DB CONTINUE command.

The correct command in the example would be:

RESTORE DB PRD CONTINUE