Re: Restoration of Backups from Prodction Server

  • From: Navneet Gupta <oraclemails@xxxxxxxxx>
  • To: "Powell, Mark D" <mark.powell@xxxxxxx>
  • Date: Tue, 27 Sep 2005 14:52:43 -0400

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@xxxxxxx> 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@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Navneet Gupta
> *Sent:* Tuesday, September 27, 2005 11:48 AM
> *To:* Howard Latham
> *Cc:* rgramolini@xxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
> *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@xxxxxxxxxx> 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@xxxxxxxxxx <Howard.latham@xxxxxxxxxx>
> >
> > 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@xxxxxxxxxxxxx [mailto:
> > oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Ruth Gramolini
> > *Sent:* 22 September 2005 13:18
> > *To:* oraclemails@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
> > *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@xxxxxxxxxxxxx [mailto:
> > oracle-l-bounce@xxxxxxxxxxxxx]*On Behalf Of* Navneet Gupta
> > *Sent:* Wednesday, September 21, 2005 6:15 PM
> > *To:* oracle-l@xxxxxxxxxxxxx
> > *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
> > *
> >
> >
>

Other related posts: