• Categories
• Copia de seguridad
• Archivo de computadora
• Bases de datos
• Almacenamiento de datos informáticos
• Predeterminado (Informática)

Citation preview

Symphony Plus Training

Chapter 6 Backup & Restore

TABLE OF CONTENTS Chapter 6 Backup & Restore .................................................................................................................................................. 1 6.1 General Information...................................................................................................................................................... 2 6.1.1 Objectives .............................................................................................................................................................. 2 6.1.2 Legend................................................................................................................................................................... 2 6.1.3 Reference Documentation ...................................................................................................................................... 2 6.2 Major Element To be Backup........................................................................................................................................ 3 6.2.1 Folders................................................................................................................................................................... 3 6.2.2 Registries ............................................................................................................................................................... 3 6.3 OFF-LINE BACKUP S+ Backup Restore Tool ............................................................................................................. 4 6.3.1 OPERATIONS HSI SERVER ................................................................................................................................ 4 6.4 ON-LINE BACKUP S+ Backup Restore Tool............................................................................................................. 12 6.4.1 OPERATIONS HSI / HISTORY SERVER .......................................................................................................... 12 6.4.1.1 Ex/Import- and Backup- Manager .................................................................................................................. 12 6.4.1.2 Start the Export ............................................................................................................................................. 15 6.4.1.3 Handling with a Redundant Symphony Plus HistoryServer............................................................................. 15 6.4.1.4 Splus Operations History – DB Limiter .......................................................................................................... 18 6.4.1.5 Import of Signal Values ................................................................................................................................. 19 6.4.1.6 Operation ...................................................................................................................................................... 21 6.4.1.7 Reset of export function and change of export disk names .............................................................................. 24 6.4.1.8 Ini-File .......................................................................................................................................................... 24 6.4.1.9 Backup .......................................................................................................................................................... 25 6.4.1.10 Call of the Backup Configuration ................................................................................................................. 26

Chapter 6 - 1

S322-06 S+ Operations - Advanced Configuration - Backup & Restore RevB.doc

6.1 General Information 6.1.1 Objectives On completion of this chapter you will be able to: ·

Know and use the backup and restore tool for S+ Operations HSI Server

·

Know and use the backup and restore tool for S+ Operations HISTORY Server

6.1.2 Legend >

Indicates when you go from one menu to a sub-menu

Italic

Indicates object and file names

“ “

Indicates dialog box buttons, tabs, menus etc.

Bold

Indicates important topics Indicates start/explanation of student activity

6.1.3 Reference Documentation

Chapter 6 - 2

2VAA003351

Symphony Plus 2.0 Release Notes

2VAA001148E

Operation System 2.0 Configuration Guide

2VAA0001151E

History User Guide

Symphony Plus Training

6.2 Major Element To be Backup 6.2.1 Folders o

GRAPHICS

·

…\ProgramData\ABB Symphony Plus\Operations\SV1.0\Display

·

....\Program Files (x86)\ABB Symphony Plus\Operations\Display

o

COMPOSER OPERATIONS

·

..\Program Files (x86)\ABB Symphony Plus\Engineering\Composer Operations

·

..\ProgramData\ABB Symphony Plus\Engineering\Composer Operations\SV1.0\SystemModel

o

OPERATIONS HSI SERVER

·

…\ProgramData\ABB Symphony Plus\Operations\SV1.0\Config\

·

....\Program Files (x86)\ABB Symphony Plus\Operations\Deck\

o

OPERATIONS HISTORY SERVER

·

…\HistData\RAW

·

....\HistData\Events

o

OPERATIONS HSI / HISTORY CLIENT Not need special Backup Configuration all the data are stored in the Operations HSI Server

6.2.2 Registries o

COMPOSER OPERATIONS

·

..\Program Files (x86)\ABB Symphony Plus\Engineering\Composer Operations

o

OPERATIONS HSI SERVER

·

…\ProgramData\ABB Symphony Plus\Operations\SV1.0\Config

o

OPERATIONS HISTORY SERVER

·

…\ProgramData\ABB Symphony Plus\Operations\SV1.0\Config

Chapter 6 - 3

S322-06 S+ Operations - Advanced Configuration - Backup & Restore RevB.doc

6.3 OFF-LINE BACKUP S+ Backup Restore Tool From Syssetup Tools it’s possible to open a Save Configuration Tool

