Home » RDBMS Server » Backup & Recovery » offline (Oracle 9.2.0.8 Windows Server 2003)
offline [message #407749] Thu, 11 June 2009 07:06 Go to next message
dirish
Messages: 205
Registered: November 2006
Senior Member
Dear All,

My old server config:
ORACLE_HOME in c:\oracle
Datafiles + Control files + Redo Logs + Init file in c:\oradata
Oracle 9.2.0.8 - Enterprise
Windows Server 2003


My new server config:ORACLE_HOME in c:\oracle\app
Oracle 9.2.0.8 - Enterprise
Windows Server 2003


If I make an offline backup on my old server and copy the Datafiles + Control files + Redo Logs + Init file to the new server in c:\oradata.

Will I be able to start the database on the new server.


Thank you,
Re: offline [message #407752 is a reply to message #407749] Thu, 11 June 2009 07:18 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Yes. You'll just have to create a Windows service with oradim for the Oracle database prior to starting the database.

[Updated on: Thu, 11 June 2009 07:18]

Report message to a moderator

Re: offline [message #407754 is a reply to message #407752] Thu, 11 June 2009 07:27 Go to previous messageGo to next message
dirish
Messages: 205
Registered: November 2006
Senior Member
you mean to say that the path of the software installation is not a problem?
just copy the file to the new server, use oradim then startup the DB
Re: offline [message #407755 is a reply to message #407754] Thu, 11 June 2009 07:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The path of Oracle home does not matter, the path of the db files does.
If you have not the same path for them, you then have to startup in mount mode and change each location with alter database statement, or rman same command if your backup was made by rman.

Regards
Michel
Re: offline [message #407756 is a reply to message #407754] Thu, 11 June 2009 07:38 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
The only thing you need to be concerned of with the new ORACLE_HOME is to have a spfile in %ORACLE_HOME%\database directory or specify the PFILE location when you use oradim.
Re: offline [message #407758 is a reply to message #407749] Thu, 11 June 2009 07:46 Go to previous messageGo to next message
dirish
Messages: 205
Registered: November 2006
Senior Member
in the old server the spfile is in c:\oradata

and i shall copy the spfile in c:\oradata in the new server

so this should not cause any harm?
Re: offline [message #407760 is a reply to message #407758] Thu, 11 June 2009 07:59 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You should create your Windows Oracle Serive specifying the PFILE and where it is located. In the PFILE should be a pointer to the SPFILE in c:\oradata.

Check the contents of your old PFILE and verify it simply had a pointer to the SPFILE.

[Updated on: Thu, 11 June 2009 08:01]

Report message to a moderator

Previous Topic: Daily database backup runnig on RAC 10.2.0.3 with two Solaris nodes & ASM
Next Topic: Create a Backup and Restore "Tablespace"
Goto Forum:
  


Current Time: Fri Dec 09 02:00:33 CST 2016

Total time taken to generate the page: 0.10359 seconds