Archive for November 2013

29 November 2013

IBM TSM V6 Administrator Certification Question and Answers - Part4

03:54 No Comments
76) What must be defined in order for migration to occur?

A. migstgpool=<pool name>
B. nextstgpool=<pool name>
C. highmigpool=<pool name>
D. cachestgpool=<pool name>
Correct Answer: B


77) Which statement applies to scratch volumes?

A. They might contain valid data.
B. They are empty or contain no valid data.
C. They are used or owned by an application.
D. They can only be used to satisfy a request to mount the specified volume.
Correct Answer: B


78) When defining a storage pool, which parameter triggers migration?

A. lowmig
B. highmig
C. migstart
D. migsched
Correct Answer: B


79) Which command can be used to check which tape drives are loaded?

A. Q LIB
B. Q MOUNT
C. Q STATUS
D. Q VOLUMES
Correct Answer: B


80) If migration for a storage pool starts during a storage pool backup, some files may be migrated before they are backed up. Which action should an IBM Tivoli Storage Manager administrator take to prevent this situation?

A. Ensure migration processes finish before backing up storage pools.
B. Back up all primary pools at the same time using PARALLEL scripting option.
C. A backup stgpool command should be run for the tape storage pool before disk storage pool.
D. A backup stgpool command should be run for the disk storage pool as well as the tape storage pool.
Correct Answer: D


81) Which command can be used to verify if a BACKUP STGPOOL command finished successfully?

A. Q LOG
B. Q ACTLOG
C. Q PROCESS
D. Q STGPOOL
Correct Answer: B


82) Why does an IBM Tivoli Storage Manager (Tivoli Storage Manager) administrator set EXPInterval to zero?

A. to specify expiration set to quiet mode
B. to set expiration to run every night at midnight
C. to export policy information from a Tivoli Storage Manager server to tape every night at midnight
D. to disable expiration functionality so that it does not degrade performance during backup operations
Correct Answer: D

83) Which command runs the expiration process for backup data for 2 hours with 3 threads on nodes A, B, and C?

A. expire inventory duration=2 node=A,B,C type=backup
B. expire inventory duration=120 node=A,B,C type=backup
C. expire inventory duration=2 node=A,B,C resource=3 type=backup
D. expire inventory duration=120 node=A,B,C resource=3 type=backup
Correct Answer: D


84) What occurs when EXPINTERVAL is set to 24?

A. Expiration runs every night at midnight.
B. Expiration runs every 24 days from the start time of the server.
C. Expiration runs every 24 minutes from the start time of the server.
D. Expiration runs each time the server is started, and then every 24 hours from the start time of the server.
Correct Answer: D

85) When using NOPREEMPT option in the IBM Tivoli Storage Manager option file, which process has higher priority to preempt other operation to access a device?

A. MIGRATION
B. RECLAMATION
C. BACKUP STGPOOL
D. DATABASE BACKUP
Correct Answer: D

86) The IBM Tivoli Storage Manager (Tivoli Storage Manager) storage administrator notices that the server recovery log is approaching more than 80% utilization. Which action must be taken to provide an extra level of protection?

A. Create a DRM file on daily basis.
B. Perform a backup of all the storage pools.
C. Perform a backup of the device configuration file.
D. Perform a FULL backup of the Tivoli Storage Manager server database.
Correct Answer: D


87) An administrator decided to automatically run the typical administrative tasks for IBM Tivoli Storage Manager(Tivoli Storage Manager) starting from Migration to off-site movement of media. What is the most suitable choice?

A. Create DRM file on daily basis.
B. Create a Server Maintenance Script.
C. Define Schedules for different server process.
D. An operator with STORAGE authority is required to run daily Tivoli Storage Manager server task.
Correct Answer: B


88) Reclamation can be run for which two types of storage pools? (Choose two.)

A. random-access copy storage pool
B. sequential-access copy storage pool
C. random-access primary storage pool
D. sequential-access primary storage pool
E. random-access active-data storage pool
Correct Answer: B,D


89) What is defined in order for reclamation to run?

A. reclamation cache
B. reclamation buffer
C. reclamation trigger
D. reclamation threshold
Correct Answer: D


90) There is a restore operation running for an IBM Tivoli Storage Manager (Tivoli Storage Manager) client. The client on which the restore operation started receives a message on the Tivoli Storage Manager server saying:
There is no data currently available for this client. What is the solution for this restore problem?

A. Wait for availability on the server.
B. Check the tape drive for online status.
C. Check the volumes for read/write access.
D. Check the network connection on the tape library.
Correct Answer: C


91) On a tape library, suddenly, there are no SCRATCH volumes available in the library. Which action will help diagnose the situation?

A. Q LIBV libname F=D
B. Insert new Tape volumes to the library.
C. UPDATE DRIVE divename ONLINE=YES
D. CHECKIN LIBV libname SEARCH=YES LABELSource=BARCODE ACCESS=SCRATCH
Correct Answer: A


92) During start-up, the IBM Tivoli Storage Manager server is in the foreground. Several tapes in read- only and/or are unavailable. Which action will correct the status?
A. MOVE VOLUME volid ACCESS=READWRITE
B. UPDATE VOLUME volid ACCESS=READWRITE
C. UPDATE LIBRARY volid ACCESS=READWRITE
D. UPDATE VOLUME volid ACCESS=UNAVAILABLE
Correct Answer: B


93) An IBM Tivoli Storage Manager (Tivoli Storage Manager) administrator has to include a new Oracle server named "ORA_DEV01" to the Tivoli Storage Manager backup schedule. This server has to be associated to the management class (DATABASE_MC) under the policy set (DB_POL) of the domain DB_DOMAIN, which retains the online backups for 45 days. The appropriated backup client is already installed to the server. Which Tivoli Storage Manager command defines the ORA_DEV01 node into the Tivoli Storage Manager server?

A. register node ORA_DEV01 password type=server maxnummp=1
B. define node ORA_DEV01 password type=server maxnummp=1 do=DB_DOMAIN
C. register node ORA_DEV01 password do=DB_DOMAIN type=client maxnummp=1
D. define node ORA_DEV01 do=DB_DOMAIN type=client maxnummp=1 class=system
Correct Answer: C


94) A client node named WINSRV009 is already defined in the IBM Tivoli Storage Manager Server (Tivoli Storage Manager) under the Policy Domain WIN_DOMAIN. Its backup operation was taking too long and it decided to change its backup to send data directly to four tape drives by using LAN- free only. The paths to the drives were already defined for the WINSRV009 server. Which Tivoli Storage Manager command satisfies this condition?

