Tagged: Real Application Cluster Toggle Comment Threads | Keyboard Shortcuts

  • Mustafa 3:41 am on September 25, 2016 Permalink | Reply
    Tags: 12.1.0.2.160719, , , , , , , , Real Application Cluster   

    Howto: Apply July PSU 12c Grid and DB to an Oracle 12c 2 Node RAC cluster 

    Following my previous post, here we will be applying the July 2016 PSU (Patch:23054246) 12.1.0.2.160719 on top of an existing April 2016 PSU (Patch: 22646084) 12.1.0.2.160419.

    Steps are the same, only difference is we will be apply an PSU on top of another PSU. I will assume you will go through all the prechecks listed in the previous blog.

     

    After its complete, validate that the patches went through else manually run datapatch, check how to here

    Check datapatch updated the registry

    Thats all, follow the same procedure on the other nodes in the cluster.

    Watch the video below!

     
  • Mustafa 6:38 pm on November 23, 2010 Permalink | Reply
    Tags: Controlfile, , , , Real Application Cluster, Recreate   

    Recreating Controlfile the RAC way! 

    Recreating the controlfile isn’t much of a hassle when the need arises. You might never want to recreate one until you have lost all of them. It is always a good move to backup your controlfile to trace file to save time, else you can always type it up. 🙂 Moving forward recreating the controlfile in a Real Application Cluster environment is a bit different than single node databases. And if you happen to come across articles and documents on metalink oracle the same, you might hold your head and say WHAT IS THIS. Well the procedure which I will show it isnt much of a pain.

    Follow the simple steps mentioned below and in no time your database would be up. I had to do it because recovery of the database was being comprised by missing archivelog files, so had to perform

    1. alter database backup controlfile to trace;
    2. create pfile=’/home/oracle/initsid.ora’ from spfile;
    3. Shutdown database, nodeapps, …
    4. Modify initsid.ora file and remove

    *.cluster_database_instances=2

    And change the parameter

    *.cluster_database=true

    To FALSE

    1. startup nomount pfile=’/home/oracle/initsid.ora’
    2. recreate the controlfile from the text generated in step 1 and follow the same procedure to resetlogs in the trace file.

    Just a word or caution, might seem naive to some but surely will save alot of time. While recreating the controlfile and performing a resetlogs if you forget to register the archivelogs mentioned in the trace file remember to perform cancel based recovery else your database wont open and you’ll have to restore files again.

    Have some more articles coming up so stay tuned!!

     
c
compose new post
j
next post/next comment
k
previous post/previous comment
r
reply
e
edit
o
show/hide comments
t
go to top
l
go to login
h
show/hide help
shift + esc
cancel