亚洲精品无码永久在线观看男男,亚洲情综合五月天,4338×亚洲全国最大色成网站

Glorin — Tue, 17 Jan 2017 05:17:00 GMT

今天在给客户服务器Microsoft SQL Server2008数据库服务器��d��l�护计划时报错：

创徏�l�护计划��p�|�?br />------------------------------
其他信息:
�?IClassFactory �?CLSID �?{17BCA6E8-A95D-497E-B2F9-AF6AA475916F} �?COM �l��g创徏实例��p�|�Q�原因是出现以下错误: c001f011�?(Microsoft.SqlServer.ManagedDTS)
------------------------------
�?IClassFactory �?CLSID �?{17BCA6E8-A95D-497E-B2F9-AF6AA475916F} �?COM �l��g创徏实例��p�|�Q�原因是出现以下错误: c001f011�?(Microsoft.SqlServer.ManagedDTS)
解决�Ҏ��Q?br />C:\Documents and Settings\Administrator>regsvr32 "C:\Program Files\Microsoft SQL Server\100\DTS\Binn\DTS.dll"�Q?br />�Q�或�?div>C:\Documents and Settings\Administrator>regsvr32 "C:\Program Files(x86)\Microsoft SQL Server\100\DTS\Binn\DTS.dll"�Q?/div>

Glorin 2017-01-17 13:17 发表评论

Glorin — Mon, 02 Nov 2015 07:04:00 GMT

1、shutdown normal
正常方式关闭数据库�?nbsp;

2、shutdown immediate
   立即方式关闭数据库�?nbsp;
   在SVRMGRL中执行shutdown immediate�Q�数据库�q�不立即关闭�Q?nbsp;
   而是在Oracle执行某些清除工作后才关闭�Q�终止会话、释放会话资源）�Q?nbsp;
   当��用shutdown不能关闭数据库时�Q�shutdown immediate可以完成数据库关闭的操作�?

3、shutdown abort
直接关闭数据库，正在讉K��数据库的会话会被�H�然�l�止�Q?nbsp;
如果数据库中有大量操作正在执行，�q�时执行shutdown abort后，重新启动数据库需要很长时�?
--------------------------------------------------------
shutdown abort 的时候，�?/strong>kill �q�程是一��L��效果
数据库立卛_��闭，�q�个时候文件状态可能不一�?
因�ؓ正常关闭数据库会同步校验各文�Ӟ��使得重新启动的时候文件时间点一致�ƈ且不用进行崩溃恢�?/p>

若检查点信息一��_��则做崩溃恢复
若检查点信息不一��_��正好在更新文件头�Q�则需要做介质恢复

�q�些问题都好处理�Q�最怕的问题是这个时候系�l�有大量IO�Q�结果这样造成写的�H�然中断�Q�碰巧造成文�g块的逻辑坏块�Q�那�ȝ��比较大一些，��其是系�l�表�I�间的block损坏

虽然shutdown abort 出错的几率很��，1000个�h可能只有一个�h��到�Q�但是我们还是要��心�?
正确的处理流�E�是�Q�shutdown immediate ,若数据库�q�迟不能down下来�Q�在os上观察IO状况�Q�几乎没有io的时候，另开一�H�口shutdown abort �Q�几乎不会出问题�?br />--------------------------------------------------------
http://www.itpub.net/showthread.php?threadid=180315&pagenumber=
先用IMMEDIATE来DOWN�Q�实在不行了�Q�看一下数据库文�g上没IO了，再用ABORT
------------------------------------------------------------------------------
你可以尝试先在系�l��杀掉非后台Oracle�q�程�Q�在�q�接shutdown immediate��安全多�?/p>
在Oracle8i里，当数据库失去响应以后�Q�你在操作系�l�上杀掉用戯��E�后�Q�一般数据库��可以恢复正�怺�
-------------------------------------------------------------------------------
�?shutdown immediate 应该是首�?/p>
然后不行再重新shutdown abort

其实起不来也是因为os的缘故，在文件正在写的时候出现问题导致文件不一致或者损�?#8230;…

Glorin 2015-11-02 15:04 发表评论

Glorin — Wed, 30 Sep 2015 01:56:00 GMT
在给mysql数据库备份时�Q�报错：mysqldump: Got error: 145: Table './jxzhtopenfire/ofoffline' is marked as crashed and should be repaired when using LOCK TABLES�?br />如上错误的解��x��法如下：
1、进入数据库对该表进行检��：
mysql> check tables ofoffline;
+-------------------------+-------+----------+-------------------------------------------------------+
| Table                   | Op    | Msg_type | Msg_text                                              |
+-------------------------+-------+----------+-------------------------------------------------------+
| jxzhtopenfire.ofoffline | check | warning | Table is marked as crashed                            |
| jxzhtopenfire.ofoffline | check | warning | 1 client is using or hasn't closed the table properly |
| jxzhtopenfire.ofoffline | check | error    | Record at pos: 1175720 is not remove-marked           |
| jxzhtopenfire.ofoffline | check | error    | record delete-link-chain corrupted                    |
| jxzhtopenfire.ofoffline | check | error    | Corrupt                                               |
+-------------------------+-------+----------+-------------------------------------------------------+
5 rows in set
2、��用repair解决�Ҏ��Q?br />mysql> repair table ofoffline;
+-------------------------+--------+----------+------------------------------------------+
| Table                   | Op     | Msg_type | Msg_text                                 |
+-------------------------+--------+----------+------------------------------------------+
| jxzhtopenfire.ofoffline | repair | warning | Number of rows changed from 2349 to 2451 |
| jxzhtopenfire.ofoffline | repair | status   | OK                                       |
+-------------------------+--------+----------+------------------------------------------+
再次�q�行dump备䆾��可以了�?br />
备䆾mysql数据库时报错�Q�mysqldump: Got error: 145: Table './jxzhtopenfire/ofoffline' is marked as crashed and should be repaired when using LOCK TABLES�?br />
�q�样的错误�?br />搜烦了一下，发现只要在mysqldump的时候加�?-lock-tables=false��可以解决问题�?br />mysqldump -u root -pMyPassword DbName --lock-tables=false > data.sql

