iSelfSchooling.com - Community of Sharing

Click here for Online Oracle 8i, 9i, 10g, 11g and 12c Training

from www.iSelfSchooling.com

November 25, 2014, 11:13:00 PM *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
 
   Home   Help Login Register  
Pages: [1] |   Go Down
  Send this topic  |  Print  
Author Topic: How to solve the RMAN-06207 and RMAN-06208 rman worning...  (Read 6585 times)
dba4ora
writepostonly
Jr. Member
*****
Posts: 19


« on: May 19, 2010, 05:53:37 AM »

www.iselfschooling.com
-----------------------

When you perform the RMAN backup and if you get the following worning.

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


Example:
RMAN-06207: WARNING: 3 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: Backup Piece    /backup/stage/6ildatbj_1_1
.....

To delete above files which physically not exist.
Just perform the following commands to solve the problem:
RMAN> crosscheck copy;
RMAN> delete expired copy;

--or
RMAN>crosscheck copy
RMAN>delete noprompt obsolete;

--or
Report obsolete
Delete obsolete


--dba4ora
Logged

?Good teaching is one-fourth preparation and three-fourths theater.? Gail Godwin

OCP 11g
Pages: [1] |   Go Up
  Send this topic  |  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.18 | SMF © 2013, Simple Machines Valid XHTML 1.0! Valid CSS!