Search This Blog

Monday, July 21, 2008

crosscheck controlfilecopy + RMAN-06207

RMAN-06207: WARNING: 31 objects could not be deleted for DISK channel(s) due
RMAN-06208: to mismatched status. Use CROSSCHECK command to fix status

Above error message I am getting when i given "delete noprompt obsoelete".
RMAN> delete noprompt obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 2
using channel ORA_DISK_1
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Controlfile Copy 1 13-SEP-07 /db/hot_backup/controlfile/contro l01.ctl
Controlfile Copy 2 13-SEP-07 /db/hot_backup/controlfile/contro l02.ctl
[output cut]
RMAN-06207: WARNING: 31 objects could not be deleted for DISK channel(s) due
RMAN-06208: to mismatched status. Use CROSSCHECK command to fix status
RMAN-06210: List of Mismatched objects
RMAN-06211: ==========================
RMAN-06212: Object Type Filename/Handle
RMAN-06213: --------------- ---------------------------------------------------
RMAN-06214: Datafile Copy /db/hot_backup/controlfile/control01.ctl
RMAN-06214: Datafile Copy /db/hot_backup/controlfile/control02.ctl
RMAN-06214: Datafile Copy /db/hot_backup/controlfile/control03.ctl

Now question is how can i delete above controlfile which physically not exists.
I search on net and found below link
Link

Just below two command will solve the problem

RMAN> crosscheck copy;
RMAN> delete expired copy;

3 comments:

Anonymous said...

You've made some really good points there. I looked on the web for more information about the issue and found most individuals will go along with your views on this web site.

My website; Video Production

Anonymous said...

I was very happy to uncover this great site. I need to to thank
you for your time due to this fantastic read!
! I definitely liked every bit of it and I have you book marked to look at new things in your site.
I hope you don't mind, I bookmarked Blogger: Oracle Newbie DBA / Apps DBA at Reddit so my friends may see it as well. If you don't
mind I would also reveal a tip. Finding fantastic video marketing can also be fairly tough.
I find it most beneficial to speak with a a Probate Lawyer
San Diego. Our crew of San Diego Bankruptcy Attorney are right here to
help you with all of your legal demands.

Also visit my homepage :: Amazing Estate Planning Lawyer San Diego

Anonymous said...

Its not my first time to pay a visit this website,
i am visiting this web site dailly and take fastidious facts from here every day.


Stop by my web page ... continue