??????????????????????????б?????????μ??????????????????????????????????鵵???￡????????е?鵵?????????????????????????
?????????????????????????????????????????
????ALTER TABLESPACE USERS
????ADD DATAFILE 'D:ORACLEPRODUCT10.2.0ORADATACOLINusers02.dbf' SIZE 5120K REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE 32767M;
????SQL> alter table colin.emp
????2 allocate extent(size 100k datafile 'D:ORACLEPRODUCT10.2.0ORADATACOLINUSERS02.DBF');
????????????
????SQL> shutdown immediate
????????????????
???????ж???????
????ORACLE ???????????
???????ò?????????
???????????????????D:ORACLEPRODUCT10.2.0ORADATACOLINusers02.dbf
??????????????????????????/????????
?????????????????????????
????SQL> startup
????ORACLE ????????????
????Total System Global Area  167772160 bytes
????Fixed Size                  1247900 bytes
????Variable Size              83887460 bytes
????Database Buffers           79691776 bytes
????Redo Buffers                2945024 bytes
????????????????
????ORA-01157: ??????/??????????? 6 - ????? DBWR ???????
????ORA-01110: ??????? 6: 'D:ORACLEPRODUCT10.2.0ORADATACOLINUSERS02.DBF'
??????????????????????????
????SQL> select * from v$recover_file;
????FILE# ONLINE  ONLINE_
????---------- ------- -------
????ERROR                                                                CHANGE#
????----------------------------------------------------------------- ----------
????TIME
????--------------
????6 ONLINE  ONLINE
????FILE NOT FOUND                   0
????SQL> select * from v$recovery_log;
????δ?????
???????????????????????????ɡ?
???????????????????/??????????????
????1?????????????????:
????SQL> alter database datafile 6 offline;
???????????????
????2?????′??????
????SQL> alter database open;
???????????????
??????????????????????????????????????????????????????
????3?????′?????/??????????????
????SQL> alter database create datafile 'D:ORACLEPRODUCT10.2.0ORADATACOLINUSERS02.DBF' as 'D:ORACLEPRODUCT10.2.0ORADATACOLINUSERS02.DBF';
???????????????
????4???????/?????????????????????????????鵵????????????????????
????SQL> recover datafile 'D:ORACLEPRODUCT10.2.0ORADATACOLINUSERS02.DBF';
??????????????
????5?????????????????????????Ok??~
????SQL> alter database datafile 'D:ORACLEPRODUCT10.2.0ORADATACOLINUSERS02.DBF' online;
???????????????