IBM E02HRLL-G Administration Guide - Page 142
Restoring archived data of WebSphere Partner Gateway V6.1 and earlier, Searching the restored
![]() |
View all IBM E02HRLL-G manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 142 highlights
Restoring archived data of WebSphere Partner Gateway V6.1 and earlier About this task The console based restore (from archive) feature in WebSphere Partner Gateway V6.2 does not support the backup database archives taken on WebSphere Partner Gateway versions prior to V6.1. However, it supports the restoration of non repudiation file archives taken prior to WebSphere Partner Gateway V6.1. If the database is on DB2 and the archive backup was taken on WebSphere Partner Gateway V6.1 or later, then you can restore them using the 'restore' feature provided in WebSphere Partner Gateway V6.2. In the case of Oracle database, when you try to restore the data, an error occurs: "Exception while doing the db restore java.sql.SQLException: ORA-20999: 20002 AR_IMPORT_DATA ORA-29913: error in executing ODCIEXTTABLEOPEN callout ORA-29400: data cartridge error KUP-11010: unable to open at least one dump file for load ORA-06512: at "BCGAPPSD.AR_IMPORT_DATA", line 338" The workaround is to convert the format of the Oracle export files. To do this, you need to have another (separate from the production) installation of WebSphere Partner Gateway V6.2. Steps to be followed to restore the database archives taken on WebSphere Partner Gateway V6.1 or later: 1. Use the 'bcgDBNonRepImport' script to import the table data into LG_MSG_ARCHIVE table. 2. Run the archiver from the console. This will create the database export files in the format supported by WebSphere Partner Gateway V6.2, which can be restored using the console. The steps to restore the archived data are same as described for DB2 database in the previous section. To restore V6.0 non repudiation file backup through the WebSphere Partner Gateway V6.2 console, the last modified date of the directory must fall within the start date and end date range selected in the Archiver Restore screen. This is because the V6.0 non rep directory structure is not in the YYYYMMDD format. Searching the restored documents About this task You can search for the required restored document by specifying the search criteria. Here are the steps to follow: 1. Login as administrator and navigate to Hub Admin > Hub Configuration > Archiver > Archiver Restore > Search Restored Documents. 2. Use the following filter criteria to search for a particular document: v Date range v Source Partner v Package v Protocol v Document type v Results Per Page 3. Click Search. The list of archiver tasks, along with the corresponding details are retrieved from the LG_MSG_RESTORE table and presented in a tabular format. The following information is displayed: 136 IBM WebSphere Partner Gateway Enterprise and Advanced Editions: Administration Guide
![](/manual_guide/products/ibm-e02hrllg-administration-guide-f948001/142.png)