Re: About restore from 11g

As an aside we have a server (well 2 actually - one HPUX and one Linux) that we use for backup proving.
We have a couple of Oracle homes on each and we recover the backups from our Commvault repository onto these servers. If we have an 11.2.0.3 database we will recover into whichever OH is installed - it might be 11.2.0.2 or 11.2.0.4. and we do not run any upgrade/downgrade scripts All we are testing is that the database can be restored and that the backup is fully functional

I am not recommending taking this approach if you intend using the database for any functional work but in our case any OH will suit our needs

John

www.jhdba.wordpress.com

On 13 April 2017 at 02:14, Jack van Zanen <jack_at_vanzanen.com> wrote:

> +1....
>
>
> Doesnt take long at all to install another 11G version on a server... You
> need space though
>
> I would install side by side and does not require an outage during install
>
> Jack van Zanen
>
>
> -------------------------
> This e-mail and any attachments may contain confidential material for the
> sole use of the intended recipient. If you are not the intended recipient,
> please be aware that any disclosure, copying, distribution or use of this
> e-mail or any attachment is prohibited. If you have received this e-mail in
> error, please contact the sender and delete all copies.
> Thank you for your cooperation
>
> On Thu, Apr 13, 2017 at 9:05 AM, Tim Gorman <tim.evdbt_at_gmail.com> wrote:
>
>> My US$0.02...
>>
>> Upgrade the $ORACLE_HOME from 11.2.0.3 to 11.2.0.4, don't downgrade the
>> database.
>>
>> Why would anyone choose to go back to the bug-ridden cesspool of 11.2.0.3?
>>
>>
>>
>>
>>
>> On 4/12/17 09:24, angelo wrote:
>>
>> Andrew
>>
>> yep, I could imagine.. the right thing would be have Oracle updated,
>> but... they didn´t the homework..
>> So, I will negotiate with my users if I can make a expdp/impdp instead to
>> avoid these issues... just for restoring a few schemas and tables, from a
>> production to a devel machine
>>
>>
>>
>> On 12 April 2017 at 12:01, Andrew Kerber <andrew.kerber_at_gmail.com> wrote:
>>
>>> yes, all kinds of problems. At the very least, you will need to open
>>> the database resetlogs upgrade and run catupgrade after the restore.
>>>
>>> On Wed, Apr 12, 2017 at 9:57 AM, angelo <angelolistas_at_gmail.com> wrote:
>>>
>>>> Hello,
>>>>
>>>> Is there any big issue about restoring an oracle 11.2.0.4 backup to
>>>> 11.2.0.3 server ?
>>>>
>>>> I will do it on this afternoon attending a request
>>>>
>>>>
>>>> regards,
>>>>
>>>> Angelo
>>>>
>>>
>>>
>>>
>>> --
>>> Andrew W. Kerber
>>>
>>> 'If at first you dont succeed, dont take up skydiving.'
>>>
>>
>>
>>
>

-- 

*Technology Manager - Databases and System Management*

Wm Morrison Supermarkets PLC

Tel 0845 611 4589 (Int. 7949 4589)
Mob: 07876 790540

E-mail: john.hallas_at_morrisonsplc.co.uk

-- 

------------------------------
Wm Morrison Supermarkets Plc is registered in England with number 358949. 
The registered office of the company is situated at Gain Lane, Bradford, 
West Yorkshire BD3 7DL. This email and any attachments are intended for the 
addressee(s) only and may be confidential.

If you are not the intended recipient, please inform the sender by replying 
to the email that you have received in error and then destroy the email.
If you are not the intended recipient, you must not use, disclose, copy or 
rely on the email or its attachments in any way.

This email does not constitute a contract in writing for the purposes of 
the Law of Property (Miscellaneous Provisions) Act 1989.

Our Standard Terms and Conditions of Purchase, as may be amended from time 
to time, apply to any contract that we enter into. The current version of 
our Standard Terms and Conditions of Purchase is available at:
http://www.morrisons.co.uk/gscop

Although we have taken steps to ensure the email and its attachments are 
virus-free, we cannot guarantee this or accept any responsibility, and it 
is the responsibility of recipients to carry out their own virus checks.
------------------------------

--
http://www.freelists.org/webpage/oracle-l