2009年9月27日 上周要查寻马司系统中问题,须对归档分析,但有如下问题。
1. SQL> execute dbms_logmnr.add_logfile(LogFileName =>'/u01/databak/jzxgl/ARCH_1_4606.dbf',Options => dbms_logmnr.new);
BEGIN dbms_logmnr.add_logfile(LogFileName =>'/u01/databak/jzxgl/ARCH_1_4606.dbf',Options => dbms_logmnr.new); END;
*
ERROR at line 1:
ORA-01284: file /u01/databak/jzxgl/ARCH_1_4606.dbf cannot be opened
ORA-00308: cannot open archived log '/u01/databak/jzxgl/ARCH_1_4606.dbf'
ORA-27047: unable to read the header block of file
Additional information: 2
ORA-06512: at "SYS.DBMS_LOGMNR", line 68
ORA-06512: at line 1
对应这个问题,应该是linux系统与unix系统下的块的不同造成的吧,不能分析归档。
2009年10月21日 在做江阴测试库时,去分析归档时,有如下错误。之前就有发现过,改用青州测试完成。
2.SQL> execute dbms_logmnr.start_logmnr(DictFileName => '/databak/jydict.ora');
BEGIN dbms_logmnr.start_logmnr(DictFileName => '/databak/jydict.ora'); END;
*
ERROR at line 1:
ORA-01843: not a valid month
ORA-06512: at line 1
看看这个应该是时间上的问题,测下就明白了。
SQL> select to_char(sysdate,'month dd,yyyy') from dual;
TO_CHAR(SYSDATE,'MONTHDD
------------------------
10£? 21,2009
SQL> alter session set nls_date_language = AMERICAN; (要更改的话,应该在初始化文件里)
Session altered.
SQL> select to_char(sysdate,'month dd,yyyy') from dual;
TO_CHAR(SYSDATE,'MONTHDD,YYYY')
----------------------------------
october 21,2009
SQL> execute dbms_logmnr.start_logmnr(DictFileName => '/databak/jydict.ora');
PL/SQL procedure successfully completed.
这样就可以执行成功了。
还有一点就是环境变量问题。
$ env | grep NLS
NLS_LANG=simplified chinese_china.zhs16cgb231280 AMERICAN
ORA_NLS33=/u01/app/oracle/product/8.1.7/ocommon/nls/admin/data
更改掉就可以了,就不会再出现这问题了.
SQL> create table test as select * from v$logmnr_contents;
create table test as select * from v$logmnr_contents
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel 经典错误。
查看alert.log后发现,原因这问题太难弄了。
Wed Oct 21 12:14:26 2009
Errors in file /u01/app/oracle/admin/ora817/udump/ora817_ora_1663.trc:
ORA-07445: exception encountered: core dump [0000000100DD27DC] [SIGBUS] [Invalid
address alignment] [47649372] [] []
做了很久都先卡在这边了,换到别的机器上去做吧。。。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15242702/viewspace-666012/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/15242702/viewspace-666012/