OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » Backup Failure (AIX 5.3, Oracle 10.2.0.2.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Backup Failure [message #387472]

Thu, 19 February 2009 06:20

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

Report message to a moderator

Re: Backup Failure [message #387473 is a reply to message #387472]

Thu, 19 February 2009 06:26

Michel Cadot
Messages: 68641
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

Report message to a moderator

Re: Backup Failure [message #387689 is a reply to message #387472]

Fri, 20 February 2009 05:24

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

Report message to a moderator

Re: Backup Failure [message #387710 is a reply to message #387689]

Fri, 20 February 2009 06:25

Michel Cadot
Messages: 68641
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 21:29:09 CDT 2024