unixandtsm
ADSM.ORG Member
- Joined
- Feb 9, 2011
- Messages
- 307
- Reaction score
- 0
- Points
- 0
Hi all,
RMAN backup failed with error "ANS1329S (RC29) Server out of data storage space"
Below is more info on error
Below is the stgpool info from TSM server.
i think the stgpool for these RMAN backups is TAPEPOOL-ORACLE (is there any way to confirm this ? ) so more info on it
Above i can see that device class name is 3590 and there are no 3590 scratch tapes available. But 3590 scratch tapes are not available from a month now and till today the backups were running fine. NOt sure what is the issue.
Please help me on this and thanks in advance!
RMAN backup failed with error "ANS1329S (RC29) Server out of data storage space"
Below is more info on error
Code:
input archive log thread=1 sequence=5193 recid=4690 stamp=785829879
channel ORA_SBT_TAPE_2: starting piece 1 at 13-JUN-2012 06:04:42
RMAN-03009: failure of backup command on ORA_SBT_TAPE_1 channel at 06/13/2012 06:06:57
ORA-19502: write error on file "dtnddjvp_1_1", blockno 8705 (blocksize=512)
ORA-27030: skgfwrt: sbtwrite2 returned error
ORA-19511: Error received from media manager layer, error text:
ANS1329S (RC29) Server out of data storage space
channel ORA_SBT_TAPE_1 disabled, job failed on it will be run on another channel
RMAN-03009: failure of backup command on ORA_SBT_TAPE_2 channel at 06/13/2012 06:09:02
ORA-19502: write error on file "dunddjvp_1_1", blockno 8193 (blocksize=512)
ORA-27030: skgfwrt: sbtwrite2 returned error
ORA-19511: Error received from media manager layer, error text:
ANS1329S (RC29) Server out of data storage space
channel ORA_SBT_TAPE_2 disabled, job failed on it will be run on another channel
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_SBT_TAPE_1 channel at 06/13/2012 06:06:57
ORA-19502: write error on file "dtnddjvp_1_1", blockno 8705 (blocksize=512)
ORA-27030: skgfwrt: sbtwrite2 returned error
ORA-19511: Error received from media manager layer, error text:
ANS1329S (RC29) Server out of data storage space
Below is the stgpool info from TSM server.
Code:
q stg
Storage Device Estimated Pct Pct High Low Next Stora-
Pool Name Class Name Capacity Util Migr Mig Mig ge Pool
Pct Pct
----------- ---------- ---------- ----- ----- ---- --- -----------
ARCH 3590H-C 12,396 G 22.3 23.5 90 70
ARCHIVEPOOL DISK 11 G 0.0 0.0 0 0 ARCH
BACKUPPOOL DISK 101 G 0.1 0.0 0 0 BKUPJA
BKUP 3590H-C 171,245 G 1.6 2.0 70 60
BKUPJA 3592H-C 615,816 G 25.3 63.2 90 70
COPYOFF 3590H-C 75,010 G 20.2
COPYOFFJA 3592H-C 572,593 G 15.8
COPYON 3590H-C 101,957 G 14.9
COPYONJA 3592H-C 551,640 G 25.0
SPACEMGPOOL DISK 11 G 0.0 0.0 0 0
TAPEPOOL-O- 3590H-C 273,796 G 3.7 4.0 90 70
RACLE
i think the stgpool for these RMAN backups is TAPEPOOL-ORACLE (is there any way to confirm this ? ) so more info on it
Code:
q stg TAPEPOOL-ORACLE f=d
Storage Pool Name: TAPEPOOL-ORACLE
Storage Pool Type: Primary
Device Class Name: 3590H-C
Estimated Capacity: 273,796 G
Space Trigger Util:
Pct Util: 3.7
Pct Migr: 4.0
Pct Logical: 100.0
High Mig Pct: 90
Low Mig Pct: 70
Migration Delay: 0
Migration Continue: Yes
Migration Processes: 1
Reclamation Processes: 1
Next Storage Pool:
Reclaim Storage Pool:
Maximum Size Threshold: No Limit
Access: Read/Write
Description: Tape Pool For Oracle Backups
Overflow Location:
Cache Migrated Files?:
Collocate?: No
Reclamation Threshold: 60
Offsite Reclamation Limit:
Maximum Scratch Volumes Allowed: 2,000
Number of Scratch Volumes Used: 81
Delay Period for Volume Reuse: 0 Day(s)
Migration in Progress?: No
Amount Migrated (MB): 0.00
Elapsed Migration Time (seconds): 0
Reclamation in Progress?: No
Last Update by (administrator): ADMIN
Last Update Date/Time: 08/16/06 19:00:15
Storage Pool Data Format: Native
Copy Storage Pool(s):
Active Data Pool(s):
Continue Copy on Error?: Yes
CRC Data: No
Reclamation Type: Threshold
Overwrite Data when Deleted:
Above i can see that device class name is 3590 and there are no 3590 scratch tapes available. But 3590 scratch tapes are not available from a month now and till today the backups were running fine. NOt sure what is the issue.
Please help me on this and thanks in advance!