A. upd node WINSRV009 MAXNUMMP=2 DATAWritepath=LANFree
B. upd node WINSRV009 MAXNUMMP=4 DATAWritepath=SAN VALIdateprotocol=no
C. upd node WINSRV009 MAXNUMMP=4 DATAWritepath=LANFree VALIdateprotocol=no
D. upd node WINSRV009 MAXSESSIONS=4 DATAWritepath=SAN VALIdateprotocol=yes
Correct Answer: C


95) An IBM Tivoli Storage Manager (Tivoli Storage Manager) administrator wants to define a node on the Tivoli Storage Manager server to support Network Data Management Protocol (NDMP) operations. The node name should be FILE_SRV18 and it should be assigned under the domain FS_DOM. Which Tivoli Storage Manager administrative command can perform the operation?

A. register node FILE_SRV18 password type=NAS
B. define node FILE_SRV18 password do=FS_DOM type=NDMP
C. register node FILE_SRV18 password do=FS_DOM type=NAS
D. register node FS_DOM FILE_SRV18 password=1234 type=NDMP
Correct Answer: C


96) What does the REVOKE AUTHORITY command do?

A. It revokes privileges of IBM Tivoli Data Protections clients.
B. It revokes privileges of IBM Tivoli Storage Manager administrators.
C. It revokes privileges of IBM Tivoli Storage Manager backup-archive clients.
D. It revokes privileges of IBM Tivoli Storage Manager administrators as well as backup-archive clients.
Correct Answer: B


97) How is the expiration period set for both administrator and client node passwords?

A. SET PASSEXP
B. SET PASSWORD
C. RESET PASSEXP
D. RESET PASSWORD
Correct Answer: A


98) Which privilege class is NOT available for the GRANT AUTHORITY command in IBM Tivoli Storage Manager V6.1?

A. Policy
B. System
C. Analyst
D. Storage
Correct Answer: C

99) On the Windows platform, where should a predefined (custom) dsm.opt file be placed when installing IBM Tivoli Storage Manager V6.1 client?

A. ...\CLIENT directory
B. ...\CONFIG directory
C. ...\BACLIENT directory
D. ...\BACLIENT\CONFIG directory
Correct Answer: B

100) Which two methods can be used to edit/update the IBM Tivoli Storage Manager client options file on a Windows client? (Choose two.)

A. In the BA GUI, go to edit -> preferences menu.
B. In the BA GUI, go to file -> edit -> options menu.
C. In the BA GUI, go to file -> edit preferences menu.
D. In the BA GUI, go to edit -> edit preferences menu.
E. Explore to the client installation directory and edit dsm.opt file.
Correct Answer: A,E


101) What does the command 'dsmc q sess -se=tsmServer' test?

A. Client can invoke archive function.
B. Client can invoke selective backup.
C. Client can invoke the retrieve function.
D. Client can verify a session with tsmServer has been established.
Correct Answer: D

102) What is the purpose of schedule randomization?

A. The client schedule start time is dispersed.
B. The server administrative schedule start time is dispersed.
C. The client schedule alternates different nodes on different days.
D. The server administrative schedule alternates different jobs on different days.
Correct Answer: A

103) What is the purpose of the define clientaction command?

A. It associates a policy to client nodes on the client.
B. It associates a policy to client nodes on the server.
C. It schedules a one-time client command when executed on the client.
D. It schedules a one-time client command when executed on a the server.
Correct Answer: C

104) What is the minimum authority level to set the scheduling mode on the server or client?

A. System Privilege
B. Storage Privilege
C. Standard Privilege
D. Schedule Privilege
Correct Answer: A

105) Which command can be used to check if a client schedule ran successfully?

A. Q LOG
B. Q EVENT
C. Q STATUS
D. Q SCHEDULE
Correct Answer: B


106) What is a primary advantage of configuring the IBM Tivoli Storage Manager (Tivoli Storage Manager) client to manage the scheduler process using the Tivoli Storage Manager client acceptor?

A. The client acceptor is required to manage scheduler memory.
B. One client acceptor process can manage only one scheduler process.
C. This is mandatory if SESSIONINITiation=SERVEROnly backups are required.
D. A TCP port does not have to be opened at the firewall because only UDP communications are used.
Correct Answer: A


107) A customer has a created and backed up a file called C:\home\client\myhome.txt. The customer wants to ensure that this file is backed up again. Which command will back up this file again?

A. dsmc sel c:\home
B. dsmc incr myhome.txt
C. dsmc sel c:\home\client\*
D. dsmc incd c:\home\client\
Correct Answer: C


108) An IBM Tivoli Storage Manger administrator has to determine why a backup failure occurred. Which location is the best place to find the cause of the failure?

A. event.log
B. cliact.log
C. dsmerror.log
D. IBM Web site
Correct Answer: C


109) What does the command dsmc sel do?

A. selects files to be deleted
B. selects files to be restored
C. selects files to be archived
D. backs up all files whether they have changed or not
Correct Answer: D


110) After a scheduled backup to IBM Tivoli Storage Manager (Tivoli Storage Manager) performed by Tivoli Storage Manager client node, it has been found that few files have been skipped or not included in backup for some reason. Which two logs from backup-archive client should be checked as an initial step to get information of schedule operation failure? (Choose two.)

A. activity log
B. error report from operating system
C. dsmerror.log file located in backup-archive client installation directory
D. Daily Operational Report generated by Tivoli Storage Manager server
E. dsmsched.log file located in backup-archive client installation directory
Correct Answer: C,E

IBM Tivoli Storage Manager TSM Administrator Certification Question and Answers - Part3

03:50 No Comments
51) IBM Tivoli Storage Manager (Tivoli Storage Manager) reporting and monitoring feature does not have an option to create custom reports for Tivoli Storage Manager, however a client wants to create their own custom report. Which additional software is required to enable this feature?

A. Crystal Reports
B. Promodag Reports
C. MicroStrategy Reporting Suite
D. Business Intelligence and Reporting Tools
Correct Answer: D

52) What is the maximum number of copygroups that can be assigned to a management class?

A. one
B. two
C. three
D. no limit
Correct Answer: B


53) Which statement is true regarding a Policy domain?

A. A Policy domain has maximum two policy sets, and both have ACTIVE.
B. A Policy domain has several policy sets, and all of the policy sets can be considered ACTIVE.
C. A Policy domain has maximum two policy sets, and one is ACTIVE and the other is INACTIVE.
D. A Policy domain can have several policy sets, but only one policy set can be considered ACTIVE.
Correct Answer: D

54) What is the command to modify backup/archive retention parameter values?

A. Update domain
B. Update copygroup
C. Update mgmtclass
D. Update policyset
Correct Answer: B

55) What does RETVer specify?

A. the number of days to keep a backup copy
B. the number of days to keep an archive copy
C. the number of versions to keep for a backup
D. the number of versions to keep for an archive
Correct Answer: B

