Transfer the Old STA Database to the STA Server (Task 7)

In the single-server upgrade method, transfer the backup of the old database to the STA server.

1. Only perform this procedure if using the single-server method. Skip if using the two-server method.
2. Stop all STA services on the STA server:

   $ STA stop all
   

3. Transfer the database. The –p option on for SCP preserves timestamp values.

   $ scp -p backup_host:/path_to_dump_file/dump_file_name.sql.gz /local_path
   

   In the following example, SCP is used to transfer the compressed database dump file Jan26_dump.sql.gz from /dbdumpfiles on host backup1 to the /home/oracle folder on the STA server.

   $ scp -p backup1:/dbdumpfiles/Jan26_dump.sql.gz /home/oracle
   

4. Perform a checksum of the transferred file. Verify the checksum value matches the one you received when creating the database dump. For example:

   $ cd /home/oracle/
   $ cksum Jan26_dump.sql.gz
   2169286306 37 /Jan26_dump.sql.gz