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