Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RMAN error when deleting archivefiles on tape

RMAN error when deleting archivefiles on tape

From: Peter Gram <peter.gram_at_miracleas.dk>
Date: Mon, 20 Jan 2003 17:19:02 -0800
Message-ID: <F001.0053548F.20030120171902@fatcity.com>


Dear RMAN Wizards

I have this problem with a script for deleting archive file on tape. The story is that this script has worked perfect for more than a 2 year until the database
and there by rman was upgraded to 8.1.7.4 from 8.1.6..x. The media manager is TSM (IBM Tivoli) and everything is running on a Win NT 4 sp 6a.
The odd thing is that backup and restore works OK, this was tested. The NT box is using TSM to send the the backup to a MVS that has the tape robot attached.

I have looked at Metalink / Google and IBM Web support without getting a sensible clue.

Recovery Manager: Release 8.1.7.4.1 - Production

RMAN-06005: connected to target database: TMSPRD8 (DBID=4183866567) RMAN-06008: connected to recovery catalog database

RMAN> allocate channel for delete type 'SBT_TAPE';

2> change backuppiece '/archivefiles/af_TMSPRD8_480164575_21631_1' delete;
3> change backuppiece '/archivefiles/af_TMSPRD8_480197119_21669_1' delete;
4> change backuppiece '/archivefiles/af_TMSPRD8_480197446_21670_1' delete;
5> change backuppiece '/archivefiles/af_TMSPRD8_480197663_21671_1' delete;
6> change backuppiece '/archivefiles/af_TMSPRD8_480197810_21672_1' delete;
7> change backuppiece '/archivefiles/af_TMSPRD8_480250980_21673_1' delete;
8> change backuppiece '/archivefiles/af_TMSPRD8_480251087_21674_1' delete;
9> change backuppiece '/archivefiles/af_TMSPRD8_480251194_21675_1' delete;
10> change backuppiece '/archivefiles/af_TMSPRD8_480251313_21676_1' delete;
11> change backuppiece '/archivefiles/af_TMSPRD8_480251421_21677_1' delete;
12> change backuppiece '/archivefiles/af_TMSPRD8_480251531_21678_1' delete;
13> change backuppiece '/archivefiles/af_TMSPRD8_480251648_21679_1' delete;
14> change backuppiece '/archivefiles/af_TMSPRD8_480284960_21717_1' delete;
15> change backuppiece '/archivefiles/af_TMSPRD8_480285117_21718_1' delete;
16> change backuppiece '/archivefiles/af_TMSPRD8_480285323_21719_1' delete;
17> change backuppiece '/archivefiles/af_TMSPRD8_480285480_21720_1' delete;
18> release channel;
19> exit;
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: delete
RMAN-08500: channel delete: sid=71 devtype=SBT_TAPE
RMAN-08526: channel delete: Tivoli Data Protection for Oracle: version
2.2.0.0
RMAN-03022: compiling command: change
RMAN-03023: executing command: DELETE
RMAN-03026: error recovery releasing channel resources
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03006: non-retryable error occurred during execution of command:
change
RMAN-07004: unhandled exception during command execution on channel delete RMAN-10035: exception raised in RPC: ORA-19509: failed to delete sequential file, handle="/archivefiles/af_TMSPRD8_480164575_21631_1", parms="" ORA-27027: sbtremove2 returned error
ORA-19511: ANS0238E (RC2041) The sequence of calls is invalid. RMAN-10031: ORA-19509 occurred during call to DBMS_BACKUP_RESTORE.CHANGEBACKUPPIECE Recovery Manager complete.

--

Peter Gram, Miracle A/S
Phone : +45 2527 7107, Fax : +45 4466 8856 mailto:peter.gram@MiracleAS.dk - http://MiracleAS.dk


Content-Type: text/plain; name="ReadMe.txt"; charset="us-ascii" Content-Transfer-Encoding: 7bit

The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail.

This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact Postmaster_at_fatcity.com for clarification.

--------------ms060105000404070008030102--

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Peter Gram
  INET: peter.gram_at_miracleas.dk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Received on Mon Jan 20 2003 - 19:19:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US