Skip to Content
avatar image
Former Member

Error run backup online oracle.

Hi, I have error try run online backup in oracle. attach the alert.log.

please, you can see errror? this has ever happened

Thu Aug 09 02:00:00 2012

Closing scheduler window

Closing Resource Manager plan via scheduler window

Clearing Resource Manager plan via parameter

Thu Aug 09 02:00:29 2012

/* BRBACKUP */ ALTER DATABASE BACKUP CONTROLFILE TO '/oracle/RPD/sapbackup/cntrlRPD.dbf'

Errors in file /oracle/RPD/saptrace/diag/rdbms/rpd/RPD/trace/RPD_ora_29391.trc:

ORA-00202: control file: '/oracle/RPD/origlogA/cntrl/cntrlRPD.dbf'

ORA-27072: File I/O error

Additional information: 4

Additional information: 3

Additional information: -1

Errors in file /oracle/RPD/saptrace/diag/rdbms/rpd/RPD/trace/RPD_ora_29391.trc:

ORA-00204: error in reading (block 3, # blocks 61) of control file

ORA-00202: control file: '/oracle/RPD/origlogA/cntrl/cntrlRPD.dbf'

ORA-27072: File I/O error

Additional information: 4

Additional information: 3

Additional information: -1

ORA-204 signalled during: /* BRBACKUP */ ALTER DATABASE BACKUP CONTROLFILE TO '/oracle/RPD/sapbackup/cntrlRPD.dbf'...

Thu Aug 09 02:11:38 2012

Incremental checkpoint up to RBA [0x1fe4.3431.0], current log tail at RBA [0x1fe4.35c1.0]

Thu Aug 09 02:41:53 2012

Incremental checkpoint up to RBA [0x1fe4.3d4b.0], current log tail at RBA [0x1fe4.3f0d.0]

Thu Aug 09 02:54:21 2012

alter database backup controlfile to '/oracle/RPD/sapbackup/ctrlRPD.dbf'

Completed: alter database backup controlfile to '/oracle/RPD/sapbackup/ctrlRPD.dbf'

Thu Aug 09 03:12:08 2012

Incremental checkpoint up to RBA [0x1fe4.4c64.0], current log tail at RBA [0x1fe4.4deb.0]

Thu Aug 09 03:13:30 2012

Stopping background process CJQ0

Best Regards

EDRS

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Aug 15, 2012 at 02:33 PM

    Hi EDRS,

    Seems the control file may be corrupt as we see a file i/o error and error reading the file:

    oracle/RPD/origlogA/cntrl/cntrlRPD.dbf

    Check if the file exists and permissions ont he fiel and path.

    From these errors and error messages it appears that there may be an

    issue with the underlying OS/disk which is causing a corruption in

    control file. We would recommend SAP Note No. 546006 - Problems with

    Oracle due to operating system errors.

    Please see note 546006, whole not specifically point 3

    Also please see note 491160 regarding recovering the control files.

    Let us know if issues persist.

    Best regards,

    Paul

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Eli

      try to run on Wednesday

      alter database endbackup;

      and then ensure that there is no additional backup running on Thursday or no parallel runs are not initiated.

      Also make sure that no endbackup is getting triggered from any script or by any user explicitly.

      Another suggestion is try to adjust or change the default backup trigger time.

      With the above steps, you should be able get a solution to the problem.

      Regards

      Raj