Re: Bad File Name in the Control file for Control file copy

On 7/15/22 11:45, Andrew Kerber wrote:
> Hi.  we are getting an oracle error
>
> RMAN-03009: failure of crosscheck command on ORA_DISK_1 channel at
> 07/12/2022 10:29:45
> ORA-19633: control file record 130 is out of sync with recovery catalog
>
> The problem is that the file name has a special character of some
> sort, and no matter what I do I cannot remove the record from the
> controlfile.  I have tried 'delete controlfilecopy 130;'  , deleting
> based on the tag, etc.  But nothing I do will remove the record.
>
> I expect it can be removed if I re-create the controlfile, but I
> really dont want to shut down the database.  I have an SR open with
> oracle and they have provided nothing as yet, other than request
> information I provided when I opened the SR.
>
> Does anyone have any ideas?
>
> --
> Andrew W. Kerber
>
> 'If at first you dont succeed, dont take up skydiving.'

Hi Andy,

Have you tried to make it unavailable? CHANGE CONTROLFILECOPY 130 UNAVAILABLE or CHANGE CONTROLFILECOPY 130 UNCATALOG? The "UNCATALOG" is supposed to remove it from the catalog and set the status to "DELETED"?

That is the best I can think of.

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

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