| RMAN-6014 trying to uncatalog old controlfile copy [message #73544] |
Wed, 19 May 2004 07:38  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
