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!

problem after rename datafile belongs to SYSTEM tablespace

val75May 12 2009 — edited May 12 2009
Hi
I've renamed one file belongs to SYSTEM tablespace.
Then I brought database online and dropped the old file, now I can open database,
but I can't run backup.
I delete previous one so I can't restore that file from backup, I have the file because I clonned db,
but when I restore file and run recover from RMAN database got recovered.
After that I still can't run backup.
Do you have idea what to do???
SYS@orcl >select * from v$recover_file;

FILE# ONLINE ONLINE_
---------- ------- -------
ERROR CHANGE#
----------------------------------------------------------------- ----------
TIME
---------
14 OFFLINE OFFLINE
OFFLINE NORMAL 0
This post has been answered by Anand... on May 12 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 9 2009
Added on May 12 2009
10 comments
876 views