56) Which parameters should the backup copygroup have, to keep only the last backup copy of data indefinitely after the file has been deleted from the file system and a daily incremental backup has been completed?

A. verdeleted=0 retonly=nolimit
B. verdeleted=1 retonly=nolimit
C. verdeleted=1 retextra=nolimit
D. verextra=1 retextra=nolimit retonly=nolimit
Correct Answer: B


57) Which parameters should the copygroup have, to retain four inactive versions of a file when the file is available on client system?

A. veronly=4
B. retonly=5
C. verexists=4
D. verexists=5
Correct Answer: D

58) Which statement described a device class?

A. A copy storage pool must be associated with two device classes.
B. Each storage pool can be associated with multiple device classes.
C. A device class is a collection of storage volumes chained together to create a storage hierarchy.
D. A device class is a set of storage devices with similar availability, performance, and storage characteristics.
Correct Answer: D

59) Which type of storage pool can use either a sequential access device class or a random access device class?

A. active-data pool
B. copy storage pool
C. primary storage pool
D. deduplicated data pool
Correct Answer: C


60) Given that active-data pools contain only active versions of client data, which statement is true about the use of active-data pools?

A. The use of active-data pools allows faster backups.
B. There is a reduction on the number of on-site volumes and an increase of off-site volumes.
C. There is a reduction of bandwidth utilization when moving files that are vaulted electronically.
D. Hierarchical storage management data can use active-data pools as a destination for migration.
Correct Answer: C

61) Assuming data belongs to a node that is a member of a policy domain which specifies the active- data pool as the destination for active data, to copy active versions of client backup files from primary storage pools to active-data pools, the COPY ACTIVEDATA command can be issued. Which alternative approach to this command can be used to accomplish the same result?

A. Use MOVE COPYDATA command.
B. Use the simultaneous-write function.
C. Use at least two parallel backup sessions.
D. Set MIRRORCOPYDATA option to YES on the primary storage pool.
Correct Answer: B


62) What is a characteristic of active-data pools?

A. It can accept use of Collocation.
B. It can use DISK or FILE device classes.
C. It can be used as a primary destination for backed-up files.
D. It can accept DESTROYED access mode on the pool volumes.
Correct Answer: A


63) Which option disables deduplication when using update stgpool?

A. DUPLICATE=NO
B. DUPLICATE=OFF
C. DEDUPLICATE=NO
D. DEDUPLICATE=OFF
Correct Answer: C


64) Which data CANNOT be deduplicated?

A. DB2 data
B. archive data
C. encrypted data
D. Tivoli Data Protection data
Correct Answer: C


65) What happens when an administrator copies data from a deduplicated storage pool to a copy storage tape pool?

A. The process fails. Deduplicated data cannot be copied.
B. The deduplicated data is copied as deduplicated to the copy tape pool.
C. The deduplicated data is reduplicated and copied to the copy tape pool.
D. The deduplicated data is uncompressed but remains deduplicated and copied to the copy tape pool.
Correct Answer: C


66) A worldwide active bank has a requirement for their data be shredded after the data is disposed. What occurs during data shredding?

A. The data is deleted after expiration.
B. Only the backup data will be shredded.
C. All data will be shredded on given storage pools.
D. The deleted data is overwritten one or more times after it is deleted.
Correct Answer: D


66) Which two statements are true about shredding sensitive data? (Choose two.)
A. I/O response time is improved.

B. Performance for shredding data is faster.
C. Discovering and reconstructing data is easy.
D. Data is overwritten one or more times after it is deleted.
E. Shredding can be done either automatically or manually.
Correct Answer: D,E


67) You have to build and protect the IBM Tivoli Storage Manager (Tivoli Storage Manager) server data for several clients with a secure environment. Which two statements are true for data shredding? (Choose two.)

A. The data is physically overwritten and is no longer readable.
B. Data which is shredded is difficult to discover and reconstruct.
C. The Tivoli Storage Manager client is able to restore the shredded data.
D. The shredding process can be done on the Tivoli Storage Manager client.
E. The process increases the complexity on the Tivoli Storage Manager server.
Correct Answer: A,B


68) An administrator observed that their IBM Tivoli Storage Manager server environment is presenting performance degradation during restore operation. He verified with support team that cache hit percentage should be increased to resolve this problem. Which command can help an administrator verify the current statistic of cache hit percentage?

A. query option
B. query db f=d
C. query log f=d
D. query buffpool
Correct Answer: B

69) An administrator of IBM Tivoli Storage Manager schedules a migration to move data from the DISKPOOL to TAPEPOOL for local sequential copy, but he also wants to keep the data on DISKPOOL for faster restore to improve performance. Which option will accomplish this task?

A. CHANGE STGPOOL DISKPOOL ACCESS=READWRITE NEXTSTGPOOL=TAPEPOOL HIGHMIG=0 LOWMIG=0 CACHE=YES MIGPROCESS=2 MlGCONTINUE=YES
B. UPDATE STGPOOL DISKPOOL ACCESS=READWRITE NEXTSTGPOOL=TAPEPOOL HIGHIMIG=0 LOWMIG=0 CACHE=YES MIGPROCESS=2 MlGCONTINUE=YES
C. UPDATE STGPOOL DISKPOOL ACCESS=READWRITE NEXTSTGPOOL=TAPEPOOL HIGHMIG=50 LOWMIG=50 CACHE=NO MIGPROCESS=2 MIGCONTINUE=YES
D. CHANGE STGPOOL DISKPOOL ACCESS=READWRlTE NEXTSTGPOOL=BACKPOOL HIGHMIG=100 LOWMIG=100 CACHE=YES MIGPROCESS=2 MlGCONTINUE=YES
Correct Answer: B

71) Which command should be used to install the IBM Tivoli Storage Manager Client Acceptor services on a client system?
A. dsmcutil
B. dsmcinstall
C. dsmcadinstall
D. dsmcad install
Correct Answer: A


72) A new administrative schedule did not run when it was scheduled. What is the most likely cause?

A. the priority = 0
B. It was not active.
C. The node was not registered.
D. It was not associated with a node.
Correct Answer: B

73) Which option should be enabled to back up a raw volume during a scheduled backup?

A. image.raw
B. include.image
C. rawbackup yes
D. enablerawbackup
Correct Answer: B


74) Which command can be used to add an unlabeled tape to an automated library if autolabel=no, and make it available as a scratch tape?

A. dsmclabel
B. label libvol
C. checkout libv
D. define volume
Correct Answer: B


75) Which select statement will give the count of the scratch volumes available within the IBM Tivoli Storage Manager?

A. SELECT SUM(*) FROM volumes WHERE status='scratch'
B. SELECT COUNT(*) FROM volumes WHERE status='scratch'
C. SELECT SUM(*) FROM libvolumes WHERE status='Scratch'
D. SELECT COUNT(*) FROM libvolumes WHERE status='Scratch'
Correct Answer: D

