Preliminary Restore Tasks - Intergraph Smart Instrumentation - Administration & Configuration

SmartPlant Instrumentation Configuration and Maintenance Guide

Language
English
Product
Intergraph Smart Instrumentation
Search by Category
Administration & Configuration
Smart Instrumentation Version
2016 SP1 (11.0.1)
  1. Run the SQL Plus utility.

  2. In the Log On dialog box, enter the required values to log on as the System Manager.

  3. In the Oracle SQL Plus window, type and then press Enter after each command:

    SPOOL <result text file full filepath>

    Press Enter.

    Type the following:

    SELECT TABLESPACE_NAME,FILE_NAME,BYTES FROM DBA_DATA_FILES
    ORDER BY TABLESPACE_NAME,FILE_NAME;

    Press Enter.

    Type the following:

    SELECT USERNAME,DEFAULT_TABLESPACE,TEMPORARY_TABLESPACE
    FROM DBA_USERS ORDER BY USERNAME;

    Press Enter.

    Type the following:

    SELECT * FROM DBA_SYS_PRIVS ORDER BY GRANTEE,PRIVILEGE;

    Press Enter.

    Type the following:

    SELECT * FROM V$NLS_PARAMETERS;

    Press Enter.

    Type the following:

    SPOOL OFF

    Press Enter.

  4. On the target server, create a new Oracle instance with a new database. Follow the Installation Guide instructions to create the new instance compatible with . Note that the new database must have the same character set as the source database.

  5. To improve the restore performance, create the Indexes, Data, and Temporary files on different physical disks if possible.

  6. Create table spaces for Admin data, Admin indexes, Admin temporary data, Domain data, Domain indexes, and temporary data for each domain.

    1. In the SQL Plus window, type and then press Enter as follows:

      CREATE SMALLFILE TABLESPACE <tablespace name> DATAFILE '<full path and name of the data file>' SIZE 50M AUTOEXTEND ON;

      CREATE BIGFILE TABLESPACE <tablespace name> DATAFILE '<full path and name of the data file>' SIZE 50M AUTOEXTEND ON;

      CREATE TEMPORARY TABLESPACE <tablespace name> TEMPFILE '<full path and name of the temp data file>' SIZE 50M AUTOEXTEND ON;

    2. Press Enter.

      SHARED Tip The size of the tablespace determines the size of the file:

      • Small file = less than 1GB.

      • Large file = greater than 1GB

  7. Repeat the last two CREATE commands for each required domain (as in the source database).