RE: Restoration of Backups from Prodction Server

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Tue, 27 Sep 2005 13:45:06 -0400
Message-ID: <5A14AF34CFF8AD44A44891F7C9FF41050395BAF0@usahm236.amer.corp.eds.com>

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 
	
	http://www.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

Received on Tue Sep 27 2005 - 12:50:05 CDT