on 08-15-2012 3:01 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.