Re: [OAUGNetDBA]-Re: Cloning process from hot backups
- From: "Anant (DBA)" <shastry17@xxxxxxxxx>
- To: "OAUG Net DBA listserver" <OAUGNetDBA@xxxxxxxx>
- Date: Sun, 4 Nov 2007 05:17:20 +0530
Hi gurus,
Can someone please tell me what is the difference between
DBTIER,DBCONFIG,DBTECHSTACK options when using in the cloning process?
Thanks in Advance,
Ann
On 11/2/07, Sangster, Simon <SSangster@xxxxxxxxxxxxxx> wrote:
>
> For us newbies to cloning can you explain why :)
>
> -----Original Message-----
> From: OAUG Net DBA listserver [mailto:OAUGNetDBA@xxxxxxxx] On Behalf Of
> NV
> Sent: 02 November 2007 16:24
> To: OAUG Net DBA listserver
> Subject: [OAUGNetDBA]-Re: Cloning process from hot backups
>
> Chris,
>
> I would also recommend adding following as step 14 before proceeding
> to apps tier cloning.
> perl adcfgclone.pl dbconfig <target context file>
> and if you are refreshing oracle home binaries from source, I would
> also do following before doing step number 1 as identified by Joe.
> perl adcfgclone.pl dbTechStack
>
> On 10/31/07, Joseph Imbimbo <joei@xxxxxxxxxxxxxx> wrote:
> > Yes you have to do recovery. Here are the steps I use:
> >
> > 1. Make sure you have the recreate controlfile script completed
> first.
> > 2. Connect / as sysdba
> > 3. @recreate_controlfile.sql
> > 4. recover database until cancel using backup controlfilel
> > 5 After you have applied the last archived redo file, enter "cancel"
> > 6. alter database open resetlogs;
> > 7. alter tablespace temp (to add the location and name of the temp
> > tablespace data files)
> > 8. shutdown immediate;
> > 9. startup;
> > 10. change directory to $ORACLE_HOME/appsutil/install/<context>
> > 11. connect / as sysdba
> > 12. @adupdlib.sql so (for solaris systems).
> > 13. commit;
> >
> >
> > Now ready to do the APPS Tier at this point.
> >
> > -----Original Message-----
> > From: OAUG Net DBA listserver [mailto:OAUGNetDBA@xxxxxxxx] On Behalf
> Of
> > Sanitors DBA
> > Sent: Wednesday, October 31, 2007 2:06 PM
> > To: OAUG Net DBA listserver
> > Subject: [OAUGNetDBA]-Cloning process from hot backups
> >
> > Would someone mind sharing their cloning steps with me for cloning 11i
> apps
> > which is running hot backups. I am trying to follow Oracle's clone
> notes
> > (metalink 230672.1) and using the Appendix B section for hot backups,
> but it
> >
> > says nothing about recover commands for reapplying the archive logs.
> How
> > can you clone from a hot backup without running any kind of recovery?
> >
> > Help! An SR analyst is telling me my cloning problems are because I
> am not
> > following the clone notes exactly. How can I when they are written so
> > poorly in my opinion (as least as far as cloning from hot backups are
> > concerned).
> >
> > Thanks,
> > Chris --------------------------------------------------------
> >
> > dba dba - Sanitors - - dba@xxxxxxxxxxxxxxx San Antonio Phone:
> 210-495-6021
> > Mobile: Fax: Web: Address: 1019 Central Parkway North Suite #100,
> San
> > Antonio, Texas
> > The information in this e-mail (including any attachment) is
> confidential
> > and intended to be for the use of the addressee(s) only. If you have
> > received the e-mail by mistake, any disclosure, copy, distribution or
> use of
> > the contents of the e-mail is prohibited, and you must delete the
> e-mail
> > from your system. As e-mail can be changed electronically ISS assumes
> no
> > responsibility for any alteration to this e-mail or its attachments.
> ISS
> > has taken every reasonable precaution to ensure that any attachment to
> this
> > e-mail has been swept for virus. However, ISS does not accept any
> liability
> > for damage sustained as a result of such attachment being virus
> infected and
> > strongly recommend that you carry out your own virus check before
> opening
> > any attachment [v.1.e]
> >
> > #############################################################
> > This message is sent to you because you are subscribed to the mailing
> list
> > <OAUGNetDBA@xxxxxxxx>.
> > To unsubscribe, E-mail to: <OAUGNetDBA-off@xxxxxxxx>
> > To switch to the FEED mode, send any message to
> <OAUGNetDBA-feed@xxxxxxxx>
> > To switch to the DIGEST mode, E-mail to <OAUGNetDBA-digest@xxxxxxxx>
> > To switch to the INDEX mode, E-mail to <OAUGNetDBA-index@xxxxxxxx>
> > Send administrative queries to <OAUGNetDBA-request@xxxxxxxx>
> >
> >
> >
> >
> > #############################################################
> > This message is sent to you because you are subscribed to the mailing
> list <OAUGNetDBA@xxxxxxxx>.
> > To unsubscribe, E-mail to: <OAUGNetDBA-off@xxxxxxxx>
> > To switch to the FEED mode, send any message to
> <OAUGNetDBA-feed@xxxxxxxx>
> > To switch to the DIGEST mode, E-mail to <OAUGNetDBA-digest@xxxxxxxx>
> > To switch to the INDEX mode, E-mail to <OAUGNetDBA-index@xxxxxxxx>
> > Send administrative queries to <OAUGNetDBA-request@xxxxxxxx>
> >
> >
>
> #############################################################
> This message is sent to you because you are subscribed to the mailing
> list <OAUGNetDBA@xxxxxxxx>.
> To unsubscribe, E-mail to: <OAUGNetDBA-off@xxxxxxxx>
> To switch to the FEED mode, send any message to
> <OAUGNetDBA-feed@xxxxxxxx>
> To switch to the DIGEST mode, E-mail to <OAUGNetDBA-digest@xxxxxxxx>
> To switch to the INDEX mode, E-mail to <OAUGNetDBA-index@xxxxxxxx>
> Send administrative queries to <OAUGNetDBA-request@xxxxxxxx>
>
>
>
> **************************************************************************
> IMPORTANT NOTICE
>
> This e-mail may contain information that is privileged, confidential or
> otherwise protected from disclosure. It must not be used by, or its
> contents
> copied or disclosed to persons other than the intended recipient(s).
> If you have received this e-mail in error, please notify us immediately at
> itsupport@xxxxxxxxxxxxxx and delete this e-mail from your system.
> Any liability (in negligence or otherwise) arising from any third party
> acting, or refraining from acting, on any information contained in this
> e-mail
> is excluded.
> It is the responsibility of the recipient to ensure that this message and
> its
> attachments are virus free. UAP Limited are not responsible for any
> reliance
> placed on the information contained in this e-mail and excludes all
> liability.
> **************************************************************************
>
> #############################################################
> This message is sent to you because you are subscribed to the mailing list
> <OAUGNetDBA@xxxxxxxx>.
> To unsubscribe, E-mail to: <OAUGNetDBA-off@xxxxxxxx>
> To switch to the FEED mode, send any message to <OAUGNetDBA-feed@xxxxxxxx>
> To switch to the DIGEST mode, E-mail to <OAUGNetDBA-digest@xxxxxxxx>
> To switch to the INDEX mode, E-mail to <OAUGNetDBA-index@xxxxxxxx>
> Send administrative queries to <OAUGNetDBA-request@xxxxxxxx>
>
>
Other related posts:
