Kbase P22011: A Progress backup strategy with 3 after-image extents
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
09/06/2009 |
|
Status: Unverified
GOAL:
A Progress backup strategy with 3 after-image extents
FACT(s) (Environment):
Progress
FACT(s) (Environment):
Unix
FIX:
A backup strategy with 3 after-image extents divided in 3 steps
(initiate AI, backup routine and recovery):
Shortcuts:
AI = After-Image
DB = Database
Steps:
1) Initiate AI:
a) Add AI:
$ vi <db name>_add.st
add the following lines:
a <ai file path> f <size>
a <ai file path> f <size>
a <ai file path>
add segments to DB using prostrct:
$ prostrct add <dbname> <dbname>_add.st
b) Create backup catalog and do initial backup into
$ mkdir <path to backup disk>
$ probkup test <path to backup disk/<db name>.bck
c) Activate AI:
$ rfutil test -C aimage begin -G 0
d) Check AI status:
$ rfutil test -C aimage list
2) Backup rutine
a) Do Backup
$ probkup <db name> <path to backup disk>/<db name>.bck
$ cp <dbname>.a* <path to backup disk>
$ rfutil <db name> -C aimage empty
b) Verify Backup
$ prorest <db name> <path to backup disk>/<db name>.bck -vp
$ prorest <db name> <path to backup disk>/<db name>.bck -vf
d) LAST THING
copy the info on the backup disk to tape
3) Recovery
a) FIRST
Copy the last working backup data from the backup tape to backup disk
b) Restore data to database
prorest <db name> <path to backup disk>/<db name>.bck
c) Roll forward to last transaction before crash
$ rfutil <db name> -C roll forward> -a <path to backup disk>/<db name>.a1
$ rfutil <db name> -C roll forward> -a <path to backup disk>/<db name>.a2
$ rfutil <db name> -C roll forward> -a <path to backup disk>/<db name>.a3