Installation scenarios of Postgres 8.4.8

5. Upon data validation, remove the files /var/opt/psb/db/db_backup.sql.123 and

/var/opt/psb/db/restore_pid_data

NOTE: When Clone disk is booted, products would get configured and backed up data shall be restored.

DRD Session- Perform backup on booted system and sync to the clone for PA

Assumption

Booted disk and cloned disk are always kept in sync with respect to data. If they are not in sync, use

‘drd sync’ command.

Steps to be followed

1. Create metafile at /var/opt/sfmdb/restore_pid_data

# echo "123" > /var/opt/sfmdb/restore_pid_data

# ll /var/opt/sfmdb/restore_pid_data

-rw-rw-rw- 1 root sys 4 Aug 31 10:16 /var/opt/sfmdb/restore_pid_data

2. As a sfmdb user, take backup of the diagnostic data using ‘sfmDBUtil’ on booted disk and save it

in /var/opt/sfmdb/db_backup.sql.123

# su sfmdb

$ /opt/sfm/bin/sfmDBUtil bkup /tmp/db_backup.sql.`cat /var/opt/sfmdb/restore_pid_data`

$ ll /tmp/db_backup.sql.`cat /var/opt/sfmdb/restore_pid_data`

-rw-rw-rw- 1 sfmdb users 16517848 Aug 31 10:18 /tmp/db_backup.sql.123

$ exit

# mv /tmp/db_backup.sql.123 /var/opt/sfmdb/

# ll /var/opt/sfmdb/db_backup.sql.123

-rw-rw-rw- 1 sfmdb users 16517848 Aug 31 10:18 db_backup.sql.123

3. Perform DRD sync. Ensure that data backup file and metafile are part of sync

# /opt/drd/bin/drd sync –p

# cat /var/opt/drd/sync/files_to_be_copied_by_drd_sync

…

/var/opt/sfmdb