引數檔案丟失無法啟動_ 利用alert日誌修復

dengxm發表於2010-12-29

1、為了試驗需要,現刪除D:\work_tools\oracle\product\10.2.0\db_1\database下,SPFILEDXM.ORA 和 INITdxm.ORA

2、SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file 'D:\WORK_TOOLS\ORACLE\PRODUCT\10.2.0\DB
_1\DATABASE\INITDXM.ORA'
SQL>

3、利用D:\work_tools\oracle\product\10.2.0\admin\dxm\bdump\alert_dxm.log 建立 文字引數檔案
   
    建立D:\work_tools\oracle\product\10.2.0\db_1\database\INITdxm.ORA
   
    將alert_dxm.log中的如下部分,copy到INITdxm.ORA
    processes                = 400
  __shared_pool_size       = 88080384
  shared_pool_size         = 37748736
  __large_pool_size        = 4194304
  __java_pool_size         = 4194304
  __streams_pool_size      = 4194304
  sga_target               = 285212672
  control_files            = D:\WORK_TOOLS\ORACLE\PRODUCT\10.2.0\ORADATA\DXM\CONTROL01.CTL, D:\WORK_TOOLS\ORACLE\PRODUCT\10.2.0\ORADATA\DXM\CONTROL02.CTL, D:\WORK_TOOLS\ORACLE\PRODUCT\10.2.0\ORADATA\DXM\CONTROL03.CTL
  db_block_size            = 8192
  __db_cache_size          = 176160768
  db_cache_size            = 50331648
  compatible               = 10.2.0.1.0
  db_file_multiblock_read_count= 16
  db_recovery_file_dest    = D:\work_tools\oracle\product\10.2.0\flash_recovery_area
  db_recovery_file_dest_size= 2147483648
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  remote_login_passwordfile= EXCLUSIVE
  db_domain                =
  dispatchers              = (PROTOCOL=TCP) (SERVICE=dxmXDB)
  job_queue_processes      = 10
  audit_file_dest          = D:\WORK_TOOLS\ORACLE\PRODUCT\10.2.0\ADMIN\DXM\ADUMP
  background_dump_dest     = D:\WORK_TOOLS\ORACLE\PRODUCT\10.2.0\ADMIN\DXM\BDUMP
  user_dump_dest           = D:\WORK_TOOLS\ORACLE\PRODUCT\10.2.0\ADMIN\DXM\UDUMP
  core_dump_dest           = D:\WORK_TOOLS\ORACLE\PRODUCT\10.2.0\ADMIN\DXM\CDUMP
  db_name                  = dxm
  open_cursors             = 300
  pga_aggregate_target     = 94371840
  -------------------------------------------------------------------------------------------------
4、然後
SQL> startup force
ORA-01078: failure in processing system parameters
LRM-00116: syntax error at 'dispatchers' following '='
SQL>

5、根據錯誤提示,修改INITdxm.ORA
processes                = 400
  __shared_pool_size       = 88080384
  shared_pool_size         = 37748736
  __large_pool_size        = 4194304
  __java_pool_size         = 4194304
  __streams_pool_size      = 4194304
  sga_target               = 285212672
  control_files            = D:\WORK_TOOLS\ORACLE\PRODUCT\10.2.0\ORADATA\DXM\CONTROL01.CTL, D:\WORK_TOOLS\ORACLE\PRODUCT\10.2.0\ORADATA\DXM\CONTROL02.CTL, D:\WORK_TOOLS\ORACLE\PRODUCT\10.2.0\ORADATA\DXM\CONTROL03.CTL
  db_block_size            = 8192
  __db_cache_size          = 176160768
  db_cache_size            = 50331648
  compatible               = 10.2.0.1.0
  db_file_multiblock_read_count= 16
  db_recovery_file_dest    = D:\work_tools\oracle\product\10.2.0\flash_recovery_area
  db_recovery_file_dest_size= 2147483648
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = ''
  dispatchers              = '(PROTOCOL=TCP) (SERVICE=dxmXDB)'
  job_queue_processes      = 10
  audit_file_dest          = D:\WORK_TOOLS\ORACLE\PRODUCT\10.2.0\ADMIN\DXM\ADUMP
  background_dump_dest     = D:\WORK_TOOLS\ORACLE\PRODUCT\10.2.0\ADMIN\DXM\BDUMP
  user_dump_dest           = D:\WORK_TOOLS\ORACLE\PRODUCT\10.2.0\ADMIN\DXM\UDUMP
  core_dump_dest           = D:\WORK_TOOLS\ORACLE\PRODUCT\10.2.0\ADMIN\DXM\CDUMP
  db_name                  = dxm
  open_cursors             = 300
  pga_aggregate_target     = 94371840

6、根據文字檔案INITdxm.ORA 啟動資料庫  
SQL> startup
ORACLE instance started.

Total System Global Area  285212672 bytes
Fixed Size                  1248552 bytes
Variable Size             100664024 bytes
Database Buffers          176160768 bytes
Redo Buffers                7139328 bytes
Database mounted.
Database opened.
SQL> show parameter pfile;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string
SQL> show parameter spfile;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string
SQL>

7、根據文字檔案建立二進位制檔案
SQL> create pfile from spfile;
create pfile from spfile
*
ERROR at line 1:
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) 系統找不到指定的檔案。


SQL> create spfile from pfile;

File created.

SQL> show parameter spfile;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string
SQL> show parameter pfile;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string
SQL> startup force
ORACLE instance started.

Total System Global Area  285212672 bytes
Fixed Size                  1248552 bytes
Variable Size             100664024 bytes
Database Buffers          176160768 bytes
Redo Buffers                7139328 bytes
Database mounted.
Database opened.
SQL> show parameter pfile;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      D:\WORK_TOOLS\ORACLE\PRODUCT\1
                                                 0.2.0\DB_1\DATABASE\SPFILEDXM.
                                                 ORA
SQL>

 

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/13726712/viewspace-682774/,如需轉載,請註明出處,否則將追究法律責任。

相關文章