ITPub博客

首页 > Linux操作系统 > Linux操作系统 > dbua report datafile not exists

dbua report datafile not exists

原创 Linux操作系统 作者:flyerchen2000 时间:2010-08-05 09:55:52 0 删除 编辑
Because when DBA add datafiles,  the datafile name with the end "space"  For example:   'a ' !='a',
the dbua check the datafiles trim the space, but when alter database datafile '        'autoextend on ;
report the datafile not found,.
need take action as below:
1.Find the data file  which name have space                                                                                        
 select file_name, length(file_name), length(trim(file_name)) from dba_data_files where length(file_name)!=length(trim(file_name));
                                                                                                                                   
2.Rename the data file name which have hide space                                                                                  
 sqlplus >startup mount                                                                                                            
 ! mv "/u11/oradata/mdw/lss1_p12_11.dbf " /u11/oradata/mdw/lss1_p12_11.dbf                                                         
 ! mv "/u13/oradata/mdw/lss1_p12_13.dbf " /u13/oradata/mdw/lss1_p12_13.dbf                                                         
 ! mv "/u14/oradata/mdw/lss1_p12_14.dbf " /u14/oradata/mdw/lss1_p12_14.dbf                                                         
                                                                                                                                   
alter database rename file '/u11/oradata/mdw/lss1_p12_11.dbf ' to '/u11/oradata/mdw/lss1_p12_11.dbf';                              
alter database rename file '/u13/oradata/mdw/lss1_p12_13.dbf ' to '/u13/oradata/mdw/lss1_p12_13.dbf';                              
alter database rename file '/u14/oradata/mdw/lss1_p12_14.dbf ' to '/u14/oradata/mdw/lss1_p12_14.dbf';                              

conclusion: this one oracle small bug.



来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/3637/viewspace-670319/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-08-25

  • 博文量
    43
  • 访问量
    84412