With the help of this article today we are going to learn about those steps which are going to use during the restore lost non-system datafiles on different location the database is closed. In our previous post, we have discussed the restore lost non–system datafiles on a different location while the database while the database is open. We […]
Articles Tagged: ORA-01157
ACCIDENTALLY data file is added without “+” sign
In RAC or ASM environment, we missed the ‘+’ sign while adding datafile in tablespace. we got error in ora-01110, ora-27037 in alert log. ORA-01157: cannot identify/lock data file 3129 – see DBWR trace file ORA-01110: data file 3129: ‘/home/oracle/product/10.2.0/db/dbs/DATA’ ORA-27037: unable to obtain file status ORA-01186: file 3129 failed verification tests ORA-01157: cannot identify/lock […]