一次修改系統引數導至ORACLE無法啟動例項的故障

事因：由於修改了CONTROL_FILES 引數,導至ORACLE 重啟後無法啟動,連例項也起不了.
如果INSTANCE能夠START, 那麼解決起來就很容易了,可是現在INSTANCE都啟不了.
可是我又不甘心用PFILE 起動,因此花費了半天時間研究琢磨,有點小收穫,在此分享.

[@more@]

1, SET CONTROL_FILES PARAMETER.
SQL> alter system set control_files='+NORM_DG1/ggctl01.ora,

+NORM_DG1/ggctl02.ora, d:hqgg.ora' scope=spfile;

2, START INSTANCE.
SQL> startup
ORA-15124: ASM file name '+NORM_DG1/ggctl01.ora, +NORM_DG1/ggctl02.ora,

d:hqgg.ora' contains an invalid alias name

3, USE UltraEdit to modify spfile located at
G:oracleproduct10.2.0db_1dbsspfilegg2.ora .
in binary mode, find and modify paramter to the correct value.

4, Retry :
SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file

'G:oracleproduct10.2.0db_1/dbs/spfilegg.ora'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch (OS 2561)

5, UnderStand and resolve the puzzle above.
It resulted by the modification of the spfile which change the file size.
so we just go back to this file , open it and delete the redundant NULL char
at the end of the file.

6, Start instance
SQL> startup
ORACLE instance started.

Total System Global Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 247466884 bytes
Database Buffers 356515840 bytes
Redo Buffers 7135232 bytes
ORA-00214: control file 'D:HQGG.ORA' version 661 inconsistent with file
'+NORM_DG1/ggctl01.ora' version 755

--- This is because control file of 'D:HQGG.ORA' have a different SCN with
'+NORM_DG1/ggctl01.ora' .
SQL> select status from v$instance ;

STATUS
------------------------
STARTED

7, delete 'D:HQGG.ORA' and Recreate it .
SQL> alter database backup controlfile to 'd:hqgg.ora' ;

Database altered.

8, Restart database .

Problem has been cleared up Now.