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: 232
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,

Report message to a moderator

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: 232
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

Report message to a moderator

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: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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.

Report message to a moderator

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: 232
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?

Report message to a moderator

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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 22 07:58:41 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.