Home » RDBMS Server » Backup & Recovery » Rman -6207 (11.2.0.3 )
Rman -6207 [message #662384] Fri, 28 April 2017 05:23 Go to next message
maoro
Messages: 312
Registered: May 2005
Senior Member
Hello
after using the below to rename datafiles:
1-ALTER TABLESPACE DATAMPP OFFLINE;
2-RMAN> COPY DATAFILE '+DATA/dbm/datafile/datampp.328.877737659' TO '+NEWDATA';
3-sqlplus> alter database rename file ' ' to ' ' ;
4-ALTER TABLESPACE DATAMPP ONLINE

rman logs shows the backup as copy as obsolete and tries to delete it and luckily fails with :
RMAN-06207: WARNING: n objects could not be deleted for DISK channel(s) due
RMAN-06208: to mismatched status. Use CROSSCHECK command to fix status

please advise on how to configure rman to consider the copy of datafile not obsolete
and never tries to delete it
Regards
Re: Rman -6207 [message #662385 is a reply to message #662384] Fri, 28 April 2017 06:40 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
What did you actually do? For example, you did not run the RENAME command you claim to have run, because it doesn't work:
orclz>  alter database rename file ' ' to ' ' ;
 alter database rename file ' ' to ' '
*
ERROR at line 1:
ORA-01511: error in renaming log/data files
ORA-09314: sltln: error translating logical name
OSD-04026: Invalid parameter passed.
Re: Rman -6207 [message #662386 is a reply to message #662384] Fri, 28 April 2017 06:46 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
maoro wrote on Fri, 28 April 2017 05:23
Hello
after using the below to rename datafiles:
1-ALTER TABLESPACE DATAMPP OFFLINE;
2-RMAN> COPY DATAFILE '+DATA/dbm/datafile/datampp.328.877737659' TO '+NEWDATA';
3-sqlplus> alter database rename file ' ' to ' ' ;
4-ALTER TABLESPACE DATAMPP ONLINE

rman logs shows the backup as copy as obsolete and tries to delete it and luckily fails with :
RMAN-06207: WARNING: n objects could not be deleted for DISK channel(s) due
RMAN-06208: to mismatched status. Use CROSSCHECK command to fix status

please advise on how to configure rman to consider the copy of datafile not obsolete
and never tries to delete it
Regards

alter database rename file ' ' to ' ' ;

What do you think that is doing?
And Where did you come up with that procedure?

See Moving Data Files Between Oracle ASM Disk Groups Using RMAN


Re: Rman -6207 [message #662387 is a reply to message #662384] Fri, 28 April 2017 06:54 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
Also asked on OTN
Re: Rman -6207 [message #662388 is a reply to message #662387] Fri, 28 April 2017 07:06 Go to previous messageGo to next message
maoro
Messages: 312
Registered: May 2005
Senior Member
Hi
File names were used in between quotes

Regards
Re: Rman -6207 [message #662389 is a reply to message #662388] Fri, 28 April 2017 07:07 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
So what did you actually do?
Re: Rman -6207 [message #662393 is a reply to message #662388] Sat, 29 April 2017 06:41 Go to previous message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
maoro wrote on Fri, 28 April 2017 07:06
Hi
File names were used in between quotes

Regards
Given the problem, don't you think that what was really between the quotes might have been useful? How do you expect us to be able to help if you don't show what you did?

Previous Topic: v$recovery_file_dest don't show actual space usage
Next Topic: RMAN-03008: error while performing automatic resync of recovery catalog
Goto Forum:
  


Current Time: Thu Mar 28 08:39:35 CDT 2024