Home » RDBMS Server » Backup & Recovery » Move DB to a new server (Oracle 9i Rel1. windows2000)
Move DB to a new server [message #564450] Thu, 23 August 2012 21:57 Go to next message
Rayam69
Messages: 43
Registered: May 2012
Member
I am testing to move the production DB to a new server.
The current OS is windows 2000 server and the new OS i want to use is windows 2003 server.
I have the RMAN backup file along with the catalog file.

I have already installed the Oracle software and pathces on to the new server.
What are the steps to create the database from the RMAN backup file.

Please help.
Thanks.
Re: Move DB to a new server [message #564451 is a reply to message #564450] Thu, 23 August 2012 22:09 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
why are willing to upgrade the OS from one unsupported version to another
& yet stick with obsoleted & unsupported version of Oracle DB?

>Oracle 9i Rel1 was a really buggy version

>What are the steps to create the database from the RMAN backup file.
same as to restore any DB from RMAN backup.
Don't you have documented & tested Recovery Manual?
Re: Move DB to a new server [message #564516 is a reply to message #564451] Fri, 24 August 2012 09:57 Go to previous messageGo to next message
Rayam69
Messages: 43
Registered: May 2012
Member
Dont have license for newer version of DB nor the support.
The version we have with the patch seems to be stable.

We dont have any documentation.
what is the difference between restore from dmp and rman.
I have done the prior more than a few times and it works ok.

I want to try restore from rman so I may not have to do a lot of extra steps
Thanks.
Re: Move DB to a new server [message #564517 is a reply to message #564516] Fri, 24 August 2012 10:07 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
when all else fails Read The Fine Manual

http://docs.oracle.com/cd/A91202_01/901_doc/server.901/a90136/toc.htm
Re: Move DB to a new server [message #564518 is a reply to message #564516] Fri, 24 August 2012 10:09 Go to previous message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Database Backup and Recovery Basics
Database Backup and Recovery Reference
Database Backup and Recovery Advanced User's Guide

Regards
Michel
Previous Topic: tablespace export vs Schema export
Next Topic: Problem in manual DB Recovery.
Goto Forum:
  


Current Time: Tue Dec 17 21:22:54 CST 2024