Backup and Restore
- Sanjay Sahani
- Sonu Kumari
- Dheeraj Kumar Aggarwal
For an RMsis instance you must take backup of two things - one is RMsis home directory and the other is database.
Backup and restore of RMsis home directory
RMsis home directory is what you have configure during the installation. RMsis home directory is used to store RMsis database settings, SMTP settings and logs. Use the operating system utilities to take backup of the home directory. On UNIX, use programs like tar, cpio to take backup and on Microsoft Windows you can use WinZip. Restoring is extracting the data back from the backup file using the same tools.
Backup and restore of RMsis database
Database backup is dependent on the type of database you are using. Currently RMsis supports - MySQL, MSSQL, PostgreSQL and Oracle databases. There are separate topics explaining backup and restore on these databases.
MySQL
Backup and restore of MySQL should be done using the utilities that come packaged with MySQL. This section briefly describes the process.
MSSQL
This section briefly describes how to backup and restore MSSQL database using the SQL Server Management Studio.
PostgreSQL
This section briefly describes how to backup and restore PostgreSQL database.
Oracle
- A detailed information for Database Backup and Recovery for Oracle 12 c is available here : http://docs.oracle.com/database/121/BRADV/toc.htm
- A detailed information for Database Backup and Recovery for Oracle 11 g is available here : http://docs.oracle.com/cd/E11882_01/backup.112/e10642/toc.htm