Hi, Thank you for the detailed explanation. We even follow the steps you have highlighted to backup the oracle db to TSM server. We missed out running "crosscheck backup" & "resync catalog" command after the backup schedule , so that the TSM has the same set of image as in RMAN catalog. Now we have added these commands to the backup script.
We wanted to monitor whether the RMAN catalog & TSM are in syn. I felt that instead of running "tdposync" manually once a while, we can automate this process. When I ran the below command in my script and redirecting to output to a file. It was generating a huge file and was going on indefinite loop. If you have automated this tdposync process, do share you process. /usr/tivoli/tsm/client/oracle/bin64/tdposync syncdb -tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo_prd.opt << 'start' rmancat <password> rmancat 'start' Thanx for your detailed mail. Regards, Rajesh -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[email protected]] On Behalf Of Grigori Solonovitch Sent: Friday, January 18, 2013 12:48 PM To: [email protected] Subject: Re: [ADSM-L] AUto Sync of TDP backup and RMAN catalog Hello, Maybe I do not understand your request, but I will try to give you some solution. To enable automatic retention in RMAN catalog you need to set recovery window for each database (in my case it is for Oracle instance ifns and 31 DAYS is a recovery window, which has to be in sync with TSM retention period for the same database): #!/bin/sh # export ORACLE_SID=ifns export ORACLE_BASE=/home/oracle export ORACLE_HOME=`grep "ifns:" /etc/oratab | head -n1 | cut -f2 -d":"` export PATH=$ORACLE_HOME/bin:$PATH export TNS_ADMIN=$ORACLE_HOME/network/admin # # Configure backup policy rman <<EOF # # Connect to Recovery Manager Catalog Database connect catalog $RC_USER/$RC_PASSWORD@$RC_SERVICE; # # Connect to target database connect target; # # Set retention policy CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 31 DAYS; # # Set compression mode #CONFIGURE DEVICE TYPE sbt_tape BACKUP TYPE TO COMPRESSED BACKUPSET; # EOF exit In addition, you need to run daily RMAN crosscheck for each database, something like this (key command in this script is "crosscheck backup": #!/bin/sh # # Cross-check Recovery Catalog and TSM database # # Input parameters: # 1 - database SID. # export ORACLE_SID=$1 export ORACLE_HOME=`grep "$1:" /etc/oratab | head -n1 | cut -f2 -d":"` export PATH=$ORACLE_HOME/bin:$PATH export TNS_ADMIN=$ORACLE_HOME/network/admin # ####################################################################### # Remove expired datafiles, control files and archived redo log files # ####################################################################### rman <<EOF # # Connect to Recovery Catalog database connect catalog $RC_USER/$RC_PASSWORD@$RC_SERVICE; # # Connect to target database connect target; # # Allocate channel for maintenance allocate channel for maintenance type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/home/oracle/admin/tdpo/$1.opt)'; # # Set date and time format sql 'alter session set NLS_DATE_FORMAT = "YYYY-MM-DD:HH24:MI:SS"'; # # Resynchronize catalog resync catalog; # # List database incarnations list incarnation; # # List backups list backup summary; # # Crosscheck backups crosscheck backup; # # List expired backups list expired backup summary; # # Delete expired backups delete noprompt expired backup; # # Delete obsolete backups delete noprompt obsolete; # # Release channel release channel; # # Allocate channel for maintenance allocate channel for maintenance type disk; # # Check archived logs on disk crosscheck archivelog all; # # Remove obsolete archived redo logs delete noprompt expired archivelog all; # # Release channel release channel; # exit; EOF exit 0 After implementing this solution I never use tdposync except some crazy cases. Kindest regards, Grigori G. Solonovitch Senior Technical Architect Ahli United Bank Kuwait www.ahliunited.com.kw Please consider the environment before printing this E-mail -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[email protected]] On Behalf Of Lakshminarayanan, Rajesh Sent: 18 01 2013 6:21 AM To: [email protected] Subject: [ADSM-L] AUto Sync of TDP backup and RMAN catalog Hi, We have been backing the Oracle db to TSM through TDP api. And we have been syncing the RMAN catalog and TSM through "TDPOSYNC" command manually. Just want to check with you, it there a way to automate this process and has any one tired it before. Regards, Rajesh Lakshminarayanan Please consider the environment before printing this Email. CONFIDENTIALITY AND WAIVER: The information contained in this electronic mail message and any attachments hereto may be legally privileged and confidential. The information is intended only for the recipient(s) named in this message. If you are not the intended recipient you are notified that any use, disclosure, copying or distribution is prohibited. If you have received this in error please contact the sender and delete this message and any attachments from your computer system. We do not guarantee that this message or any attachment to it is secure or free from errors, computer viruses or other conditions that may damage or interfere with data, hardware or software.