Glorin 2015-09-30 09:56 发表评论

ORA-01113: file 26 needs media recovery解决�Ҏ��

Glorin — Thu, 26 Sep 2013 01:49:00 GMT
问题�Q?br />
SQL> startup
ORACLE instance started.

Total System Global Area 538514184 bytes
Fixed Size                   451336 bytes
Variable Size             503316480 bytes
Database Buffers           33554432 bytes
Redo Buffers                1191936 bytes
Database mounted.
ORA-01113: file 26 needs media recovery
ORA-01110: data file 26: '/opt/ora9/product/oradata/NTDB/EXAMPLE02.dbf'
解决�Ҏ��Q?br />

SQL> recover datafile '/opt/ora9/product/oradata/NTDB/EXAMPLE02.dbf'
ORA-00279: change 244674111 generated at 09/24/2013 15:20:41 needed for thread
1
ORA-00289: suggestion : /opt/ora9/product/oracle/dbs/arch1_1123.dbf
ORA-00280: change 244674111 for thread 1 is in sequence #1123

Specify log: {=suggested | filename | AUTO | CANCEL}
auto
Log applied.
Media recovery complete.
SQL> alter database open;

Database altered.

Glorin 2013-09-26 09:49 发表评论

Glorin — Mon, 17 Jun 2013 01:58:00 GMT
oracle9i在进行数据库全库备䆾时出现如下错误：

Connected to: Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set

About to export the entire database ...
. exporting tablespace definitions
EXP-00008: ORACLE error 1187 encountered
ORA-01187: cannot read from file 201 because it failed verification tests
ORA-01110: data file 201: '/opt/ora9/product/oradata/NTDB/temp1.dbf'
EXP-00000: Export terminated unsuccessfully
从上面的错误信息可以看出是temp临时表空间的数据文�g有问题，解决办法�Q?br />1、删除��时表�I�间�Q?nbsp;alter database tempfile '/opt/ora9/product/oradata/NTDB/temp1.dbf' drop;
2、重建数据文�Ӟ��
alter tablespace temp add tempfile '/opt/ora9/product/oradata/NTDB/temp01.dbf' size 512M REUSE AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED;
通过上述两个步骤��可以解军_��q�行数据库备份时出现的ORACLE error 1187 encountered错误�?/p>

Glorin 2013-06-17 09:58 发表评论

Glorin — Fri, 31 Aug 2012 02:04:00 GMT

1、查�?etc/oratab�q�个文�g�Q?br />
[oracle@readhatAS53 etc]$ cat /etc/oratab
#

# This file is used by ORACLE utilities. It is created by root.sh
# and updated by the Database Configuration Assistant when creating
# a database.

# A colon, ':', is used as the field terminator. A new line terminates
# the entry. Lines beginning with a pound sign, '#', are comments.
#
# Entries are of the form:
#   $ORACLE_SID:$ORACLE_HOME::
#
# The first and second fields are the system identifier and home
# directory of the database respectively. The third filed indicates
# to the dbstart utility that the database should , "Y", or should not,
# "N", be brought up at system boot time.
#
# Multiple entries with the same $ORACLE_SID are not allowed.
#
#
ORCL:/u01/oracle/product/ora10g:Y
�?ORACLE_SID:$ORACLE_HOME: 讄��为Y�Ӟ��允许实例自启动，当设�|��ؓN�Ӟ��则不允许自启动�?�q�个文�g里的配置仅仅起一个开关的作用�Q�其�q�不会具体的执行启动和关闭，具体的操作由$ORACLE_HOME/bin/dbstart和dbshut 脚本来实现�?�q?个脚本在执行时会��?etc/oratab 文�g里的配置�Q��ؓY时才能��l�执行。因此只要将ORCL:/u01/oracle/product/ora10g:N修改为Y��p��了�?br />2、��用root用户�?font face="Verdana">/etc/rc.d/rc.local�q�个文�g中添加如下内容：

#!/bin/sh
#
# This script will be executed *after* all the other init scripts.
# You can put your own initialization stuff in here if you don't
# want to do the full Sys V style init stuff.

touch /var/lock/subsys/local
su - oracle -c'lsnrctl start'//启动oracle数据库监�?br />su - oracle -c'/u01/oracle/product/ora10g/bin/dbstart start'//启动oracle数据库实�?br />su - oracle -c'/opt/tomcat/apache-tomcat-6.0.20/bin/startup.sh'//启动tomcat服务器的配置�?br />
3、reboot�pȝ��Q�oracle数据库与tomcat服务器就可以自动启动了�?br />

Glorin 2012-08-31 10:04 发表评论