Pages

Helpful Links

Saturday, October 29, 2011

Oracle BPM: Disaster Recovery (Using DATABASE)

Last Post was about back ups, now i will show you how to perform disaster recovery using it.

Recovery using Database:


Follow the following steps if you want to change the database or if the database crashes and you want to start the BPM in a different database.

1.       Make new schemas of the same names as in the previous database. From your exported database of BPM users use them to recover it in a new location

d
2.       Import the schema users into the new (empty) schema that has been taken as backup, using the following script
<Your Location>D:\oracle\product\10.2.0\db_1\BIN\imp userid=system/<password> file=D:\Backup\<Restore_File_Name.dmp> SHOW=n IGNORE=n CONSTRAINTS=y FROMUSER=(ENGINE,BAM,DM,DIR,ARCHIVE,EXTDB) TOUSER=( ENGINE,BAM,DIR,DM,ARCHIVE,EXTDB) log=D:\Backup\ Restore_File_Name.log

 
Follow the steps below:
 1.       Make sure to check the log that all the tables of all the schemas have been imported and no errors have been found. 
2.       Install the BPM Enterprise server on the machine, if it doesn’t already exist. 
3.       In the Admin Centre of the Enterprise go to configuration (do not start it). In the Configuration option press add button. 
4.       A new window opens up. Check the Use existing Directory Service radio button. Uncheck the Create Process Engine checkbox. 

5.       Press next. Select Use a database managed by Oracle BPM 

6.       Press next. Enter the directory Configuration name, its description, Directory provider, BPM Admin user and pass. 

7.       Press next. Enter the host database (IP address or its name).Port by default is 1521 for Directory provider: Oracle BPM Driver version 10,11. Enter user, pass and SID for the username you gave to your schemas. 

8.       This username and pass should be the BPM directory database (DIR). 
9.       Press next. Save template. Finish 
10.   Close the window. 
11.   Press Start BPM WEB Application from the admin center. 
12.   When it is started. Launch Process Administrator. Check engines, projects, OU, BAM, External Resources, Variable, and External Processes all are working fine. 
13.   Launch Workspace in the Admin center. If it does not open then go to Process Administrator -> Engines-> Select your Engine -> networking tab -> Workspace URL. Change this workspace URL to the current machine or the URL that is required.
14.  Change the logs locations as required


Posted by at
Labels:

7 comments:

  1. SandraNovember 18, 2011 at 12:36 AM

    I read this blog and it is the good and step by step information about the use of Database. I am always looking out to BPM

    ReplyDelete
  2. Haris KamalNovember 18, 2011 at 3:05 AM

    This comment has been removed by the author.

    ReplyDelete
  3. Haris KamalNovember 18, 2011 at 3:05 AM

    Thanks Sandra

    ReplyDelete
  4. KalpeshDecember 12, 2011 at 4:11 AM

    This article is amazing as it helps me to get the sort of information that i needed. I am thankful as i got your article when was searching BPM

    ReplyDelete
  5. Business continuity planningJuly 16, 2012 at 2:42 AM

    good advices and really helped me

    ReplyDelete
  6. kamOctober 2, 2012 at 7:44 AM

    Hi Haris,

    Thanks for your article, it helps to us because there is not a lot of information about this topic.

    However, there are some ideas that are no clear for me. In my case, I trying to migrate an existing Oracle BPM enviroment installed in one server to another server (inlcuding the databases: Directory Service and Engine). I face this with two approachs:

    1. Installing Oracle BPM Entreprise and Weblogic in the new server, and restoring the databases (Directory Service and Engine). After configuring the OBPM from existing Directory Service, but in this point I don't know how to restore de Weblogic configuration and engine with publishing my projects and load properly the BPM instances.

    2. The second approach consists in installing all in a new server from scratch; and after this, export the organization and import in the new one. After publish my Obpm projects for finally export and import the instances with ant tasks. But in this case, before proceed with the export/import of instances, I tried to test the basic funcionality of my Obmp projects, but have a problems with my custom JSP's because seemingly the JSP can't access the BPM Objects, throwing an exception because the object is null or no BPMObject, but it's works fine in the source environment.

    What is the best way to accomplish this?, please can you give me some advice?

    Thanks for your comments, I really appreciate your help.

    ReplyDelete
  7. UnknownMarch 15, 2013 at 7:42 AM

    I've been researching a few different disaster recovery services and came across your post. This was very informative, thanks!

    ReplyDelete

Subscribe to: Post Comments (Atom)