6.3.1 OPERATIONS HSI SERVER With this tool is possible to Backup S+ Operations HSI (Registry & Folder). o

Chapter 6 - 4

It’s Possible to backup All the registry.

Symphony Plus Training

o

It’s possible to backup different database

o

It’s also possible to backup display

Chapter 6 - 5

S322-06 S+ Operations - Advanced Configuration - Backup & Restore RevB.doc

NOTE: is not possible to make backup while the system is running.

The backup files are stored on the folder: “….\ProgramData\ABB Symphony Plus\Operations\SV1.0\config\Backup”

Chapter 6 - 6

Symphony Plus Training

The files are stored with the name: “ComputerName_Data”

Chapter 6 - 7

S322-06 S+ Operations - Advanced Configuration - Backup & Restore RevB.doc

After backup is done is possible to look on the Tab Restore to list all the Backup files already created.

Chapter 6 - 8

Symphony Plus Training

It’s also possible to change the name of the *.scb file already created directly from the folder

Chapter 6 - 9

S322-06 S+ Operations - Advanced Configuration - Backup & Restore RevB.doc

Chapter 6 - 10

Symphony Plus Training

Just click to the files that you want to restore and after click restore:

So this is the way to make OFF-LINE backup for S+ Operations HSI Database and Registry

Chapter 6 - 11

S322-06 S+ Operations - Advanced Configuration - Backup & Restore RevB.doc

6.4 ON-LINE BACKUP S+ Backup Restore Tool 6.4.1 OPERATIONS HSI / HISTORY SERVER 6.4.1.1 Ex/Import- and Backup- Manager The program ExImNew.exe saves the archived data stored in the Symphony Plus History database. It can either be used for backup purposes, or for moving the data to an external media. This program could be used to delete the oldest data on the hard disk. Normally a magnetic-optical drive is used for data storage. The drive may be included in the Symphony Plus History server PC, connected as external device or as a network connection. After starting the Symphony Plus History ExImport the main window appears.

Note: To configure the program, the Symphony Plus History ExImport automatic process must be stopped. After the configuration work is finished, the export automatic process should be started again. Configuration of the Signal Export The export programming uses export classes. Each signal is assigned to these export classes. Configure Export-Classes

Chapter 6 - 12

Symphony Plus Training

The ExImport program allows the definition of the export classes related to a Symphony Plus History server. Each export class is identified by a name (for example "Move1Year"). Each class must have the following information:

Name of the export class:Default (for example) Mode: COPY – Leaves the current Historical data on the Historian MOVE – Moves the date from the Historian to the Archive DELETE – Deletes the current History and does not archive Delay [days]:

for example 2

Path to archive files:

for example: "F:\REO1" for the external drive

Max. size of archive files [MB]: defines the desired maximum size of the export media. This value can be used as a limit for network drives in order to avoid disk space overruns. Event Export: Export events out of the event database to an external drive. The export the events can be the same export path as the Symphony Plus History data. The export class "Default" is always available after installation of the Symphony Plus History ExImport with the defined with following parameters; Name of the export class = Mode =

Default

COPY

Delay [days] =

2

Path to archive files =

C:\REO1

Max. size of archive files [MB] =

-1

Event Export = Note: The value "-1" for the parameter MaxMB indicates that the complete medium will be used. Selecting the menu item "Configure Export Classes" opens the configuration dialog box. Right-mouse click to modify the lines in the table (Insert, Delete, and Move).

Chapter 6 - 13

S322-06 S+ Operations - Advanced Configuration - Backup & Restore RevB.doc

The "Mode" must be selected from a pull-down-menu. Double-clicking into the field "Export folder" opens a folder tree, from which the desired folder can be selected. Assign Signals to Export classes The assignment of signals to export classes is configured using the SignalExplorer. The signals must be selected and then the dialog box "properties" must be opened. In the tab "Database", double-click the field "Export classes" to open a list of the existing export classes. Select the signals to be assigned. Multiple selection of several export classes (for example [Signals_Unit_1] [Default]) is also possible.

If new signals are created in the database, these signals are automatically assigned to the default export class. The default export class is defined under Extras->Options in the SignalExplorer.

Chapter 6 - 14

Symphony Plus Training

