Re: Changing Retention
Kirti, If the retension period change has to be performed for all nodes in this domain (I hope those nodes are Oracle only) the copygroup has to be updated. If only one node needs this change I would suggest you to define new domain with appropriate ARCHRETension setting, rename the node to _old, re-register the node again and move the node to this domain (UPDate Node DOMain=). Old archives will stay as new name, new archives will go to re-registered old_name. You *CANNOT* rebind archives, only backups can be rebound. If you change the mgmtclass in inclexcl list old archives will stay with old class (and short retension) and new archives will be made with new class (and long retension). All those tasks have to be done at the TSM server. You are writing about "SAs". If this is Storage Administrators, i.e. TSM admins, they have to do it. Being only a user of TSM you can only retrieve and re-archive. Somebody still should define the longer retension management class. TDP for Oracle in very simplified overview may be thought as interface wrapper. RMAN calls TDPO through Oracle specified APIs, TDP transforms the request to TSM APIs and calls TSM API client, TSM API client moves the data to TSM server. It is separately priced product and for small Oracle installations and those which allow off-line backup some customers prefer not to buy it and use only B/A client. Oracle DBAs for sure should know if you have it because RMAN has to be configured to use TDPO. Zlatko Krastev IT Consultant "Deshpande, Kirti" <[EMAIL PROTECTED]> on 16.01.2002 19:21:31 Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] cc: Subject:Changing Retention Hi, Is there any way to change retention for already archived set of files? We have archived a number of files for an Oracle database with the default setting for the Management Class (4week retention). The need is to make sure this set is preserved beyond the 4week retention time. Thanks. - Kirti
Re: Changing Retention
We thought about that. But the archived set uses the default Mgmt Class which is used by several other archive jobs. The need was to selectively change the retention of this set of files to over 1 year. It's not a big deal to re-archive it as the set is not that large to handle. Thanks. - Kirti -Original Message- From: Steve Harris [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 17, 2002 9:15 PM To: [EMAIL PROTECTED] Subject: Re: Changing Retention If the situation is a short term one time thing, you can change your management class retention period for the affected management calss until the need has passed and then change it back. Whilst I have a lot of management classes for ad-hoc archives arch_1M, arch_1y and so on, for any application that has an archive requirement I give them their own archive management class that is named by function rather than retention period specifically so that it can be changed easily when requirements change Steve Harris AIX and TSM Admin Queensland Health, Brisbane Australia ** This e-mail, including any attachments sent with it, is confidential and for the sole use of the intended recipient(s). This confidentiality is not waived or lost if you receive it and you are not the intended recipient(s), or if it is transmitted/ received in error. Any unauthorised use, alteration, disclosure, distribution or review of this e-mail is prohibited. It may be subject to a statutory duty of confidentiality if it relates to health service matters. If you are not the intended recipient(s), or if you have received this e-mail in error, you are asked to immediately notify the sender by telephone or by return e-mail. You should also delete this e-mail message and destroy any hard copies produced. **
Re: Changing Retention
If the situation is a short term one time thing, you can change your management class retention period for the affected management calss until the need has passed and then change it back. Whilst I have a lot of management classes for ad-hoc archives arch_1M, arch_1y and so on, for any application that has an archive requirement I give them their own archive management class that is named by function rather than retention period specifically so that it can be changed easily when requirements change Steve Harris AIX and TSM Admin Queensland Health, Brisbane Australia ** This e-mail, including any attachments sent with it, is confidential and for the sole use of the intended recipient(s). This confidentiality is not waived or lost if you receive it and you are not the intended recipient(s), or if it is transmitted/ received in error. Any unauthorised use, alteration, disclosure, distribution or review of this e-mail is prohibited. It may be subject to a statutory duty of confidentiality if it relates to health service matters. If you are not the intended recipient(s), or if you have received this e-mail in error, you are asked to immediately notify the sender by telephone or by return e-mail. You should also delete this e-mail message and destroy any hard copies produced. **
Re: Changing Retention
Thanks for the information. All we have are home grown scripts invoking 'dsmc' command to 'archive' database files. We do not use 'backup' for these files. The solution we have come to is to 'retrieve' the files and perform another 'archive' with new Management Class having desired retention period. Thanks. - Kirti -Original Message- From: Salak Juraj [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 17, 2002 9:10 AM To: [EMAIL PROTECTED] Subject: Re: Changing Retention Hi, Oracle TDP is Tivoli Data Protection for Oracle, which is the Oracle backup agent, which is TSM client able to backup oracle. If I read your question correctly you backup oracle with standard tsm client (cold backup with oracle shut-off), and then yes, you can rebind your files as long they exist in oroginal file system by simply backing them again using new management class. Alternatively you can update (and activate) the management class previously used. regards juraj -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 17, 2002 2:45 PM To: [EMAIL PROTECTED] Subject: Re: Changing Retention Paul, Thanks for the suggestion. I am new to ADSM. I am an Oracle DBA. Trying to understand some of these things with ADSM. I will talk to our SAs about this and see if it feasible. I do not know what Oracle TDP is. So I do not know if we are using it or not. But my wild guess is : not (else someone would have informed the Oracle DBAs). Regards, - Kirti -Original Message- From: Seay, Paul [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 5:43 PM To: [EMAIL PROTECTED] Subject: Re: Changing Retention You can rebind the files to a new management class with the new retention and I think this will take care of you, but I have not read up on this. I presume you are not using the Oracle TDP. -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 12:22 PM To: [EMAIL PROTECTED] Subject: Changing Retention Hi, Is there any way to change retention for already archived set of files? We have archived a number of files for an Oracle database with the default setting for the Management Class (4week retention). The need is to make sure this set is preserved beyond the 4week retention time. Thanks. - Kirti
Re: Changing Retention
Hi, Oracle TDP is Tivoli Data Protection for Oracle, which is the Oracle backup agent, which is TSM client able to backup oracle. If I read your question correctly you backup oracle with standard tsm client (cold backup with oracle shut-off), and then yes, you can rebind your files as long they exist in oroginal file system by simply backing them again using new management class. Alternatively you can update (and activate) the management class previously used. regards juraj -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 17, 2002 2:45 PM To: [EMAIL PROTECTED] Subject: Re: Changing Retention Paul, Thanks for the suggestion. I am new to ADSM. I am an Oracle DBA. Trying to understand some of these things with ADSM. I will talk to our SAs about this and see if it feasible. I do not know what Oracle TDP is. So I do not know if we are using it or not. But my wild guess is : not (else someone would have informed the Oracle DBAs). Regards, - Kirti -Original Message- From: Seay, Paul [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 5:43 PM To: [EMAIL PROTECTED] Subject: Re: Changing Retention You can rebind the files to a new management class with the new retention and I think this will take care of you, but I have not read up on this. I presume you are not using the Oracle TDP. -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 12:22 PM To: [EMAIL PROTECTED] Subject: Changing Retention Hi, Is there any way to change retention for already archived set of files? We have archived a number of files for an Oracle database with the default setting for the Management Class (4week retention). The need is to make sure this set is preserved beyond the 4week retention time. Thanks. - Kirti
Re: Changing Retention
Paul, Thanks for the suggestion. I am new to ADSM. I am an Oracle DBA. Trying to understand some of these things with ADSM. I will talk to our SAs about this and see if it feasible. I do not know what Oracle TDP is. So I do not know if we are using it or not. But my wild guess is : not (else someone would have informed the Oracle DBAs). Regards, - Kirti -Original Message- From: Seay, Paul [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 5:43 PM To: [EMAIL PROTECTED] Subject: Re: Changing Retention You can rebind the files to a new management class with the new retention and I think this will take care of you, but I have not read up on this. I presume you are not using the Oracle TDP. -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 12:22 PM To: [EMAIL PROTECTED] Subject: Changing Retention Hi, Is there any way to change retention for already archived set of files? We have archived a number of files for an Oracle database with the default setting for the Management Class (4week retention). The need is to make sure this set is preserved beyond the 4week retention time. Thanks. - Kirti
Re: Changing Retention
You can rebind the files to a new management class with the new retention and I think this will take care of you, but I have not read up on this. I presume you are not using the Oracle TDP. -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 12:22 PM To: [EMAIL PROTECTED] Subject: Changing Retention Hi, Is there any way to change retention for already archived set of files? We have archived a number of files for an Oracle database with the default setting for the Management Class (4week retention). The need is to make sure this set is preserved beyond the 4week retention time. Thanks. - Kirti
Re: Changing Retention
Dwight, Thanks for reply. I was afraid we may have to re-archive those file. You are right about the client focus etc.. but in this case, the Client is the darn Damagement! Thanks. - Kirti -Original Message- From: Cook, Dwight E (SAIC) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 12:34 PM To: [EMAIL PROTECTED] Subject: Re: Changing Retention The only way is to 1) retrieve the files and re-archive with a management class of the desired retention 2) DO NOT RUN ANY "EXPIRE INVENTORY" and then I won't guarantee anything... 3) Rename the node, set up another domain with an archive grace period of how long you need the data, that DOES NOT have the management class to which the files are currently bound, and move that node over to that domain... AND I WON'T GUARANTEE ANYTHING... and you will still need to re-register the node as it was before. Yes, we need to be client focused but a lack of planning on their part does not constitute an emergency on ours... Also it is a security thing... if you could extend the retention period, you could also reduce it. Granted we, as admins, can just delete it, but having things as they are does provide a little extra security. Dwight -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 11:22 AM To: [EMAIL PROTECTED] Subject: Changing Retention Hi, Is there any way to change retention for already archived set of files? We have archived a number of files for an Oracle database with the default setting for the Management Class (4week retention). The need is to make sure this set is preserved beyond the 4week retention time. Thanks. - Kirti
Re: Changing Retention
The only way is to 1) retrieve the files and re-archive with a management class of the desired retention 2) DO NOT RUN ANY "EXPIRE INVENTORY" and then I won't guarantee anything... 3) Rename the node, set up another domain with an archive grace period of how long you need the data, that DOES NOT have the management class to which the files are currently bound, and move that node over to that domain... AND I WON'T GUARANTEE ANYTHING... and you will still need to re-register the node as it was before. Yes, we need to be client focused but a lack of planning on their part does not constitute an emergency on ours... Also it is a security thing... if you could extend the retention period, you could also reduce it. Granted we, as admins, can just delete it, but having things as they are does provide a little extra security. Dwight -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 11:22 AM To: [EMAIL PROTECTED] Subject: Changing Retention Hi, Is there any way to change retention for already archived set of files? We have archived a number of files for an Oracle database with the default setting for the Management Class (4week retention). The need is to make sure this set is preserved beyond the 4week retention time. Thanks. - Kirti
