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
Any workaround to this?

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.
        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
        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
                You could just DUPLICATE the database in the new
location and apply the archivelogs as they are requested duriing
                -----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

                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,

Other related posts: