This discussion is archived
6 Replies Latest reply: Jan 29, 2013 4:09 AM by 844001 RSS

ORA-00283: recovery session canceled due to errors

844001 Newbie
Currently Being Moderated
Dear All,

I have standby database in which STANDBY_FILE_MANAGEMENT was MANUAL. I have shrink undo table-space in primary database. After 2 days I tried to recover standby database. I got following error.

ORA-00283: recovery session canceled due to errors
ORA-01274: cannot add data file '/home/app/oracle/oradata/OMNDB/undotbs01.dbf'
- file could not be created


I am unable to shrink undo table-space in standby database as I did in primary database as it is not open.

please anyone help me to get clarify this issue.

In Standby_

SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/home/app/oracle/oradata/OMNDB/system01.dbf
/home/app/oracle/oradata/OMNDB/undotbs01.dbf
/home/app/oracle/oradata/OMNDB/sysaux01.dbf
/home/app/oracle/oradata/OMNDB/MY_oms_ts01.dbf
/home/app/oracle/oradata/OMNDB/nologging_ts01.dbf
  • 1. Re: ORA-00283: recovery session canceled due to errors
    CKPT Guru
    Currently Being Moderated
    I have standby database in which STANDBY_FILE_MANAGEMENT was MANUAL. I have shrink undo table-space in primary database. After 2 days I tried to recover standby database. I got following error.

    ORA-00283: recovery session canceled due to errors
    ORA-01274: cannot add data file '/home/app/oracle/oradata/OMNDB/undotbs01.dbf'
    - file could not be created
    If it is failed to create then your standby undo datafile name probably should be the name with "UNNAMED".
    Once again start the MRP and post the latest and complete information and also share the information from trace file also.

    and also share

    SQL> select file#,status,error from v$datafile_header where file#=<>;
  • 2. Re: ORA-00283: recovery session canceled due to errors
    844001 Newbie
    Currently Being Moderated
    Thank you CKPT for reply.

    this is the output when MRP

    SQL> recover standby database;
    ORA-00283: recovery session canceled due to errors
    ORA-01111: name for data file 2 is unknown - rename to correct file
    ORA-01110: data file 2: '/home/app/oracle/product/10.2.0/db_1/dbs/UNNAMED00002'
    ORA-01157: cannot identify/lock data file 2 - see DBWR trace file
    ORA-01111: name for data file 2 is unknown - rename to correct file
    ORA-01110: data file 2: '/home/app/oracle/product/10.2.0/db_1/dbs/UNNAMED00002'


    this is in the alert log

    ORA-1112 signalled during: ALTER DATABASE RECOVER CANCEL ...
    Tue Jan 29 09:17:53 2013
    db_recovery_file_dest_size of 10240 MB is 0.00% used. This is a
    user-specified limit on the amount of space that will be used by this
    database for recovery-related files, and does not reflect the amount of
    space available in the underlying filesystem or ASM diskgroup.
    Tue Jan 29 10:29:57 2013
    ALTER DATABASE RECOVER standby database
    Tue Jan 29 10:29:57 2013
    Media Recovery Start
    Managed Standby Recovery not using Real Time Apply
    Tue Jan 29 10:29:57 2013
    Media Recovery failed with error 1111
    ORA-283 signalled during: ALTER DATABASE RECOVER standby database ...
  • 3. Re: ORA-00283: recovery session canceled due to errors
    Shivananda Rao Guru
    Currently Being Moderated
    Hello,

    Please refer this http://shivanandarao.wordpress.com/2012/04/02/managed-recovery-process-mrp-terminates-on-standby-database-upon-adding-datafile-on-the-primary-database/
    Hope it helps ! If you feel that your questions have been answered, then please consider closing them by providing appropriate points.

    Regards,
    Shivananda
  • 4. Re: ORA-00283: recovery session canceled due to errors
    CKPT Guru
    Currently Being Moderated
    DB**** wrote:
    Thank you CKPT for reply.

    this is the output when MRP

    SQL> recover standby database;
    ORA-00283: recovery session canceled due to errors
    ORA-01111: name for data file 2 is unknown - rename to correct file
    ORA-01110: data file 2: '/home/app/oracle/product/10.2.0/db_1/dbs/UNNAMED00002'
    ORA-01157: cannot identify/lock data file 2 - see DBWR trace file
    ORA-01111: name for data file 2 is unknown - rename to correct file
    ORA-01110: data file 2: '/home/app/oracle/product/10.2.0/db_1/dbs/UNNAMED00002'
    That is what am looking for :)
    You can also refer this link http://www.oracle-ckpt.com/unnamed-file-in-standby-after-adding-new-file-to-primary-ora-01111-ora-01110-ora-01157/
  • 5. Re: ORA-00283: recovery session canceled due to errors
    844001 Newbie
    Currently Being Moderated
    Thank you. It works. Ur post really helped.
  • 6. Re: ORA-00283: recovery session canceled due to errors
    844001 Newbie
    Currently Being Moderated
    Thank you. Ur post really helped.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points