请教tsm自身的数据库文件恢复问题,急,谢谢!
我才接触tsm一个多星期,这次把单位的tsm自身的数据库文件删除了一个,db02.dsm,不小心删除的,另外的几个文件是db01.dsm,db03.dsm,db04.dsm,其它的都每删除,现在运行dsmserv启动不起来tsm server了,提示db02.dsm这个文件找不到,我查看了dsmserv.dsk文件,里面有tsmserver的一些dsm文件信息,我把db02.dsm那一项注释掉了,还是起不来,请问怎么恢复这个文件阿,好着急阿。我的tsm是5版本,在红旗linux DC5.0sp2版本。tsm被之前的工程师设置为默认不使用安装默认的db.dsm和log.dsm。我把dsmserv.dsk里面只写两行/path/db.dsm和/path/log.dsm就能起来,但是磁带,备份信息都没有了。使用原来的dsmserv.dsk又启动不起来。恳请大家帮助一下我把。我现在十分后悔删除了db02.dsm。 坐等高手来告诉你,那几个文件是做啥用的先。 本帖最后由 donggua0713 于 2010-07-20 09:40 编辑首先,你确定这4个文件是数据库文件,然后,你有这个数据库的备份吗? 谢谢楼上的回答,请帮我分析一下:
我运行dsmserv错误如下:
# dsmserv
Tivoli Storage Manager for Linux/i386
Version 5, Release 3, Level 0.0
Licensed Materials - Property of IBM
(C) Copyright IBM Corporation 1990, 2004.
All rights reserved.
U.S. Government Users Restricted Rights - Use, duplication or disclosure
restricted by GSA ADP Schedule Contract with IBM Corporation.
ANR7800I DSMSERV generated at 05:35:17 on Dec6 2004.
ANR7801I Subsystem process ID is 8162.
ANR0900I Processing options file dsmserv.opt.
ANR4726I The ICC support module has been loaded.
ANR0990I Server restart-recovery in progress.
ANR7806W Unable to open file /opt/tivoli/tsm/server/bin/db02.dsm.
Explanation (open error): ??
ANR0259E Unable to read complete restart/checkpoint information from any database or recovery log volume.
dsmserv.dsk 的内容如下:
# more dsmserv.dsk
#dsk_comment#page_shadow_token:1100719112535
/tsmdata/tsmlog/log01.dsm
/tsmdata/tsmdb/db01.dsm
/opt/tivoli/tsm/server/bin/db02.dsm
/tsmdata/tsmdb/db03.dsm
/tsmdata/tsmdb/db04dsm
/tsmdata/tsmlog/log02.dsm
我不确定是否有备份啊,我现在就是不熟悉tsm。我找到/tsmdata/tsmback目录下有如下文件,貌似是备份的吧?
-rw-------1 root root 4194304007月 18 06:54 79407279.dbb
-rw-------1 root root 4194304007月 18 06:55 79407294.dbb
-rw-------1 root root 4194304007月 18 06:55 79407323.dbb
-rw-------1 root root 4194304007月 18 06:55 79407340.dbb
-rw-------1 root root 2694040517月 18 06:56 79407357.dbb
-rw-------1 root root 4194304007月 19 06:56 79493680.dbb
-rw-------1 root root 4194304007月 19 06:56 79493775.dbb
-rw-------1 root root 4194304007月 19 06:56 79493787.dbb
-rw-------1 root root 4194304007月 19 06:56 79493800.dbb
-rw-------1 root root 2699217247月 19 06:57 79493814.dbb
-rw-r--r--1 root root 16247月 19 06:54 devconfig
drwxr-xr-x2 root root 40962月 282008 tsmbackscripts
-rw-------1 root root 1962554982月 282008 tsmdbbk280208.dsm
-rw-r--r--1 root root 140797月 19 06:54 volhistory
我看devconfig内容如下:
/* Device Configuration */
DEFINE DEVCLASS 3583CLASS DEVTYPE=LTO FORMAT=DRIVE MOUNTLIMIT=DRIVES MOUNTWAIT=60 MOUNTRETENTION=60 PREFIX=ADSM LIBRARY=3583L
IB
DEFINE DEVCLASS DBBACK DEVTYPE=FILE FORMAT=DRIVE MAXCAPACITY=409600K MOUNTLIMIT=20 DIRECTORY=/tsmdata/tsmback SHARED=NO
SET SERVERNAME SERVER1
DEFINE LIBRARY 3583LIB LIBTYPE=SCSI SERIAL="0000013262461000" SHARED=NO
DEFINE DRIVE 3583LIB 3580DRV01 ELEMENT=256 ONLINE=Yes WWN="500308FF43FF6001" SERIAL="1110330534"
/* LIBRARYINVENTORY SCSI 3583LIB ZY5060L2 4114 101*/
/* LIBRARYINVENTORY SCSI 3583LIB ZY5061L2 4115 101*/
/* LIBRARYINVENTORY SCSI 3583LIB ZY5062L2 4116 101*/
/* LIBRARYINVENTORY SCSI 3583LIB ZY5063L2 4117 101*/
/* LIBRARYINVENTORY SCSI 3583LIB ZY5064L2 4118 101*/
/* LIBRARYINVENTORY SCSI 3583LIB ZY5065L2 4119 101*/
/* LIBRARYINVENTORY SCSI 3583LIB ZY5066L2 4120 101*/
/* LIBRARYINVENTORY SCSI 3583LIB ZY5067L2 4121 101*/
/* LIBRARYINVENTORY SCSI 3583LIB ZY5070L2 4096 101*/
/* LIBRARYINVENTORY SCSI 3583LIB ZY5071L2 4097 101*/
/* LIBRARYINVENTORY SCSI 3583LIB ZY5072L2 4098 101*/
/* LIBRARYINVENTORY SCSI 3583LIB ZY5073L2 4099 101*/
/* LIBRARYINVENTORY SCSI 3583LIB ZY5074L2 4100 101*/
/* LIBRARYINVENTORY SCSI 3583LIB ZY5075L2 4101 101*/
/* LIBRARYINVENTORY SCSI 3583LIB ZY5076L2 4102 101*/
/* LIBRARYINVENTORY SCSI 3583LIB ZY5077L2 4103 101*/
/* LIBRARYINVENTORY SCSI 3583LIB ZY5078L2 4104 101*/
/* LIBRARYINVENTORY SCSI 3583LIB ZY5079L2 4105 101*/
DEFINE PATH SERVER1 3583LIB SRCTYPE=SERVER DESTTYPE=LIBRARY DEVICE=/dev/IBMchanger0 ONLINE=YES
DEFINE PATH SERVER1 3580DRV01 SRCTYPE=SERVER DESTTYPE=DRIVE LIBRARY=3583LIB DEVICE=/dev/IBMtape0 ONLINE=YES
这些信息,请大拿帮我看看,如果这些是备份信息的话,我如何操作??谢谢!!
还有,我删除db02.dsm有5天了,但是tsmserver居然一直跑着,没出问题,我昨天重启机器就起不来了。 tsm真不懂
是不是类似于nbu的catalog库的东西啊 cat volhistory文件看看 对。就是类似NBU里的CATALOG。
这个DB01.LOG如果没有备份的话,只能把你以前配置的备份重新创建了。磁带里的目录信息也没有了。 more volhistory的信息如下,请看看
# more volhistory
*********************************************************************************************************
*
* Sequential Volume Usage History
* Updated 07/19/2010 06:54:40 AM
*
* Operation Volume Backup Backup Volume Device Volume
* Date/Time Type Series Oper. Seq Class Name Name
*********************************************************************************************************
2008/02/04 17:47:01STGNEW 0 0 0 3583CLASS ZY5060L2
2008/02/04 18:12:25STGNEW 0 0 0 3583CLASS ZY5061L2
2008/02/05 03:43:25STGNEW 0 0 0 3583CLASS ZY5062L2
2008/02/05 04:38:53STGNEW 0 0 0 3583CLASS ZY5063L2
2008/02/05 05:11:19STGNEW 0 0 0 3583CLASS ZY5064L2
2008/02/05 06:10:21STGNEW 0 0 0 3583CLASS ZY5065L2
2008/02/05 06:47:15STGNEW 0 0 0 3583CLASS ZY5066L2
2008/02/05 07:34:40STGNEW 0 0 0 3583CLASS ZY5067L2
2008/02/05 13:39:49STGNEW 0 0 0 3583CLASS ZY5070L2
2008/02/06 04:07:36STGNEW 0 0 0 3583CLASS ZY5071L2
2008/02/06 05:04:00STGNEW 0 0 0 3583CLASS ZY5072L2
2008/02/06 05:48:40STGNEW 0 0 0 3583CLASS ZY5073L2
2008/02/07 06:18:29STGNEW 0 0 0 3583CLASS ZY5074L2
2008/02/08 03:33:35STGNEW 0 0 0 3583CLASS ZY5075L2
2008/02/08 04:44:14STGNEW 0 0 0 3583CLASS ZY5076L2
2008/02/08 05:37:00STGNEW 0 0 0 3583CLASS ZY5077L2
2008/02/09 03:33:34STGNEW 0 0 0 3583CLASS ZY5078L2
2008/02/09 04:09:37STGNEW 0 0 0 3583CLASS ZY5079L2
2008/02/28 09:29:05STGDELETE 0 0 0 3583CLASS ZY5062L2
2008/02/28 09:29:05STGDELETE 0 0 0 3583CLASS ZY5063L2
2008/02/28 09:29:05STGDELETE 0 0 0 3583CLASS ZY5064L2
2008/02/28 09:29:05STGDELETE 0 0 0 3583CLASS ZY5065L2
2008/02/28 09:29:05STGDELETE 0 0 0 3583CLASS ZY5071L2
2008/02/28 09:29:05STGDELETE 0 0 0 3583CLASS ZY5072L2
2008/02/28 09:29:05STGDELETE 0 0 0 3583CLASS ZY5073L2
2008/02/28 09:29:05STGDELETE 0 0 0 3583CLASS ZY5074L2
2008/02/28 09:29:05STGDELETE 0 0 0 3583CLASS ZY5075L2
2008/02/28 09:29:05STGDELETE 0 0 0 3583CLASS ZY5076L2
2008/02/28 09:29:05STGDELETE 0 0 0 3583CLASS ZY5077L2
2008/02/28 09:29:05STGDELETE 0 0 0 3583CLASS ZY5078L2
2008/02/28 09:29:05STGDELETE 0 0 0 3583CLASS ZY5079L2
2008/02/28 09:30:01STGNEW 0 0 0 3583CLASS ZY5062L2
2008/02/29 04:06:00STGNEW 0 0 0 3583CLASS ZY5063L2
2008/02/29 05:07:02STGNEW 0 0 0 3583CLASS ZY5064L2
2008/02/29 05:40:16STGNEW 0 0 0 3583CLASS ZY5065L2
2008/02/29 06:16:49STGNEW 0 0 0 3583CLASS ZY5071L2
2008/02/29 07:14:55STGNEW 0 0 0 3583CLASS ZY5072L2
2008/02/29 08:24:08STGNEW 0 0 0 3583CLASS ZY5073L2
2008/02/29 09:00:57STGNEW 0 0 0 3583CLASS ZY5074L2
2008/02/29 09:58:59STGNEW 0 0 0 3583CLASS ZY5075L2
2008/03/01 04:45:33STGNEW 0 0 0 3583CLASS ZY5076L2
2008/03/01 05:13:10STGNEW 0 0 0 3583CLASS ZY5077L2
2008/03/01 05:48:19STGNEW 0 0 0 3583CLASS ZY5078L2
2008/03/06 22:06:58STGDELETE 0 0 0 3583CLASS ZY5071L2
2008/03/06 22:08:25STGDELETE 0 0 0 3583CLASS ZY5077L2
2008/03/06 22:12:17STGNEW 0 0 0 3583CLASS ZY5071L2
2008/03/06 22:47:24STGDELETE 0 0 0 3583CLASS ZY5063L2
2008/03/06 22:47:44STGDELETE 0 0 0 3583CLASS ZY5064L2
2008/03/06 22:48:04STGDELETE 0 0 0 3583CLASS ZY5065L2
2008/03/06 22:48:37STGDELETE 0 0 0 3583CLASS ZY5072L2
2008/03/06 22:49:02STGDELETE 0 0 0 3583CLASS ZY5073L2
2008/03/06 22:49:24STGDELETE 0 0 0 3583CLASS ZY5074L2
2008/03/06 22:49:43STGDELETE 0 0 0 3583CLASS ZY5076L2
2008/03/06 22:50:02STGDELETE 0 0 0 3583CLASS ZY5078L2
2008/03/06 23:14:38STGNEW 0 0 0 3583CLASS ZY5063L2
2008/03/07 00:17:29STGNEW 0 0 0 3583CLASS ZY5064L2
2008/03/07 01:06:31STGNEW 0 0 0 3583CLASS ZY5065L2
2008/03/07 02:23:54STGNEW 0 0 0 3583CLASS ZY5072L2
2008/03/07 03:21:39STGNEW 0 0 0 3583CLASS ZY5073L2
2008/03/07 04:20:28STGNEW 0 0 0 3583CLASS ZY5074L2
2008/03/07 05:22:32STGNEW 0 0 0 3583CLASS ZY5076L2
2008/03/07 06:09:10STGNEW 0 0 0 3583CLASS ZY5077L2
2008/03/07 07:11:45STGNEW 0 0 0 3583CLASS ZY5078L2
2008/03/07 13:56:28STGDELETE 0 0 0 3583CLASS ZY5064L2
2008/03/07 13:56:28STGDELETE 0 0 0 3583CLASS ZY5065L2
2008/03/07 13:56:28STGDELETE 0 0 0 3583CLASS ZY5072L2
2008/03/07 13:56:28STGDELETE 0 0 0 3583CLASS ZY5073L2
2008/03/07 13:56:28STGDELETE 0 0 0 3583CLASS ZY5074L2
2008/03/07 13:56:28STGDELETE 0 0 0 3583CLASS ZY5076L2
2008/03/07 13:56:28STGDELETE 0 0 0 3583CLASS ZY5077L2
2008/03/07 14:49:55STGNEW 0 0 0 3583CLASS ZY5064L2
2008/03/07 15:49:56STGNEW 0 0 0 3583CLASS ZY5065L2
2008/03/07 16:12:02STGNEW 0 0 0 3583CLASS ZY5072L2
2008/03/09 03:33:29STGNEW 0 0 0 3583CLASS ZY5073L2
2008/03/09 04:46:28STGNEW 0 0 0 3583CLASS ZY5074L2
2008/03/09 05:32:55STGNEW 0 0 0 3583CLASS ZY5076L2
2008/03/09 06:35:02STGNEW 0 0 0 3583CLASS ZY5077L2
2008/03/12 15:57:42STGDELETE 0 0 0 3583CLASS ZY5064L2
2008/03/12 15:57:42STGDELETE 0 0 0 3583CLASS ZY5073L2
2008/03/12 15:57:42STGDELETE 0 0 0 3583CLASS ZY5074L2
2008/03/12 15:57:42STGDELETE 0 0 0 3583CLASS ZY5076L2
2008/03/12 15:57:42STGDELETE 0 0 0 3583CLASS ZY5077L2
2008/03/12 15:58:32STGNEW 0 0 0 3583CLASS ZY5064L2
2008/03/13 12:08:58STGNEW 0 0 0 3583CLASS ZY5073L2
2008/03/17 06:25:29STGNEW 0 0 0 3583CLASS ZY5074L2
2008/04/08 06:32:23STGNEW 0 0 0 3583CLASS ZY5076L2
2008/04/25 17:31:32STGDELETE 0 0 0 3583CLASS ZY5065L2
2008/04/25 17:31:32STGDELETE 0 0 0 3583CLASS ZY5070L2
2008/04/29 17:46:43STGDELETE 0 0 0 3583CLASS ZY5060L2
2008/04/29 17:52:36STGDELETE 0 0 0 3583CLASS ZY5061L2
2008/04/29 17:53:36STGDELETE 0 0 0 3583CLASS ZY5062L2
2008/05/06 13:47:45STGNEW 0 0 0 3583CLASS ZY5060L2
2008/05/12 18:29:15STGDELETE 0 0 0 3583CLASS ZY5075L2
2008/05/13 18:35:00STGDELETE 0 0 0 3583CLASS ZY5063L2
2008/05/20 13:44:58STGNEW 0 0 0 3583CLASS ZY5061L2
2008/05/28 19:44:01STGDELETE 0 0 0 3583CLASS ZY5064L2
2008/06/24 05:28:53STGNEW 0 0 0 3583CLASS ZY5070L2
2008/07/02 20:41:48STGDELETE 0 0 0 3583CLASS ZY5076L2
2008/07/11 02:42:56STGNEW 0 0 0 3583CLASS ZY5062L2
2008/07/26 19:19:09STGDELETE 0 0 0 3583CLASS ZY5060L2
2008/07/29 01:05:44STGNEW 0 0 0 3583CLASS ZY5060L2
2008/07/30 02:41:47STGNEW 0 0 0 3583CLASS ZY5075L2
2008/08/05 16:47:21STGNEW 0 0 0 3583CLASS ZY5063L2
2008/09/02 01:20:15STGNEW 0 0 0 3583CLASS ZY5065L2
2008/09/14 01:29:23STGDELETE 0 0 0 3583CLASS ZY5074L2
2008/09/16 16:44:28STGNEW 0 0 0 3583CLASS ZY5077L2
2008/09/26 04:05:41STGDELETE 0 0 0 3583CLASS ZY5061L2
2008/10/01 04:32:16STGDELETE 0 0 0 3583CLASS ZY5072L2
2008/10/03 12:44:39STGNEW 0 0 0 3583CLASS ZY5061L2
2008/10/07 05:09:53STGDELETE 0 0 0 3583CLASS ZY5070L2
2008/10/17 06:16:46STGDELETE 0 0 0 3583CLASS ZY5060L2
2008/10/21 06:09:26STGNEW 0 0 0 3583CLASS ZY5070L2
2008/11/01 13:04:45STGNEW 0 0 0 3583CLASS ZY5060L2
2008/11/11 08:36:40STGNEW 0 0 0 3583CLASS ZY5072L2
2008/11/19 08:56:06STGDELETE 0 0 0 3583CLASS ZY5065L2
2008/11/19 08:56:06STGDELETE 0 0 0 3583CLASS ZY5063L2
2008/11/26 13:25:15STGNEW 0 0 0 3583CLASS ZY5063L2
2008/12/03 13:03:50STGNEW 0 0 0 3583CLASS ZY5064L2
2008/12/16 02:54:01STGNEW 0 0 0 3583CLASS ZY5065L2
2008/12/17 12:19:41STGNEW 0 0 0 3583CLASS ZY5074L2
2008/12/30 02:54:57STGNEW 0 0 0 3583CLASS ZY5076L2
2009/10/22 12:04:42STGDELETE 0 0 0 3583CLASS ZY5060L2
2009/10/22 12:08:19STGDELETE 0 0 0 3583CLASS ZY5061L2
2009/10/22 12:18:51STGDELETE 0 0 0 3583CLASS ZY5062L2
2009/10/22 15:18:51STGNEW 0 0 0 3583CLASS ZY5061L2
2009/10/22 16:21:34STGNEW 0 0 0 3583CLASS ZY5062L2
2009/10/28 12:57:52STGNEW 0 0 0 3583CLASS ZY5060L2
2009/11/27 16:26:20STGDELETE 0 0 0 3583CLASS ZY5075L2
2009/11/28 03:27:18STGNEW 0 0 0 3583CLASS ZY5075L2
2010/01/10 19:47:07STGDELETE 0 0 0 3583CLASS ZY5061L2
2010/01/10 19:49:09STGNEW 0 0 0 3583CLASS ZY5061L2
2010/07/18 06:54:39BACKUPFULL 96 0 1 DBBACK /tsmdata/tsmback/79407279.DBB
2010/07/18 06:54:39BACKUPFULL 96 0 2 DBBACK /tsmdata/tsmback/79407294.DBB
2010/07/18 06:54:39BACKUPFULL 96 0 3 DBBACK /tsmdata/tsmback/79407323.DBB
2010/07/18 06:54:39BACKUPFULL 96 0 4 DBBACK /tsmdata/tsmback/79407340.DBB
2010/07/18 06:54:39BACKUPFULL 96 0 5 DBBACK /tsmdata/tsmback/79407357.DBB
2010/07/19 06:53:16BACKUPFULL 97 0 1 3583CLASS ZY5079L2 2010/07/18 06:54:39BACKUPFULL 96 0 1 DBBACK /tsmdata/tsmback/79407279.DBB
2010/07/18 06:54:39BACKUPFULL 96 0 2 DBBACK /tsmdata/tsmback/79407294.DBB
2010/07/18 06:54:39BACKUPFULL 96 0 3 DBBACK /tsmdata/tsmback/79407323.DBB
2010/07/18 06:54:39BACKUPFULL 96 0 4 DBBACK /tsmdata/tsmback/79407340.DBB
2010/07/18 06:54:39BACKUPFULL 96 0 5 DBBACK /tsmdata/tsmback/79407357.DBB
有这么几个数据库的备份。
很奇怪哦,为什么在同一时间,连续备份5个呢?
可以用这5个备份来恢复数据库 用dsmserv restore db就可以恢复了.
如果恢复过程中出现什么问题,把所有的你的操作步骤,出现的信息贴上来