OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » Rman -6207 (11.2.0.3 )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Rman -6207 [message #662384]

Fri, 28 April 2017 05:23

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

Report message to a moderator

Re: Rman -6207 [message #662385 is a reply to message #662384]

Fri, 28 April 2017 06:40

John Watson
Messages: 8738
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.

Report message to a moderator

Re: Rman -6207 [message #662386 is a reply to message #662384]

Fri, 28 April 2017 06:46

EdStevens
Messages: 1375
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

Report message to a moderator

Re: Rman -6207 [message #662387 is a reply to message #662384]

Fri, 28 April 2017 06:54

EdStevens
Messages: 1375
Registered: September 2013

Senior Member

Also asked on OTN

Report message to a moderator

Re: Rman -6207 [message #662388 is a reply to message #662387]

Fri, 28 April 2017 07:06

maoro
Messages: 312
Registered: May 2005

Senior Member

Hi
File names were used in between quotes

Regards

Report message to a moderator

Re: Rman -6207 [message #662389 is a reply to message #662388]

Fri, 28 April 2017 07:07

John Watson
Messages: 8738
Registered: January 2010
Location: Global Village

Senior Member

So what did you actually do?

Report message to a moderator

Re: Rman -6207 [message #662393 is a reply to message #662388]

Sat, 29 April 2017 06:41

EdStevens
Messages: 1375
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?

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Aug 10 02:28:53 CDT 2022