6 Replies Latest reply: Jan 29, 2013 6:09 AM by 844001 RSS

    ORA-00283: recovery session canceled due to errors

    844001
      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
          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
            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
              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
                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
                  Thank you. It works. Ur post really helped.
                  • 6. Re: ORA-00283: recovery session canceled due to errors
                    844001
                    Thank you. Ur post really helped.