Re: Oct. PSU / RMAN Error

From: MacGregor, Ian A. <"MacGregor,>
Date: Tue, 27 Nov 2018 22:05:27 +0000
Message-ID: <BYAPR07MB49018B2E0955363A47A13D87E2D00_at_BYAPR07MB4901.namprd07.prod.outlook.com>

This is a problem with purging backups written to tape. Searching in the

06091 error will give the workaround and also point to overlay patches. We were hit by this as well.

Ian A. MacGregor
SLAC National Accelerator Laboratory
Computing Division
To offer the best IT service at the lab and be the IT provider of choice.

---

From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Leng <lkaing_at_gmail.com> Sent: Tuesday, November 27, 2018 1:51:12 PM To: srcdco_at_rit.edu
Cc: oracle-l_at_freelists.org
Subject: Re: Oct. PSU / RMAN Error

Scott,

Just the errorneoous line is not enough to work with.

Please share:

1. Rman> show all;
2. command
3. full log
4. are you using a recovery catalog?

Cheers,
Leng

On 28 Nov 2018, at 8:25 am, Scott Canaan <srcdco_at_rit.edu<mailto:srcdco_at_rit.edu>> wrote:

I just installed the Oct. PSU in my Oracle 12.1.0.2 Oracle Home. The next RMAN hot backup failed with the same issue that occurred with the July PSU, which we backed out and didn’t apply. There was supposed to be a fix for this, which I assumed would be included with the Oct. PSU.

Because of this issue, we didn’t apply the July PSU, but our internal security office is insisting we have to apply this one. If we do, we won’t be able to back up any of our production databases, as they are all hot backups.

I have opened an SR with Oracle, but was wondering if anyone else has run into this issue and, if so, did you get a patch from Oracle to fix it? I’ve been looking for a patch online and on Oracle’s site all afternoon, with no success.

The error is:

released channel: ch1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03002: failure of delete command at 11/27/2018 09:38:40 RMAN-06091: no channel allocated for maintenance (of an appropriate type) RMAN> Scott Canaan ‘88
Sr Database Administrator
Information & Technology Services
Finance & Administration

Rochester Institute of Technology
o: (585) 475-7886 | f: (585) 475-7520

srcdco_at_rit.edu<mailto:srcdco_at_rit.edu> | c: (585) 339-8659

CONFIDENTIALITY NOTE: The information transmitted, including attachments, is intended only for the person(s) or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and destroy any copies of this information.

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Nov 27 2018 - 23:05:27 CET