This discussion is archived
7 Replies Latest reply: Jul 16, 2013 11:20 AM by user11987087 RSS

rac db on asm

user11987087 Newbie
Currently Being Moderated

how to mount 11g rac db when asm attibute compatible.rdbms set to 11.2

  • 1. Re: rac db on asm
    user11987087 Newbie
    Currently Being Moderated

    11g rac db in 11.1.0.7

  • 2. Re: rac db on asm
    JohnWatson Guru
    Currently Being Moderated

    Have you raised the compatibility before upgrading the database? Advancing compatible.rdbms is, as far as I know, irreversible. You can of course get all the database files off the disk group. You could, for example, create another disk group with lower compatibility, and use the asmcmd utility to copy the files to the new group (or to a file system).

    --

    John Watson

    Oracle Certified Master DBA

    http://skillbuilders.com

  • 3. Re: rac db on asm
    user11987087 Newbie
    Currently Being Moderated

    Thanks John for your guidance.

    Yes I raised db compatibility before db upgrade. How stupid I was. This is physical standby database. I upgraded crs from 11.1.0.7 to grid 11.2.0.3. In order to relocate ocr and voting from raw devices to ASM I raised asm and db compatibility of all asm disk groups. I should not have raised db compatibility. Now to get around this issue I have to do

    1. Create asm diskgroups with lower db compatibility.

    2. Copy all files from diskgroups to new disk groups. I guess I need to use COPY command of asmcmd utility. Please correct me if I am wrong.

    What are the next steps to mount the standby database ?

    I really thankful for your help.

    Our production primary database is crs is in 11.1.0.7. Once we mount standby database, we are going to upgrade our primary database.

    Thnaks so much. 

  • 4. Re: rac db on asm
    JohnWatson Guru
    Currently Being Moderated

    I would think that having moved the files you will need to adjust your control_files parameter to point to the new location of the controlfile, startup mount, and issue a series of ALTER DATABASE RENAME FILE commands to update the controlfile with the new location of the data, temp, and log files. At some point you'll need to re-create or move the spfile, too. And don't forget your archivelog destinations(s). Then redo apply should run OK. Good luck!

     

    Incidentally, my preference is to create one small, high redundancy, disk group with five little devices and use that exclusively for vote files and OCR.

  • 5. Re: rac db on asm
    user11987087 Newbie
    Currently Being Moderated

    Thanks John for your valuable guidance and help.

    I will sure follow the procedure suggested. Yes I need good luck. Will update once I could able to bring standby in sync with primary.

  • 6. Re: rac db on asm
    user11987087 Newbie
    Currently Being Moderated

    I was able to mount standby database after creating asm diskgroups with compatibility 10.1.0.0.0 for asm and database and copy all files. Rename all data files, log files and temp files. When started recovery using "alter database recover managed standby database disconnect", I am getting 3113 end of file communication.

    Nothing is written to alert log files. Am I missing any thing please ? -Chou

  • 7. Re: rac db on asm
    user11987087 Newbie
    Currently Being Moderated

    I got around 3113 error by increasing memory target for asm instances. Recovered standby database by manually applying old archive logs.

    Now the standby database is in sync with primary. Oh boy,  great relief. Thanks for your valuable help.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points