Restore system objects to new WIN 2K client
** Entertainment UK Limited Registered Office: 243 Blyth Road, Hayes, Middlesex UB3 1DN. Registered in England Numbered 409775 This e-mail is only intended for the person(s) to whom it is addressed and may contain confidential information. Unless stated to the contrary, any opinions or comments are personal to the writer and do not represent the official view of the company. If you have received this e-mail in error, please notify us immediately by reply e-mail and then delete this message from your system. Please do not copy it or use it for any purposes, or disclose its contents to any other person. Thank you for your co-operation. ** Dear TSMers, We are having a problem either querying or restoring system objects on a new WIN2K client. We are testing the restore process and have installed WIN2K on a new server and changed the nodename in dsm.opt to the name of the original server. We can restore the data, but not the system objects. On the new server from dsmc, query systemobject results in no match, If we run the same command on the original server, we get a list of objects returned. Likewise on the new server, checking the system object from the GUI to restore, does not expand to give us any objects, although again the original server indicates system objects can be restored from the GUI. TIA George
archive or incremental backup type
** Entertainment UK Limited Registered Office: 243 Blyth Road, Hayes, Middlesex UB3 1DN. Registered in England Numbered 409775 This e-mail is only intended for the person(s) to whom it is addressed and may contain confidential information. Unless stated to the contrary, any opinions or comments are personal to the writer and do not represent the official view of the company. If you have received this e-mail in error, please notify us immediately by reply e-mail and then delete this message from your system. Please do not copy it or use it for any purposes, or disclose its contents to any other person. Thank you for your co-operation. ** I would like to get some advice on the advantages / disadvantages of archive versus incremental backup types. The files I am backing up are database files so in general are large and need to be restorable to point in time for consistency. Thanks
Re: archive or incremental backup type
Most of the database backups will be Oracle databases. Currently we do not have the option of using TDP, so we will either take hot or cold database backups. If space permits we will backup to disk first then start the dsmc. The main database recovery requirement is consistency between files, so the restored files must all come from the SAME backup. Daniel Sparrman [EMAIL PROTECTED]@VM.MARIST.EDU on 29/04/2002 14:37:05 Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject: Re: archive or incremental backup type Hi Incremental = Minimizes your backup window, as only changed files are moved. However, you could activate subfile backup, which means that only the changed part of the file is backed up. Incremental works best with smaller files, as large files requires that the complete file is backed up. Subfile cache would perhaps work good also with large files, as only the changed part of the file is backed up. However, normlly a database doesn't work as ordinary large file, as there is to much changes in the file. Archive = Best for storing files for a specific amount of days/month/years. However, archiving is like doing full backups all the time, which makes a cost in backup time. Normally for databases, you use a TDP to minimize the time required for backup. Different types of TDP:s have different ways of backing up; differential, incremental, log archiving, full backups and so on. But, if you do hot backups, it's recommended to use TDP:s, as a file backup client doesn't work 100%(some files may have been locked by the application during the backup. This can be solved by using Dynamic setting, but this doesn't automatically mean 100% consistency when trying to restore). It would be easier to do a recommendation if you told us what kind of application you are using. For some applications, doing incremental/archiving works great, for some it's a disaster. If you still insist on using file backup/archive client, I'd recommend using cold backups, using archive. This could be done on perhaps a weekly basis. Best Regards Daniel Sparrman --- Daniel Sparrman Exist i Stockholm AB Propellervägen 6B 183 62 HÄGERNÄS Växel: 08 - 754 98 00 Mobil: 070 - 399 27 51 George Harding [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 2002-04-29 10:51 Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:archive or incremental backup type I would like to get some advice on the advantages / disadvantages of archive versus incremental backup types. The files I am backing up are database files so in general are large and need to be restorable to point in time for consistency. Thanks
TSM backup type (non TDP) for Oracle files
** Entertainment UK Limited Registered Office: 243 Blyth Road, Hayes, Middlesex UB3 1DN. Registered in England Numbered 409775 This e-mail is only intended for the person(s) to whom it is addressed and may contain confidential information. Unless stated to the contrary, any opinions or comments are personal to the writer and do not represent the official view of the company. If you have received this e-mail in error, please notify us immediately by reply e-mail and then delete this message from your system. Please do not copy it or use it for any purposes, or disclose its contents to any other person. Thank you for your co-operation. ** Dear All, I am investigating a TSM backup strategy for Oracle databases (online and offline database backups). We do not have TDP as an option yet so I need to back up using traditional TSM methods. I am interested to hear what arguments there are in favor and against using either TSM incremental or archive backup types to ensure recoverability of the database. Some of the issues are:- Oracle archived redo (transaction logs) need to be backed up regularly throughout the day, other database files generally are backed up once per day or less frequently. In case of restore, point in time restore of all Oracle data files is required to ensure consistency between Oracle database files. Larger databases may have read only files (Oracle readonly tablespaces) which do not need to be backed up as regularly as the remainder of the database but must be available to be restored in a point in time restore Many databases also interface with external files e.g. video clips, image files which must be consistent with the database for point in time restore. If the main database files are backed up less often e.g. weekly the required restore process may require restoring all database files to point in time e.g. to last weekly backup and then restoring all database redo logs backed up since up to the recovery time required. Looking at the ADSM-L archives, many people seem to use TSM archive backup for Oracle databases if they are not using TDP, but I'm not sure why a dsmc incremental wouldn't be just as good as long as the versioning parameters (VEREXISTS, VERDELETED) were set appropriately. Also what are the recommendations of storage pool configuration for backing up databases and associated files. TIA George
