環境歸檔

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] [] []
做了很久都先卡在這邊了，換到別的機器上去做吧。。。