Re: Reg:DB Refresh in Application

Oracle will always gives you the log information. Are you doing the single
node clone or Multinode cloning? Have a look while running adcfgclone where
you find the path of clone log file at the end and paste to forum.
Ensure your database process and listener is up and running. before you run
adcfgclone on Application node/application tier.
Do let us know for any needs.

-Ananth


2008/12/23 kathy.robb <kathy.robb@xxxxxxx>

>  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 J
>
>
>  ------------------------------
>
> *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.. L
>
>
>
> 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: