Error run backup online oracle.

[Former Member]

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

[paul_power · Accepted solution]

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

[Former Member · Accepted solution]

   Hi Paul, thanks for you information but this error ocurrs only thursday day. The backup online run all every day and fail only thursday.

  Best Regards,

Eli Daniel

[paul_power · Accepted solution]

Hi Eli,

That is very unusual. If the online backup completes sucessfully every other day but always fails on Thursday with the same error, I would check what other activities are occuring at the same time on Thursdays. For example, a virus scan might be locking the Oracle control file, making it unavailable for Oracle. This is just a guess but one possible scenario.

Best regards,

Paul

[Former Member · Accepted solution]

Hi Eli,

Before running Thursday backup, make sure database is not in back up mode.

Best Regards,

Arjun

[Former Member · Accepted solution]

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