【原】【实验】DB2V9.5恢复实验

[hdkv95@red01 ~]$ ls -l TOOLSDB*
-rwxrwxrwx  1 root   root   280354816 Apr  1 18:03 TOOLSDB.0.db2inst9.NODE0000.CATN0000.20080325133723.001
[hdkv95@red01 ~]$

[hdkv95@red01 ~]$ db2 restore db toolsdb into toolsdb redirect
SQL2539W  Warning!  Restoring to an existing database that is the same as the
backup image database.  The database files will be deleted.
Do you want to continue ? (y/n) y
SQL0970N  The system attempted to write to a read-only file.  SQLSTATE=55009

2008-04-02-10.58.00.740808+480 E3545G995          LEVEL: Warning
PID     : 3896                 TID  : 3080711072  PROC : db2sysc 0
INSTANCE: hdkv95               NODE : 000         DB   : TOOLSDB
APPHDL  : 0-446                APPID: *LOCAL.hdkv95.080402025800
AUTHID  : HDKV95
EDUID   : 807                  EDUNAME: db2agent (TOOLSDB) 0
FUNCTION: DB2 UDB, database utilities, sqluCompareDB, probe:1437
MESSAGE : SQL2539W  Warning!  Restoring to an existing database that is the
          same as the backup image database.  The database files will be
          deleted.
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
 sqlcaid : SQLCA     sqlcabc: 136   sqlcode: 2539   sqlerrml: 0
 sqlerrmc:
 sqlerrp : sqluComp
 sqlerrd : (1) 0x00000000      (2) 0x00000000      (3) 0x00000000
           (4) 0x00000000      (5) 0x00000000      (6) 0x00000000
 sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)
           (7)      (8)      (9)      (10)        (11)
 sqlstate:

2008-04-02-10.58.02.654938+480 I4541G413          LEVEL: Error
PID     : 3896                 TID  : 2456808352  PROC : db2sysc 0
INSTANCE: hdkv95               NODE : 000
EDUID   : 869                  EDUNAME: db2bm.807.0 (TOOLSDB) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbDMSDoContainerOp, probe:810
MESSAGE : ZRC=0x8402001E=-2080243682=SQLB_CONTAINER_NOT_ACCESSIBLE
          "Container not accessible"

2008-04-02-10.58.02.655222+480 I4955G456          LEVEL: Error
PID     : 3896                 TID  : 2456808352  PROC : db2sysc 0
INSTANCE: hdkv95               NODE : 000
EDUID   : 869                  EDUNAME: db2bm.807.0 (TOOLSDB) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbDMSDoContainerOp, probe:810
DATA #1 : String, 118 bytes
Error checking container 0 (/home/db2inst9/db2inst9/NODE0000/TOOLSDB/T0000000/C0000000.CAT) for tbsp 0.  Rc = 870F0011

2008-04-02-10.58.02.662349+480 E5412G795          LEVEL: Error (OS)
PID     : 3896                 TID  : 2456808352  PROC : db2sysc 0
INSTANCE: hdkv95               NODE : 000
EDUID   : 869                  EDUNAME: db2bm.807.0 (TOOLSDB) 0
FUNCTION: DB2 UDB, oper system services, sqlomkdirp, probe:10
MESSAGE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
          DIA8701C Access denied for resource "", operating system return code
          was "".
CALLED  : OS, -, mkdir                            OSERR: EACCES (13)
DATA #1 : File name, 21 bytes
/home/db2inst9/hdkv95
DATA #2 : signed integer, 4 bytes
448
DATA #3 : signed integer, 4 bytes
448
DATA #4 : String, 105 bytes
Search for ossError*Analysis probe point after this log entry for further
self-diagnosis of this problem.

正确的方法：

[hdkv95@red01 ~]$  db2 restore db toolsdb on /home/hdkv95 dbpath on /home/hdkv95 into toolsdb
SQL2523W  Warning!  Restoring to an existing database that is different from
the database on the backup image, but have matching names. The target database
will be overwritten by the backup version.  The Roll-forward recovery logs
associated with the target database will be deleted.
Do you want to continue ? (y/n) y
SQL2555I  The restored database was successfully migrated to the current
release.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/5718/viewspace-223948/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/5718/viewspace-223948/