Total Pageviews

Monday, October 17, 2016

moving datafile to ASM storage database 11.2.0.4



ORA-01157: cannot identify/lock data file 64 - see DBWR trace file
ORA-01110: data file 64: '/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/path_to_your_datafiles_foldername_of_df_you_want.dbf'
ORA-02002: error while writing to audit trail
ORA-00604: error occurred at recursive SQL level 1
ORA-01157: cannot identify/lock data file 64 - see DBWR trace file
ORA-01110: data file 64: '/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/path_to_your_datafiles_foldername_of_df_you_want.dbf'







file was created locally instead of ASM storage. corrective action is move the file using RMAN (use copy command /oroginal/location  to '+DATA/' )

alter database rename file in database so system will also look at ASM place

No comments:

Post a Comment