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;
"Teach Oracle Learn Oracle" -- Taj Contact me for support at askdbataj@gmail.com This blog is dedicated to all ORACLE Professionals and Learning Students.
Search This Blog
Monday, July 21, 2008
crosscheck controlfilecopy + RMAN-06207
Subscribe to:
Post Comments (Atom)
3 comments:
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
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
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
Post a Comment