6.4.1.2 Start the Export Click the "Start Archive Management" button to start Symphony Plus History ExImport program. If an export class is processed for the first time the following dialog box appears:

After setting the desired start time for the export class, and clicking "OK", the Symphony Plus History ExImport is ready to execute the defined archive jobs at the time specified in the initialization file. Note: The first start date of an export class can be specified only once. Later changes are not possible.

6.4.1.3 Handling with a Redundant Symphony Plus HistoryServer In the case of a redundant Symphony Plus History server, two types of installations are possible. 1. ExImport as a redundant application on the redundant Symphony Plus History servers 2. ExImport installed on one Symphony Plus History Client Redundant ExImport with a red. Symphony Plus History server The ExImport software can be installed as a redundant application. For example: On each of the redundant Symphony Plus History servers the ExImport software is installed. Both installations work with the same Symphony Plus History server/database.

Chapter 6 - 15

S322-06 S+ Operations - Advanced Configuration - Backup & Restore RevB.doc

The following menu can be opened in the System settings.

Put in the Symphony Plus History server database names of both servers, and then set the path names for both databases. The "Redundancy settings" tab shows the adjustments necessary for the redundant installation.

Put a unique identifier name in the field redundancy name. For example, ExImporter1 is the name of one installation and ExImporter2 is the name of the second installation. The inspection interval sets how often the redundancy status will be checked. Select Active to set the redundant mode

Chapter 6 - 16

Symphony Plus Training

SQL Server 1 : name of the ODBC connection to the first Symphony Plus History event database SQL Server 2 : name of the ODBC connection to the second Symphony Plus History event database Database : name of the Symphony Plus History events database User

: username of the Symphony Plus History events database

Password : password of the Symphony Plus History events database

1. Import path : first import path ( normally : ..\ HISTORY\PlantConnect.SYS\Events ) 2. Import path : second import path ( If more than one event database exists )

Chapter 6 - 17

S322-06 S+ Operations - Advanced Configuration - Backup & Restore RevB.doc

6.4.1.4 Splus Operations History – DB Limiter The SPlus DB Limiter which is located on the system where the Splus EventImporter is running controls the maintenance of the event database. Live time of Event Data The live time of the event messages can be configured in several ways: o

Time based ring buffer

o

Database sized ring buffer

To modify, enable or disable the configuration, the SPlus DB Limiter service must be stopped. The configuration file for the SPlus DB Limiter can be found under: ..PlantConnect.BIN\Events\Importer\PlaCoImport.ini ExImport with red. Symphony Plus History Server For a single installation of the ExImport, typically on a Symphony Plus History Client or Application Server, both Symphony Plus History servers must be accessible. Open the System settings menu.

Enter the Symphony Plus History server database names of both servers, and then set the path for both databases. The "Redundancy settings" tab shows the adjustments necessary for the installation.

Chapter 6 - 18

Symphony Plus Training

The number in inspection interval is not used in a single installation. Do not select Active to set the redundant mode. The ExImport should works without a redundant node.

6.4.1.5 Import of Signal Values The import of the exported values must be executed on the computer where the export program is installed. In order to import the exported values the dialog box must be opened in Tools->Re-import of signal-values. This dialog box shows the existing export classes. Select the desired signals to be imported in the SignalExplorer, and then move the signals to the desired export class. The desired import interval must also be specified.

The configuration can be identified in a signal list as follows:

Chapter 6 - 19

S322-06 S+ Operations - Advanced Configuration - Backup & Restore RevB.doc

Open the signal list by clicking the desired Export class within the import window. Drag signals to the list using the SignalExplorer Click OK to close the list

Remove all imported signal values from the database Imported values can be removed from the database by selecting Import->Remove imported signal-values. A confirmation to delete the imported values is required. Import of events The re-import of events is executed via the menu Import > Re Import events. Specify the start and end of the import interval in the input mask. The only events that should be re-imported are those events that are not accessing the database directly. When re-importing existing events, the events will appear twice in the database. The events are re-imported via the Symphony Plus History EventImport into the event database. The following entry must be inserted in the INI file of the Symphony Plus History EventImport (PlaCoImport.ini, refer to the Event Management documentation): In this example only an exchange file is available. [Exchangefile 2] Filename = C:\Program Files\ABB Symphony Plus\Operations\History\PlantConnect.SYS\Events\EM_*.txt Name = PlaCo ExImport The entry of the exchange file is defined in the same manner as the event management

