恢复的问题可能...... [英] problem with a restore maybe ...
问题描述
我想知道恢复正在做什么。
我的DB2版本是Linux RH ES 2.1上的7.2版本。
我已复制NAS上的最新备份，以便在我的机器上进行测试。
然后我使用简单的
命令行db2 restore backup DBNAME创建数据库来恢复备份。
For信息，我把自己放在包含
备份的文件夹（目录）上。
恢复一开始很顺利，但是30分钟之后它是善良的......
卡住了。
我做了''ps aux | grep DBNAME''我已经注意到这个过程被卡住了
（S为SLEEP）。
所以我杀了它（对不起我有点像野蛮的这一个）与
''杀死-9''。
这个过程就像你想象的那样，剪掉了。
我稍后尝试进行恢复，但以下消息不断发生
：" SQL1042C发生了意外的系统错误。 SQLSTATE = 58004" 。
我首先想到的是备份已损坏（通常是在Oracle中的日志文件中使用
）所以我将其删除并再次解压缩。 />
但问题仍然存在。
问题：知道发生了什么事吗？
提前Thx。
Andy是DB2的初学者。
ps1：这个平台上没有数据库。 （我没有创建一个
数据库）
ps2：我的备份就像那样
DBNAME.0.db2inst1.NODE0000。 CATN0000.20050531020000 .001
Hi ,
I''m wondering what''s going on with a restore I''m trying to do .
My DB2 version is a 7.2 on a Linux RH ES 2.1 .
I''ve copy a recent backup that was on NAS for a test on my machine .
I then restore the backup without creating a database with the simple
command line "db2 restore backup DBNAME".
For information , I put myself on the folder (directory) that contains
the backup .
The restore went quite well at first but 30 mn later it was kind of ...
stuck .
I did a ''ps aux | grep DBNAME'' and I''ve noticed the process was stuck
(S for SLEEP).
So I killed it (sorry I was kind of barbaric with this one) with a
''kill -9'' .
The process was as you can imagine , snipped .
I try later to do a restore but the following message keep coming
:"SQL1042C An unexpected system error occurred. SQLSTATE=58004" .
I thought first that the backup was corrupted (It happens often with
the logfile in Oracle) so I deleted it and unzip it again .
But the problem keep coming .
Question : Any idea what''s going on ?
Thx in Advance .
Andy the beginner in DB2 .
ps1: there is no database on this platform . (I didn''t create a single
database)
ps2: My backup is like that
DBNAME.0.db2inst1.NODE0000.CATN0000.20050531020000 .001
推荐答案
你检查过Db2diag.log吗？
你有必要的系统吗？资源？你能找到时间吗？b $ b认为它是挂起的，并从db2diag.log跟踪它b / b
并查看当时是否有任何错误。
顺便说一句，你确定你执行了命令，db2 restore backup
DBNAME ？ ，语法看起来不太好
Did you check Db2diag.log ?
Do you have necessary system resources ? Can you find the time you
think it''s hang , and track it from db2diag.log
and see if any error persisting at that time.
By the way , you sure you executed the command , "db2 restore backup
DBNAME" ? , the syntax doesn''t look good
Hi,
我是我想知道恢复正在进行什么。
我的DB2版本是Linux RH ES 2.1上的7.2版本。
我不知道我是否真的可以帮助你，因为我有类似的问题
只有Win32上的8.1.7。但也许它至少可以帮助你处理IBM支持。
我已经复制了NAS上的最新备份以便在我的机器上进行测试。
我将备份映像从一个8.1.7 / w2k3系统复制到另一个系统并且
将其恢复到那里。在休息期间我没有做任何残忍的事情，并且
甚至没有错误地向前推进了restoerd数据库（这是我恢复的在线
备份）。 br />
然后我恢复备份而不用
简单命令行db2 restore backup DBNAME创建数据库。
对我来说很奇怪。 8.x语法wood是db2 restore DATABASE dbname。
当然你按照你描述的方式做到了吗？
我稍后再尝试做一次恢复但是以下消息仍然存在
：SQL1042C发生了意外的系统错误。 SQLSTATE = 58004" 。
I''m wondering what''s going on with a restore I''m trying to do .
My DB2 version is a 7.2 on a Linux RH ES 2.1 .
I don''t know if I really can help you, cause I had similiar problems
only with 8.1.7 on Win32. But maybe it could help at least if you are
dealing with the IBM support.
I''ve copy a recent backup that was on NAS for a test on my machine .
I copied a backup image from one 8.1.7/w2k3 system to another and
restored it there. I didn''t do anything cruel during the restoer, and
even rolled forward the restoerd db without an error (it was an online
backup I restored from).
I then restore the backup without creating a database with the
simple command line "db2 restore backup DBNAME".
Looks strange to me. 8.x syntax wood be "db2 restore DATABASE dbname".
Sure you did it the way you described?
I try later to do a restore but the following message keep coming
:"SQL1042C An unexpected system error occurred. SQLSTATE=58004" .
这就是我在整个恢复过程中得到的，因为我尝试了简单的连接到XXXXX。 （请记住：对我而言，在W2K3上它是8.1.7）。
经过一些调查我们了解到，这是一个问题acl
在文件系统上，由DB2在恢复期间自行设置。这是用FP8固定的（对于8.x）
。也许你的中断恢复留下了
表空间容器上的一些错误的设置访问标志？试图清理
在第一次恢复期间创建的桌面空间？
问候，
Bernd
That''s exactly what I got after the whole restore process as I tried a
simple "CONNECT TO XXXXX" (keep in mind: For me it was 8.1.7 on W2K3).
After some investigation we learned, that it was a problem with the acl
on the file system, set by DB2 by itself during the restore. That was
fixed (for 8.x) with FP8. Maybe your interrupted restore left behind
some wrong set access flags on the tablespace containers? Tried to clean
out the table spaces created during your first restore?
Regards,
Bernd
大家好，
感谢您的见解。
它非常有帮助。
目前的情况：我的恢复正在进行中。它与昨天的b $ b相同，意味着它似乎已经睡着了。
这一次，我不会狙击它。
为了恢复，我必须创建另一个数据库DBNAME
并使用以下命令行恢复它：
从/ opt / db2inst1 / bck031 / savdatabase恢复db DBNAME
20050531020000重定向;
不确定结果会是什么，但会看到。
问候，
安迪在DB2中初学者
ps：一些链接为我提供了一些帮助。
http://www-106.ibm.com/developerwork...nxw07=DBclones
http://divbyzero.com/PHP/view-source ... ate-tables.sql
Andy Kaécrit：
Hi everyone ,
Thanks for your insight .
It''s been quite helpful .
Current situation : My restore is on the way . It''s the same thing than
yesterday mean it seems to be asleep.
This time , I won''t snipe it.
For that restore to happen , I had to create an another database DBNAME
and restore it with the following command line :
restore db DBNAME from /opt/db2inst1/bck031/savdatabase taken at
20050531020000 redirect;
Not sure what the result will be but will see .
Regards,
Andy the beginner in DB2
ps: a few link that provided me some help .
http://www-106.ibm.com/developerwork...nxw07=DBclones
http://divbyzero.com/PHP/view-source...ate-tables.sql
Andy K a écrit :
我想知道恢复正在做什么。
我的DB2版本是Linux RH ES 2.1上的7.2版。
我已经复制了NAS上的最新备份，以便在我的机器上进行测试。
然后我使用简单的
命令行db2 restore backup DBNAME创建数据库来恢复备份。
有关信息，我将自己置于文件夹（目录） ）包含
备份。
恢复进行得很顺利，但30分钟后它有点......
卡住了。
我做了''ps aux | grep DBNAME''我已经注意到这个过程被卡住了（S代表SLEEP）。
所以我把它杀死了（抱歉我对这个有点野蛮） br'>''kill -9''。
这个过程就像你想象的那样，剪掉了。
我后来尝试进行恢复，但以下信息不断出现
：SQL1042C发生了意外的系统错误。 SQLSTATE = 58004" 。
我首先想到备份已损坏（通常是在Oracle中的日志文件中发生）所以我将其删除并再次解压缩。
但是问题一直存在。
问题：知道发生了什么事吗？
Thx提前。
Andy是DB2的初学者。
ps1：这个平台上没有数据库。 （我没有创建单个
数据库）
ps2：我的备份就像那样。
DBNAME.0.db2inst1.NODE0000.CATN0000.20050531020000 .001
Hi ,
I''m wondering what''s going on with a restore I''m trying to do .
My DB2 version is a 7.2 on a Linux RH ES 2.1 .
I''ve copy a recent backup that was on NAS for a test on my machine .
I then restore the backup without creating a database with the simple
command line "db2 restore backup DBNAME".
For information , I put myself on the folder (directory) that contains
the backup .
The restore went quite well at first but 30 mn later it was kind of ...
stuck .
I did a ''ps aux | grep DBNAME'' and I''ve noticed the process was stuck
(S for SLEEP).
So I killed it (sorry I was kind of barbaric with this one) with a
''kill -9'' .
The process was as you can imagine , snipped .
I try later to do a restore but the following message keep coming
:"SQL1042C An unexpected system error occurred. SQLSTATE=58004" .
I thought first that the backup was corrupted (It happens often with
the logfile in Oracle) so I deleted it and unzip it again .
But the problem keep coming .
Question : Any idea what''s going on ?
Thx in Advance .
Andy the beginner in DB2 .
ps1: there is no database on this platform . (I didn''t create a single
database)
ps2: My backup is like that
DBNAME.0.db2inst1.NODE0000.CATN0000.20050531020000 .001
这篇关于恢复的问题可能......的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
