Hi Hussein Sawwan,
I have a question that will be useful to other members of the community. How do I restore Oracle E-Business Suite R12 after physically loosing the server that hosts the ERP instance?
I have 2 scenarios here:
1-Existing cold backups of the DbTier and AppsTier are available
I have been doing a full backup of the Apps and Inst folders once a week on an external drive.
I have been copying the DB folder (Data + DBMS_ORACLE_HOME) after shutting down the database cleanly once a week on an external drive. Noting that, here the database is in NOARCHIVELOG mode.
2-Existing Hot backups of the Database are available and I have a backup of the Apps and Inst folders (AppsTier)
The database is in archivelog here. I have been doing a full hot backup of the database once a week, an Incremental backup everyday, and a full backup of the archivelogs once a week. All of this to an external drive. The Apps and Inst folders are backed up once a week to an external drive.
Let say something bad happens and we completely loose the physical server. How can I do to restore and recover my Oracle E-Business Suite R12 to a new server?
I know I will have to Install the same OS on the new server, but what happens after that?
Thanks in advance,
I believe the easiest approach would be:
- Install the same OS on the new servers
- Install OS pre-req software and packages for your EBS instance
- Restore from cold backup (if the crash happened directly after this backup and you haven't lost any data)
- Restore from hot backup (if the crash happened after your cold backup and you have data that wasn't part of the cold backup)
I assume that no changes to the hostname, domainname, IP Address, port numbers, directory structure, ..etc is taking place in this restore.
Assuming that the new server is configured exactly as the old server (IP, hostname, port pool, directories...), what you mean by restoring is that I will just have to copy the cold/hot backup from the external drive to the new server? Is that all that needs to happen? Can you please go into more details?
Yes, you just need to restore the files (assuming your OS is Linux/Unix). Once you restore the files run AutoConfig to make sure that everything is working as expected. You will also need to do sanity checks (verify CMs, Workflow, run concurrent programs, ..etc).