本文記錄一個真實案例:Oracle 10g 資料庫運行於 AIX 5.2 作業系統。資料庫系統檔案位於 rootvg 的 /oracle 檔案系統,資料檔案位於 datavg 的 /oradata 檔案系統。控制檔案分別在 $ORACLE_HOME/dbs/ 一個、/oradata 兩個。重做日誌檔案在 $ORACLE_HOME/dbs/ 和 /oradata 各一組,共三組。擁有最新的 SPFILE 備份。
ORA-00444: background process "MMAN" failed while starting ORA-07446: sdnfy: bad value '' for parameter . Cause: The directory specified as the value for the stated parameter could not be used. Action: Make sure the directory you have specified is a valid directory/file specification.
SQL> create pfile from spfile; File created.依 PFILE 內容建立缺少的後台進程目錄與歸檔目錄:
$ cd $ORACLE_BASE/hb052500/ $ mkdir bdump $ cd $ORACLE_HOME/dbs/ $ mkdir archive
ORA-01990: error opening password file '/oracle/app/oracle/OraHome/dbs/orapw' ORA-27037: unable to obtain file status IBM AIX RISC System/6000 Error: 2: No such file or directory
orapwd file=$ORACLE_HOME/dbs/orapwd.ora password=oracle
SQL> alter database flashback off; Database altered. SQL> alter database open; Database altered.
SQL> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination /oracle/app/oracle/OraHome/dbs/archive Oldest online log sequence 614 Next log sequence to archive 616 Current log sequence 616