Home » RDBMS Server » Backup & Recovery » retrieving oradata files (Oracle 9i)
retrieving oradata files [message #433736] Thu, 03 December 2009 21:55 Go to next message
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 #433741 is a reply to message #433736] Thu, 03 December 2009 23:09 Go to previous messageGo to next message
Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku
Senior Member

Open database in mount mode and use

ALTER DATABASE RENAME DATAFILE 'old_name' TO 'new_name'

Then open the database. Doing it, you change the information about location of datafiles written in controlfiles and point to the new directory
Re: retrieving oradata files [message #433800 is a reply to message #433741] Fri, 04 December 2009 05:39 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Also check here

- Babu
Re: retrieving oradata files [message #434648 is a reply to message #433736] Thu, 10 December 2009 01:58 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
icon12.gif  Re: retrieving oradata files [message #434790 is a reply to message #434650] Thu, 10 December 2009 14:11 Go to previous message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member

Warning: Instead of executing '@catproc' execute '@catupgd'
Shocked
Previous Topic: RMAN Restore stuck up
Next Topic: RMAN-08132 during backup archive logs on physical standby database.
Goto Forum:
  


Current Time: Fri Dec 02 18:20:52 CST 2016

Total time taken to generate the page: 0.18591 seconds