在操作系统损坏时恢复Oracle10g全过程

环境：oracle10g，操作系统5.2 VJJ0oiGZ=  
数据库系统在rootvg下/oracle文件系统下， bAp%YObj  
数据文件在datavg下/oradata文件系统下 s@1Xpd%  
控制文件在 $/ORACLE_HOME/dbs/一个和/oradata下两个 s\n
XRV*  
重做日志文件在 $/ORACLE_HOME/dbs/和/oradata下每组日志文件各一个，共三组 KC0]>e-s  
有最新spfile文件备份。 p <9M8s  
1、rootvg损坏，重新安装操作系统。 L BM*=g1{  
2、安装oracle数据库系统文件 -n
nr]'!  
3、恢复spfile文件到$/ORACLE_HOME/dbs/下， %/~2_4N,K  
4、startup nomount，出现错误提示，建立$/ORACLE_BASE/hb052500/cdump 和udump &r7!d4}  
5、startup nomount，出现错误提示 P@81qi!,  
SQL> startup nomount rA6 8{jR  
ORA-00444: background process "MMAN" failed while starting \,({1^AIk  
ORA-07446: sdnfy: bad value '' for parameter . W/-#>&  
j hw&  
ORA-07446 sdnfy: bad value 'string' for parameter string. ?i@vV  
Cause: The directory specified as the value for the stated parameter could not UfQQr  
be used. xKce?$f  
Action: Make sure the directory you have specified is a valid directory/file \ `w<  
specification. dO4GHt  

xp#{ Q  
6、建立pfile文件 7ca/rz58  
SQL> create pfile from spfile; Y!CtO H  
$G~Pr ,2  
File created. Z1&-=J  
s{UY.VW:,  
7、查看pfile文件，按照pfile文件中列出的路径，建立相应路径后台进程目录和归档目录 xIEj{8t?K  
*.log_archive_dest_1='LOCATION=/oracle/app/oracle/OraHome/dbs/archive' )HBGE{xw  
*.background_dump_dest='/oracle/app/oracle/admin/hb052500/bdump' 0"$ t</6n  
$ cd $/ORACLE_BASE/hb052500/ H O\hKaW,  
$ ls "UZA3 >$!  
cdump udump TA[L:E t  
$ mkdir bdump }N/w-  
$ cd $ORACLE_HOME/dbs/ e'02,o85  
$ ls )22RHGTB  
hb052500 init.ora inithb052500.ora ?w M%2  
hc_hb052500.dat initdw.ora spfilehb052500.ora 7Hfu*4s"  
$ mkdir archive sJi}%N)NF  
8、startup nomount成功。 ACHxgs]  
$ sqlplus /nolog *a@AE!  
+C2]ACA  
SQL*Plus: Release 10.1.0.2.0 - Production on Sun Oct 16 21:23:17 2005 3Q
WN3  
cE<EMkw  
Copyright (c) 1982, 2004, Oracle. All rights reserved. '`C8h) 2  
1 ,8  
SQL> conn / as sysdba nBi ,.^l  
Connected to an idle instance. PMSd=p1
R4  
SQL> startup nomount; DWdG&S~n*  
ORACLE instance started. s,p
,YHS  
 ^R&50  
Total System Global Area 289406976 bytes =i5?R3A  
Fixed Size 1328912 bytes !=9`M*JD  
Variable Size 262387952 bytes /R7O9 ta  
Database Buffers 25165824 bytes P4)
!U[@  
Redo Buffers 524288 bytes 02%KDt&6  
SQL>  MCe$_h  
9、alter database mount，出现错误提示 e!xZ3^IL  
SQL> alter database mount; cyOLX9P  
alter database mount F_vj eqf  
* M3$7(`h  
ERROR at line 1: ;?88C{5p  
ORA-01990: error opening password file '/oracle/app/oracle/OraHome/dbs/orapw' o
hv?JsKh  
ORA-27037: unable to obtain file status 'nT:0O~@0  
IBM AIX RISC System/6000 Error: 2: No such file or directory yr+~IwR  
Additional information: 3 %Q[L@ v/9&  
kh5S%evU  
10、建立口令文件 xc
R|W  
orapwd file=$ORACLE_HOME/dbs/orapwd.ora password=oracle 9\YX !*dk  
11、 Rto_Hk|  
SQL> alter database mount; # |(q+L L  
alter database mount Jp5}\kd\  
* l7
X%@srn  
ERROR at line 1: xQ@.*u+  
ORA-01100: database already mounted g; (8Xh   
j^c_qLtg D  
on| ][ 5  
SQL> alter database open; O/ax~k 'bl  
alter database open l0;J1Fu  
* gs;4u~"6  
ERROR at line 1: NX`[=qZA  
ORA-38760: This database instance failed to turn on flashback database #>
jY&l  
~3O{RQo=P  
I=j.}A6q  
3,W&TQ.  
:Dsm+3 y4~  
SQL> alter database flashback off; I;Pnth~N  
nH5bs*  
Database altered. .W,oxQG  
$.*T r  
SQL> alter database open; s"e
 1Bx  
*&;o Tj  
Database altered. /;1oFy:
  
HNu{7-@ 1  
SQL> archive log list; u w3eN*t4  
Database log mode Archive Mode F=6lGI t  
Automatic archival Enabled $v RIx``2  
Archive destination /oracle/app/oracle/OraHome/dbs/archive \!y4/= c  
Oldest online log sequence 614  zry0uJGM  
Next log sequence to archive 616 "5Ef M  
Current log sequence 616 &TRm'#Y  
SQL>