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 |
Problem
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.
|
|
| Source | ETrack |
| Value | 1939010 |
| Description | DB2: Unable to restore DB2 due to incorrect archive log association |
| Source | UMI |
| Value | V-79-57344-832 |
| Description | The 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
Thank you.