Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle Applications Development Database Refresh

RE: Oracle Applications Development Database Refresh

From: April Wells <awells_at_csedge.com>
Date: Tue, 09 Jul 2002 05:33:21 -0800
Message-ID: <F001.00492275.20020709053321@fatcity.com> 





Be careful who you get when you open the tar... there is one chick in Denver
who INSISTS on repeatedly reading you the whitepaper over the phone, and
INSISTS that bad things CAN'T happen in a clone (they can... I have had two
failed clones... one I believed them and manually fixed every file and it
took a month to get it repaired... the other I did not believe them,
restored and fixed it in two days).  There is a white paper on Metalink that
will walk you through it.. but make sure you have a good backup before you
start.  It is very straight forward and very step by step, but it can still
fail.  You do not have to do a fresh install before each clone, don't let
anyone tell you different.  You have to do ONE install on the target system.
The procedure for 11i is (from what I understand) much easier than for 10.7.



April Wells


Oracle DBA (Oracle OCP 8, 8i)


Corporate Systems


Amarillo Texas



-----Original Message-----


Sent: Tuesday, July 09, 2002 7:43 AM


To: Multiple recipients of list ORACLE-L




You will want to open a TAR on this.  There is a lengthly procedure document
that Oracle will provide for doing an Apps Clone on 11i.  There are issues 
with just duplicating the executables and database.  I got out of Apps on
10.7, but remember that a doc was being written by Oracle as of the 2001 
Open World for 11i.



HtH,



John P Weatherman


Database Administrator


Replacements Ltd.





-----Original Message-----


Sent: Monday, July 08, 2002 11:43 PM


To: Multiple recipients of list ORACLE-L




If anyone has refreshed the Dev database from the Production database Oracle
HRMS 11/11I successful, please tell me how to do it ? Thanks.



Regds,


New Bee

		-----Original Message-----
		From:	Scott.Shafer_at_dcpds.cpms.osd.mil
[mailto:Scott.Shafer_at_dcpds.cpms.osd.mil]
		Sent:	Tuesday, July 09, 2002 6:25 AM
		To:	Multiple recipients of list ORACLE-L
		Subject:	RE: Oracle Applications Development Database


Refresh



                My apps person tells me that they just restore the db and
the applmgr stuff


                works fine with 10.7.  Its sloppier than restoring the
appl_top as well, but


                works.  11/11i being an entirely different animal.


		Scott Shafer
		San Antonio, TX
		210-581-6217




		> -----Original Message-----

		> From:	Jared.Still_at_radisys.com

[SMTP:Jared.Still_at_radisys.com]


		> Sent:	Monday, July 08, 2002 5:06 PM

		> To:	Multiple recipients of list ORACLE-L

		> Subject:	RE: Oracle Applications Development Database

Refresh


		> 

		> Thanks Scott, but the applmgr stuff is where the details

are.


		> 

		> 

		> 

		> 

		> 

		> 

		> Scott.Shafer_at_dcpds.cpms.osd.mil

		> Sent by: root_at_fatcity.com

		> 07/08/2002 11:23 AM

		> Please respond to ORACLE-L

		> 

		>  

		>         To:     Multiple recipients of list ORACLE-L

		> <ORACLE-L_at_fatcity.com>

		>         cc: 

		>         Subject:        RE: Oracle Applications

Development Database


		> Refresh

		> 

		> 

		> Jared, we do that here, but just:

		> take a cold backup of the production db, 

		> lay it down over the old dev db (via scp or tape), 

		> and open it renaming with a backup cpontrolfile script. 

		> 

		> Works like a charm, though I'm not sure what applmgr steps

are required.


		> 

		> Scott Shafer

		> San Antonio, TX

		> 210-581-6217

		> 

		> 

		> > -----Original Message-----

		> > From:          Jared.Still_at_radisys.com

[SMTP:Jared.Still_at_radisys.com]


		> > Sent:          Friday, July 05, 2002 5:43 PM

		> > To:            Multiple recipients of list ORACLE-L

		> > Subject:               Oracle Applications Development

Database Refresh


		> > 

		> > Fellow listers,

		> > 

		> > In addition to the usual SAP system that runs most of

our company, we 


		> have

		> > Oracle Apps 10.7 HR.  For some reason the HR folks

didn't like the SAP 


		> HR

		> > module, so I have SAP and Oracle Apps.

		> > 

		> > The problem is a request I have to refresh the Dev

database from the 


		> > Production database.

		> > 

		> > If you can point me to the correct documentation for

this, I'll take a 


		> > look at it.

		> > 

		> > There's a lot of stuff to wade through in the docs and

MetaLink, and I'd


		> 

		> 

		> > rather just

		> > read documentation that's actually relevant.

		> > 

		> > Thanks,

		> > 

		> > Jared

		> > 

		> > -- 

		> > Please see the official ORACLE-L FAQ:

http://www.orafaq.com


		> > -- 

		> > Author: 

		> >   INET: Jared.Still_at_radisys.com

		> > 

		> > Fat City Network Services    -- (858) 538-5051  FAX:

(858) 538-5051


		> > San Diego, California        -- Public Internet access /

Mailing Lists


		> >

