Archive for February, 2008

今天碰到ORA-600错误

Wednesday, February 13th, 2008

今天在standby上碰到ORA-600错误。在陈栋的帮助下，顺利饶过错误。事情过程大致如下：
当时STANDBY的空间是满的，且standby_file_management为AUTO
Primary:
我给UNDO TBS加了几个数据文件。
Standby:
发现日志无法恢复，提示ORA-600。
@>recover standby database;
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00283: recovery session canceled due to errors
ORA-01670: new datafile 25 needed for standby database recoveryORA-01157: cannot identify/lock data file 25 - see DBWR trace fileORA-01110: data file 25: ‘/disk2/oradata/crmcn/undotbs06.dbf’
@>alter database create datafile ‘/disk2/oradata/crmcn/undotbs06.dbf’ as ‘/backup/crmcn_wt/undotbs06.dbf’;Database altered.
此时undotbs06.dbf文件是过了，可以继续恢复。
@>recover standby database;Specify log: {<RET>=suggested | filename | AUTO [...]

Posted in 大话技术 | No Comments »

最有创意的新春短信

Thursday, February 7th, 2008

erpdb warning:ORA-02008:Hi guy,don’t worry,thanks for your care,I’m all right and strong,happy new year,dbas.
jacky祝大家2008新年快乐，万事如意。恋爱的恋爱，结婚的结婚，造人的造人，当爹的当爹，P10的升P11，数据库坚如磐石，alidba纳斯达克上市。
2008 Be part of something BIG!!!

Posted in 生活八卦 | 4 Comments »

今天我干的事，确实很怪

Sunday, February 3rd, 2008

由于我自己做了大量的DML操作，我CANCEL掉了。发现v$locked_object里还有被自己LOCK住的进程，火大了。就干脆来了把猛的：
select ‘kill -9 ‘ || a.spid from v$process a ,v$session b
where a.addr=b.paddr and machine like ‘%crmtest%’ ；（crmtest是我的主机名）
然后莫名其妙的事情就发生了：
补充下：我的SID：CRMCN，ORACLE 9.2.0.4 LINUX
远程是可以访问，但是本地除了SYSDBA以外，所有的用户都无法连接，就hang在那里。
可以SELECT,UPDATE，但是无法进行COMMIT;
@>SELECT SPID FROM V$PROCESS WHERE ADDR IN (SELECT PADDR FROM V$SESSION WHERE type <> ‘USER’);SPID
————
3687
3691
3693
3695
3697
3699
3703
3707 8 rows selected.@>HOST
oracle@crmtest:/home/oracle>ps -ef | grep 3687
oracle 29759 29728 0 14:01 pts/9 00:00:00 grep 3687
oracle@crmtest:/home/oracle>
再来一次：
oracle@crmtest:/home/oracle>ps -ef | grep pmon
oracle 17660 1 0 [...]

Posted in 大话技术 | 1 Comment »

街头惊现alidba广告

Saturday, February 2nd, 2008

Posted in 生活八卦 | 2 Comments »

强悍的oracle 文档中的错误解释

Saturday, February 2nd, 2008

http://download.oracle.com/docs/cd/B19306_01/server.102/b14219/plsus.htm#PLS-00101
PLS-00101: reserved for future use

Cause: This error message is not used yet. (Heh, heh, that”s a joke, son.)

Action: none

Posted in 大话技术 | 2 Comments »

Next Entries »
阿里巴巴DBA出品