Technology Stack - EBS (MOSC)

MOSC Banner

ORA-01157: cannot identify/lock data file 1 - see DBWR trace file

edited Aug 20, 2021 11:53AM in Technology Stack - EBS (MOSC) 2 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center