Restoring the data

Restoring the database

Note: Start the database backup restoration only for the local host!

If your database has become damaged, you can save your data by re-importing the backups. The following procedure restores the database:

  1. Check, if the project is stopped.
  2. Delete the damaged database (the winccoa folder in the db directory shall be deleted or renamed).
  3. Start a UI in the console without a connection to the Data or Event manager and open the restore panel with:

WCCOAui -n -p vision/restore.pnl

Figure: Panel for Restoring the Data

  1. Specify the directory where your backup is located, e.g. C:\Temp.
  2. Select your used medium, e.g. HD/MO/JAZ.
  3. Click Start restore.

The data of your database backup (the database) will be restored to your project. You can now start the project in the usual way.

Note:

Under Windows the directory C:\temp must exist, regardless in which directory the backup is located. If the C:\temp doesn't exist, the info-line displays the message "Error while opening destination file".

In this case, just create the folder "temp" under C:\ and click on "Start restore" again.

Under Linux, you may encounter the following error messages in the PVSS_II.log file:

  1. WCCILdata (1), 2003.02.21 14:34:39.766,IMPL ,SEVERE , 54, "Unexpected state", DataManDpIntern::refreshDiskStatus Cannot stat /tmp/prototype_1_db_backup/ WCCILdata (1),

  2. 2003.02.21 14:34:39.785,IMPL ,SEVERE , 54, "Unexpected state", DataManDpIntern::refreshDiskStatus Cannot stat /local/prototype_1/v1.01/db WCCILdatabg (1),

  3. 2003.02.21 14:35:52.237,IMPL ,SEVERE , 54, "Unexpected state", DataManDpIntern::refreshSaveDirList Fehler beim lesen der Verzeichnissen! WCCILdatabg (1),

  4. 2003.02.21 14:35:52.237,IMPL ,SEVERE , 54, "Unexpected state", DataManDpIntern::refreshAlertSaveDirList Fehler beim lesen der Verzeichnisse!

Errors 1 and 2, although labelled "severe" are a known problem that you can safely ignore.

Errors 3 and 4 are also known problems and will disappear if you create two directories /db/wincc_oa_path/save and /db/wincc_oa_path/alsave.

When using the local identification caching ([data] useLocalIdentification = 1) the local data point ID caches inside of your projects /data folder must be removed before restarting the project.

Restoring the project

The following procedure restores the backup of your project:

  1. First, check that your existing project is not running.
  2. Replace the files of your project with the files from your backup (simply "copy" and "replace").
  3. Start your project.
  4. Import the ASCII-Files of your backup using the ASCII Manager.

The data of your project backup is restored.