IBM Tivoli Storage Manager (TSM) Certified Administrator Examination Question and Answers - Part 2

03:45 No Comments
26) Which command can be used to perform an automatic backup of the IBM Tivoli Storage Manager database?


 A. define dbbackup
B. define dbbackuptrigger
C. define databackup trigger
D. define schedule backup_database type=administrative cmd="backup db type=full devclass=file" active=yes starttime=22:00 period=2
Correct Answer: D

27) Which statement will be added to the client's option file to assign a management class for a file for backup?

A. MC=<management class name>
B. Accept policy <policy domain name>
C. Backup <fully qualified file name> mgmtclass
D. Include <fully qualified file name> mgmtclass
Correct Answer: D




 28) Which two statements describe the processing of the include/exclude list in the client options file? (Choose two.)

A. It is read from the top down.
B. It is read from the bottom up.
C. If the file is not excluded, it is included.
D. If the file is not included, it is excluded.
E. Processing stops when all lines are read.
Correct Answer: B,C

29) What are two purposes of having include/exclude lists in the client options file? (Choose two.)

A. Include open files to back up.
B. Reduce the amount of data being backed up.
C. Validate a policy set for a file or a group of files.
D. Ensure file security is maintained during backups.
E. Associate a management class with a file or a group of files.
Correct Answer: B,E

30) A customer wants to secure client data as well as IBM Tivoli Storage Manager's database backups using encryption. Assuming the tape drives, libraries, and client's operating systems support all methods below, which encryption method must be used to meet customer's requirement?

A. SSL encryption
B. Client encryption
C. Library Managed tape drive encryption
D. Application Managed tape drive encryption
Correct Answer: C

31) Checking a customer's IBM Tivoli Storage Manager server configuration, a defined device class is detailed as shown. According to this configuration, which method of encryption is being used in the customer environment?
tsm: PERIGEE>q devclass lib2-encrypt f=d
Device Class Name: LIB2-ENCRYPT
Device Access Strategy: Sequential
Storage Pool Count: 2
Device Type: 3592
Mount Limit: DRIVES
Mount Wait (min): 5
Mount Retention (min): 0
Label Prefix: ADSM
Library: LIB2-ENCRYPT
Directory:
Server Name:
Retry Period:
Format: DRIVE
Retry Interval:
Shared:
High-level Address:
Minimum Capacity:
WORM: No
Drive Encryption: On
Scaled Capacity: 20
Last Update by (administrator): ADMIN
Last Update Date/Time: 08/10/09 12:31:02
A. API client-side transparent encryption
B. Library Managed tape drive encryption
C. System Managed tape drive encryption
D. Application Managed tape drive encryption
Correct Answer: D


32) Which encryption policy is used by the Library Managed tape encryption method?
A. range or set of volumes
B. dedicated storage pools
C. enabled at tape drive level
D. activated at COPY GROUPS definitions
Correct Answer: A


33) The IBM Tivoli Storage Manager administrator wants to reduce restore times. Which action helps accomplish that objective?

A. Increase scratch volumes.
B. Enable collocation groups.
C. Shorten the client backup window.
D. Enable collocation on the random access storage pool.
Correct Answer: B


34) An IBM Tivoli Storage Manager (Tivoli Storage Manager) administrator is tasked with restoring critical data quickly during a disaster. How can this be accomplished within Tivoli Storage Manager?

A. backing up critical node data first
B. collocating the critical data on tape
C. writing all data to a single storage pool
D. using the description field in the storage pool definition to declare the data critical
Correct Answer: B


35) What is the result of enabling collocation?

A. Backup times decrease.
B. Less scratch tapes are used.
C. Tape mounts decrease during a restore.
D. Tape mounts decrease during migration.
Correct Answer: C

36) During a recovery situation for IBM Tivoli Storage Manager (Tivoli Storage Manager) database, which file is required by Tivoli Storage Manager in order to read the latest database backup volume information?

A. Volhist.out file
B. Dsmserv.opt file
C. Dsmserv.dsk file
D. Device configuration file
Correct Answer: A


37) An administrator has set up a disaster recovery for IBM Tivoli Storage Manager (Tivoli Storage Manager) where the server database needs to be restored in an environment with different hardware from their production environment. Which action must be taken to perform the Tivoli Storage Manager database recovery?

A. Modify the restore instructions stanza of the recovery plan file to use a manual library at the recovery location.
B. There is no need to modify recovery plan file. The restore operation is already taken care by Tivoli Storage Manager server.
C. Modify the device configuration file stanza of the recovery plan to allow the use of the hardware found at the recovery location.
D. Modify the machine general instructions stanza of the recovery plan file to allow the use of the hardware at the recovery location.
Correct Answer: C


38) Which two steps should be performed by an administrator of IBM Tivoli Storage Manager to make sure they have intact database backup volumes information and device definitions available? (Choose two.)

A. Perform backup of volhist file.
B. Perform backup of devconfig file.
C. Perform DB backup of Type=FULL.
D. Perform backup of dsmserv.dsk file each day.
E. Perform backup of dsmserv.opt file each day.
Correct Answer: A,B

39) How does IBM Tivoli Storage Manager handle symbolic links, if a symbolic link points to a file?

A. The client only backs up the files.
B. The client only backs up the path information.
C. The client does not back up the directory structure.
D. The client backs up both the file and the directory structure.
Correct Answer: B


40) if a symbolic link points to a directory, the backup depends on how the directory is specified on the command. If a directory is specified with a trailing slash on a selective or incremental backup command, how does the client save the symbolic link?

A. The client only backs up the path information.
B. The client does not back up the contents of the target directory.
C. The client saves the symbolic link as a directory, and backs up the contents of the target directory.
D. The client does not save the symbolic link and the contents of the target directory are not backed up.
Correct Answer: C

41) if a symbolic link is backed up as a directory, what happens to future incremental backups that do not back up that symbolic link as a directory?

A. IBM Tivoli Storage Manager will default to the management class rules.
B. IBM Tivoli Storage Manager will back up all the files and directories in the directory.
C. IBM Tivoli Storage Manager will back up all the files and directories which have the option - subdir.
D. IBM Tivoli Storage Manager will expire that symbolic link as a directory, and will expire the files and directories in that directory.
Correct Answer: D

42) A system administrator has IBM Tivoli Storage Manager V6.1 (Tivoli Storage Manager) installed but is not using or has not installed the ISC, and wants to check on the status of the nightly backups. Which three steps can this administrator perform to check the status of backups, and the success or cause of any failure? (Choose three.)

