Saturday, March 14, 2009

Generate backupset of a database

There are 4 filesystems to generate a backupset.

For eg:
/data/db01/ssuprod
/data/db02/ssuprod
/opt/app/oracle/backup/ssuprod
/opt/app/oracle/admin/ssuprod

unix: -
dsmadmc -id=$id -password=$pw "generate backupset TSMserver ssolve_01162009 \
/opt/app/oracle/admin/ssolve,/opt/app/oracle/backup/ssolve,/dev/ssolveredo*, \
/data/db01/ssolve,/data/db02/ssolve,/data/db03/ssolve,/data/db04/ssolve,/data/db05/ssolve

Client side
dsmadmc -id=$id -password=$pw "generate backupset TSMserver ssuprod_02182009 \
/data/db01/ssuprod,/data/db02/ssuprod,/opt/app/oracle/backup/ssuprod, /opt/app/oracle/admin/ssuprod \
devclass=LTOCLASS retention=9999 scratch=yes description=SSOLVE_data3_011609 wait=no" > /tmp/ssuprod_02182009_backupset.out

client side:
dsmadmc -id=$id -password=$pw "generate backupset TSMserver ssuprod_02182009 \
/data/db01/ssuprod,/data/db02/ssuprod,/opt/app/oracle/backup/ssuprod,/opt/app/oracle/admin/ssuprod \
devclass=NASOFFSITE retention=9999 scratch=yes description=SSOLVE_data3_011609 wait=no" > /tmp/ssuprod_02182009_backupset.out

unix:-
pbrun /usr/tivoli/tsm/client/ba/bin/dsmc archive /data/db01/ssuprod,/data/db02/ssuprod,/opt/app/oracle/backup/ssuprod,
/opt/app/oracle/admin/ssuprod -ARCHMC=RET4EVER -su=yes -desc="Ssolve Jan2002 Hold Permanent"

TSM command line:
generate backupset TSMserver ssuprod_02182009
/data/db01/ssuprod,/data/db02/ssuprod,/opt/app/oracle/backup/ssuprod,/opt/app/oracle/admin/ssuprod
devclass=LTOCLASS retention=9999 scratch=yes description=SSOLVE_data3_011609 wait=no

No comments:

Post a Comment