Dale, The best way to assure a copy pool matches its primary is perform a backup stg pool command and see if it completes successfully. I run a search of the activity log daily that picks out the message of primary pool volumes skipped because they are not available (marked unavailable). You can see the message in a backup stg command by marking a tape that has some data on it not in the copy pool as unavailable and running the backup stg command. I just do not remember the message id.
We also use the TEC interface to send the message to us when many conditions occur. Here is the select I run daily. select substr(cast(date_time as char(26)),1,16) as "date time", message as "Message " from actlog where date_time >current_timestamp - 24 hours - 5 minutes and (msgno = 8359 or msgno = 8302 or msgno = 1412 or msgno = 1229 or msgno = 1402 or msgno = 1440 or msgno = 8873) Paul D. Seay, Jr. Technical Specialist Naptheon, INC 757-688-8180 -----Original Message----- From: Jolliff, Dale [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 7:33 AM To: [EMAIL PROTECTED] Subject: Re: Occupancy comparison script We are just trying to do sanity checks prior to shipping offsite copypools off for a DR exercise. -----Original Message----- From: Seay, Paul [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 11:19 PM To: [EMAIL PROTECTED] Subject: Re: Occupancy comparison script They often do not exactly match because of the agregates and other factors related to expiration, but they are usually close. May I ask what the problem is you are trying to solve that you think the successful completion of a backup stgpool command does not? Paul D. Seay, Jr. Technical Specialist Naptheon, INC 757-688-8180 -----Original Message----- From: Jolliff, Dale [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 3:02 PM To: [EMAIL PROTECTED] Subject: Occupancy comparison script I know someone has already invented this wheel... I need to create a script to compare occupancy of primary sequential pools to copypools to verify a complete stgpool backup. Anyone got one handy that won't bring a server to it's knees?
