在操作系統損壞時恢復Oracle10g全過程 環境：oracle10g，操作系統5.2數據庫系統在rootvg下/oracle文件系統下，數據文件在datavg下/oradata文件系統下控制文件在 $/ORACLE_HOME/dbs/一個和/oradata下兩個重做日志文件在 $/ORACLE_HOME/dbs/和/oradata下每組日志文件各一個，共三組有最新spfile文件備份。1、rootvg損壞，重新安裝操作系統。2、安裝oracle數據庫系統文件3、恢復spfile文件到$/ORACLE_HOME/dbs/下，4、startup nomount，出現錯誤提示，建立$/ORACLE_BASE/hb052500/cdump 和udump5、startup nomount，出現錯誤提示SQL> startup nomountORA-00444: background process 'MMAN' failed while startingORA-07446: sdnfy: bad value '' for parameter .ORA-07446 sdnfy: bad value 'string' for parameter string.Cause: The Directory specified as the value for the stated parameter could notbe used.Action: Make sure the directory you have specified is a valid directory/filespecification.6、建立pfile文件SQL> create pfile from spfile;File created.7、查看pfile文件，按照pfile文件中列出的路徑，建立相應路徑后臺進程目錄和歸檔目錄*.log_archive_dest_1='LOCATION=/oracle/app/oracle/OraHome/dbs/archive'*.background_dump_dest='/oracle/app/oracle/admin/hb052500/bdump'$ cd $/ORACLE_BASE/hb052500/$ lscdump udump$ mkdir bdump$ cd $ORACLE_HOME/dbs/$ lshb052500 init.ora inithb052500.orahc_hb052500.dat initdw.ora spfilehb052500.ora$ mkdir archive8、startup nomount成功。$ sqlplus /nologSQL*Plus: Release 10.1.0.2.0 - ProdUCtion on Sun Oct 16 21:23:17 2005Copyright (c) 1982, 2004, Oracle. All rights reserved.SQL> conn / as sysdbaConnected to an idle instance.SQL> startup nomount;ORACLE instance started.Total System Global Area 289406976 bytesFixed Size 1328912 bytesVariable Size 262387952 bytesDatabase Buffers 25165824 bytesRedo Buffers 524288 bytesSQL>9、alter database mount，出現錯誤提示SQL> alter database mount;alter database mount*ERROR at line 1:ORA-01990: error opening passWord file '/oracle/app/oracle/OraHome/dbs/orapw'ORA-27037: unable to oBTain file statusIBM AIX RISC System/6000 Error: 2: No such file or directoryAdditional information: 310、建立口令文件orapwd file=$ORACLE_HOME/dbs/orapwd.ora password=oracle11、SQL> alter database mount;alter database mount*ERROR at line 1:ORA-01100: database already mountedSQL> alter database open; alter database open*ERROR at line 1:ORA-38760: This database instance failed to turn on flashback databaseSQL> alter database flashback off;Database altered.SQL> alter database open;Database altered.SQL> archive log list;Database log mode Archive ModeAutomatic archival EnabledArchive destination /oracle/app/oracle/OraHome/dbs/archiveOldest online log sequence 614Next log sequence to archive 616Current log sequence 616SQL>