Allows you to select the type of plant restoration and to browse to the plant structure backup file you want to import.
Plant structure restoration types
Allows you to select the type of plant structure you want to restore.
Non-Workshare plant structure
Allows you to select a plant structure backup file ending in *_p.zip.
Host plant structure
Allows you to select a host backup file ending in *_m.zip. When restoring host plant structure schemas, all the proxy user objects for the plant structure will be restored. Existing proxy user tables and views will be dropped and restored from the Oracle export data. This is true for both remote and same-instance satellite proxy users.
Satellite plant structure
Allows you to select a satellite backup file ending in *_w.zip. Because the backups for remote satellite plant structures do not include the proxy user objects in the Oracle export data, the proxy user objects must be restored by the host plant structure. When restoring same-instance satellite plant structures, the proxy user objects can be restored by either the satellite restoration or by the host plant structure restoration because the proxy user objects were included in the backup file.
Plant and projects
Allows you to select a plant backup file ending in *_a.zip.
Import file
Browse to the plant structure backup file you want to import. This field is limited to 255 characters.
The backup file type must match the restoration type selected above and for SQL Server,
the file path must be in UNC format.
Oracle alias
Type the Oracle alias for the database the plant structure will be imported into. This option appears only if the site is using Oracle.
SQL Server host
Type the SQL Server host name for the database the plant structure will be imported into. This option appears only if the site is using SQL Server. If you leave the Oracle alias or SQL Server host boxes empty when you browse to the Import file, the software will display the value stored in the plant backup file. However, if you are restoring the plant to a different site server, you must type the Oracle alias or SQL Server host name for the database on the computer to which you are restoring the plant.
System user
Type a database system user name. This name does not have to be the database administrator user name, but this user must be granted minimum DBA privileges to be able to perform Smart Engineering Manager procedures.
System password
Type the database system password. Oracle system passwords cannot contain any special characters other than: @ ('at' symbol), . (period), and _ (underscore). SQL Server database passwords cannot contain the character: '.
-
After you complete this page and select Next, the wizard obtains the database user names from the backup file and determines if they are existing users. If a database user exists, you must delete the plant structure schema, plant structure Data Dictionary schema, and associated application schemas manually.
-
On an Oracle platform, if the specified system user does not have privileges for performing this action, on selecting Next, an additional dialog opens on which you need to enter the system user and password details for a user who does have these privileges. The information entered on this dialog is used only to allow the restore process to complete successfully; it is not retained in the database. See Create Oracle Admin Users with Limited Privileges.
-
On a SQL Server platform, if the specified system user does not have privileges for performing this action, the System Administrator can grant backup and restore privileges to a general admin user. See Create SQL Server Admin Users with Limited Privileges.
-
The Oracle instance on the computer to which you are restoring the plant must contain matching tablespace names for all of the schema users included in the import file. If any of the permanent or temporary tablespace names in the import file do not exist in this Oracle instance, you must create the correct tablespace types and names before continuing the plant restoration.
-
On an Oracle platform using different instances, when exiting this Wizard page, you might receive a message about having insufficient privileges to create the plant structure, followed by a list of the required privileges. To fix this problem, you must create one or more of these privileges manually using Oracle tools.