A. Issue Q Event * *.
B. Issue Q Schedule.
C. View the Tivoli Storage Manager calendar file.
D. View the error log of any node that shows failed.
E. View the Tivoli Storage Manager server error log file.
F. View the schedule log of any node that shows missed.
Correct Answer: A,D,F


43) What is the minimum level of authority needed by the administrator to query the sessions that are running on the IBM Tivoli Storage Manager server?

A. Policy
B. System
C. Storage
D. No privilege
Correct Answer: D

44) The IBM Tivoli Storage Manager (Tivoli Storage Manager) client will be installed on a new customer account and the purpose of the dsm.opt file on the Tivoli Storage Manager client has to be explained. What is the purpose of the dsm.opt file on the Tivoli Storage Manager client?

A. The server definition can be overwritten.
B. DSM.OPT file can only be found on AIX system.
C. The option file can be found only on the Tivoli Storage Manager server.
D. It tells where the network address of the Tivoli Storage Manager server can be found.
Correct Answer: D


45) On a Windows platform, what is the purpose of the include/exclude list in the dsm.opt file?

A. which files are scheduled to be backed up
B. to ensure the IBM Tivoli Storage Manger client password is encrypted
C. that the include/exclude list does not apply to the Windows dsm.opt file
D. to specify the files to be treated differently from the DEFAULT managementclass
Correct Answer: D

46) What are the correct steps to upgrade manually with the IBM Tivoli Storage Manager upgrade utilities?

A. dsmserv preparedb, dsmserv extractdb, dsmserv loadformat, dsmserv insertdb
B. dsmupgrd preparedb, dsmupgrd extractdb, dsmserv loadformat, dsmserv insertdb
C. dsmserv loadformat, dsmupgrd extractdb, dsmupgrd preparedb, dsmserv insertdb
D. dsmupgrd extractdb, dsmupgrd preparedb, dsmserv loadformat, dsmupgrd insertdb
Correct Answer: B

47) Which two statements are true about DSMUPGRD upgrade utilities? (Choose two.)

A. DSMUPGRD utilities are run on the original database.
B. DSMUPGRD EXPORTDB utility extracts data from a server database.
C. DSMUPGRD PREPAREDB upgrades a server database version to V5.5.
D. DSMUPGRD INSERTDB utility moves a server database into a new V6.1 database.
E. The upgrade utilities prepare and extract data from an IBM Tivoli Storage Manager server version V5.2 or above server database.
Correct Answer: A,C

48) What are two of the requirements for the upgrade to IBM Tivoli Storage Manager (Tivoli Storage Manager) V6.1? (Choose two.)

A. The upgrade does not support the network method.
B. Only Tivoli Storage Manager V5.3, V5.4, or V5.5 servers can be upgraded to V6.1.
C. It is necessary to upgrade a V5.3 or V5.4 server to V5.5 level before upgrading to V6.1 level.
D. The upgrade utility package must be installed on the system where the V5 database is located.
E. Once Tivoli Storage Manager V6.1 is installed on a server with multiple instances, only one instance can be upgraded and used.
Correct Answer: B,D


49) What are three component installations for the Tivoli monitoring and reporting feature? (Choose three.)

A. Admin Center
B. Tivoli Netcool
C. Tivoli Monitoring
D. Tivoli Directory server
E. Tivoli Common Reporting
F. Tivoli Storage Manager backup-archive client
Correct Answer: A,C,E


50) What is the default port number of ISC during IBM Tivoli Storage Manager reporting and monitoring feature installation?

A. 9044
B. 9043
C. 9042
D. 9041
Correct Answer: A

IBM Tivoli Storage Manager (TSM) Administrator Certification Question and Answers - Part 1

03:23 No Comments
IBM Tivoli Storage Manager (TSM) V6.1 Certified Administrator Examination Questions and Answers. These whole  (all parts)TSM Version 6.1 certification material was shared by Ranjith.
1) What is the first step that should be performed after setting up a new IBM Tivoli Storage Manager server?

A. prepare
B. storage manager database backup
C. process to return local scratch tapes to the library
D. cron job to back up the Tivoli Storage Manager file system
Correct Answer: B
2) Using the administrative command line on the client machine, query the IBM Tivoli Storage Manager (Tivoli Storage Manager) server and save the output to be used for a report later. What must a Tivoli Storage Manager administrator with Operator authority do in order for this output to be redirected for reports?

A. Add > filename to the command.
B. Set the Admin authority to System and create a file output.
C. Create a report in the ISC and direct it to outfile="outputname".
D. Issue Query Systeminfo and from the DOS prompt select file output.
Correct Answer: A

3) Which type of device class is supported by random access storage?

A. Disk
B. Tape
C. Virtual
D. GenericTape
Correct Answer: A



4) Which command will add a new volume to the library, which is in the entry/exit ports of the library?

 A. checkin libvolume libname volname search=no status=scratch
B. checkin libvolume libname volname search=no status=scratch waitt=0
C. checkin libvolume libname search=yes status=scratch checklabel=yes
D. checkin libvolume libname search=bulk status=scratch checklabel=barcode
Correct Answer: D




5) What is the term for automatic data movement that frees up space on tape volumes by consolidating active data from fragmented tape volumes onto a single volume?

 A. migration
B. collocation
C. reclamation
D. aggregation
Correct Answer: C



6) Which command must be used to define a schedule that archives specific files quarterly on the last Friday of the month?

A. DEFINE SCHEDULE command with SCHEDSTYLE=ENHANCED parameter
B. DEFINE SCHEDULE command with SCHEDSTYLE=ADVANCED parameter
C. DEFINE CLIENTACTION command with SCHEDSTYLE=ENHANCED parameter
D. DEFINE CLIENTACTION command with SCHEDSTYLE=ADVANCED parameter
Correct Answer: A


7) A customer has a 3584 library with 1000 tape volumes. All of the tape volumes are in IBM Tivoli Storage Manager library inventory with private and scratch status. Now the customer wants to know the total number of 'Private' volumes by SQL command. What is the correct SQL statement for an automatic count?

A. SELECT * FROM volumes WHERE status='Private'
B. SELECT * FROM libvolumes WHERE status='Private'
C. SELECT COUNT(*) FROM volumes WHERE status='Private'
D. SELECT COUNT(*) FROM libvolumes WHERE status='Private'
Correct Answer: D


8) A new server-to-server environment is being set up. One server is called Source and the other Target. With the define server command, the servers will be defined in one step to these two servers. But only one server is defined. On one side, there is no server definition for the issuing server to find. How can this problem be solved?

A. On the Source server, DEFINE SERVER SOURCE ...
B. Set on Source and on Target server, SET CROSSDEFINE ON.
C. Set on both servers the IP address, IP port, and the server password.
D. On the Target server, DEFINE SERVER SOURCE ... CROSSDEFINE=YES.
Correct Answer: D


