表空间roll forward pending

starym 2015-04-27 08:39:53

20号宕机过一次，有两个表空间状态roll forward pending。
求大神帮帮忙水货客串的dba...

Tablespace ID = 7
Name = REPLICAS
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x0080
Detailed explanation:
Roll forward pending
Total pages = 959104
Useable pages = 959072
Used pages = 0
Free pages = 0
High water mark (pages) = 0
Page size (bytes) = 32768
Extent size (pages) = 32
Prefetch size (pages) = 32
Number of containers = 1
Minimum recovery time = 2012-08-29-06.28.54.000000

Tablespace ID = 8
Name = TRACKING
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x0080
Detailed explanation:
Roll forward pending
Total pages = 731648
Useable pages = 731616
Used pages = 0
Free pages = 0
High water mark (pages) = 0
Page size (bytes) = 4096
Extent size (pages) = 32
Prefetch size (pages) = 32
Number of containers = 1
Minimum recovery time = 2012-09-29-08.33.08.000000

手动roll forward，发现归档日志已经被删掉了。。从tsm恢复也恢复不了。。

$ db2 restore db rmdb11 use tsm
SQL1035N The database is currently in use. SQLSTATE=57019
$ db2 "rollforward db rmdb11 to end of logs tablespace(REPLICAS,TRACKING) online"
SQL1263N The archive file "S0029102.LOG" is not a valid log file for database
"RMDB11" on node "0".

进程状态，全都无法结束掉。。。
$ db2 list application show detail

CONNECT Auth Id Application Name Appl. Application Id Seq# Number of Coordinating DB Coordinator Status Status Change Time DB Name DB Path
Handle Agents partition number pid/thread
-------------------------------------------------------------------------------------------------------------------------------- -------------------- ---------- -------------------------------------------------------------- ----- ---------- ---------------- --------------- ------------------------------ -------------------------- -------- --------------------
RMADMIN db2jcc_application 105 10.201.251.3.60762.150427123035 00290 1 0 4884 UOW Waiting Not Collected RMDB11 /rmdb11data/rminst11/NODE0000/SQL00001/
RMADMIN db2fw9 72 *LOCAL.DB2.150427121953 00001 1 0 12337 Connect Completed Not Collected RMDB11 /rmdb11data/rminst11/NODE0000/SQL00001/
RMADMIN db2jcc_application 118 10.201.251.23.60778.150427123223 00269 1 0 19276 UOW Waiting Not Collected RMDB11 /rmdb11data/rminst11/NODE0000/SQL00001/
RMADMIN db2fw22 85 *LOCAL.DB2.150427122006 00001 1 0 8996 Connect Completed Not Collected RMDB11 /rmdb11data/rminst11/NODE0000/SQL00001/
RMADMIN db2fw2 65 *LOCAL.DB2.150427121946 00001 1 0 14136 Connect Completed Not Collected RMDB11 /rmdb11data/rminst11/NODE0000/SQL00001/
RMADMIN db2jcc_application 111 10.201.251.3.60768.150427123041 00171 1 0 17734 UOW Waiting Not Collected RMDB11 /rmdb11data/rminst11/NODE0000/SQL00001/
RMADMIN db2fw15 78 *LOCAL.DB2.150427121959 00001 1 0 10795 Connect Completed Not Collected RMDB11 /rmdb11data/rminst11/NODE0000/SQL00001/
RMADMIN db2evmg_DB2DETAILDEA 91 *LOCAL.DB2.150427122012 00001 1 0 7454 Connect Completed Not Collected RMDB11 /rmdb11data/rminst11/NODE0000/SQL00001/
RMADMIN db2stmm 58 *LOCAL.DB2.150427121939 00001 1 0 15935 UOW Waiting Not Collected RMDB11 /rmdb11data/rminst11/NODE0000/SQL00001/
RMADMIN db2fw8 71 *LOCAL.DB2.150427121952 00001 1 0 12594 Connect Completed Not Collected RMDB11 /rmdb11data/rminst11/NODE0000/SQL00001/
RMADMIN db2jcc_application 117 10.201.251.23.60780.150427123226 00297 1 0 16192 UOW Waiting Not Collected RMDB11 /rmdb11data/rminst11/NODE0000/SQL00001/
RMADMIN db2fw21 84 *LOCAL.DB2.150427122005 00001 1 0 9253 Connect Completed Not Collected RMDB11 /rmdb11data/rminst11/NODE0000/SQL00001/
RMADMIN db2fw1 64 *LOCAL.DB2.150427121945 00001 1 0 14393 Connect Completed Not Collected RMDB11 /rmdb11data/rminst11/NODE0000/SQL00001/
RMADMIN db2jcc_application 110 10.201.251.3.60767.150427123039 00299 1 0 3599 UOW Waiting Not Collected RMDB11 /rmdb11data/rminst11/NODE0000/SQL00001/
RMADMIN db2fw14 77 *LOCAL.DB2.150427121958 00001 1 0 11052 Connect Completed Not Collected RMDB11 /rmdb11data/rminst11/NODE0000/SQL00001/
RMADMIN db2fw27 90 *LOCAL.DB2.150427122011 00001 1 0 7711 Connect Completed Not Collected RMDB11 /rmdb11data/rminst11/NODE0000/SQL00001/

...全文