| retrieving oradata files [message #433736] |
Thu, 03 December 2009 21:55  |
jayantm
Messages: 1
Registered: December 2009
|
Junior Member |
|
|
Friends,
I have oradata folder from customer and I have my own oracle setup at my machine. The oradata folder from customer showing that it was in D Drive whereas my oracle is in E drive.
How to retrieve the control, logs and db files from the oradata folder of drive 1 to drive 2 when oracle home is changed?
Kindly help me.
With Regards,
Jayant
|
|
|
|
|
|
|
|
| Re: retrieving oradata files [message #434648 is a reply to message #433736] |
Thu, 10 December 2009 01:58  |
stonevishcool
Messages: 29
Registered: June 2008
Location: Mumbai
|
Junior Member |
|
|
Hello,
If primary db on lower version than test db then what would happened? In my case (WIndows) i copied ORADATA folder on test db server and follow below mentioned steps.
1. Create a new password file for db.
2. Create a new service.
3. Create bdump,cdump,udump.... folder
4. Made the changes in pfile i.e change controlfile path from d:\ to c:\ and also for other folder.
5. Mount db the database and executed "ALTER DATBASE RENAME FILE" command for all files.
6. Then tried to "ALTER DATABASE OPEN" (But on this stage i an error )
After checked the alter lof file i found "ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option" message.
Let me clear you that my primary db on 10.2.0.1 version and test db where i copied the ORADATA folder which is on 10.2.0.4 version.
Is there any UPGRADE script which i need to execute? How to execute it?
Regards,
Vish
|
|
|
|
| Re: retrieving oradata files [message #434650 is a reply to message #434648] |
Thu, 10 December 2009 02:06 |
stonevishcool
Messages: 29
Registered: June 2008
Location: Mumbai
|
Junior Member |
|
|
Quote:
Is there any UPGRADE script which i need to execute? How to execute it?
Sorry for inconvenience.
Just now i got the answer. Below mentioned steps:
1. Open a command prompt and browse to /rdbms/admin
1. Start sqlplus (sqlplus / as sysdba)
2. Run "startup upgrade"
3. Run @catproc.sql
will let you know once it works.
Regards,
Vish
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
