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 > > * > > > > >