RE: Restoration of Backups from Prodction Server
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: <oraclemails@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 27 Sep 2005 13:45:06 -0400
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
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@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:
