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.
------------------ Start --------------------
Fri 03/01/2003
10:29
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:[EMAIL PROTECTED] - http://MiracleAS.dk
smime.p7s
Description: application/pkcs7-signature
