- 论坛徽章:
- 0
|
生产机:
P670/DB2/3582带库
备份的时候采用离线全备
DB2 BACKUP DB xxx TO /DEV/RMT1
还原机:
P620/DB2/3582带库
还原命令如下:
RESTORE DATABASE XXXC FROM "/dev/rmt0" TO "/dbfs" INTO XXX REDIRECT ;
SET TABLESPACE CONTAINERS FOR 0 REPLAY ROLLFORWARD CONTAINER OPERATIONS USING (PATH "/dbfs/db2inst1/NODE0000/SQL00001/SQLT0000.0"
SET TABLESPACE CONTAINERS FOR 1 REPLAY ROLLFORWARD CONTAINER OPERATIONS USING (DEVICE "/dev/rTempsys4_1" 163840,DEVICE "/dev/rtempsys4_2" 163840);
SET TABLESPACE CONTAINERS FOR 2 REPLAY ROLLFORWARD CONTAINER OPERATIONS USING (DEVICE "/dev/rdataspace_1" 9338880,DEVICE "/dev/rdataspace_2" 6881280);
SET TABLESPACE CONTAINERS FOR 3 REPLAY ROLLFORWARD CONTAINER OPERATIONS USING (DEVICE "/dev/rindexspace_1" 3276800,DEVICE "/dev/rindexspace_2" 3276800);
SET TABLESPACE CONTAINERS FOR 4 REPLAY ROLLFORWARD CONTAINER OPERATIONS USING (DEVICE "/dev/rtempsys32_1" 163840,DEVICE "/dev/rtempsys32_2" 163840);
SET TABLESPACE CONTAINERS FOR 5 REPLAY ROLLFORWARD CONTAINER OPERATIONS USING (DEVICE "/dev/rtempuser_1" 163840,DEVICE "/dev/rtempuser_2" 163840);
RESTORE DATABASE XXXC CONTINUE;
还原完成后,数据库的状态是PENDING
使用DB2 ROLLFORWARD DB XXX AND STOP.
系统当机.
请教:
1\我所做的还原命令是否正确
2\我所作的BACKUP是否为离线全备,如果是,那么还原时是否不需要日志回滚.
3\请教是否可以直接在还原的时候让数据库不需要回滚.
RESTORE DATABASE XXXC FROM "/dev/rmt0" TO "/dbfs" INTO XXX REDIRECT PARALLELISM 1 WITHOUT PROMPTING;
请教这样写是不是可以不需要做日志的回滚.或者说还原完后,数据库的状态就是正常的状态?
急!急!急!
请大虾指教 |
|