Transfer the Old Database Dump (Task 2)

Transfer the compressed dump of the old STA database to either an off-platform backup server (single-server method) or the new STA server (two-server method). This is the second task in a single server upgrade, but a later task in the two-server method.

  1. IMPORTANT: If you are upgrading from STA 2.3.0 or below with the single-server method, you must back up the STA database to another server. Do not backup the database to a file system on the current STA server, as the Linux installation in will destroy all data on the server.
  2. If you have not done so already, stop all STA services: $ STA stop all
  3. Record the checksum of the dump file. For example:
    $ cksum /home/oracle/Jan26_dump.sql.gz
    2169286306 37 /home/oracle/Jan26_dump.sql.gz
    
  4. Transfer the file to the target server using a transfer utility such as SCP. The –p option preserves timestamp values.
    $ scp -p dump_file target_host:/path/
    

    In the following single-server example, SCP is used to transfer the compressed database dump file Jan26_dump.sql.gz to the /dbdumpfiles folder on backup host backup1. The /dbdumpfiles folder already exists on the backup host.

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

    In the following two-server example, SCP is used to transfer the compressed database dump file Jan26_dump.sql.gz to the /dbdumpfiles folder on STA 2.3.1 host sta_new.

    $ cd /home/oracle
    $ scp -p Jan26_dump.sql.gz sta_new:/dbdumpfiles
    
  5. On the target server, perform a checksum of the transferred file. Verify that the checksum values match. For example:
    $ cd /dbdumpfiles
    $ cksum Jan26_dump.sql.gz
    2169286306 37 Jan26_dump.sql.gz