dataguard error

[Roshan]

Oracle Database 12.1.0.2

Hi Erman,

please find below dataguard environment

Primary:
ORACLE_SID=orchestratio
db_name = orchestr
db_unique_name= orchestr

listener entries
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = rhis-orch-db01.mtg.local)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (ORACLE_HOME = /d01/ora12c/app/ora12c/product/12.1.0/dbhome_1)
      (SID_NAME =orchestr)
    )
    (SID_DESC =
      (ORACLE_HOME = /d01/ora12c/app/ora12c/product/12.1.0/dbhome_1)
      (SID_NAME = orcstby)
    )
  )


Standby:
ORACLE_SID = orcstby
db_name: orchestr
db_unique_name = ORCSTBY

listener entries:
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = orcstby)
      (ORACLE_HOME = /d01/ora12c/app/ora12c/product/12.1.0/dbhome_1)
      (SID_NAME = orcstby)
    )
    (SID_DESC =
      (ORACLE_HOME = /d01/ora12c/app/ora12c/product/12.1.0/dbhome_1)
      (SID_NAME = orchestratio)
    )
  )

LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = OTDR-DBGUARD-01.mtg.local)(PORT = 1525))
  )

I have create the password files on both primary and standby using
orapwd file=orapw$ORACLE_SID password=m force=y entries=5

. I am getting error below from alert log on primary

Error 1033 received logging on to the standby

Please advise.

Regards,

[Roshan]

I noticed whenever I execute
alter database recover managed standby database disconnect from session;

I get error shown below in alert log
MRP0: Background Media Recovery process shutdown

I check the trace file, I see the error below

ksvp2penabled: ep->flg = 0, rpr->slv_flg = 0
ksvp2penabled: ep = 0x7fe97e184b38, rpr = 0x19d5f0090
ORA-01110: data file 1: '/data/oradata/ORCHESTRATION/datafile/o1_mf_system_dvlq96jw_.dbf'
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '/data/oradata/ORCHESTRATION/datafile/o1_mf_system_dvlq96jw_.dbf'
*** 2018-04-20 09:32:42.759922 4929 krsh.c
MRP0: Background Media Recovery process shutdown

[ErmanArslansOracleBlog]

Does the following datafile exist?

/data/oradata/ORCHESTRATION/datafile/o1_mf_system_dvlq96jw_.dbf

[Roshan]

No. I restored the database again and now it is ok.

Thanks