Monday, June 20, 2011

PRD Disaster Recovery

The entire procedure for DRS switchover
PRODUCTION TO DRS SWITCHOVER


1. Take Offline backup of the PRD Database.
2. In SM02, Put message on the PRD system.
3. On PRD,

cmd>SVRMGR30
Connect Internal;
Alter system switch logfile;
Do switch log file 3-4 times.

4. In DRS, apply up to the last Archive Log created in PRD.
5. On PRD, Stop R/3, Shutdown Database And Stop SAP & Oracle Services.
6. On PRD, Backup Mirrlog A, Mirrlog B, Origlog A, Origlog B & Control file of PRD.
7. Shutdown DRS Database & Stop Oracle Services.
8. On DRS, Backup Mirrlog A, Mirrlog B, Origlog A, Origlog B & Control file of DRS.
9. Copy the redo log files & control files from PRD (production DB System) to DRS (DRS DB System). Copy the control file to all the locations on DRS (OriglogA, Saparch & Sapdata1 sub-folders).
10. Start the Oracle Services on DRS.
11. In DRS
Start SVRMGR30
Connect Internal;
Startup Mount;
Recover Database; (Ensure the message ‘Media Recovery Complete’ appears).
Alter databases Open; (This opens in NORESETLOGS mode).
Exit;
12. Start SAPOSCOL, SAP_00 services on DRS.
13. Start SAP R/3 application on DRS.
14. Logon to the DRS System through SAP Logon Pad.
15. Check the System Status & transactions like SM51, ST22, and SM21 Etc.

DRS TO PRODUCTION SWITCHOVER


16. On DRS, Stop R/3, Shutdown Database and Stop SAP & Oracle Services.
17. Copy the redo log files & control files from DRS (DRS DB System) to PRD (production DB System). Copy the control file to all the locations on PRD (OriglogA, Saparch & Sapdata1 sub-folders).
18. Start the Oracle services on the DRS.
19. Start the Oracle Services on PRD.
20. In PRD
Start SVRMGR30
Connect Internal;
Startup Mount;
Recover Database; (Ensure the message ‘Media Recovery Complete’ appears).
Alter databases Open; (This opens in NORESETLOGS mode).
Exit;
21. Start SAPOSCOL, SAP_00 services on PRD.
22. Start SAP R/3 application on PRD.
23. Logon to the PRD System through SAP Logon Pad.
24. Check the System Status & transactions like SM51, ST22, and SM21 Etc.
Note: - DRS: DRS database server
PRD: Production database server