Oracle??????????

????1??nomout??Σ??y???????????????????????????в????????????????????ù????У?????????????????????????????alter??????
???????nomount????????
????--?????????
????[oracle@secdb1 admin]$ echo $ORACLE_SID
????PROD
????[oracle@secdb1 admin]$ ps -ef|grep PROD
????oracle   14890  6310  0 21:12 pts/1    00:00:00 grep PROD
????--alter??????
????[oracle@secdb1 bdump]$ ls -lrt
????total 48
????-rw-r----- 1 oracle oinstall  1113 Mar  4 23:15 prod_lgwr_7319.trc
????-rw-r----- 1 oracle oinstall   779 Mar  5 19:42 prod_mmnl_7329.trc
????-rw-r--r-- 1 oracle oinstall 40910 Mar  5 21:08 alert_PROD.log
???????????????nomount??
[oracle@secdb1 admin]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Mar 5 21:15:50 2014
Copyright (c) 1982?? 2005?? Oracle.  All rights reserved.
Connected to an idle instance.
SQL> startup nomount
ORACLE instance started.
Total System Global Area  314572800 bytes
Fixed Size                  1219184 bytes
Variable Size             100664720 bytes
Database Buffers          209715200 bytes
Redo Buffers                2973696 bytes
SQL>
????????????????????
[oracle@secdb1 bdump]$ ls -lrt
total 52
-rw-r----- 1 oracle oinstall  1113 Mar  4 23:15 prod_lgwr_7319.trc
-rw-r----- 1 oracle oinstall   779 Mar  5 19:42 prod_mmnl_7329.trc
-rw-r--r-- 1 oracle oinstall 42513 Mar  5 21:15 alert_PROD.log  ----------------?????????????
[oracle@secdb1 bdump]$ ps -ef|grep PROD  ----------------------------???г?????????
oracle   14946     1  0 21:15 ?        00:00:00 ora_pmon_PROD
oracle   14948     1  0 21:15 ?        00:00:00 ora_psp0_PROD
oracle   14950     1  0 21:15 ?        00:00:00 ora_mman_PROD
oracle   14952     1  0 21:15 ?        00:00:00 ora_dbw0_PROD
oracle   14954     1  0 21:15 ?        00:00:00 ora_lgwr_PROD
oracle   14956     1  0 21:15 ?        00:00:00 ora_ckpt_PROD
oracle   14958     1  0 21:15 ?        00:00:00 ora_smon_PROD
oracle   14960     1  0 21:15 ?        00:00:00 ora_reco_PROD
oracle   14962     1  0 21:15 ?        00:00:00 ora_mmon_PROD
oracle   14964     1  0 21:15 ?        00:00:00 ora_mmnl_PROD
oracle   14965 14942  0 21:15 ?        00:00:00 oraclePROD (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle   14988  5989  0 21:17 pts/3    00:00:00 grep PROD
?????????$ORACLE_HOME/dbs?????????????????????????????￡?
????[oracle@secdb1 dbs]$ sqlplus / as sysdba
????SQL*Plus: Release 10.2.0.1.0 - Production on Wed Mar 5 21:21:19 2014
????Copyright (c) 1982?? 2005?? Oracle.  All rights reserved.
????Connected to an idle instance.
????SQL> startup nomount
????ORA-01078: failure in processing system parameters
????LRM-00109: could not open parameter file '/u01/app/oracle/product/10.2.0/db_1/dbs/initPROD.ora'
????SQL> quit
????????????????? spfileSID.ora----initSID.ora
??????y?Σ???????????????????????????????
????2??mount????y?Σ??????????????п?????????????????????????????????????????????????????????????????????????????????λ???????????????????????????????
????mount????
SQL> select * from v$controlfile;
no rows selected
SQL> select * from v$datafile;
select * from v$datafile
*
ERROR at line 1:
ORA-01507: database not mounted
mount???
SQL> alter database mount;
Database altered.
SQL> select name from v$controlfile;
NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/PROD/disk1/control01.ctl
/u01/app/oracle/oradata/PROD/disk2/control02.ctl
SQL> select file#??name from v$datafile;
FILE#  name
--------------------------------------------------------------------------------
1  /u01/app/oracle/oradata/PROD/disk1/system01.dbf
2  /u01/app/oracle/oradata/PROD/disk1/undotbs01.dbf
3 /u01/app/oracle/oradata/PROD/disk1/sysaux01.dbf
??????y?Σ???????????????????????????????鵵??????????????????????
SQL> archive log list  ---???????鵵??
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            /u01/app/oracle/product/10.2.0/db_1/dbs/arch
Oldest online log sequence     3
Current log sequence           5
SQL> alter database archivelog; ---????鵵??
SQL> alter database noarchivelog;---?????鵵??
?????????????????????????????????￡?
SQL> startup mount
ORACLE instance started.
Total System Global Area  314572800 bytes
Fixed Size                  1219184 bytes
Variable Size             100664720 bytes
Database Buffers          209715200 bytes
Redo Buffers                2973696 bytes
ORA-00205: error in identifying control file?? check alert log for more info
????3??open??Σ??y??????????????????????????????????ж??????????????????????????飬???????￡???SMON????????????????????????????????
SQL> alter database open;
Database altered.
--?????????????￡??????
SQL> startup mount;
ORACLE instance started.
Total System Global Area  314572800 bytes
Fixed Size                  1219184 bytes
Variable Size              79693200 bytes
Database Buffers          230686720 bytes
Redo Buffers                2973696 bytes
Database mounted.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '/u01/app/oracle/oradata/PROD/disk1/system01.dbf'
????4??С??
??????????????????裬1??nomount??Σ??y??????????????????????????????????棬???????????mount??Σ???????????????????????????????????????λ?ü?飬??????????????????????open??Σ???????????Σ???????????????????????????з????????????????μ????????????????????????????????