1 2 Previous Next 18 Replies Latest reply: Feb 8, 2013 3:26 AM by Sunny kichloo RSS

    Error in starting MRP process in Standby database.

    $phinx19
      Hi All,

      OS:Windows server 03
      DB:11g

      I am creating a Standby database, everything is fine until i fire the below command to start the MRP process to start the recovery of the database.
      alter database recover managed standby database disconnect from session;
      MRP0 started with pid=27, OS id=6640
      2013-02-07 17:59:48.515000 +05:30
      started logmerger process
      Managed Standby Recovery not using Real Time Apply
      Errors in file d:\app\oracle\diag\rdbms\testdr\testdr\trace\testdr_dbw0_6000.trc:
      ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
      ORA-01110: data file 1: 'D:\APP\ORACLE\ORADATA\TEST\TEST\SYSTEM01.DBF'
      ORA-27086: unable to lock file - already in use
      OSD-00002: additional error information
      O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.
      Errors in file d:\app\oracle\diag\rdbms\testdr\testdr\trace\testdr_dbw0_6000.trc:
      ORA-01157: cannot identify/lock data file 2 - see DBWR trace file
      ORA-01110: data file 2: 'D:\APP\ORACLE\ORADATA\TEST\TEST\SYSAUX01.DBF'
      ORA-27086: unable to lock file - already in use
      OSD-00002: additional error information
      O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.
      Errors in file d:\app\oracle\diag\rdbms\testdr\testdr\trace\testdr_dbw0_6000.trc:
      ORA-01157: cannot identify/lock data file 3 - see DBWR trace file
      ORA-01110: data file 3: 'D:\APP\ORACLE\ORADATA\TEST\TEST\UNDOTBS01.DBF'
      ORA-27086: unable to lock file - already in use
      OSD-00002: additional error information
      O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.
      Errors in file d:\app\oracle\diag\rdbms\testdr\testdr\trace\testdr_dbw0_6000.trc:
      ORA-01157: cannot identify/lock data file 4 - see DBWR trace file
      ORA-01110: data file 4: 'D:\APP\ORACLE\ORADATA\TEST\TEST\USERS01.DBF'
      ORA-27086: unable to lock file - already in use
      OSD-00002: additional error information
      O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.
      MRP0: Background Media Recovery terminated with error 1110
      Errors in file d:\app\oracle\diag\rdbms\testdr\testdr\trace\testdr_pr00_7984.trc:
      ORA-01110: data file 1: 'D:\APP\ORACLE\ORADATA\TEST\TEST\SYSTEM01.DBF'
      ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
      ORA-01110: data file 1: 'D:\APP\ORACLE\ORADATA\TEST\TEST\SYSTEM01.DBF'
      Recovery Slave PR00 previously exited with exception 1110
      Errors in file d:\app\oracle\diag\rdbms\testdr\testdr\trace\testdr_mrp0_6640.trc:
      ORA-01110: data file 1: 'D:\APP\ORACLE\ORADATA\TEST\TEST\SYSTEM01.DBF'
      ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
      ORA-01110: data file 1: 'D:\APP\ORACLE\ORADATA\TEST\TEST\SYSTEM01.DBF'
      Completed: alter database recover managed standby database disconnect from session

      Can anyone tell me why is this comming?

      Regards,
      Sphinx
        1 2 Previous Next