Recovery as Normal Files(DB2)

From Tranzman Documentation
Revision as of 09:56, 6 January 2021 by Sachin (talk | contribs)
Jump to: navigation, search

Below documentation shows how to restore DB2 data after it has been recovered as normal files using steps as shown in Recovery as Normal Files . Please recover the DB2 database files.

Recovered filename will have a naming convention as shown below.

e.g. SAMPLE.0.DB2.NODE0000.CATN0000.20210105171743.001

   Database Name = Sample
   Instance Name = DB2
   Timestamp = 20210105171743
   Catalog Name = CATN000 

We are demonstrating recovery for SAMPLE database (shown in below picture).


DB2SAMPLERestore.JPG


Note.png Note: There are more ways to perform DB2 restore.

For more detailed information please refer to the DB2 Restore Documentation.

Once you have the files, please follow the steps to restore.

Step 1

Login to DB2 Server and connect to the SAMPLE database.

db2 => connect to sample

  Database Connection Information
Database server        = DB2/NT64 9.7.0
SQL authorization ID   = ADMINIST...
Local database alias   = SAMPLE


Step 2

db2 => restore database sample from "C:\Temp\RestoredData" taken at 20210105171743 with 2 buffers 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.


Step 3

Roll the logs forward to the end of the backup to make sure the database is in a consistent state.

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             = 2021-01-05-17.17.46.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.


Return to DP/DataProtector Recovery