RE: Reg:DB Refresh in Application

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

Other related posts: