What are the specific steps to move the database to a new server (Oracle DB)?
I am tasked with moving our JTS/application database to a new server. I am new to Jazz and the Rational suite of tools but have been doing a lot of reading recently. From what I have read, it seems pretty straight forward to move the database.
I understand the high level steps to be:
1) Use Oracle RMAN to replicate the existing production database to a new server
2) Export some views from the existing production database (to test the database migration)
3) Edit the server/conf/applicationName/teamserver.properties for each application and point to the new database server
4) Export the same views from step 2 and compare to those in step 2 to validate the database replication was sucessful. If the views don't compare, then edit the teamserver.properties to point back to the original database server.
Are there any other specifics to be aware of? Are there any services that need to be stopped first? Is it as simple as replicating the database and pointing the applications to the new server? Any hidden steps?
Thank you,
Accepted answer
Hi Becky,
Yes, it is so simple:
Yes, it is so simple:
- Stop the servers
-
Migrate database to a new server
-
Change database connection in teamserver.properties for each application. You must notice that in each teamserver.properties you have a reference to both: application data and datawarehouse database.
-
Start database and the server