Ora-01141 Error Renaming Data File
Contents |
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any ora-01511 error in renaming log/data files standby questions you might have Meta Discuss the workings and policies of ora-01511 ora-01516 this site About Us Learn more about Stack Overflow the company Business Learn more about hiring
How To Rename Datafile In Oracle
developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top rename datafile when file does not exists up vote 0 down vote favorite I am trying to clone our production database in test virtual machine. Our production database works with ASM. I would like to use plain file system in test database. I created database, services, pfile etc. I gave production database control files to test database. Right now I am trying to rename datafiles in test database. I get following error. SQL> startup mount; ..... SQL> alter database rename file '+NEWDATA/XX/XX01.dbf' to 'M:\oracle\datafiles\XX\XX01.dbf'; alter database rename file '+NEWDATA/XX/XX01.dbf' to 'M:\oracle\datafiles\XX\XX01.dbf'; * ERROR at line 1: ORA-01511: error in renaming log/data files ORA-01141: error renaming data file 162 - new file 'M:\oracle\datafiles\XX\XX01.dbf' not found ORA-01110: data file 162: '+NEWDATA/XX/XX01.dbf' ORA-27046: file size is not a multiple of logical block size OSD-04012: file size mismatch O/S-Error: (OS 4) The system cannot open the file. My backup is normal rman backup pieces not backup as copy. I am trying to rename nonexistent files. After this rena
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 4 Replies Latest reply on Mar 7, 2014 2:54 PM by tvCa-Oracle Renaming datafile of a single tablespace shows error Hasan Al Mamun Mar http://dba.stackexchange.com/questions/55807/rename-datafile-when-file-does-not-exists 7, 2014 10:26 AM Hi I was looking to move datafile from one location to another location.I issues the command as follows:When I issue thw query select a.name:select a.name,b.namefrom v$tablespace a,v$datafile bwhere a.ts#=b.ts#;It shows all the tablespaces and their datafiles. No probles there.I then issued the following commands:My tablespace is meddata, First I took it to offline.alter tablespace https://community.oracle.com/thread/3527480 meddata offline normal;Then I issued the command:alter tablespace meddata renamealter tablespace meddata rename datafile 'E:\MEDDATA\MEDDATA01.DBF'to 'D:\ORACLE112\ORADATA\ORCL\MEDDATA01.DBF';But following error message appears:SQL> alter tablespace meddata rename datafile 'E:\MEDDATA\MEDDATA01.DBF' 2 to 'D:\ORACLE112\ORADATA\ORCL\MEDDATA01.DBF';alter tablespace meddata rename datafile 'E:\MEDDATA\MEDDATA01.DBF'*ERROR at line 1:ORA-01525: error in renaming data filesORA-01141: error renaming data file 14 - new file 'D:\ORACLE112\ORADATA\ORCL\MEDDATA01.DBF' not foundORA-01110: data file 14: 'E:\MEDDATA\MEDDATA01.DBF'ORA-27047: unable to read the header block of fileOSD-04006: ReadFile() failure, unable to read from fileO/S-Error: (OS 38) Reached the end of the file.Cant figure what wrong here. Please help.Hasan Al Mamun 223Views Tags: none (add) datafileContent tagged with datafile, tablespaceContent tagged with tablespace This content has been marked as final. Show 4 replies 1. Re: Renaming datafile of a single tablespace shows error Anand... Mar 7, 2014 10:29 AM (in response to Hasan Al Mamun) Hi,After taking the tablespace offline , did you manually copy the file from E: location to D:\ORACLE112\ORADATA\ORCL\ loction? You need to copy the datafile manually and then run alter tablespace rename datafile and then recover tablespace and bring it
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have https://community.oracle.com/community/developer/search.jspa?q=ORA-01525 JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page.Search this communityOracle CommunityBridged communitiesOracle BlogsOracle University TrainingOracle data file VideosOTN DocumentationOTN Search ResultsSearch forSearch forContentSearch forPeopleSearch forPlacesLast modifiedLast modifiedAll timeLast modified1 dayLast modified7 daysLast modified30 daysLast modified90 daysLast modified1 yearSort byRelevanceRelevanceLast modifiedLast modifiedRestrict results byRestrict results by: PeopleRestrict results by: PlacesSubspace depthSubspace ora-01141 error renaming depthNo subspacesSubspace depthChild subspacesSubspace depthAll subspacesMatchingMatch names onlyDeactivated UsersShow/HideShowShowAll contentShowBlog postsShowDocumentsShowDiscussionsShowPollsShowIdeasShowStatus updatesShowMessagesShowExternal activityShowShowAll placesShowSpacesShowProjectsShowGroupsContent marked asShowAll ContentShowFinalShowReservedShowCommunity RecommendedShowOutdatedShowAction ItemShowDecisionShowHelpfulShowResolvedShowCommunity Feedback RequestedSocial Search On/OffSearchSearch TipsView more results from Oracle BlogsView more results from Oracle University TrainingView more results from Oracle VideosView more results from OTN DocumentationView more results from OTN Search ResultsAbout Oracle Technology Network (OTN)My Oracle Support Community (MOSC)MOS Support PortalAboutModern Marketing BlogRSS FeedPowered byOracle Technology NetworkOracle Communities DirectoryFAQAbout OracleOracle and SunRSS FeedsSubscribeCareersContact UsSite MapsLegal NoticesTerms of UseYour Privacy Rights© 2007-2016 Jive Software | Powered by Home | Top of pageJive Software Version: 8.0.3.1 , revision: 20160414082626.1619a91.release_8.0.3.x