Oracle Database Discussions

Hi all

In my database backup process I am getting

RMAN-03009: failure of backup command on dev1_1 channel at 03/16/2007 08:36:22

[03/16/2007-08:36:26 ,-1,23,2,0,0,523,18,0,0]AX-RMAN ORA-27192: skgfcls: sbtclose2 returned error - failed to close file

[03/16/2007-08:36:26 ,-1,23,2,0,0,523,18,0,0]AX-RMAN ORA-19511: Error received from media manager layer, error text:

[03/16/2007-08:36:26 ,-1,23,2,0,0,523,18,0,0]AX-RMAN freeResources(): The Oracle agent has returned an error status(-100).

[03/16/2007-08:36:26 ,-1,23,2,0,0,523,18,0,0]AX-RMAN ORA-19502: write error on file "0aico9gi_1_1", blockno 3913217 (blocksize=512)

[03/16/2007-08:36:26 ,-1,23,2,0,0,523,18,0,0]AX-RMAN ORA-27030: skgfwrt: sbtwrite2 returned error

[03/16/2007-08:36:26 ,-1,23,2,0,0,523,18,0,0]AX-RMAN ORA-19511: Error received from media manager layer, error text:

[03/16/2007-08:36:26 ,-1,23,2,0,0,523,18,0,0]AX-RMAN

[03/16/2007-08:36:26 ,-1,23,2,0,0,523,18,0,0]AX-RMAN RMAN> **end-of-file**

[03/16/2007-08:36:26 ,-1,23,2,0,0,523,18,0,0]AX-RMAN

[03/16/2007-08:36:26 ,-1,23,2,0,0,523,18,0,0]AX-RMAN RMAN>

[03/16/2007-08:36:26 ,-1,23,2,0,0,523,18,0,0]AX-RMAN

[03/16/2007-08:36:26 ,-1,23,2,0,0,523,18,0,0]AX-RMAN Recovery Manager complete.

[03/16/2007-08:36:26 ,-1,23,2,0,0,523,18,0,0]AE360070 The Oracle database backup failed. return code [-1]
[03/16/2007-08:36:26 ,-1,23,2,0,0,523,18,0,0]AW360074 Please refer to the Backup Agent log file
[03/16/2007-08:36:26 ,1,23,2,0,143,11,0,0,0]1 node(s) 2 session(s) 1 file(s) 0 MB processed
[03/16/2007-08:36:26 ,1,23,0,0,43,11,2,0,0]Backup operation Failed



I am using CA Bright StoreArcScerve 11.5 version
(i am running without catalog mode)
it will automatically write script for RMAN ,
and
for small tablespaces backup is successfull but for large and entire database backup is failing

it is giving Freeresources error
and process simopher is suddenly killed
so RMAN cannot continue further

Error:
Failed to execute the RMAN command /oracle/app/oracle10g/product/10.1.0.2/db_1/bin/rman msglog '/tmp/rman_23.log' nocatalog


Using shared memory mode to communicate with media
[03/16/2007-08:34:37 ,-1,24,3,0,0,11,18,0,0]The backup job option is RECOVERY MANAGER
[03/16/2007-08:34:37 ,-1,24,3,0,0,11,18,0,0]Backup ORACLE: to TEST_MEDIA session 3
[03/16/2007-08:34:37 ,1,24,3,0,453,11,18,0,0]Backup ORACLE to TEST_MEDIA (ID 913) session 3 sequence 1
[03/16/2007-08:36:08 ,1,24,3,0,119,523,18,0,0]E9014 Failed to receive header packet [dbserver2: No such file or directory]
[03/16/2007-08:36:15 ,1,24,3,0,143,11,18,0,0]1 node(s) 1 session(s) 1 file(s) 1898 MB processed
[03/16/2007-08:36:15 ,1,24,0,0,43,11,18,0,0]Backup operation Failed
[03/16/2007-08:36:15 ,1,24,0,0,-1,11,18,0,0]-


in SBTIO.log
Exiting with success.
03/15 20:09:02 (29456) - sbtwrite2() : Enter
03/15 20:09:02 (29456) - sbtwrite2() : flags = 0
03/15 20:09:02 (29456) - sbtwrite2() : This backup operation was initiated through RMAN.
03/15 20:09:04 (29456) - NbBlks=50; BlkSz=262144; CreatorPID=29456; PartnerPID=29761;
shmId=1453; shmDataId=2174;
semFull=65543, semMT=196614; semClose=65544; semResume=65545
03/15 20:09:04 (29456) - sendSHM()[29456:1173969542]: sending block (type=100,len=262144,sync=FALSE)
03/15 20:09:04 (29456) - semop_timed()[29456]: Before mutex lock...
03/15 20:09:04 (29456) - semop_timed()[29456]: Notify watchDog...timeout=3600,pid=29761
03/15 20:09:04 (29456) - semop_timed()[29456]: calling semop (semid=196614)
03/15 20:09:04 (29456) - semop_timed()[29456]: Out of semop [rc=0]
03/15 20:09:04 (29456) - semop_timed()[29456]: msg = SHM_W_KILLED
03/15 20:09:04 (29456) - <>
03/15 20:09:04 (29456) - sbtwrite2(): The Oracle agent doesn't run anymore
03/15 20:09:04 (29456) - setSbtError() : errCode = 7501
03/15 20:09:04 (29456) - setSbtError() : msgStr = sbtwrite2() : flags = 0


These types of errors comming


Please help me in this regard

Thankyou in Advance
Adithya