Unable to perform point in time restore for DB2 database due to incorrect archive log association

Article:TECH128830  |  Created: 2010-01-15  |  Updated: 2010-01-19  |  Article URL http://www.symantec.com/docs/TECH128830
Article Type
Technical Solution

Product(s)

Environment

Issue



Unable to perform point in time restore for DB2 database due to incorrect archive log association

Error



Final error: 0xe0000340 - The Database script returned an error. Refer to the Database script output section in job logs for more details.
Final error category: Resource Errors

For additional information regarding this error refer to link V-79-57344-832

Solution



This issue will come up due to incorrect association of archive logs during point in time restore of DB2 database.

Resolution:
For Backup Exec 2010:
This issue has been resolved with Hotfix 344584 in Backup Exec 2010. See the related documents for download information.
Backup Exec 12.5:
Use following workaround if this issue is encountered in Backup Exec 12.5.
Workaround:
1. Temporarily delete catalog information that is not needed by the point in time restore job. For example if some data between 10th January and 15th January has to be restored then following catalog files need to be deleted:
a. All catalog files created on or before 9th January.
b. All catalog files created on or after 16th January.

2. To delete the catalog files following step has to be followed:
a. Stop all Backup Exec services.
b. Copy the catalog folder to a safe location.
c. Delete the catalog files (.FH and .XML).
d. Start all the BEWS services.

3. Restore the database with point-in-time option.
 
4. Stop all the BEWS services.

5. Copy back Catalog folder saved in step 2 (b) into the original location (overwrite).

6. Start all the BEWS services.

Supplemental Materials

SourceETrack
Value1939010
DescriptionDB2: Unable to restore DB2 due to incorrect archive log association

SourceUMI
ValueV-79-57344-832
DescriptionThe Database script returned an error. Refer to the Database script output section in job logs for more details


Legacy ID



350351


Article URL http://www.symantec.com/docs/TECH128830


Terms of use for this information are found in Legal Notices