1. [db2inst1@server1 ~]$ db2 update db cfg for sample using logretain recovery
2. DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.
3. SQL1363W One or more of the parameters submitted for immediate modification
4. were not changed dynamically. For these configuration parameters, all
5. applications must disconnect from this database before the changes become
6. effective
7.
8. --这时候,需要手动备份数据库,否是会出现backup pending的状态:
9.
10. [db2inst1@server1 ~]$ con sample
11. SQL1116N A connection to or activation of database "SAMPLE" cannot be made
12. because of BACKUP PENDING. SQLSTATE=57019
13.
14. [db2inst1@server1 ~]$ db2 backup db sample to /tmp
15.
16. Backup successful. The timestamp for this backup image is : 20101117125927
17.
18.
19. --检查相关设置:
20.
21. [db2inst1@server1 ~]$ con sample
22.
23. Database Connection Information
24.
25. Database server = DB2/LINUX 9.5.2
26. SQL authorization ID = DB2INST1
27. Local database alias = SAMPLE
28.
29. [db2inst1@server1 ~]$ db2 get db cfg |grep -i log
30. Log retain for recovery status = RECOVERY
31. Log retain for recovery enabled (LOGRETAIN) = RECOVERY
32. First log archive method (LOGARCHMETH1) = LOGRETAIN
33. Options for logarchmeth1 (LOGARCHOPT1) =
34. Second log archive method (LOGARCHMETH2) = OFF
35.
36.
37. --再设置归档的路径:
38.
39. [db2inst1@server1 ~]$ db2 update db cfg for sample using LOGARCHMETH1 "DISK:/arch/"
40.
41. DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.
42.
43. [db2inst1@server1 ~]$ db2 get db cfg |grep LOGARCHMETH1
44. First log archive method (LOGARCHMETH1) = DISK:/arch/
45.
46.
47. --手动归档一下:
48.
49. [db2inst1@server1 ~]$ db2 ARCHIVE LOG FOR DATABASE sample
50. DB20000I The ARCHIVE LOG command completed successfully.
51.
52. --看看归档情况
53. [root@server1 /arch/db2inst1/SAMPLE/NODE0000/C0000000]# ll
54. total 16
55. -rw-r----- 1 db2inst1 db2iadm1 12288 Nov 17 13:09 S0000000.LOG
56. [db2inst1@server1 ~]$ db2 LIST HISTORY ARCHIVE LOG all for sample
57.
58. List History File for sample
59.
60. Number of matching file entries = 2
61.
62.
63. Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
64. -- --- ------------------ ---- --- ------------ ------------ --------------
65. X D 20101117130935 1 D S0000000.LOG C0000000
66. ----------------------------------------------------------------------------
67.
68. ----------------------------------------------------------------------------
69. Comment:
70. Start Time: 20101117130935
71. End Time: 20101117130935
72. Status: A
73. ----------------------------------------------------------------------------
74. EID: 23 Location: /arch/db2inst1/SAMPLE/NODE0000/C0000000/S0000000.LOG
75.
76.
77. Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
78. -- --- ------------------ ---- --- ------------ ------------ --------------
79. X D 20101117130935 N S0000000.LOG
80. ----------------------------------------------------------------------------
81.
82. ----------------------------------------------------------------------------
83. Comment: ARCHIVE LOG
84. Start Time: 20101117130935
85. End Time: 20101117130935
86. Status: A
87. ----------------------------------------------------------------------------
88. EID: 24
收起