????ORACLE?????????ж?????????????????????
??????????????????????????????汾???????????????????????????SID???鵵????????????????????????????????????????????????
????????????·???????????
????1?????????????????nomount????
?????????????????????$ORACLE_HOME/dbs/spfile<SID>.ora?????????????????pfile??????
???????pfile????????????nomount??????????????????????????????????????????????????????
????2?????mount????mount???????????????????
????3????????????mount??????????????п?????????
????4???????????????????????????????????????????????????????????
??????????????飺
?????????????????????????????????????????????????????????????????
?????????????
??????????SID ??????????????????????????????????????????????????
????????????????
???????濪????????裺
????1????pfile??nomount??
SQL> startup nomount pfile='/u01/app/oracle/product/10.2.0/db_1/dbs/initorcl.ora'
ORACLE instance started.
Total System Global Area  432013312 bytes
Fixed Size                  2021344 bytes
Variable Size             121636896 bytes
Database Buffers          306184192 bytes
Redo Buffers              2170880 bytes
??????????????pfile????spfile?????????????????????
????2????mount??
????SQL> alter database mount;
????Database altered.
??????????????
?????????????????????????????·???????????е?·??????￡?????????????????п???????????????????????
????3????open??
????SQL> alter database open;
????Database altered.
?????????????????????????????????????????
???????
????alter database rename file 'home/oracle/1.dbf' /home/oracle/oradata/1.dbf';
???????????
????4 ??????????????
????SQL> select * from test;
????ID
????----------
????1
????????????