Re: Restoration of Backups from Prodction Server

Hi Mark,
 It's Oracle9i on Solaris 9.
When I try to set log_archive_dest_1 at system level, Oracle complains that I can not have log_archive_dest_n with log_archive_dest.  Regards,
Navneet

 On 9/27/05, Powell, Mark D <mark.powell_at_eds.com> wrote:
>
> Navneet, what version of Oracle are you using? I haven't pulled the manual
> but looking at v$parameter my query shows me that the parameter cannot be
> dynamically changed at the SESSION level, but that a change at the SYSTEM
> level has immediate effect.
> HTH -- Mark D Powell --
> ------------------------------
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Navneet Gupta
> *Sent:* Tuesday, September 27, 2005 11:48 AM
> *To:* Howard Latham
> *Cc:* rgramolini_at_tax.state.vt.us; oracle-l_at_freelists.org
> *Subject:* Re: Restoration of Backups from Prodction Server
>
> Both of these having same hardware.
> Now I am facing one more problem, in our production server we have
> log_archive_dest parameter.
> Oracle docs says we can's change it dynamically, so we can't have
> log_archive_dest_n.
> Any workaround to this?
> Regards,
> Navneet
>
> On 9/22/05, Howard Latham <howard.latham_at_rsmb.co.uk> wrote:
> >
> > Do you really mean different hardware as in DIFFERENT or same
> > or similar hardware?
> >
> > Howard A. Latham
> >
> > Tech Services Director UK Oracle User Group.
> >
> > SENIOR DATABASE ADMINISTRATOR
> > RSMB Television Research Ltd,
> > The Communications Building,
> > 48 Leicester Square,
> > London. WC2H 7LT
> >
> >
> > Tel: +44 (0)20 7808 3619
> > SW: +44 (0)20 7808 3600
> > Fax: +44 (0)20 7839 7446
> >
> > mailto:Howard.latham_at_rsmb.co.uk <Howard.latham_at_rsmb.co.uk>
> >
> > http://www.rsmb.co.uk
> >
> >
> > Email Disclaimer
> >
> > This email has been sent from RSMB TV Research , a UK limited
> > liability company. The information in
> > this email is confidential and may be legally privileged.
> > It is intended solely for the addressee. Access to this
> > email by anyone else is unauthorised. If you are not the
> > intended recipient, any disclosure, copying, distribution
> > or any action taken or omitted to be taken in reliance on it,
> > is prohibited and may be unlawful.
> >
> > -----Original Message-----
> > *From:* oracle-l-bounce_at_freelists.org [mailto:
> > oracle-l-bounce_at_freelists.org] *On Behalf Of *Ruth Gramolini
> > *Sent:* 22 September 2005 13:18
> > *To:* oraclemails_at_gmail.com; oracle-l_at_freelists.org
> > *Subject:* RE: Restoration of Backups from Prodction Server
> >
> > You could just DUPLICATE the database in the new location and apply the
> > archivelogs as they are requested duriing recovery.
> > Ruth
> > -----Original Message-----
> > *From:* oracle-l-bounce_at_freelists.org [mailto:
> > oracle-l-bounce_at_freelists.org]*On Behalf Of* Navneet Gupta
> > *Sent:* Wednesday, September 21, 2005 6:15 PM
> > *To:* oracle-l_at_freelists.org
> > *Subject:* Restoration of Backups from Prodction Server
> >
> > *
> >
> > Hi,
> > We are migrating our database on different hardware/location. We will
> > get RMAN backup of the database. And we will have access to archive logs
> > generated during shipping/restoration(It would be some seven days archive
> > logs).
> > What are the options we have got to restore the databases and bring it
> > uptodate by applying archives.
> > Dataguard is a solution here?
> >
> > It's 9i on Solaris 9.
> >
> > Thanks in Advance,
> > Navneet
> > *
> >
> >
>

--
http://www.freelists.org/webpage/oracle-l