RE: Reg:DB Refresh in Application

Mamta - 

 

When you are running adcfgclone.pl dbTier - you will enter the parameters
for the database, including the new sid.  You don't need to modify any files
as the scripts will do it for you.

 

So - if all you are doing is copying the database and everything else is
set...

1.      on the source database, do the preclone steps - perl adpreclone.pl
dbTier  
2.      I am assuming that you are using a cold backup of your source
database, so shut down that database.  If not, there are steps you can use
to clone it hot, but a few more steps than this.
3.      copy the datafiles to your target system
4.      start your source backup
5.      Make sure the datafiles are owned by the oracle user on that target
system
6.      adcfgclone.pl dbTier   - Answer all the questions, including what
you want you target SID to be.
7.      run autoconfig on your appstier

 

That's it.  If you are trying to do a hot clone, that's fine, but then you
would run adcfgclone.pl dbTechStack, manually recreate the target
controlfile, recover the database as necessary, and run adcfgclone.pl
dbconfig, so it's more complex, but nice because you don't need a
maintenance window.

 

  _____  

From: ora-apps-dba-bounce@xxxxxxxxxxxxx
[mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of NEELI-SC, Mamta
Sent: Tuesday, December 23, 2008 3:34 AM
To: ora-apps-dba@xxxxxxxxxxxxx
Subject: RE: Reg:DB Refresh in Application

 

Thanks Sarfraz,

 

But the source SID and target SID are different then what all changes I need
to do?

 

  _____  

From: ora-apps-dba-bounce@xxxxxxxxxxxxx
[mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of fraz baig
Sent: Tuesday, 23 December 2008 18:30
To: ora-apps-dba@xxxxxxxxxxxxx
Subject: RE: Reg:DB Refresh in Application

 

This is not necessary to refresh proddb or Oracle home binaries if you have
not changed any database physical structures like resizing datafiles or
added any new onces if so you need to copy the OHome too or simply you can
only copy clone folder to target from souce thats enough.
But its recommended you should copy oracle home from source to target.
 

  _____  


Subject: RE: Reg:DB Refresh in Application
Date: Tue, 23 Dec 2008 16:56:42 +0800
From: Mamta.NEELI@xxxxxxxxxxxxxx
To: ora-apps-dba@xxxxxxxxxxxxx

Yes got the clue.the system_01.dbf is corrupted.not able to recover the
file..just trying to do with new backup again.

 

What to you mean by refreshing ORACLE_HOME..

Do I need to copy the proddb along with proddata from production?

 

Thanks for you kind help :-)

 

  _____  

From: ora-apps-dba-bounce@xxxxxxxxxxxxx
[mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of kathy.robb
Sent: Tuesday, 23 December 2008 13:54
To: ora-apps-dba@xxxxxxxxxxxxx
Subject: RE: Reg:DB Refresh in Application

 

What is the error you are getting when you run adcfgclone.pl dbTier?   Look
in $ORACLE_HOME/appsutil/clone/....

 - there should be some log files related to the adcfgclone.pl there.  They
should provide additional information about what is happening.  Also, what
about the alert.log?  Does it have any information?  I'm really sorry, but
there are so many pieces that there is no way we can guess as to what the
issue is without additional information.

 

 

You can try metalink note 364565.1, but again, it's hard to point you in the
right direction if you can't give us more information about what is
happening during adcfgclone.

 

The steps to clone are in metalink note 230672.1

 

1.      Copy the database tier file system if the RDBMS ORACLE_HOME or the
database needs to be refreshed. If refreshing the database, the ORACLE_HOME
should be refreshed at the same time. 
2.      perl adcfgclone.pl dbTier <Database target context file>

where database context file is:
     <RDBMS ORACLE_HOME>/appsutil/<Target CONTEXT_NAME>.xml 

 

 

when you are finished and you know your database is good - run autoconfig
and start your apps.

 

Kathy

  _____  

From: ora-apps-dba-bounce@xxxxxxxxxxxxx
[mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of NEELI-SC, Mamta
Sent: Monday, December 22, 2008 7:11 PM
To: ora-apps-dba@xxxxxxxxxxxxx
Subject: RE: Reg:DB Refresh in Application

 

There is no clue in log files.. :-(

 

When trying to bringup the concurrent getting the 1605 error.But the
database is up.

 

Can you please let me what should be the steps to be carried out so that I
can start from scratch.

 

Thanks a lot for your prompt response..

 

  _____  

From: ora-apps-dba-bounce@xxxxxxxxxxxxx
[mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of Kellyn Pedersen
Sent: Tuesday, 23 December 2008 09:57
To: ora-apps-dba@xxxxxxxxxxxxx
Subject: Re: Reg:DB Refresh in Application

 


Hello,

What is failing in the clone?  Do you have the specific error from the logs?
That would assist us greatly in assisting you.

Thank you,

Kellyn

--- On Mon, 12/22/08, NEELI-SC, Mamta <Mamta.NEELI@xxxxxxxxxxxxxx> wrote:

From: NEELI-SC, Mamta <Mamta.NEELI@xxxxxxxxxxxxxx>
Subject: Reg:DB Refresh in Application
To: ora-apps-dba@xxxxxxxxxxxxx
Date: Monday, December 22, 2008, 5:41 PM

DBA?s

 

I have 11.5.9 on windows with oracle 9.2.05 database.(Single Node)

 

I want to refresh the test database so that its in sync with Production.

 

After copying the DATA TOP and DB TOP from production to test box..what all
all steps needs to be done?

 

Please guide me I?m trying to run adcfgclone.pl dbTier but its failing.

 

Urgent help will be very grateful..

 

Regards

Mamta

 

 

 

 

  _____  

Get news, entertainment and everything you care about at Live.com. Check it
out! <http://www.live.com/getstarted.aspx%20>

Other related posts: