To Restore the Control Center and the CP Server Component Running on Either an Oracle or Postgres Database

Steps

1. Run the command:

   /opt/terraspring/sbin/restoredb restored file name

   ---

   Note –

   The parameter restored file name refers to the backup file created during backup of the database.

   ---

2. Run the configure.sh script and provide the required parameters when prompted.

   /opt/terraspring/gwdb/bin/configure.sh

   For a Postgres database:

   DB_TYPE Postgres (case-sensitive) DB Admin User: postgres DB Admin Password: postgres DB User: tcc DB Password: tcc DB HOst Name: localhost DB Instance Name: tsprdb DB Instance Listening Port: 5432 DB Backup Directory: backup direcotry name DB Backup Filename: backup file name

   For an Oracle database:

   DB_TYPE Postgres (case-sensitive) DB Admin User: system DB Admin Password: manages DB User: tcc DB Password: tcc DB HOst Name: localhost DB Instance Name: tsprdb DB Instance Listening Port: 1521 DB Backup Directory: backup direcotry name DB Backup Filename: backup file name

3. To create the database type:

   /opt/terraspring/gwdb/bin/createDB.sh -y

4. To restore the database type:

   /opt/terraspring/gwdb/bin/restoreDB