Difference between revisions of "RecoverDB2"
| Line 32: | Line 32: | ||
{| class="wikitable" style="padding-left: auto; color:#FFFFFF; background-color: black; width: 1100px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap; | {| class="wikitable" style="padding-left: auto; color:#FFFFFF; background-color: black; width: 1100px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap; | ||
| | | | ||
| − | > db2 rollforward db sample to end of backup | + | db2 => restore database sample from "C:\backup" taken at 20180919172832 with 2 b |
| + | uffers buffer 1024 parallelism 1 without prompting | ||
| + | SQL2540W Restore is successful, however a warning "2539" was encountered | ||
| + | during Database Restore while processing in No Interrupt mode. | ||
| + | db2 => rollforward db sample to end of backup | ||
| + | |||
| + | Rollforward Status | ||
| + | |||
| + | Input database alias = sample | ||
| + | Number of nodes have returned status = 1 | ||
| + | |||
| + | Node number = 0 | ||
| + | Rollforward status = DB working | ||
| + | Next log file to be read = S0000000.LOG | ||
| + | Log files processed = - | ||
| + | Last committed transaction = 2018-09-19-16.28.42.000000 UTC | ||
| + | |||
| + | DB20000I The ROLLFORWARD command completed successfully. | ||
|} | |} | ||
Revision as of 08:13, 21 September 2018
Steps to be followed after importing the images to NBU
In the following example, there is a database called SAMPLE ; the recovery logs are included in the backup image; the database is restored; and the database is rolled forward to the end of backup timestamp.
Step 1
Restore the image on the DB2 client as a file.
Step 2
Filename will have a naming convention as shown below.
e.g. SAMPLE.0.DB2.NODE0000.CATN000.20180523164142.001
Database Name is Sample Instance Name is DB2 Timestamp is 20180523164142 Catalog Name is CATN000
Step 3
Restore the database. The example below restores the database SAMPLE from location in "C:\Backup"
|
> db2 => RESTORE DATABASE SAMPLE FROM "C:\Backup" TAKEN AT 20180627095334 WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING |
Step 4
Roll the logs forward to the end of the backup to make sure the database is in a consistent state.
|
db2 => restore database sample from "C:\backup" taken at 20180919172832 with 2 b uffers buffer 1024 parallelism 1 without prompting SQL2540W Restore is successful, however a warning "2539" was encountered during Database Restore while processing in No Interrupt mode. db2 => rollforward db sample to end of backup Rollforward Status Input database alias = sample Number of nodes have returned status = 1 Node number = 0 Rollforward status = DB working Next log file to be read = S0000000.LOG Log files processed = - Last committed transaction = 2018-09-19-16.28.42.000000 UTC DB20000I The ROLLFORWARD command completed successfully. |
Note : If log files are not included in backup images, the rollforward recovery needs to be done as per the method used for backing up logs.
Use this link to go back to the main recoverydocs Page.