修改数据文件名字的三种途径（Three ways to change the name of a data file）.doc

修改数据文件名字的三种途径（Three ways to change the name of a data file） [experiment] three ways to modify the name of data file Personal classification: troubleshooting and analysis [problem phenomenon] After adding files to the table space, it is found that the added location or name of the data file is not standard and requires normalization correction As follows: Sys@ora10g, col, tablespace_name, for, A15 Sys@ora10g, col, file_name, for, A50 Sys@ora10g, select, tablespace_name, file_name, from, dba_data_files, where, tablespace_name =TBS_SEC_D; TABLESPACE_NAME FILE_NAME ----------------------------------------------------- TBS_SEC_D /oracle/oradata/ora10g/tbs_sec_d01dbf Carefully, you should see that the data file name should be tbs_sec_d01.dbf, which is missing a point here. (another scenario is wrong. Adding data files to incorrect paths requires revision.) You may also encounter this mistake. First, make a statement: if you keep this error name unchanged, it will not affect the normal operation of the database, but in order to prevent unnecessary interference during the maintenance process, it should be corrected. [method 1] OFFLINE data file - modify the operating system on the file name -- modify the database file name in the data file recovery -- -- ONLINE data file Special emphasis: archiving mode required! Because data files need to be recovered 1.OFFLINE data file Sys@ora10g, alter, database, datafile,/oracle/oradata/ora10g/tbs_sec_d01dbf, offline; Database altered. 2. modify the file name on the operating system Ora10g@testdb, /oracle/oradata/ora10g$, MV, tbs_sec_d01dbf, tbs_sec_d01.dbf 3. modify the file name in the database Sys@ora10g, alter, database, rename, file,/oracle/oradata/ora10g/tbs_sec_d01dbf, to,/oracle/oradata/ora10g/tbs_sec_d01.dbf; Database altered. 4. restore the data files Sys@ora10g recover datafile/oracle/oradata/ora10g/tbs_sec_d01.dbf; Media recovery complete. 5.ONLINE data file Alter, database, datafile,/oracle/oradata/ora10g/tbs_sec_d01.d