From oracle-l-bounce@freelists.org Tue Sep 27 12:50:05 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j8RHo5Ui008465 for ; Tue, 27 Sep 2005 12:50:05 -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 j8RHnn6H008414 for ; Tue, 27 Sep 2005 12:49:50 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 60E7C1EFCE7; Tue, 27 Sep 2005 12:48:08 -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 25583-07; Tue, 27 Sep 2005 12:48:08 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D2D8587603; Tue, 27 Sep 2005 12:48:07 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5C38B.32945BA6" Subject: RE: Restoration of Backups from Prodction Server Date: Tue, 27 Sep 2005 13:45:06 -0400 Message-ID: <5A14AF34CFF8AD44A44891F7C9FF41050395BAF0@usahm236.amer.corp.eds.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Restoration of Backups from Prodction Server Thread-Index: AcXDe9bJ7CiILZ0uTna3TYD76zFBkwADvsvw From: "Powell, Mark D" To: , X-OriginalArrivalTime: 27 Sep 2005 17:45:07.0440 (UTC) FILETIME=[330EB700:01C5C38B] X-archive-position: 25948 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: mark.powell@eds.com Precedence: normal Reply-To: mark.powell@eds.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=-3.4 required=5.0 tests=AWL,BAYES_00, HTML_FONTCOLOR_BLUE,HTML_MESSAGE autolearn=no version=2.63 ------_=_NextPart_001_01C5C38B.32945BA6 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable 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. =20 HTH -- Mark D Powell -- =20 ________________________________ From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Navneet Gupta Sent: Tuesday, September 27, 2005 11:48 AM To: Howard Latham Cc: rgramolini@tax.state.vt.us; oracle-l@freelists.org Subject: Re: Restoration of Backups from Prodction Server Both of these having same hardware.=20 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? =20 Regards, Navneet =20 On 9/22/05, Howard Latham wrote:=20 Do you really mean different hardware as in DIFFERENT or same=20 or similar hardware? =20 =20 Howard A. Latham =09 Tech Services Director UK Oracle User Group. =09 SENIOR DATABASE ADMINISTRATOR RSMB Television Research Ltd, The Communications Building, 48 Leicester Square, London. WC2H 7LT=20 =09 =09 Tel: +44 (0)20 7808 3619 SW: +44 (0)20 7808 3600 Fax: +44 (0)20 7839 7446 =09 mailto:Howard.latham@rsmb.co.uk=20 =09 http://www.rsmb.co.uk =20 =09 =09 Email Disclaimer =09 This email has been sent from RSMB TV Research , a UK limited=20 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=20 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.=20 =09 -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Ruth Gramolini=20 Sent: 22 September 2005 13:18 To: oraclemails@gmail.com; oracle-l@freelists.org Subject: RE: Restoration of Backups from Prodction Server =09 =09 You could just DUPLICATE the database in the new location and apply the archivelogs as they are requested duriing recovery. =20 =20 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=20 To: oracle-l@freelists.org Subject: Restoration of Backups from Prodction Server =09 =09 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).=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 =09 ------_=_NextPart_001_01C5C38B.32945BA6 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
Navneet, what version of Oracle are you = using?  I=20 haven't pulled the manual but looking at v$parameter = my query shows me=20 that the parameter cannot be dynamically changed at the SESSION level, = but that=20 a change at the SYSTEM level has immediate effect.
 
HTH -- Mark D Powell=20 --
 

From: oracle-l-bounce@freelists.org=20 [mailto:oracle-l-bounce@freelists.org] On Behalf Of Navneet=20 Gupta
Sent: Tuesday, September 27, 2005 11:48 AM
To: = Howard=20 Latham
Cc: rgramolini@tax.state.vt.us;=20 oracle-l@freelists.org
Subject: Re: Restoration of Backups = from=20 Prodction Server

Both of these having same hardware.
Now I am facing one more problem, in our production server we have=20 log_archive_dest parameter.
Oracle docs says we can's change it dynamically, so we can't have=20 log_archive_dest_n.
Any workaround to this?
 
Regards,
Navneet

 
On 9/22/05, Howard=20 Latham <howard.latham@rsmb.co.uk>= =20 wrote:=20
Do you really = mean different=20 hardware as in DIFFERENT or same
or similar=20 hardware?
 
 

Howard A. Latham

Tech Services Director UK = Oracle User=20 Group.

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


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

mailto:Howard.latham@rsmb.co.uk

http://www.rsmb.co.uk


Email=20 Disclaimer

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

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

You could just=20 DUPLICATE the database in the new location and apply the archivelogs = as they=20 are requested duriing recovery. 
 
Ruth
-----Original=20 Message-----
From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf = Of Navneet=20 Gupta
Sent: Wednesday, September 21, 2005 6:15 PM =
To:=20 oracle-l@freelists.org
Subject: = Restoration of=20 Backups from Prodction Server

Hi,

We are migrating our database on different hardware/location. = We will=20 get RMAN backup of the database. And we will have access to archive = logs=20 generated during shipping/restoration(It would be some seven days = archive=20 logs).
What are the options we have got to restore the databases = and=20 bring it uptodate by applying archives.
Dataguard is a solution here?

It's 9i on Solaris 9.

Thanks in=20 Advance,
Navneet


------_=_NextPart_001_01C5C38B.32945BA6-- -- http://www.freelists.org/webpage/oracle-l