You will not get one finite list - you will but this list will greatly depend on what applications you have selected as also some of the many installation choices you can make while installing the AR System as well as the other applications. There are at least as many as 10 different combinations if not more of different choices you can make along all the installations that will change the list of objects that get installed or upgraded during any installs or upgrades. So I think they are looking at the wrong place to shorten the time taken for a backup and restore.
The 15 hours to backup has nothing to do with the number of applications that you have installed - it has but its not what takes that significant amount of extra time. It is the amount of 'application data' that you have stored in your system and perhaps some of the configuration data and / or foundation data that impacts this time. So if your data (application, configuration, foundation) is important to you when you want to restore from that backup, it is what it is. In most cases it is the application data that fattens the database. If your application data is not that important to you when you want to restore the backup, then you could opt not to backup the application data but just the meta, foundation and configuration data. This can bring down the time of your backup and restore - especially if the purpose of this backup and restore is to refresh the production database to your development servers for staging a refreshed development environment. Oracle, if you are on Oracle, has the capability to "programatively" select objects that need to be backed up, when using the exp and imp utility to export and import by controlling the content using par files that contain parameters that can limit what you export and import. MS-SQL and other supported databases may have similar tools but I'm not a big MS-SQL expert so I won't promise you it can. I guess the question here is, "What are you trying to resolve by that backup?" Is it to restore the whole database in case of a database corruption? If so your stakeholders might as well jump out of the window as it is what it is. There is no real shortcut if that is what you are attempting to resolve. You might also want to check out the options you have for archiving old data if the purpose of your backup is data preservation. Joe _____ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Campbell, Paul (Paul) Sent: Tuesday, February 05, 2013 3:30 PM To: arslist@ARSLIST.ORG Subject: List of table modifications and data additions done by 7.6.04 SP4 upgrade We are upgrading our 7.5 Solaris/Oracle custom apps arserver to 7.6.04 SP4 and my change control group and DBAs are wanting to what tables are modified (and what are the changes) and how many data records are inserted/updated as part of the upgrade process. Are these changes documented anywhere, or can I explode the installer and find the changes? I know I can look at the def files that get imported, but I was wondering if any direct SQL changes are being done as well? Part of the reason the DBAs are asking is it takes 15 hours to backup our db and they are predicting up to a 30 hour restore window in case of some failure, for which my business stakeholder almost jumped out the window when I said that, so we are trying to see if we can limit the amount of tables/data we would have to rollback. Thanks in advance Paul Campbell | Development Team Lead | TS&D SSBL, A2R WFE, and ESP Remedy Team | Avaya Client Services | | 1145 Sanctuary Parkway Lake View II Suite 110 Alpharetta, GA 30009 | 678-421-5342 Everyone needs deadlines. Even the beavers. They loaf around all summer, but when they are faced with the winter deadline, they work like fury. If we didn't have deadlines, we'd stagnate. Walt Disney _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
