Reset Database on Lab Remote Server Virtual Machines

Objectives

1. Delete existing data in a database on a lab VM (i.e. drop all objects in application schema).
2. Import data from a database backup/export on a lab VM.

Prerequisites

1. SSH access to a lab remote server VM.
2. SSH access to "admin.portal.fullcount.net".
3. Community ID for the community that you would like to import data from.

Instructions

1. Log into the lab VM as the "root" user.
2. Change to the "/home/oracle" directory:
   
   # cd /home/oracle
    
3. Download the database backup/export file from "admin.portal.fullcount.net".
1. Files are in "/oracle/XE/remote_backups".
2. File names start with "backup_" followed by the community ID and a timestamp (for example, "backup_380_20180216010602.dmp").
   
   # scp -p admin.portal.fullcount.net:/oracle/XE/remote_backups/backup_380_20180216010602.dmp  /home/oracle
    
4. Check out scripts for databases on lab VMs:
   
   # svn checkout http://sourcecontrol.fullcount.net/repos/database/trunk/processes/lab
    
5. Change to the directory where scripts are checked out:
   
   # cd /home/oracle/lab
    
6. Run the "reset_lab_db.sh" script as the "root" user, with the name of the backup/export file as the first argument:
   
   # ./reset_lab_db.sh backup_380_20180216010602.dmp
    
7. Test against database and re-run "reset_lab_db.sh" as needed.