Disaster recovery for PI 7.0 Using oracle data guard

[former_member209962]

Dear All,

We are planning for a Disaster recovery system for PI7.0 Using oracle data guard.

My Questions are.

If we build a Disaster system using PI Production backup and configure data guard for log shipping is it enough?

Or are after building PI DR system with PI production backup we need to maintain all the settings manually like communication channel,  SLD etc in integration builder.

There is a small tool which is being used between PI and third party system called Mirth Connector we have to replicate that also?

note: this is hospital environment and PI is used for integration between LAB system and SAP so that doctor can see all the x rays in sap system.

Third party systems are LAB INFORMATION SYSTEM & RADIOLOGY INFORMATION SYSTEM

Kindly clarify above questions

Thanks

Tabrez

[Former Member]

Dear Tabrayz Abdul,

Sorry for the delay reply..

Log ship and applying standby system thats enough..What are configuration having in your production everything It will come to standby system.

If you have any more query, please ask me again.

Thanks

Mahendran

[former_member209962]

Dear Mahendran,

Thanks for your reply.

Do you have any documentation on oracle data guard configuration kindly share if you have done this before.

Thanks

Tabrayz

Message was edited by: Moderator

[Former Member]

Hi Buddy,

Please find the Parameter for Dataguard project.Take the backup of the production and restore on DR system and configure.Then you need to create standby controlfile from production system and replay to standby system.

Then configure you tnsnames.ora file for both system.

Steps in Primary server

1. STARTUP PFILE='C:\oracle\PRD\102\database\initPRD.ora' mount;
2. alter system reset log_archive_dest sid='stprd';
3. alter system set log_archive_dest='';
4. alter system set log_archive_dest_1='location=C:\oracle\PRD\oraarch\PRDarch' scope=both;
5. alter system set standby_file_management='AUTO' scope=both;
6. alter system set log_archive_dest_2='SERVICE=stprd' scope=both;
7. alter system set log_archive_dest_state_1='ENABLE'SCOPE=BOTH;
8. alter system set log_archive_dest_state_2 = ‘defer’ scope=both;
9. alter system set log_archive_dest_state_2='ENABLE'SCOPE=BOTH;

Steps in Standby server:

1. STARTUP PFILE='C:\oracle\PRD\102\database\initPRD.ora' nomount;

   2.  alter database mount standby database;

3. Delete old spfile and Create new spfile from pfile.
4. alter system reset log_archive_dest sid='stprd';
5. alter system set log_archive_dest='';
6. alter system set log_archive_dest_1='location=C:\oracle\PRD\oraarch\PRDarch' scope=both;
7. alter system set standby_file_management='AUTO' scope=both;
8. alter system set log_archive_dest_2='SERVICE=prd' scope=both;
9. alter system set log_archive_dest_state_1='ENABLE'SCOPE=BOTH;
10. alter system set log_archive_dest_state_2 = ‘defer’ scope=both;

If you have anymore question please ask me.I will help you.

Thanks

Mahendran