| error in identifying datafile [message #462846] |
Mon, 28 June 2010 02:57  |
ultgnp
Messages: 106
Registered: May 2010
Location: Germany
|
Senior Member |
|
|
Hi,
I have a database of branch A whose files are located in E:\ Drive. I want to download it in branch B.I placed all the files of Branch A in D:\ Drive of Branch B. When i start the database i was getting controlfle error. I made required corrections in initorcl.ora. Now when i start the Database,its mounted, but I am getting ORA-01157: Cannot identify datafile 1. I tried to rename the file, but the "alter database rename file1 to file2;" option is not working
(Since this file was originally in different location).Please guide
Best Regards,
|
|
|
|
|
|
| Re: error in identifying datafile [message #464022 is a reply to message #462853] |
Mon, 05 July 2010 22:31  |
suntrupth
Messages: 13
Registered: July 2010
|
Junior Member |
|
|
Hi,
First step would be to start the database with the valid path. You could change the directory as required when you open the database successfully.
Backup the controlfile.
Go ahead and recreate the Controlfile.
Thanks,
Suntrupth
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