Chapter 6 - 20

Symphony Plus Training

import. The difference is that the name used under Filename is definitely preset with EM_*.txt. The entry under Name= is used for information only, and has no effect on the events. In the channel name, the imported events are provided with the addition . When selecting the media required for import, the user is guided by the ExImport program. Open documentation file The Symphony Plus History User Manual including the description of the Symphony Plus History ExImport can be opened by selecting the Open documentation file command. Show information window Select Info to display the current version of the program is shown in the information window. System events During the export process, events are displayed on the screen. The information always points to the measures necessary at the time. Legend and exchange of export are both controlled via the note windows.

6.4.1.6 Operation Storing data continuously on external media The backup program is normally set so that data is stored cyclically every night. The program must be set to execute continuously. Normally the program starts automatically when the computer is started. The start of the program can be checked by clicking the icon (small moon) in the right lower corner of the screen in the task bar.

The only action that usually must be executed during the backup program operation is to exchange the magnetic -optical disks when they become filled with data. Check of the data storage Data storage can be checked either in the main window of the ExImport program or in the log file. The main window of the program ExImport can be switched to the foreground by clicking the (small moon) icon in the right lower corner of the screen in the task bar. All messages that appear in the main window of the program are also stored in the log file ExImNew.log in the folder: ..\PlantConnect.SYS\Debug\ExIm. The example below shows an extract from the ExImport program log file.

Chapter 6 - 21

S322-06 S+ Operations - Advanced Configuration - Backup & Restore RevB.doc

20.11.00 08:28:04> 20.11.00 08:28:04> ===== Start Program ExIm.EXE ===== 20.11.00 08:28:04> reading settings from file ExIm.INI ... 20.11.00 08:28:04> reading of settings finished. 20.11.00 08:28:04> Check Server ... 20.11.00 08:28:04> database server deutaminw1035 has 1131 KKS, 9 of them without any Export-Class. 20.11.00 08:28:04> Check Server finished successfully. 20.11.00 08:28:04> archive-manager started ... 20.11.00 08:28:04> Within 10 sec the first archiving will be started. 20.11.00 08:28:05> archive-manager stopped ... 20.11.00 08:28:05> 20.11.00 08:28:05> SPlus Operations History User Guide ADDITIONAL APPLICATIONS 212 2VAA0001151C 20.11.00 08:28:06> archive-manager started ... 20.11.00 08:28:08> do Today's Export Jobs ... 20.11.00 08:28:08> 20.11.00 08:28:08> reading Export-Class definitions from server ... 20.11.00 08:28:08> reading successfully finished. 20.11.00 08:28:14> Export-Class [default]:=== The first time signals found. === 20.11.00 08:28:14> Export-Class [default]:> start-time of export will be determined automatically ... 20.11.00 08:28:19> 20.11.00 08:28:19> Event-Message: Export aborted. Reason: :Interrupt (Cancel) by Operator ! : 20.11.00 08:28:20> finishing program ... waiting ... 20.11.00 08:28:20> Stopping Export-Automatic ... 20.11.00 08:28:20> archive-manager stopped ... Exchange the export disk If the export disk inserted into the disk drive has reached its maximum storage capacity, the user is requested to exchange the disk. This program offers complete guidance to the user in order to let him execute the necessary actions. The full disk can be removed from the drive by right-clicking the drive in Windows Explorer, and then selecting "Eject". Insert a new disk prepared for the data storage into the drive will be requested.

Chapter 6 - 22

Symphony Plus Training

Click the "Continue" button to restart the procedure. The progress can be seen in the main window of the program. Finally the program should be set to run in the background again. Restore archived signal data that is needed for examination can be restored from the archives. The action for the PlantConnect values is nearly the same as for the events. In order to be able to restore data: The main window of the program must be switched to the foreground. The automatic execution of the export task must be stopped by clicking the "Stop archive Management" button. Select "Tools->Re-Import of signal-values" Selected the signals from the SignalExplorer, and then move them to the Export class using drag-and-drop operations. The program requests the user to insert the volume into the export disk drive. The volume must be inserted into the drive. Click the "Continue" button to start the import process. This procedure may be repeated several times, depending on the data to be restored. When all the selected data has been restored to the hard disk a message appears. To import events, you must set only the time scale for the events you need. After the start of the program you must insert the disks needed. Delete restored values Data that has been restored can be removed again from the hard disk by using the "Import->Remove imported signal-values" command. Before deleting restored values, you must stop the automatic execution of the export task by pressing the "Stop archive Management" button. After the restored data has been deleted the automatic execution of the export tasks must be started again. Note: Please remove the restored data from the hard disk as soon as the data is not needed to ensure current historical data space requirements. Restored data is not removed automatically by the ExImport program.

