- 论坛徽章:
- 0
|
sos,表被清掉了
D:\Documents and Settings\root>;db2 ? restore db
RESTORE DATABASE source-database-alias { restore-options | CONTINUE | ABORT }
restore-options:
[USER username [USING password]] [{TABLESPACE [ONLINE] |
TABLESPACE (tblspace-name [ {,tblspace-name} ... ]) [ONLINE] |
HISTORY FILE [ONLINE]}] [INCREMENTAL [AUTOMATIC | ABORT]]
[{USE TSM [OPEN num-sess SESSIONS] |
FROM dir/dev [ {,dir/dev} ... ] | LOAD shared-lib
[OPEN num-sess SESSIONS]}] [TAKEN AT date-time] [TO target-directory]
[INTO target-database-alias] [NEWLOGPATH directory]
[WITH num-buff BUFFERS] [BUFFER buffer-size]
[DLREPORT file-name] [REPLACE EXISTING] [REDIRECT] [PARALLELISM n]
[WITHOUT ROLLING FORWARD] [WITHOUT DATALINK] [WITHOUT PROMPTING]
注意:从操作系统提示处,给命令冠以 'db2' 前缀。
特殊字符可能需要转义序列(\),例如:
db2 \? change database
db2 ? change database xxx comment with \"text\"
可以恢復表空間。
如果你採用的是歸檔日誌方式,是不是可以囘滾操作? |
|