Home » RDBMS Server » Backup & Recovery » RMAN-6014 trying to uncatalog old controlfile copy
RMAN-6014 trying to uncatalog old controlfile copy [message #73544] Wed, 19 May 2004 07:38 Go to next message
manny
Messages: 4
Registered: May 2000
Junior Member
1. There are 3 obsolete backups of controlfiles in the RMAN catalog. It is marked "Datafile Copy" even though these are controlfiles. I guess its because of the file extension ".dbf".

RMAN> report obsolete;
RMAN-03022: compiling command: report
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Datafile Copy        226015 25-NOV-02          /u06/oradata/ifc/cold_backup/november27/ctlifc1.dbf
Datafile Copy        226016 25-NOV-02          /u12/oradata/ifc/cold_backup/november27/ctlifc2.dbf
Datafile Copy        226017 25-NOV-02          /u18/oradata/ifc/cold_backup/november27/ctlifc3.dbf

2. Crosscheck expired does not show any of the 3 files above.

3. When I try to uncatalog, I get the following errors:

RMAN> change controlfilecopy 226015 uncatalog;

RMAN-03022: compiling command: change
RMAN-03026: error recovery releasing channel resources
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: change
RMAN-06014: command not implemented yet: controlfilecopy by key

4. I want to just delete the record from rc_controlfile_copy. Is this ok?

SQL> select * from rc_controlfile_copy
  2  /

    DB_KEY  DBINC_KEY DB_NAME     CCF_KEY      RECID      STAMP
---------- ---------- -------- ---------- ---------- ----------
NAME
--------------------------------------------------------------------------------
TAG                              RESETLOGS_CHANGE# RESETLOGS_TIME
-------------------------------- ----------------- ------------------
CHECKPOINT_CHANGE# CHECKPOINT_TIME    CREATION_TIME      BLOCK_SIZE
------------------ ------------------ ------------------ ----------
MIN_OFFR_RECID OLDEST_OFFLINE_RANGE COMPLETION_TIME    S
-------------- -------------------- ------------------ -
       288        289 IFC          226015          4  478889620
/u06/oradata/ifc/cold_backup/november27/ctlifc1.dbf
                                                 1 10-APR-01 19:17:10

    DB_KEY  DBINC_KEY DB_NAME     CCF_KEY      RECID      STAMP
---------- ---------- -------- ---------- ---------- ----------
NAME
--------------------------------------------------------------------------------
TAG                              RESETLOGS_CHANGE# RESETLOGS_TIME
-------------------------------- ----------------- ------------------
CHECKPOINT_CHANGE# CHECKPOINT_TIME    CREATION_TIME      BLOCK_SIZE
------------------ ------------------ ------------------ ----------
MIN_OFFR_RECID OLDEST_OFFLINE_RANGE COMPLETION_TIME    S
-------------- -------------------- ------------------ -
        6.6223E+12 25-NOV-02 16:53:37 10-APR-01 19:17:12       8192
             0                    0 25-NOV-02 16:53:40 D
Re: RMAN-6014 trying to uncatalog old controlfile copy [message #73545 is a reply to message #73544] Wed, 19 May 2004 08:35 Go to previous message
croca
Messages: 50
Registered: January 2004
Member
I strongly recomend not to delete records from the catalog by yourself.
There is an oracle provided script that deletes records just only to purge the catalog, that's the onlye way to delete recrods.
The catalog is not suppoused to be deleted by users, you mran commands instead.

Best regards.
try RMV to display rman backup's catalog information
from www.otools.com.ar
Previous Topic: Help: need Backup&Recovery strategies for Siebel 7 (using RMAN)
Next Topic: copy database between platforms
Goto Forum:
  


Current Time: Thu Mar 28 05:09:26 CDT 2024