--------------------------------------------------------------------


		> > To REMOVE yourself from this mailing list, send an

E-Mail message


		> > to: ListGuru_at_fatcity.com (note EXACT spelling of

'ListGuru') and in


		> > the message BODY, include a line containing: UNSUB

ORACLE-L


		> > (or the name of mailing list you want to be removed

from).  You may


		> > also send the HELP command for other information (like

subscribing).


		> -- 

		> Please see the official ORACLE-L FAQ:

http://www.orafaq.com


		> -- 

		> Author: 

		>   INET: Scott.Shafer_at_dcpds.cpms.osd.mil

		> 

		> Fat City Network Services    -- (858) 538-5051  FAX: (858)

538-5051


		> San Diego, California        -- Public Internet access /

Mailing Lists
		>
--------------------------------------------------------------------


		> To REMOVE yourself from this mailing list, send an E-Mail

message


		> to: ListGuru_at_fatcity.com (note EXACT spelling of

'ListGuru') and in


		> the message BODY, include a line containing: UNSUB

ORACLE-L


		> (or the name of mailing list you want to be removed from).

You may


		> also send the HELP command for other information (like

subscribing).


		> 

		> 

		> 

		> -- 

		> Please see the official ORACLE-L FAQ:

http://www.orafaq.com


		> -- 

		> Author: 

		>   INET: Jared.Still_at_radisys.com

		> 

		> Fat City Network Services    -- (858) 538-5051  FAX: (858)

538-5051


		> San Diego, California        -- Public Internet access /

Mailing Lists
		>
--------------------------------------------------------------------


		> To REMOVE yourself from this mailing list, send an E-Mail

message


		> to: ListGuru_at_fatcity.com (note EXACT spelling of

'ListGuru') and in


		> the message BODY, include a line containing: UNSUB

ORACLE-L


		> (or the name of mailing list you want to be removed from).

You may


		> also send the HELP command for other information (like

subscribing).
		-- 
		Please see the official ORACLE-L FAQ: http://www.orafaq.com
		-- 
		Author: 
		  INET: Scott.Shafer_at_dcpds.cpms.osd.mil

		Fat City Network Services    -- (858) 538-5051  FAX: (858)
538-5051
		San Diego, California        -- Public Internet access /


Mailing Lists
        




                To REMOVE yourself from this mailing list, send an E-Mail
message


                to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
and in

		the message BODY, include a line containing: UNSUB ORACLE-L
		(or the name of mailing list you want to be removed from).
You may
		also send the HELP command for other information (like


subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  INET: clchan_at_nie.edu.sg

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Weatherman
  INET: john.weatherman_at_replacements.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


begin 666 InterScan_Disclaimer.txt
M5&AE(&EN9F]R;6%T:6]N(&-O;G1A:6YE9"!I;B!T:&ES(&4M;6%I;"!I<R!S
M=')I8W1L>2!C;VYF:61E;G1I86P_at_86YD(&9O<B!T:&4@:6YT96YD960@=7-E
M(&]F('1H92!A9&1R97-S964@;VYL>3L@:70@;6%Y(&%L<V\@8F4@;&5G86QL
M>2!P<FEV:6QE9V5D(&%N9"]O<B!P<FEC92!S96YS:71I=F4N("!.;W1I8V4@
M:7,@:&5R96)Y(&=I=F5N('1H870_at_86YY(&1I<V-L;W-U<F4L('5S92!O<B!C
M;W!Y:6YG(&]F('1H92!I;F9O<FUA=&EO;B!B>2!A;GEO;F4@;W1H97(@=&AA
M;B!T:&4@:6YT96YD960@<F5C:7!I96YT(&ES('!R;VAI8FET960_at_86YD(&UA
M>2!B92!I;&QE9V%L+B @268@>6]U(&AA=F4@<F5C96EV960@=&AI<R!M97-S
M86=E(&EN(&5R<F]R+"!P;&5A<V4@;F]T:69Y('1H92!S96YD97(@:6UM961I
M871E;'D_at_8GD@<F5T=7)N(&4M;6%I;"X*"D-O<G!O<F%T92!3>7-T96US+"!)
M;F,N(&AA<R!T86ME;B!E=F5R>2!R96%S;VYA8FQE('!R96-A=71I;VX@=&\@
M96YS=7)E('1H870_at_86YY(&%T=&%C:&UE;G0@=&\@=&AI<R!E+6UA:6P@:&%S
M(&)E96X@<W=E<'0_at_9F]R('9I<G5S97,N("!792!A8V-E<'0@;F\@;&EA8FEL
M:71Y(&9O<B!A;GD_at_9&%M86=E('-U<W1A:6YE9"!A<R!A(')E<W5L="!O9B!S
M;V9T=V%R92!V:7)U<V5S(&%N9"!A9'9I<V4@>6]U(&-A<G)Y(&]U="!Y;W5R
M(&]W;B!V:7)U<R!C:&5C:W,@8F5F;W)E(&]P96YI;F<@86YY(&%T=&%C:&UE
%;G0N#0H 
end

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: April Wells
  INET: awells_at_csedge.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


Received on Tue Jul 09 2002 - 08:33:21 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US