Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I'm new to oracle, but I'm looking to upgrade an existing oracle database 11.2.0.1 to 11.2.0.2. Can anyone tell me if this will require wiping my existing database or will it remain intact? Thanks in advance.

--Adam

share|improve this question

2 Answers 2

Firstly, separate the concepts of database "software installation" from the database "store of data".

11.2.0.2 has changed the upgrade mechanism. Previously you had to install the base version of the software then run an upgrade. 11.2.0.2 is installed as a separate product.

There's a walkthrough here, but the actual steps may vary depending on what your database config is (single node or RAC etc). If you are not confident, make your backup, restore to another machine and test your upgrade first. Only upgrade production when you are confident.

share|improve this answer

Always take a backup of your database, but you should be able to run the patch to update your existing database. The Patch notes have instructions on what needs to be done (scripts that need to be run after the fact).

share|improve this answer
2  
Always HAVE a backup of your database (whether upgrading or not) and make sure you have tested restoring it. –  Gary Dec 16 '10 at 22:13
    
I'd give Gary 5 upvotes for that comment... –  DCookie Dec 17 '10 at 16:58

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.