9) Additional LTO4 tape drives should be added to the LTO library that has LTO2 drives, what must be done to ensure that the LTO4 drives are used for off-site tapes?


A. Define additional tape drives and path to additional tape drives.
B. Define device class for LTO4, tape drive, and update copypool.
C. Remove LTO device class, and define new LTO4 device class, tape drives, and path.
D. Define the new library, the library path, device class for LTO4, new tape drives to library, path of new drives to IBM Tivoli Storage Manager server, and update storage pool to use new device class LTO4 for off-site copypool and/or primary pools that are sent off-site.
Correct Answer: D

10) A customer wants to copy the file, my data/schedule.doc, retain it for 365 days, and maintain its default backup retention for 30 days. Which IBM Tivoli Storage Manager action should be performed?

A. archive
B. image backup
C. open file backup
D. incremental backup
Correct Answer: A




11) Which statement is true about IBM Tivoli Storage Manager selective backup?

 A. It causes the server to update the date and time of the last archive.
B. It expires backup versions of files that are deleted from the workstation.
C. It rebinds backup versions to a management class if the management class has not changed.
D. It backs up directory and file entries even if their size, modification timestamp, or permissions have not changed.
Correct Answer: D




12) Which three operating systems support journal-based backups? (Choose three.)

 A. AIX
B. Solaris
C. HP-UX
D. Linux Redhat
E. Windows 2003 Server
F. Windows 2008 Server
Correct Answer: A,E,F




13) Whenever using the backup-archive client interface to perform Network Data Management Protocol backups or restores, you are asked to authenticate yourself as an IBM Tivoli Storage Manager administrator before the operation begins. What is the minimal level of authority the administrator ID must have to complete this?

 A. system authority
B. system authority for the NAS node
C. client owner authority for the NAS node
D. analyst authority for the backup-archive client server
Correct Answer: C




14) The same backup operation can be performed with a server interface. For example, from the administrative command line client, back up the file system named /vol/vol1 on a NAS file server named NAS1, by entering the following command:
backup node nas1 /vol/vol1
What is the minimal level of authority required to perform this operation?

 A. storage authority
B. system authority for the NAS node
C. client owner authority for the NAS node
D. analyst authority for the backup-archive client server
Correct Answer: C




15) In order to back up a NAS device to an IBM Tivoli Storage Manager (Tivoli Storage Manager) native storage pool, set the destination storage pool in the copy group to point to the desired native storage pool. The destination storage pool provides the information about the library and drives used for backup and restore. When backing up a NAS file server to Tivoli Storage Manager native pools, the TOCDESTINATION may be the same as the destination of the NDMP data. What is required for this to happen?

 A. Define a new copygroup for the TOC.
B. Define a new device class for the TOC.
C. Define a copygroup with the TOCDestination parameter.
D. Define a device class, by using the TOCDestination parameter.
Correct Answer: C




16) What is the latest and fastest backup method for a large customer to use Network Data Management Protocol(NDMP) for the large filer?

 A. the NetAppSnapMirror to Tape
B. the traditional NDMP for full backup
C. a flash-copy with SnapMirror directly to Tape
D. a block-level copy with SnapMirror directly to Tape
Correct Answer: D




17) A Network Data Management Protocol (NDMP) installation is growing fast with a large filer. For these large IBM Tivoli Storage Manager nodes, a faster backup method must be implemented. Which method should be considered?

 A. NDMP full
B. SnapMirror to Tape
C. NDMP differential backup
D. Incremental backup with NDMP
Correct Answer: B




18) The Network Data Management Protocol filers must be backed up. All definitions are complete and the access to the tape environment is working properly. The backup command is not performing optimally. To allow the IBM Tivoli Storage Manager client a backup from a NetApp filer, some additional options for the backup command are required to get optimal performance. Which option should be used?

 A. TYPE = BACKUP | SNAPDisk
B. TYPE = BACKUPImage | SNAPMirror
C. TYPE = BACKUPFilespace | SNAPCopy
D. TYPE = BACKUPFiller | SNAPMultiple
Correct Answer: B


19) Which command starts the IBM Tivoli Storage Manager administrative command line interface?

A. dsmc
B. dsmadmc
C. tsmadmin
D. dsm admin
Correct Answer: B


20) What are two valid options when starting the IBM Tivoli Storage Manager administrative commandline interface? (Choose two.)

A. -clientmode
B. -adminmode
C. -mountmode
D. -servermode
E. -consolemode
Correct Answer: C,E


21) From which URL can the IBM Tivoli Storage Manager Administration Center be accessed?


22) What is the minimum size of active log?

A. 2 GB
B. 13 GB
C. 128 GB
D. It depends upon the file system size.
Correct Answer: A


23) Which log is used for database restore in IBM Tivoli Storage Manager?

A. active log
B. archive log
C. active mirror log
D. archive mirror log
Correct Answer: B


24) How can the recovery log mode be changed from roll-forward mode to normal mode in IBM Tivoli Storage Manager (Tivoli Storage Manager)?

A. Set logmode normal.
B. Update logmode normal.
C. Put 'logmode=normal' in dsmserv.opt file.
D. Tivoli Storage Manager server uses only roll-forward mode for recovery log.
Correct Answer: D



25) Which two recommended automated schedules should be created after setting up a new IBM Tivoli Storage Manager (Tivoli Storage Manager) server? (Choose two.)

 A. new client registration
B. storage pool migration
C. storage manager database backup
D. process to return local scratch tapes to the library
E. cron job to back up the Tivoli Storage Manager file system
Correct Answer: B,C

25 November 2013

How to troubleshoot IBM Tivoli Data Protection for Oracle (TDPO) backup and connection issues ?

03:28 No Comments
IBM Tivoli Data Protection for Oracle provides 3 utilities to troubleshoot the problems or issues faced during oracle backup/restore processes. You can use these utilities to configure and and also maintain Data Protection for Oracle. These utilities are located in the directory where Data Protection for Oracle is installed.

Tivoli Data Protection for Oracle Utilities

  • Use the tdpoconf (password & showenvironment) utility for password maintenance and general Data Protection for Oracle setup and maintenance.
  • Use the tdposync utility to delete the Oracle backups on the Tivoli Storage Manager server, which are not in the RMAN catalog or Oracle control file. You can use this utility when backups have not been deleted from the Tivoli Storage Manager server for various reasons.
  • Use the tdposync query utility to query backed up objects on the Tivoli Storage Manager server.

1) Tdpoconf password

When you have password related issues you can create a new password or change an existing password on the Tivoli Storage Manager server by using this utility.

tdpoconf password

2) Tdpoconf showenvironment

