DB2: Comandos Backup e Restore: Difference between revisions

Latest revision as of 18:05, 1 July 2024

Comando Backup

db2 "BACKUP DATABASE MYDB"

This will generate a file like MYDB.0.db2inst1.DBPART000.20240605211641.001

Comando Restore

db2 "CREATE DATABASE MYDB AUTOMATIC STORAGE YES USING CODESET UTF-8 TERRITORY US 
    COLLATE USING IDENTITY PAGESIZE 4096 DFT_EXTENT_SZ 32"

db2 "RESTORE DATABASE MYDB from /tmp into MYDB without prompting"

Check backup file

 db2ckbkp -H /tmp/

=====================
MEDIA HEADER REACHED:
=====================
Server Database Name           -- MYDB
Server Database Alias          -- MYDB
Client Database Alias          -- MYDB
Timestamp                      -- 20240605211641
Database Partition Number      -- 0
Instance                       -- db2inst1
Database Configuration Type    -- 0 (Non-shared data)
Sequence Number                -- 1
Database Member ID             -- 0
Release ID                     -- 0x1500 (DB2 v11.5.9.0)
AL version                     -- V:11 R:5 M:9 F:0 I:0 SB:0
...
The proper image file name would be:
MYDB.0.db2inst1.DBPART000.20240605211641.001

Restore using redirect file

You can use the "redirected" restore option by generating a file, using command:

db2 restore database MYDB redirect generate script restore.sql

Once the script is generated, you can change the names, file locations, etc.

And finally, execute the script

db2 -tvf restore.sql

Ver também

@@ Line 2: / Line 2: @@
 == Comando Backup ==
-  db2 "BACKUP DATABASE << db2_dbname >>"
+  db2 "BACKUP DATABASE '''MYDB'''"
-This will generate a file like B2BI.0.db2inst1.DBPART000.20240605211641.001
+This will generate a file like MYDB.0.db2inst1.DBPART000.20240605211641.001
 == Comando Restore ==
-  db2 "CREATE DATABASE << db2_dbname >> AUTOMATIC STORAGE YES USING CODESET UTF-8 TERRITORY US
+  db2 "CREATE DATABASE '''MYDB''' AUTOMATIC STORAGE YES USING CODESET UTF-8 TERRITORY US
       COLLATE USING IDENTITY PAGESIZE 4096 DFT_EXTENT_SZ 32"
-  db2 "RESTORE DATABASE << db2_dbname >> from /tmp into << db2_dbname >> without prompting"
+  db2 "RESTORE DATABASE '''MYDB''' from /tmp into '''MYDB''' without prompting"
 == Check backup file ==
@@ Line 20: / Line 20: @@
   MEDIA HEADER REACHED:
   =====================
-  Server Database Name           -- B2BI
+  Server Database Name           -- MYDB
-  Server Database Alias          -- B2BI
+  Server Database Alias          -- MYDB
-  Client Database Alias          -- B2BI
+  Client Database Alias          -- MYDB
   Timestamp                      -- 20240605211641
   Database Partition Number      -- 0
@@ Line 33: / Line 33: @@
   ...
   The proper image file name would be:
-  B2BI.0.db2inst1.DBPART000.20240605211641.001
+  MYDB.0.db2inst1.DBPART000.20240605211641.001
 == Restore using redirect file ==
@@ Line 40: / Line 39: @@
 You can use the "redirected" restore option by generating a file, using command:
-  db2 restore database mydb redirect generate script restore.sql
+  db2 restore database '''MYDB''' redirect generate script restore.sql
 Once the script is generated, you can change the names, file locations, etc.
@@ Line 47: / Line 46: @@
   db2 -tvf restore.sql
 == Ver também ==