Oracle Corner

Test case on duplicating database with RMAN and Tivoli

Database to be refreshed: SvD on testsv

Source, production database: SvP on prodsv

Check the existing set-up

Check whether Tivoli environment has already been set

Test server: testsv

• Find out whether you are using 32-bit or 64-bit oracle
• file $ORACLE_HOME/bin
• If 32-bit => cd /opt/tivoli/tsm/client/oracle/bin
• If 64-bit => cd /opt/tivoli/tsm/client/oracle/bin64
• Check whether the file tdpo-SvP.opt exist in the directory
• If not, ftp/scp it from the production server
• tdpoconf SHOWENVironment -TDPO_OPTfile=tdpo-SvP.opt
• The results should be like:
• IBM Tivoli Storage Manager for Databases:
• Data Protection for Oracle
• Version 5, Release 2, Level 0.0
• (C) Copyright IBM Corporation 1997, 2003. All rights reserved.
• DATA PROTECTION FOR ORACLE INFORMATION
• Version: 5
• Release: 2
• Level: 0
• Sublevel: 0
• Platform: 32bit TDP Oracle SUN
• TSM SERVER INFORMATION
• Server Name: prodsvO
• Server Address: TSMB1
• Server Type: Solaris 8/9
• Server Port: 1500
• Communication Method: TCP/IP
• SESSION INFORMATION
• Owner Name: oracle
• Node Name: prodsvO
• Node Type: TDP Oracle SUN
• DSMI_DIR: /opt/tivoli/tsm/client/api/bin
• DSMI_ORC_CONFIG: /opt/tivoli/tsm/client/oracle/bin/dsmo_temp.opt
• TDPO_OPTFILE: tdpo-SvP.opt
• Password Directory: /opt/tivoli/tsm/client/oracle/bin
• Compression: FALSE
• If the node name and server name (both in bold, red fonts) are the same as the TSM name for the production server, then the Tivoli environment is set up
  
• If they are different or if you get an error:
  
• Proceed to the next section
• TSM sever names might be different from the real server names
• If not sure, run the tdpoconf command on the production server to see

Set-up Tivoli environment

Test server: testsv

• ftp or scp the server password file
• ftp prodsv
• > bin
• > get /opt/tivoli/tsm/client/oracle/bin/TDPO.PRODSVO
• Change the tdpo-SvP.opt
• Change the line
• DSMI_ORC_CONFIG /usr/bin/dsmo.opt
• into
• DSMI_ORC_CONFIG /opt/tivoli/tsm/client/oracle/bin/dsmo_temp.opt
• Create a new file called /opt/tivoli/tsm/client/oracle/bin/dsmo_temp.opt with only 2 lines:
• SErvername prodsvo
• quiet
• Make a copy of /opt/tivoli/tsm/client/api/bin/dsm.sys (or /bin64 for 64-bit)
• Add the entries to the /opt/tivoli/tsm/client/api/bin/dsm.sys file
• Use the backup server from the source server
• If not sure, check the dsm.sys file on the production server and immitate
• Example, if prodsvo is using tmsb1 on the port 1500, add these lines at the bottom of the file
• SErvername prodsvo
• COMMmethod TCPip
• TCPPort 1500
• TCPServeraddress tsmbp1
• inclexcl /opt/tivoli/tsm/client/ba/bin/inclexcl
• Nodename prodsvo
• passwordaccess prompt
• schedlogname /var/applogs/backup/dsmsched.log
• errorlogname /var/applogs/backup/dsmerror.log

Key words
ANS1302E (RC2) No objects on server match query
ANS1353E (RC53) Session rejected: Unknown or incorrect ID entered
Tivoli RMAN "duplicate database" "Tivoli environment"