Use the showenvironment command to query the Tivoli Storage Manager server using the options set in –TDPO_OPTFILE. If the password file is not initialized properly, tdpoconf showenvironment reports this error immediately and prevents complications that can arise if this error were to go undetected.

tdpoconf showenvironment

3) Tdposync

The tdposync utility checks for items on the Tivoli Storage Manager server that are not in the RMAN catalog or Oracle control file. With this utility, you can repair these discrepancies between the Tivoli Storage Manager server and the RMAN catalog or Oracle control file. Running this command will open a "pick window" where you can select the database objects for deletion manually.

Syncdb command
This command synchronizes Oracle catalog databases or the Oracle control file with the Tivoli Storage Manager server.

tdposync syncdb

Query command
Use this command to query the Tivoli Storage Manager server for information about objects that have been backed up. You can obtain information such as whether an object has been compressed, encrypted, or deduplicated by the client during a backup operation.

tdposync query

All these utilities requires the options set in the -TDPO_OPTFILE parameter, the tdpo.opt file in the default installation directory, or the default values set by Data Protection for Oracle to query the Tivoli Storage Manager server.

Removing old backups Manually

Data Protection for Oracle uses the Tivoli Storage Manager server storage to store the oracle database backups. Each database backup creates a new object with a unique name. Since these objects have unique names, they always remain active and never expire. This allows the Database Administrator (DBA) to control and coordinate copies removed from the Tivoli Storage Manager server with RMAN.

The Tivoli Storage Manager administrator must specify backdelete=yes when registering your node in order for you to be able to delete backup objects. Make sure to use the same tdpo.opt file that was used for the original backup. This enables the backup objects to be found on the Tivoli Storage Manager server. To remove an old backup, issue this command from the RMAN prompt

run 
{
                          allocate channel for delete type ’sbt_tape’ parms
                                   ’ENV=(TDPO_OPTFILE=/home/oracle/tdpo.opt)’;
                        change backupset <backupsetnumber> delete; 
}

Troubleshooting Common problems in TDP for Oracle

If you face any issue during backing up oracle database or during connecting to TSM server using TDP for oracle, do the following steps.
  • Run the tdpoconf utility showenvironment command to collect information on your options file (–TDPO_OPTFILE=). It is a good practice to send the output to a separate file  by specifying (–outfile=).
  • If the above command ran successfully, check its output to see if the setup worked as expected.
  • If the above command failed, check the tdpoerror.log and dsierror.log files. The tdpoerror.log is a log file created in the installation directory by default. The dsierror.log is generated by the Tivoli Storage Manager API when a problem occurs with the Tivoli Storage Manager API setup.
  • Fix the problem shown in those log files and run the tdpoconf utility again.
  • The most common problems are password authentication issues, important configuration files read/write permissions and error log read/write permissions to the authorized user.
  • From the TSM server end, check the activity log for more information. Change in the client node mount point definition settings can also lead to client backup failures.
  • If you still dont know how to troubleshoot it, raise the IBM PMR support request by gathering all the required information.

How to configure IBM Tivoli Data Protection for Oracle (TDPO) and take the oracle database backup to TSM Server storage ?

00:47 No Comments
If you want to configure IBM Tivoli Data Protection for Oracle to protect your Oracle database, TDP for Oracle must be first installed on your system and a Tivoli Storage Manager server must be available to communicate with Data Protection for Oracle. You can perform full or partial, offline or online backups with Oracle. Once you identify which database to back up, Oracle locates all necessary files and sends them to the Tivoli Storage Manager server through Data Protection for Oracle. As a result, Data Protection for Oracle provides an interface between Oracle Media Management API calls and Tivoli Storage Manager API routines.

You must first register the Oracle machine as a client node in Tivoli Storage Manager Server with appropriate policy settings. The you need to configure the important TDPO configuration files such as tdpo.opt, dsm.opt and dsm.sys files in the Client side in order to start protecting the backup. In this post we will see how to register and define policy settings for TDP oracle node on TSM server end and then see how to configure those important configuration files from client end.

On Tivoli Storage Manager Server

1) Define Tivoli Storage Manager Policy Settings for TDP for Oracle node

Data Protection for Oracle requires special Tivoli Storage Manager policy domain settings. TDP for oracle uses RMAN utility to take the database backup. RMAN uses the format parameter in the RMAN script to generate unique backup file names. Because all backup objects inserted into the Tivoli Storage Manager backup storage pool have unique file names, they never expire on the Tivoli Storage Manager server.

While defining copy group parameters for TDP Oracle node, the recommended values for verdeleted and retonly is 0 because when Data Protection for Oracle marks a backup object inactive, that object is deleted from the Tivoli Storage Manager server the next time expiration processing occurs. A backup object is marked for immediate expiration when you delete it through RMAN using the Data Protection for Oracle interface or with the tdposync utility. The tdposync utility is used to remove unwanted backup objects from the Tivoli Storage Manager server. Remember that the inactive backup object cannot be restored through RMAN using the Data Protection for Oracle interface.

The following backup copy group options are not applicable to Data Protection for Oracle. Data Protection for Oracle accepts default values for these options.
  • frequency
  • verexists
  • retextra
  • mode
  • serialization

If you choose to define a new management class within an existing policy domain (not the default management class for that domain), then you must add an include statement to the Data Protection for Oracle options file to bind all objects to that management class. It is recommended to define a new policy for TDP for oracle backup.

2) Register TDP Oracle node on TSM Server

The Data Protection for Oracle node name and password must be registered to the Tivoli Storage Manager server before you can begin requesting backup and restore services.

You should register TDP Oracle node by specifying backdelete=yes in order for backup objects to be deleted. If it is not specified and a deletion request is made, the request fails and an error message displays.

register node tdponode tdpopasswd domain=domainname backdelete=yes maxnummp=2


ON TSM Client side

1) Link library files

After successful installation of TDP for Oracle on your system, make sure you link these both files as shown below.

$ORACLE_HOME/lib/libobk.a -> /usr/lib/libobk64.a

2) Configure Data Protection for Oracle tdpo.opt file

You must define options to control the way Data Protection for Oracle backs up and restores data. The Data Protection for Oracle options file, tdpo.opt, contains options that determine the behavior and performance of Data Protection for Oracle. The only environment variable Data Protection for Oracle Version 6.3 recognizes within an RMAN script is the fully qualified path name to the tdpo.opt file. For example

allocate channel t1 type ’sbt_tape’ parms
                              ’ENV=(TDPO_OPTFILE=/home/rman/scripts/tdpo.opt)’

The TDPO_OPTFILE variable must be specified in upper case characters only. If a fully qualified path name is not provided, Data Protection for Oracle uses the tdpo.opt file located in the Data Protection for Oracle default installation directory. If this file does not exist, Data Protection for Oracle fails. By default, the tdpo.opt file is located in the directory where Data Protection for Oracle is installed.

