PRM Backup Restore
Content
10 Backup/Restore
10.1 PRM Simple Backup tool
The PRM database and the Historian database is backed up/restored using the PRM Simple
Backup Tool.
¾
Backup
When backing up the databases using the PRM Simple Backup Tool, the following two files in
the “(PRM installation folder)/TOOL” folder are used.
z
PRMBackup.bat: Backup command file
z
PRMBackup.par: Backup parameter file
Procedure
1. Confirm that SQL Server is running.
2. Check if the drive in which PRM is installed has enough free disk space. At least several
hundred megabytes will be needed to back up the databases. By default, backup files will be
- 114 -
created in the PRM installation directory. If the PRM installation directory does not have
enough free disk space, change the backup file path or log file path specified in the backup
parameter file.
3. Run “(PRM installation folder)¥Tool¥PRMBackup.bat”. The backup program will run and
backup files will be created in accordance with the specifications in the backup parameter
file.
Default settings in the backup parameter file are shown below.
¾
Restore
When restoring the databases using the PRM Simple Backup Tool, the following two files in the
“(PRM installation folder)/TOOL” folder are used.
z
PRMRestore.bat: Restore command file
z
PRMRestore.par: Restore parameter file
- 115 -
Procedure
1. Log on to the OS as a user with the Administrator privilege.
2. Close PRM Client.
3. Confirm that backup files are saved to the path specified in the restore parameter file.
4. Run “(PRM installation folder)¥Tool¥PRMRestore.bat”.
5. Restart the PC.
Default settings in the restore parameter file are shown below.
10.2 PRM System Backup script
The PRM System Backup Script (PRMSAVE.bat) provides a tool for saving/restoring the
conditions of the PRM system. Use this tool when replacing the PC in which PRM is installed,
or reinstalling the OS.
The PRM system components to be saved/ restored are as follows.
z
PRM database
z
Historian database
z
Parameter file of the PRM Simple Backup Tool
- 116 -
z
Device template files
z
Master data export files
z
Device Viewer configuration files
z
Device path configuration files
z
Files managed by PLUG-IN applications
z
Files managed by advanced diagnostic applications
An overview of steps to operate the PRM System Backup Script is shown below.
1.
Open (PRM installation folder)¥TOOL¥PRMSAVE.bat, and modify the customizable items
in accordance with the installation condition of the PC where PRMSAVE.bat will be run.
2.
Run (PRM installation folder)¥TOOL¥PRMSAVE.bat. Among the customizable items, you
will find the setting for specifying the output drive. A folder of the same name as the
computer will be created directly below the specified drive, and backup files will be created
in this folder.
3.
On the PC where the system is to be restored, create a folder configuration of the same
structure as those effective when the system was backed up.
4.
On the PC where you restore the backed-up data, double-click “Computer name.reg.”
Registry information will be restored.
5.
On that same PC, double-click the backed-up “Computer name.exe”. Other files will be
restored.
6.
To restore the database, double-click “PRMRestore.bat” at (PRM installation
folder)¥TOOL on the PC where the database is to be restored.
The following table explains folders and files when PRMSAVE.bat is executed
- 117 -
EXERCISE: Backup the PRM database and restore the backup database as per the instructions
shown above.
- 118 -
11 Database maintenance tool
The quantity increment of the messages stored in the PRM server and the diagnostic results
stored in the diagnosis historian server may degrade the performance for displaying or searching
the messages. Using the Database maintenance Tools we can optimize the PRM database and
improve the performance.
The package of Database Maintenance Tools consists of the tools for database archiving,
retrieving and cleaning up as well as the tool of Tag Editor.
Archive
Archives the data in the PRM database into an archive file, and remove
the Archived data from the PRM database.
Retrieve
Retrieves the data from an archive .le to the PRM database.
Unretrieve
Undo previous retrieve so as to remove the retrieved data from the PRM
database.
Delete
¾
Deletes the data from the PRM database instead of achieving the data.
Auto Archive/ Delete
The Auto Archive Function helps to automatically Archive the Maintenance info.
The
engineers can Auto Archive the data reducing the load on the PRM, thereby improving the
performance of the system. Maintenance engineer can either Auto Archive the Data or Auto
delete the data.
¾
Cleanup
When devices are removed from the PRM database, the related data such as the operations
- 119 -
records regarding the devices will become obsolete, therefore, cleanup of the PRM database
may be required. However, cleanup can only be performed on PRM database, not on Historian
database.
¾
Tag Editor
When devices are removed, the Tag Editor can be used to remove the obsolete data related to
the deleted devices in the Historian database. The Tag Editor can only be used for editing the
tags in the Historian database.
Exercise: Auto Archiving Function
1. Open the Database maintenance tool
2. Set the destination for the Archive files, set the periodic Archive and enable the Auto Data
processing. Select the Auto Archive Radio button and enter the retention period time.
- 120 -
Exercise: Archiving Manually
1. Open the Database maintenance tool
- 121 -
2. Set the destination for the Archive files in the window
3. Select a ready to archive file and Press the Archive button.
- 122 -
FIELDBUS ENGINEERING
o FIELDBUS OVERVIEW
o FIELDBUS TECHNOLOGY OF YOKOGAWA
o PRM OVERVIEW
o PRM TECHNOLOGY
o PRM INSTRUCTION MANUAL – 01
o PRM INSTRUCTION MANUAL – 02
o PRM INSTRUCTION MANUAL - 03
10.1 PRM Simple Backup tool
The PRM database and the Historian database is backed up/restored using the PRM Simple
Backup Tool.
¾
Backup
When backing up the databases using the PRM Simple Backup Tool, the following two files in
the “(PRM installation folder)/TOOL” folder are used.
z
PRMBackup.bat: Backup command file
z
PRMBackup.par: Backup parameter file
Procedure
1. Confirm that SQL Server is running.
2. Check if the drive in which PRM is installed has enough free disk space. At least several
hundred megabytes will be needed to back up the databases. By default, backup files will be
- 114 -
created in the PRM installation directory. If the PRM installation directory does not have
enough free disk space, change the backup file path or log file path specified in the backup
parameter file.
3. Run “(PRM installation folder)¥Tool¥PRMBackup.bat”. The backup program will run and
backup files will be created in accordance with the specifications in the backup parameter
file.
Default settings in the backup parameter file are shown below.
¾
Restore
When restoring the databases using the PRM Simple Backup Tool, the following two files in the
“(PRM installation folder)/TOOL” folder are used.
z
PRMRestore.bat: Restore command file
z
PRMRestore.par: Restore parameter file
- 115 -
Procedure
1. Log on to the OS as a user with the Administrator privilege.
2. Close PRM Client.
3. Confirm that backup files are saved to the path specified in the restore parameter file.
4. Run “(PRM installation folder)¥Tool¥PRMRestore.bat”.
5. Restart the PC.
Default settings in the restore parameter file are shown below.
10.2 PRM System Backup script
The PRM System Backup Script (PRMSAVE.bat) provides a tool for saving/restoring the
conditions of the PRM system. Use this tool when replacing the PC in which PRM is installed,
or reinstalling the OS.
The PRM system components to be saved/ restored are as follows.
z
PRM database
z
Historian database
z
Parameter file of the PRM Simple Backup Tool
- 116 -
z
Device template files
z
Master data export files
z
Device Viewer configuration files
z
Device path configuration files
z
Files managed by PLUG-IN applications
z
Files managed by advanced diagnostic applications
An overview of steps to operate the PRM System Backup Script is shown below.
1.
Open (PRM installation folder)¥TOOL¥PRMSAVE.bat, and modify the customizable items
in accordance with the installation condition of the PC where PRMSAVE.bat will be run.
2.
Run (PRM installation folder)¥TOOL¥PRMSAVE.bat. Among the customizable items, you
will find the setting for specifying the output drive. A folder of the same name as the
computer will be created directly below the specified drive, and backup files will be created
in this folder.
3.
On the PC where the system is to be restored, create a folder configuration of the same
structure as those effective when the system was backed up.
4.
On the PC where you restore the backed-up data, double-click “Computer name.reg.”
Registry information will be restored.
5.
On that same PC, double-click the backed-up “Computer name.exe”. Other files will be
restored.
6.
To restore the database, double-click “PRMRestore.bat” at (PRM installation
folder)¥TOOL on the PC where the database is to be restored.
The following table explains folders and files when PRMSAVE.bat is executed
- 117 -
EXERCISE: Backup the PRM database and restore the backup database as per the instructions
shown above.
- 118 -
11 Database maintenance tool
The quantity increment of the messages stored in the PRM server and the diagnostic results
stored in the diagnosis historian server may degrade the performance for displaying or searching
the messages. Using the Database maintenance Tools we can optimize the PRM database and
improve the performance.
The package of Database Maintenance Tools consists of the tools for database archiving,
retrieving and cleaning up as well as the tool of Tag Editor.
Archive
Archives the data in the PRM database into an archive file, and remove
the Archived data from the PRM database.
Retrieve
Retrieves the data from an archive .le to the PRM database.
Unretrieve
Undo previous retrieve so as to remove the retrieved data from the PRM
database.
Delete
¾
Deletes the data from the PRM database instead of achieving the data.
Auto Archive/ Delete
The Auto Archive Function helps to automatically Archive the Maintenance info.
The
engineers can Auto Archive the data reducing the load on the PRM, thereby improving the
performance of the system. Maintenance engineer can either Auto Archive the Data or Auto
delete the data.
¾
Cleanup
When devices are removed from the PRM database, the related data such as the operations
- 119 -
records regarding the devices will become obsolete, therefore, cleanup of the PRM database
may be required. However, cleanup can only be performed on PRM database, not on Historian
database.
¾
Tag Editor
When devices are removed, the Tag Editor can be used to remove the obsolete data related to
the deleted devices in the Historian database. The Tag Editor can only be used for editing the
tags in the Historian database.
Exercise: Auto Archiving Function
1. Open the Database maintenance tool
2. Set the destination for the Archive files, set the periodic Archive and enable the Auto Data
processing. Select the Auto Archive Radio button and enter the retention period time.
- 120 -
Exercise: Archiving Manually
1. Open the Database maintenance tool
- 121 -
2. Set the destination for the Archive files in the window
3. Select a ready to archive file and Press the Archive button.
- 122 -
FIELDBUS ENGINEERING
o FIELDBUS OVERVIEW
o FIELDBUS TECHNOLOGY OF YOKOGAWA
o PRM OVERVIEW
o PRM TECHNOLOGY
o PRM INSTRUCTION MANUAL – 01
o PRM INSTRUCTION MANUAL – 02
o PRM INSTRUCTION MANUAL - 03
