- 博客(13)
- 资源 (2)
- 收藏
- 关注
原创 Xtrabackup full backup
Step:create full backup:innobackupex --defaults-file=/etc/my.cnf --user=root --password=mysql /tmp/backupshutdown mysql:mysqladmin -uroot -p'mysql' -S /tmp/mysql.sock shutdownprepare:inn
2012-05-23 09:45:46 901
转载 Handling ORA-1403 ora-12801 on logical standby app
In this Document Purpose Last Review Date Instructions for the Reader Troubleshooting DetailsApplies to:Oracle Server - Enterprise Edition - Version: 9.2.0.8 to 11.2.0.1.0 -
2012-05-22 16:40:24 1186
原创 Oracle GRANT debug Procedure privillege
grant debug any procedure to xxx;grant debug connect session to xxx;
2012-05-22 10:07:26 2268
原创 mysqldump注意事项
参考三思笔记,需要重视这个无效view问题可能导致mysqldump失败.http://space.itpub.net/7607759/viewspace-697899 自己也先演练一下.mysql> create table kin(id int,sel varchar(10));Query OK, 0 rows affected (0.01 sec)mysql> cre
2012-05-21 16:49:40 829
原创 Oracle 11g(11.2.0.2) New Fetures-rename user
Step:1.create pfile from spfile;2.add parameter*._enable_rename_user='TRUE';3.startup restrict pfile=$ORACLE_HOME/dbs/initnode1.ora;4.alter user xxx rename to xxx identified by xxx;5.start
2012-05-16 15:47:00 650
原创 Linux设定时间,日期,时区
date -s 05/11/2012date -s 11:03:00date -s "2012-05-11 11:03:00" cp /usr/share/zoneinfo/Asia/Shanghai /etc/localtimevi /etc/sysconfig/clocZONE="Asia/Shanghai"UTC=falseARC=false cloc
2012-05-11 11:04:36 624
原创 Oracle Blocking Query Script
/* Formatted on 2012/05/09 11:29 (Formatter Plus v4.8.7) */SELECT /*+ choose */ bs.username "Blocking User", bs.username "DB User", ws.username "Waiting User", bs.SID "SID", ws
2012-05-09 11:49:10 623
原创 ORA-00054:resource busy and acquire with nowait specified
1.SELECT t2.username, t2.SID, t2.serial#, t2.logon_time FROM v$locked_object t1, v$session t2 WHERE t1.session_id = t2.SIDORDER BY t2.logon_time; 2.SELECT sql_text FROM v$s
2012-05-09 10:57:02 609
转载 Linux lsof找回系统下误删除数据文件
数据文件误删除案例:Kamus http://www.dbform.com/html/2011/1761.html环境:数据库处于open状态.1.找到dbw进程pid:ps -ef|grep dbw|grep -v grep 2.找回对应数据文件cd /proc/PID/fd ls -l...261 -> /oradata/KIN/example01.db
2012-05-08 14:12:05 933
转载 Oracle SQL Profile Notes
1.创建SQL Profile:1>create table kin as select * from dba_objects;create index kin_idx on kin(object_id);2>explain plan for select * from kin where object_id= :a;select * from table(dbms_xpl
2012-05-08 09:41:41 1032
原创 Oracle PGA参考
PGA Status:SELECT NAME, VALUE FROM v$pgastat WHERE NAME IN ('aggregate PGA target parameter', 'aggregate PGA auto target', 'total PGA inuse', 'tot
2012-05-07 19:13:03 573
原创 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Solution:mysql> use mysqlDatabase changedmysql> update user set password=old_password('mysql') where user='root' and host='localhost' ;Query OK, 1 row affected (0.07 sec)Rows matched: 1 C
2012-05-02 22:51:35 677
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人