From oracle-l-bounce@freelists.org Tue Sep 27 10:50:34 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j8RFoYuP021140 for ; Tue, 27 Sep 2005 10:50:34 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j8RFoH6H021105 for ; Tue, 27 Sep 2005 10:50:17 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9589B1EFF48; Tue, 27 Sep 2005 10:49:36 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 26685-04; Tue, 27 Sep 2005 10:49:36 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0B10E1EFC9C; Tue, 27 Sep 2005 10:49:36 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:references; b=iI8Pnts0OTziWEW8997yuFR4+Oqwv/3MSAPSdgSEO9ggnV78HFvFuJ6cPW/CFiDpVnL+iuVgPuMESkgebU2PheEO615UmufaLP0/iTxqykNc60psrDVujfdLpjKGGGlIj6PMkZdhEY5Xq0lPuxoO3z6s8eCuCPOSS26QZ8FgNsw= Message-ID: <1aaba34f050927084744240e62@mail.gmail.com> Date: Tue, 27 Sep 2005 11:47:41 -0400 From: Navneet Gupta To: Howard Latham Subject: Re: Restoration of Backups from Prodction Server Cc: rgramolini@tax.state.vt.us, oracle-l@freelists.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_31883_10744505.1127836061454" References: X-archive-position: 25941 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: oraclemails@gmail.com Precedence: normal Reply-To: oraclemails@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-4.7 required=5.0 tests=AWL,BAYES_00, HTML_FONTCOLOR_BLUE,HTML_MESSAGE autolearn=no version=2.63 ------=_Part_31883_10744505.1127836061454 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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 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@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@freelists.org [mailto: > oracle-l-bounce@freelists.org] *On Behalf Of *Ruth Gramolini > *Sent:* 22 September 2005 13:18 > *To:* oraclemails@gmail.com; oracle-l@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@freelists.org [mailto: > oracle-l-bounce@freelists.org]*On Behalf Of* Navneet Gupta > *Sent:* Wednesday, September 21, 2005 6:15 PM > *To:* oracle-l@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 > * > > ------=_Part_31883_10744505.1127836061454 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
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.la= tham@rsmb.co.uk> wrote:
Do you really = mean different hardware as in DIFFERENT or same
or similar har= dware?
 
 

Howard A. Latham

Tech Services Director UK Oracl= e User Group.

SENIOR DATABASE ADMINISTRATOR
RSMB Television Resea= rch Ltd,
The Communications Building,
48 Leicester Square,
London.= WC2H 7LT


Tel: +44 (0)20 7808 3619
SW:  +44 (0)20 7808 3600
Fa= x: +44 (0)20 7839 7446

m= ailto:Howard.latham@rsmb.co.uk

http://www.rsmb.co.uk

Email Disclaimer

This email has been sent from RSMB TV Rese= arch , a UK limited
liability company. The information in
this email is confidential and= may be legally privileged.
It is intended solely for the addressee. Acc= ess to this
email by anyone else is unauthorised. If you are not the
intended recipient, any disclosure, copying, distribution
or any act= ion taken or omitted to be taken in reliance on it,
is prohibited and ma= y be unlawful.

-----Original Message-----
From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Ruth= Gramolini
Sent: 22 September 2005 13:18
To: oraclemails@gmail.com; oracle-l@freelists.org
Subject: RE: Restoration of Backups fr= om Prodction Server

= You could just DUPLICATE the database in the new location and apply the arc= hivelogs as they are requested duriing recovery. 
 
Ruth<= /div>
-----Original Message-----From: oracle-l-bo= unce@freelists.org [mailto:oracle-l-boun= ce@freelists.org]On Behalf Of Navneet Gupta
Sent: Wedn= esday, September 21, 2005 6:15 PM
To: oracle-l@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 ge= nerated during shipping/restoration(It would be some seven days archive log= s).=20
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

=

------=_Part_31883_10744505.1127836061454-- -- http://www.freelists.org/webpage/oracle-l