Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

RENAMING DATAFILE

693241May 20 2009 — edited May 20 2009
Hello All,
We use Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit on Solaris 10.
I ran out of space in one of the mount points and when i checked al the files were oracle datafiles.
so i thought of moving datafile and rename it.
This is the steps i followed and the error thrown....

1)shutdown the database
2)cp /u02/oradata/DWH/temp01.dbf /u01/oradata/DWH/temp01.dbf
3)startup nomount
4)alter database mount
5)alter database rename file '/u02/oradata/DWH/users01.dbf' to '/u01/oradata/DWH/temp01.dbf';

Database altered.

6)alter database open;
alter database open
*
ERROR at line 1:
ORA-01122: database file 4 failed verification check
ORA-01110: data file 4: '/u01/oradata/DWH/temp01.dbf'
ORA-01251: Unknown File Header Version read for file number 4


Where am i doing the mistake....


Thanks in advance
Vijay G
This post has been answered by 584650 on May 20 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 17 2009
Added on May 20 2009
6 comments
1,188 views