Re: PeopleSoft DBA Forum Databases Refreshes
- Thank you all for some very useful suggestions. My goal if possible
is to have a lights out refresh process.
As background we do refreshes by dropping sysadm and importing
objects. Yeah I could physically recreate everything but in our case
we only refresh every month or so and timing is not so of the
essence. The import used to take 4 hours but I busted up the export
in 10 files, run the import in parallel and have it down to 1hr 5min
which again is really moot for me as a refresh over the weekend and
not so often. Lots of different ways to skin this cat.
Updating the report and server nodes was one of my manual
intervention points that I was trying to eliminate and thanks for the
great feedback. The other intervention point for me concerns
projects. Developers have read only access to test here, the business
analysts do all the testing. So , the admins migrate all the
projects. During a db refresh we have to export all of the projects
and then cony from file/build again after the refresh.
Is is possible to script the exporting and then subsequent copy from
file/build of projects or am I just trying to over engineer something
here that is not practical.
--- In email@example.com, "Ken Warren" <ken.warren@U...> wrote:
> Obvious caveats: amount of data / d.b.a skills available ... but
> We found refreshes to be much much quicker using the physical
> copying the datafiles and recreating the controlfile.
> Soon we'll be using RMAN to do this part too.
> -----Original Message-----
> From: Montgomerie Steve [mailto:steve.montgomerie@s...]
> Sent: Monday, July 26, 2004 2:07 PM
> To: 'firstname.lastname@example.org'
> Subject: PeopleSoft DBA Forum Databases Refreshes
> Hi All,
> We are using PeopleSoft 8.18 Tools and HRMS 8.1.
> When we do database refreses (ie load new data into tst) we
> drop all of sysadm's objects
> and then import an Oracle dump file from production. Once this
> completed we go through App Designer
> to update the report node and server node so that the point to
> production. Is there any way to do this programmatically
> through updating the tables in Oracle? Does anyone know what those
> tables might be?
> Steve Montgomerie
> PeopleSoft/Oracle Administrator
> SIEMENS Shared Services, LLC
> PeopleSoft for the Oracle DBA will be published by Apress in
> The PeopleSoft DBA Forum is managed by http://www.go-faster.co.uk
> Yahoo! Groups Sponsor
> Yahoo! Groups Links
> a.. To visit your group on the web, go to:
> b.. To unsubscribe from this group, send an email to:
> c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of