What our DBAs discovered was that the export was not being taken with "Consistency=Yes". The reason was that they were exporting the DB using the "SYS" user. This user did not have access to be able to do a consistency export. They have since changed their export procedure and are now able to get us a consistent export.
Sean From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Guillaume Rheault Sent: Thursday, September 24, 2009 5:05 PM To: arslist@ARSLIST.ORG Subject: Re: Help with exporting an Oracle DB .... ** Any reason why you cannot do a hot database backup and restore that in the lower environments? It should be much faster too... -Guillaume -----Original Message----- From: Action Request System discussion list(ARSList) on behalf of Garrison, Sean (Norcross) Sent: Thu 09/24/09 8:34 AM To: arslist@ARSLIST.ORG Subject: Help with exporting an Oracle DB .... We have a 24x7 remedy system that runs on an Oracle DB. We are trying to get an export from production into our lower environments. We are unable to just lock out users in order to do an export. Whenever we try to do this the count of the "T" vs "H" tables are different. Basically what is happening is oracle is exporting the "H" tables first and then later gets to the "T" tables. In between the exports new records were created on a form which causes the "T" tables to have more records than the "H" tables do. There is an option called "Consistency=Yes" when doing an export that is supposed to go back and synch up all of the data but from our experience that isn't happening. The export doesn't have to be real-time but does have to have consistent data. I was wondering if there was a way to pass in an date into the export file so that no records created after a certain date get included -- or something to that effect. Any suggestions or ideas on how to get an Oracle export of a Remedy db? Thanks, Sean _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
