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: