ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
Hello All,
Thanks for your concern.
- Primary Server:
- Oracle version: Oracle 12c
- OS version: RHEL 7.4
- SID: orcl
- Hostname: erpdb
- Datafile path: /erpdata/orcl/orcldata
- Standby Server:
- Oracle version: Oracle 12c
- OS version: RHEL 7.4
- SID: stdorcl
- Hostname: stderpdb
- Datafile path: /erpdata/stdorcl/stdorcldata
I backed up these datafile of primary server to a NAS(Network Attached Storage),and then the standby server got these datafile through sftp to the NAS.
On the standby server, I revised the datafile path of the two file: environmental variables(orcl_erpdb.env) and initorcl.ora, from /erpdata/orcl/orcldata to