Change to the /usr/tivoli/tsm/client/oracle/bin64 directory and copy the tdpo.opt.smp file to tdpo.opt. Edit the tdpo.opt file to include these options

dsmi_orc_config  /usr/tivoli/tsm/client/oracle/bin64/dsm.opt 
dsmi_log  /usr/tivoli/tsm/client/oracle/bin64 (directory with write permissions)

 On Windows

 dsmi_orc_config C:\Program Files\Tivoli\TSM\AgentOBA\dsm.opt 
dsmi_log C:\Program Files\Tivoli\TSM\AgentOBA

optional parameters in this file are tdpo_owner, tdpo_pswdpath, tdpo_node, tdpo_mgmt_class2, tdpo_mgmt_class3.

3) Configure TSM client option (dsm.sys & dsm.opt) files

You must define some Tivoli Storage Manager options after the Data Protection for Oracle node is registered to the Tivoli Storage Manager server
  • These options are defined in the Tivoli Storage Manager client system options file (dsm.sys by default) and client user options file (dsm.opt by default).
  • Note that the Tivoli Storage Manager client user options file (dsm.opt by default) that you must edit for Data Protection for Oracle is located in the directory specified by the dsmi_orc_config option. If this option is not specified, Data Protection for Oracle looks for this options file in the Data Protection for Oracle installation directory.
  • The Tivoli Storage Manager client system options file (dsm.sys by default) must be located in the directory where the Tivoli Storage Manager API is installed.
  • Data Protection for Oracle provides sample Tivoli Storage Manager options files that you can modify for this purpose. These sample files are located in the Data Protection for Oracle installation directory.
  • You can also include other Tivoli Storage Manager client options  when configuring Data Protection for Oracle like compression, reduplication and enablelanfree parameters. Remember that The enablelanfree and deduplication options are mutually exclusive. Therefore, you can only use either one option or the other, but not both options together.

Go to this directory /usr/tivoli/tsm/client/oracle/bin64 and edit the dsm.opt file to include the server stanza as shown below

servername tsmserv

Change to the /usr/tivoli/tsm/client/api/bin64 directory and create a symbolic link to /usr/tivoli/tsm/client/ba/bin/dsm.sys. Edit the dsm.sys file to include another server stanza with the following options:

SErvername tsmserv
COMMMethod TCPip 
TCPServeraddress x.x.x.x 
PASSWORDAccess generate 
passworddir /home/<oracle user> 
nodename TDPONodeName

Make sure the Oracle user has the following permissions
  • Read (r) permission to the /usr/tivoli/tsm/client/oracle/bin64 and /usr/tivoli/tsm/client/api/bin64 directories.
  • Read permission (r-) to the tdpo.opt, dsm.opt, and dsm.sys files located in the /usr/tivoli/tsm/client/oracle/bin and /usr/tivoli/tsm/client/api/ bin directories.

4) Initializing Password for TSM Server authentication

Finally, The administrator must run the tdpoconf utility program to set the password before using Data Protection for Oracle. The utility uses the tdpo.opt file in the installation directory to centralize information for setup purposes. This utility helps to authenticate TDPO node password with TSM server and also to check the connection settings between TDPO node and TSM server.

Use the tdpoconf password command to create a new password or change an existing password on the Tivoli Storage Manager server. There are two different scenarios you can use this password command with passwordaccess parameter in dsm.sys file. For example 

passwordaccess prompt
Run the tdpoconf password command as the root user. This command creates an encrypted password file, TDPO.Nodename. This file is located in the directory specified by the tdpo_pswdpath option. If the tdpo_pswdpath option is not specified, the TDPO.Nodename file is placed in the Data Protection for Oracle installation directory. Make sure that the TDPO.Nodename file can be read by the Oracle user that performs the backup. The Nodename value will be the value specified by the tdpo_node option in the Data Protection for Oracle options file specified with the TDPO_OPTFILE variable.

passwordaccess generate
Run the tdpoconf password command as the Oracle user. The password is placed in the file, TSM.PWD, and is owned by the Oracle user. This TSM.PWD file is created in the directory specified by the passworddir option defined in the dsm.sys file. Do not specify the tdpo_node option in the tdpo.opt file. Data Protection for Oracle uses the value of the nodename option specified in the dsm.sys file. If the tdpo_pswdpath option is specified in the tdpo.opt file, it is ignored.

Change to the /usr/tivoli/tsm/client/oracle/bin64 directory and run the tdpoconf password command as Oracle user to generate the password file.

tdpoconf password 

Showenvironment command
Use the showenvironment command to query the Tivoli Storage Manager server using the options set in –TDPO_OPTFILE, the tdpo.opt file in the default installation directory, or the default values set by Data Protection for Oracle. The screen output displays information about the Tivoli Storage Manager API and Tivoli Storage Manager server. This command is useful when troubleshooting Data Protection for Oracle setup. If, for example, the password file is not initialized properly, tdpoconf showenvironment reports this error immediately and prevents complications that can arise if this error were to go undetected. 

Run the tdpoconf showenvironment command to confirm proper configuration.

tdpoconf show environment

5) Backup and Restore using TDP for Oracle

5.1) The Oracle user should invoke RMAN to back up and restore an Oracle database by using this command.

$>  rman target xxx/yyy@target rcvcat aaa/bbb@catalog
                         cmdfile bkdb.scr msglog bkdb.log

RMAN creates a log file (bkdb.log) in the current working directory. If an error occurs, you will see the error stack in the log file


5.2) To take the Oracle database backup as Oracle user, run your RMAN backup script with the ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt) parameter specified.

For example:

run {
        allocate channel t1 type ’sbt_tape’ parms
                 ’ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)’;
        allocate channel t2 type ’sbt_tape’ parms
                 ’ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt);
        backup
           filesperset 5
           format ’df_%t_%s_%p’
           (database);
}

This backup script allocates two parallel connections to the Tivoli Storage Manager server. The Tivoli Storage Manager server views these connections as two separate sessions.


5.3) To restore a backup, As Oracle user, run your RMAN restore script with the 
ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)

run
          {
          allocate channel t1 type ’sbt_tape’ parms
          ’ENV=(TDPO_OPTFILE=/home/oracle/tdpo.opt)’;
          allocate channel t2 type ’sbt_tape’ parms
          ’ENV=(TDPO_OPTFILE=/home/oracle/tdpo.opt)’;
          restore database;
          recover database;
          alter database open;
          }
On windows 

 Instead of  /usr/tivoli/tsm/client/oracle/bin64/tdpo.opt use 
C:\Program Files\Tivoli\TSM\AgentOBA\tdpo.opt


Subscribe to: Posts (Atom)