db2数据库的备份及恢复.docxVIP

RESTORE DATABASE NJ_HB FROM d: TAKEN AT 20121020185713 TO D: INTO NJ_HB1 WITH 2 BUFFERS BUFFER 1024 REDIRECT PARALLELISM 1 WITHOUT PROMPTING; SET TABLESPACE CONTAINERS FOR 4 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (FILE D:\DB2\NODE0000\NJ_HB1\T0000003\LM_DAT_32K 10240); SET TABLESPACE CONTAINERS FOR 5 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (FILE D:\DB2\NODE0000\NJ_HB1\T0000004\LM_DAT_8K 262400); SET TABLESPACE CONTAINERS FOR 6 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (FILE D:\DB2\NODE0000\NJ_HB1\T0000005\LM_IDX_32K 1792); SET TABLESPACE CONTAINERS FOR 7 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (FILE D:\DB2\NODE0000\NJ_HB1\T0000006\LM_IDX_8K 27136); SET TABLESPACE CONTAINERS FOR 8 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (PATH D:\DB2\NODE0000\NJ_HB1\T0000001\C0000001.TMP); RESTORE DATABASE NJ_HB CONTINUE; DB2数据库备份与恢复运用一个实例说明数据库的备份与恢复操作，实例将数据库备份在D盘，并从D盘恢复：1.备份数据库D:\DB2 BACKUP DB SAMPLES??备份成功。此备份映象的时间戳记是：200501221344131.1 除去数据库，再建立同名数据库时候，会提示错误，需要删除数据库D:\db2 catalog db dbname on d:SQL1005N 在本地数据库目录或系统数据库目录中已经存在数据库别名 dbname 。D:\db2 drop db dbnameDB20000I DROP DATABASE 命令成功完成。2.恢复2.1 恢复到一个新数据库，恢复过程自动创建数据库拷贝备份文件(dbname.0)到D 盘D:\DB2 RESTORE DB dbname INTO dbname WITHOUT ROLLING FORWARD WITHOUT PROMPTING2.2 恢复成功，但是有错误 （57019）D:\db2 connect to dbname user db2admin using xxxxxxSQL1117N 由于 ROLL-FORWARD PENDING，不能连接或激活数据库 dbname。SQLSTATE=57019D:\db2 rollforward db dbname to end of logs? 前滚状态?输入数据库别名 = dbname?节点数已返回状态 = 1?节点号 = 0?前滚状态 = DB 工作?下一个要读取的日志文件 = S0000000.LOG?已处理的日志文件 = -?上次提交的事务 = 2005-03-14-17.47.33.000000DB20000I ROLLFORWARD 命令成功完成。D:\db2 connect to dbname user db2admin using xxxxxSQL1117N 由于 ROLL-FORWARD PENDING，不能连接或激活数据库 dbname。SQLSTATE=57019D:\db2 rollforward db dbname complete? 前滚状态?输入数据库别名 = dbname?节点数已返回状态 = 1?节点号 = 0?前滚状态 = 未暂挂?下一个要读取的日志文件 =?已处理的日志文件 = -?上次提交的事务 = 2005-03-14-17.47.33.000000DB20000I ROLLFORWARD 命令成功完成。D:\db2 connect to dbname user db2admin using xxxxxx? 数