Chapter 6 - 23

S322-06 S+ Operations - Advanced Configuration - Backup & Restore RevB.doc

Deletion of reloaded events Imported events are automatically deleted via the ring buffer function in the event database. The event database, which is based on an SQL server, activates a delete function once a day. Imported events can be removed from the database by selecting Import->Removeimported events. Before the imported events are deleted a dialog box appears an asked for the time range

Note: Reloaded (imported) events are available for processing up to the next execution of the "Delete Old Rows" task. For the import of events, sufficient storage space must be available in the event database. The storage space currently available in the event database can be determined using the event import commands (Refer to the documentation for Event Management).

6.4.1.7 Reset of export function and change of export disk names If the export disk is defective it may be necessary to set the export time to an earlier date. Select "Configure Export Classes", and then choose the class you want to change. Right-click, and the select "disk history". Select the disk you want to change. Set to the date you want to start the export again. If the configuration of existing disks is lost, the names of these disks can be set in the same dialog.

6.4.1.8 Ini-File The Ini file ...\PlantConnect.BIN\ExIm\ExImport.ini includes the settings for ExImport. [Export] SingleOpDelayMilliSec=100 EventServer=

Waiting time between two signal actions

Event server name, if it exists

EventMsgRepeatAfterMinutes=60 Retry of event messages to the EventServer

Chapter 6 - 24

Symphony Plus Training

DailyExportStart=04:00 DebugLevel=0

Daily start time of ExImport

Log-Level:

0 = low level 5 = high level (Default value is 0) [ShellProgram] ProgName=

automatic start of a program in case of less capacity of the export disk Name of the program you want to start

ProgPath=

Path to the program you want to start

ProgParameter=

parameter for the program you want to start

[ServerDataRoots] DEUTAMINW1035=f:\ROH\

folder of Symphony Plus History archive data

[ReduSettings] Name=Lokal Active=1

Explicit name for the ExImport Installation 1 = Application-Redundancy active, 0 = Appl.-Redundancy not active

RCheck=3

Time in Minutes for the check, which installation is active

[EMSettings] The following settings are necessary to access an Event Management Database (SQL-Server) DSN=PlaCoEvents Database=PlaCoEvents User=conmea pwd=placo [SQLTasks] WaitForExcecuteInSeconds=2000 Time until SQL-Server command is done (Time out)

6.4.1.9 Backup The Symphony Plus History backup tool is integrated into Symphony Plus History ExImport. Any folder information can be saved. By default, the folders are saved: ..\PlantConnect.ROH\*.bin ..\PlantConnect.BIN\*.* ..\PlantConnect.SYS\*.* ..\PlantConnect\*.* They are copied at the first start of the program to the backup folder : ..\PlantConnect.Backup\ A timed backup can be performed on a drive or, by the assignment of an export class, on

Chapter 6 - 25

S322-06 S+ Operations - Advanced Configuration - Backup & Restore RevB.doc

any accessible medium. The smallest interval is 1 day; the largest interval is 365 days.

6.4.1.10 Call of the Backup Configuration Select Settings -> Configure Backup in Symphony Plus History ExImport to open the configuration dialog for backups. The configuration can only be opened after the archive management process has been stopped.

The upper check box enables or disables the backup. Use Settings to define whether A timed backup will be performed. The backup will be saved cyclically on an export medium. Use Timingsettings to define the time and cycle time for the backup Click ―Save now" to execute the backup immediately. Use Entries to define the folders to be saved. Disabled entries will not be included in the backup. Add/Delete entries Click the "New entry" button to add another folder to the backup.

Chapter 6 - 26

Symphony Plus Training

Right-click an entry to delete the entry from the list. Start Backup Click the "Enable backup" button to start the backup.

Chapter 6 - 27