Planning to Renovate old Apps Server Hardware
Our some of the Sister's companies complaining since long time, they are
facing frequent restart of server and very slow performance of database
application and different type of issues. As we are having very old
server based on Windows 2003 and Oracle 9i database with the patched
version of 9.2.0.7. We have very limited disk capacity and memory size
as well as hardware configuration is very old due to this we are facing
issues. Finally we have made two plan to renovate the hardware of these
server as well as decided to increase some database parameters. As we
are not having the complete idea of different application running on the
server as well as not having the same patched version of oracle
binaries. So we decided not to go fresh installation of OS/Oracle
binaries/Applications on some of the server. Here in this article you
can find the plan and its steps. The detail working procedure you can
find with my separate post of link below:
- Install the Oracle into New server and Restore and recover the full backup of old DBserver.
- Get the Oracle Environment from system restore and use RMAN and other process to synchronize the data after testing.
The actual process to prepare new sever is the Restore
& Recover the database after
fresh installation of oracle software on destination server but if you are
facing the complexity of running application as well as same patched version or
if you do not have idea about Instillation process of any running software or
facing any other complexity, we have another option to follow the System
backup & Restore policy.
Plan A:
Consider the Drive structure and OS version is same. Perform
fresh installation of oracle software and apply the required patch (if any) and
use RMAN restore & recovery procedure to synchronizes the data. Check my
other post “How to perform this plan: Plan A: Renovate old Apps Server Hardware
Steps:
- Install the Oracle software only in New server and Apply the related patch
- Take RMAN full Hot or Cold backup of source database and copy to the same location on destination server.
- Create PFILE from Production server and Copy to the destination server.
- Create required folder on destination drive.
- Create Oracle service for Windows.
- Configure TNS and Listener setting as you can access the Prod, TEST, RMAN database.
- Create Password file for New Server database.
- Use the RMAN Duplicate Database concept to duplicate the database.
- Compare the Test Database with Prod DB after successful.
- Create the Temp file and Activate Archivelog switch for New Database.
- Install the entire running application on the new server.
- Perform Tuning of Database and Application and keep it under testing process (7 days).
- After verification apply restore and recover procedure again.
- Change the port of new server same as previous DBserver.
- Make this server Active for end user.
Plan B:
Get the same oracle binaries from system Restore &
Recovery Procedure and use RMAN and other recovery process to synchronize the
data after testing. Check the other post how to manage successful system
restore and how to perform this plan: Plan B Renovate old Apps Server Hardware
Steps:
- Create pfile from spfile on Prod database.
- Backup & Restore whole system of Prod DB on Destination Server.
- Make either RMAN HOT or COLD Backup of Prod Database and copy it to the destination server location.
- Make sure to check the exiting folder file, pwdfile, Windows services on the destination server.
- Configure the TNS and Listener for Prod/Test/RMAN database
- Start the database using Pfile in nomount phase and Restore the Spfile and Controlfile.
- Take the database in Mount phase and Restore & Recover the database.
- Open the database and verify the successful restore and recovery.
- Verify All the Application is running successfully with normal behavior by keeping the server under testing few days.
- If all are well, disconnect the original server and Restore & Recover the database with latest prod Backup.
- Switch the Production server IP and Name with the new server and activate for end user.
Follow the Link for Detail
description of Plan:
