Restore SmartPlant Foundation databases using Oracle - SmartPlant Foundation - Update 22 - Administration & Configuration

Backing Up and Restoring Databases for SmartPlant Foundation

PPMProduct
SmartPlant Foundation
PPMCategory_custom
Administration & Configuration
SPFVersion_custom
10

If you have your Oracle backups set up to work correctly, then you should be able to recover the data in your databases using the Oracle redo logs. In the event of a database failure, Oracle can redo all changes and take the database data back to the state it was when the last redo record was written.

Make sure that all users are logged out of SmartPlant Foundation and the SmartPlant Foundation Common UI.

On the SmartPlant Foundation server:

  • Stop the SmartPlant Foundation Scheduler.

On the SmartPlant Foundation Oracle server:

  1. Stop and restart the Oracle[SID] service to disconnect all connected users.

    Contact your DBA to disconnect and kill any sessions before restarting the instance.

  2. Open a command prompt and navigate to your backup folder.

  3. At the command prompt, type the following command:

    sqlplus system/system@ORAinstance

  4. At the SQL Plus prompt, run the following statements:

    drop user #DATA_USER# cascade;
    grant connect to #DATA_USER# identified by #DATA_PWD#;

    grant resource to #DATA_USER#;

    alter user #DATA_USER# quota unlimited on #DATA_TS#;

    alter user #DATA_USER# default tablespace #DATA_TS#;

    alter user #DATA_USER# temporary tablespace #DATA_TEMP_TS#;

    grant connect,resource to #DATA_USER#;
    grant unlimited tablespace to #DATA_USER# with admin option;

  5. Run the following statement:

    imp #USER_ID#/#USER_PWD#@#DATASOURCE# fromuser=#FROM_USER# touser=#TO_USER# full=n file='#DUMP_FILE#' log='#DUMP_LOG#' commit=y;

Examine the scripts and batch files in [drive]:\Program Files (x86)\[product folder]\SPFServerManager\DatabaseScripts for more detailed information on the object created by Server Manager.

On the SmartPlant Foundation server:

If you are restoring to a new location, you must install SmartPlant Foundation and perform a restoration procedure. See Restore a SmartPlant Foundation site to a new server for more information.