Home » RDBMS Server » Backup & Recovery » Backup Failure (AIX 5.3, Oracle 10.2.0.2.0)
Backup Failure [message #387472] Thu, 19 February 2009 06:20 Go to next message
vinod_3d
Messages: 3
Registered: November 2008
Junior Member
Hi All,

Please any one can help, offline backup failing due to belwo error.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03009: failure of backup command on sbt_1 channel at 02/10/2009 21:11:59
ORA-19566: exceeded limit of 0 corrupt blocks for file /oracle/UGE/sapdata2/sr3_3/sr3.data3
RMAN-03009: failure of backup command on sbt_1 channel at 02/10/2009 21:05:53
ORA-19566: exceeded limit of 0 corrupt blocks for file /oracle/UGE/sapdata10/sr3_13/sr3.data13

Regards,
Vinod
Re: Backup Failure [message #387473 is a reply to message #387472] Thu, 19 February 2009 06:26 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have a block corruption, use DBVERIFY to check which one(s).

Regards
Michel
Re: Backup Failure [message #387689 is a reply to message #387472] Fri, 20 February 2009 05:24 Go to previous messageGo to next message
vinod_3d
Messages: 3
Registered: November 2008
Junior Member
Thanks Michel for your quick responce.

I have run the DBCHECK and found below errors.

Errors:-

ORA-1691: unable to extend lobsegment SAPR3.SYS_LOB0000292893C00013$$ by 128 in tablespace PSAPEL700D
BR0976W Database message alert - level: ERROR, line: 108053, time: 2008-10-05 11.07.53, message:

ORA-1653: unable to extend table SAPR3.REPOLOAD by 128 in tablespace PSAPEL700D
BR0976W Database message alert - level: ERROR, line: 111697, time: 2008-10-05 11.08.57, message:

BR0976W Database message alert - level: WARNING, line: 119761, time: 2008-10-06 16.54.27, message:
Checkpoint not complete

BR0976W Database message alert - level: ERROR, line: 133444, time: 2008-10-08 00.20.04, message:
ORA-1654: unable to extend index SAPR3.WBCROSSGT~INC by 320 in tablespace PSAPSOURCEI
BR0976W Database message alert - level: ERROR, line: 133445, time: 2008-10-08 00.20.04, message:


ORA-1653: unable to extend table SAPR3.WBCROSSGT by 1280 in tablespace PSAPSOURCED
BR0976W Database message alert - level: ERROR, line: 140205, time: 2008-10-10 06.15.23, message:

ORA-1652: unable to extend temp segment by 138254 in tablespace SYSTEM
BR0976W Database message alert - level: ERROR, line: 167549, time: 2008-11-10 07.25.38, message:

BR0977I Checking database profile...
BR0978W Database profile alert - level: WARNING, parameter: LOG_BUFFER, value: 6116352 (>< 4096,512 KB)
BR0978W Database profile alert - level: WARNING, parameter: OPTIMIZER_INDEX_COST_ADJ, value: 20 (set in parameter file)
BR0978W Database profile alert - level: WARNING, parameter: OPTIMIZER_MODE, value: CHOOSE (set in parameter file)
BR0978W Database profile alert - level: WARNING, parameter: SHARED_POOL_SIZE, value: 402653184 (< 400 MB)

ORA-1630: max # extents 300 reached in temp segment for tablespace PSAPSTABI
BR0976W Database message alert - level: WARNING, line: 14036, time: 2008-09-03 13.22.25, message:
Checkpoint not complete

Thanks & Regards
Vinod
Re: Backup Failure [message #387710 is a reply to message #387689] Fri, 20 February 2009 06:25 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't know DBCHECK. Where does it come from?

Regards
Michel

[Updated on: Fri, 20 February 2009 06:26]

Report message to a moderator

Previous Topic: Backup and Recovery Compatibility
Next Topic: RMAN catlog creation in windows for database in RHEL-4
Goto Forum:
  


Current Time: Sat Dec 03 16:08:45 CST 2016

Total time taken to generate the page: 0.08132 seconds