Tuesday, April 26, 2005

RMAN-10035 ORA-19502 ORA-27030

RDBMS Version: 8.1.7.2
Operating System & Version: AIX 4.3.2
Error Number (if applicable):
Product (i.e. SQL*Loader, Import, etc.): RMAN w/ TDP
Product Version:
RMAN + TDP backup failure
Hi,
I have Oracle 8.1.7.3 running on an IBM AIX 4.3.2 OS. TDP has been configured w/ RMAN for complete hotbackups. This
setup was working fine for the last 4 months before I started receiving the following error during backup. The failures occur @ haphazard intervals.
On Nov 22 I got the following error:
RMAN-00571: ==========================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ====================================================
RMAN-03007: retryable error occurred during execution of command: backup
RMAN-07004: unhandled exception during command execution on channel e1
RMAN-10035: exception raised in RPC: ORA-19502: write error on file "/backup/ELASPROD/hbkp_ELASPROD_478596261_1135_1", blockno 14370561 (blocksize=512)
ORA-27030: skgfwrt: sbtwrite2 returned error
ORA-19511: ANS1017E (RC-50) Session rejected: TCP/IP connection failure
RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE
On Nov 23 it was
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03007: retryable error occurred during execution of command: backup
RMAN-07004: unhandled exception during command execution on channel e2
RMAN-10035: exception raised in RPC: ORA-19502: write error on file "/backup/ELASPROD/hbkp_ELASPROD_478682643_1139_1", blockno 9867009 (blocksize=512)
ORA-27030: skgfwrt: sbtwrite2 returned error
ORA-19511: ANS1301E (RC1) Server detected system error
RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE
On Dec 12 it was
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03007: retryable error occurred during execution of command: backup
RMAN-07004: unhandled exception during command execution on channel e1
RMAN-10035: exception raised in RPC: ORA-19502: write error on file "/backup/ELASPROD/archive/arch_ELASPROD_480413812_1330_1", blockno 1574913 (blocksize=512)
ORA-27030: skgfwrt: sbtwrite2 returned error
ORA-19511: ANS1017E (RC-50) Session rejected: TCP/IP connection failure
RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE
On Jan 21 it was
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03007: retryable error occurred during execution of command: backup
RMAN-07004: unhandled exception during command execution on channel e1
RMAN-10035: exception raised in RPC: ORA-19502: write error on file "/backup/ELASPROD/archive/arch_ELASPROD_483781354_1696_1", blockno 1763457 (blocksize=512)
ORA-27030: skgfwrt: sbtwrite2 returned error
ORA-19511: ANS1329S (RC29) Server out of data storage space
RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE
I have another database which gets backed up after this 1 is done. i have not faced any such problems w/ the other database.
What should be done?
Thanks in advance.


From: RAMESH VENKATAKRISHNAN 21-Jan-03 18:47
Subject: Re : RMAN + TDP backup failure

Hi

Log Nov 22 and Dec 12 :-
- ORA-19511: ANS1017E (RC-50) Session rejected: TCP/IP connection failure
This might be because of the failure in tcp/ip communications when connecting to the server.
You can try playing with "IDLETIMEOUT" TSM parameter.

Log Jan 21 :-
- ORA-19511: ANS1329S (RC29) Server out of data storage space
This is because your storage pool is full

Log Nov 23 :-
- ORA-19511: ANS1301E (RC1) Server detected system error
This is a generic message. you can get more information from sbtio.log

Ramesh...







From: Oracle, Rowena Serna 23-Jan-03 16:29
Subject: Re : RMAN + TDP backup failure

Thanks to Ramesh for the suggestion, as you can see,
the errors you are seeing are media management errors and you should contact your vendor to address them.


Error: ORA-19511
Text: %s
---------------------------------------------------------------------------
Cause: An error occurred in the media management software which is linked with the Oracle server to perform backup and restore in cooperation with Recovery Manager.
Action: If the text of message 19511 does not provide enough information to resolve the problem, then you should contact the vendor of the media management software.


Regards,
Rowena Serna
Oracle Corporation

From: Jos Doldersum 16-Jun-03 14:58
Subject: Re : RMAN + TDP backup failure

I had to increase the COMMTIMEOUT parameter from 60 to 180 to solve the RC-50 problem.

No comments: