This discussion is archived
9 Replies Latest reply: Feb 11, 2013 5:02 AM by 947473 RSS

ASM replication

947473 Newbie
Currently Being Moderated
Hi All,

In our db environment, we are trying to setup a DR using the storage level replication.

the ASM Diskgroups (+DATA and +FLASH) are replicated from the Production Storage to DR Storage.

Using asmca, able to mount one of the Disk Group (+DATA), but while mounting the +FLASH Disk Group, getting the following error.

Mounting Disk Group DBFLASH failed with the following message:
ORA-15032: not all alterations performed
ORA-15096: lost disk write detected


More Information about the environment
OS : Windows 2008 Release 2
Oracle Version : 11.2.0.2.0
Database Storage : ASM


Using asmcmd, able to see the contents of the DATA diskgroup.

Please let me know if anyone faced the error mentioned above while mounting the DG.

Also please let me know how can i bring up the database using the replicated DGs.

Thanks a lot.

Regards
Yusuf
  • 1. Re: ASM replication
    Sebastian Solbach (DBA Community) Guru
    Currently Being Moderated
    Hi,

    this means, that you had a "lost write" on a disk. So your disk information is not o.k. and your diskgroup is corrupted.
    It seems your replication software did not work correctly and forgot to sync everything.

    For the future I recommend DataGuard instead of relying on storage mirroring for DR.
    Even though bad for you, this is a perfect use case, why Oracle Data Guard is recommended for disaster recovery, and storage mirroring is not....

    However good thing is, that if it it just the FAST or Flash Recovery Area, that you should still have a functional DB, and just your disk based backup (including one control file + one redolog member) got corrupted. You should be able to get the database mounted and running without the FLASH diskgroup.

    Regards
    Sebastian
  • 2. Re: ASM replication
    947473 Newbie
    Currently Being Moderated
    Hi Sebastian,

    Thanks for the valuable information.

    As the storgae level replication is too fast , we are opting for the storage level replication.

    Could you please help how i can bring the database up without having the +FLASH DG.

    Thanks a lot.

    Warm Regards
    Yusuf
  • 3. Re: ASM replication
    Sebastian Solbach (DBA Community) Guru
    Currently Being Moderated
    Hi,

    if this is not a cluster, then RMAN will help you. (Identifying the possible problem).

    Since your FLASH is corrupted, first thing I would do is create a new diskgroup in ASM. I would at the moment prefer, not to take the same disks as the FLASH diskgroup. Maybe use a new LUN for the time beeing. After everything is finished, you still can decide to reuse the defect disks.

    If this is single instance, than it is pretty easy:

    => Mount the DATA diskgroup (which you already did).
    => Mount the newly created diskgroup
    => Call RMAN and try to startup the DB.
    => Do a "list failure" in RMAN, which will very likely tell you, that one controlfile copy is missing
    => Do an "advise failure" in RMAN, which tells you the plan how to recreate the second controlfile (probably need to exchange the FLASH diskgroup in the statement).
    => Then again try to startup and use list and advise failure, which then will tell you what to do with the redologs.
    After this is done, you will likely have to change the DB_RECOVERY_DEST to the new diskgroup.

    Regards
    Sebastian
  • 4. Re: ASM replication
    947473 Newbie
    Currently Being Moderated
    Hi Sebastian,

    Thanks for your reply.

    More Information about the production and DR environment

    Production Environment is a 2 node RAC. As it is 11g R2, Oracle Grid Infrastructure is installed.

    DR Environment is a Single Server where Oracle Grid Infrastructure for a Standalone Server and Oracle Database Software are installed.No Database Instance created.

    Please let me know your valuable points in proceeding further.

    As the replication is a third party storage replication, Oracle will not provide support.

    Thanks,
    Yusuf
  • 5. Re: ASM replication
    Sebastian Solbach (DBA Community) Guru
    Currently Being Moderated
    Hi,

    ouch. Again use data guard. You will find lots of information on how the setup has to be done and how it is handled.

    Doing storage mirroring with RAC on one side, and single node on the other side, is not an easy tasks, which can be answered in a forum thread.
    There are as far as I know no technical whitepaper identifying this kind of implementation you can refer to. Maybe other have found something.

    Since you already were able to mount the Data diskgroup at the standby side (but not flash), you are at least one step further.
    However as indicated above, this already identifies a major problem of your DR. No information what else can go wrong.... Maybe next time it is both diskgroups, and then the solution won't work at all.

    The first starting point would be how to recover a single instance database from a RAC database.
    HowTo Restore RMAN Disk backups of RAC Database to Single Instance On Another Node (Doc ID 415579.1)

    However since you have datafiles and spfile, you don't need the recovery. You can access the spfile on the Data diskgroup.
    However you need to change some setting in the spfile, before you can continue.

    Regards
    Sebastian
  • 6. Re: ASM replication
    947473 Newbie
    Currently Being Moderated
    Hi Sebastian,

    We did a replication of the DATA and FLASH Disk Groups again from production environment and we are able to mount the 2 disk groups.

    Now i have DATA and FLASH in the DR site.

    My Plan is as follows.

    1. Create an instance in DR Server using oradim.
    2. Create the pfile from production db and remove the RAC related parameters.
    3. Using the edited pfile bring up the instance in DR to no mount state.
    4. Use RMAN and connect to the catalog.
    5. Restore/Recover the control file and datafiles.
    6. Open the database using resetlogs.

    the issue i am facing now is while trying to startup the instance using the edited pfile (step 3) getting the following error.

    ORA-00439: feature not enabled: Real Application Clusters
    ORA-01078: failure in processing system parameters

    Please let me know your valuable suggestions.

    Thanks,
    Yusuf

    Edited by: 944470 on Feb 7, 2013 7:28 AM
  • 7. Re: ASM replication
    Sebastian Solbach (DBA Community) Guru
    Currently Being Moderated
    Hi,

    post the contents of your pfile.
    You still have a parameter, which identifies it as a RAC DB.
    Probably you still have 2 UNDO Tablespaces or similar....

    Regards
    Sebastian
  • 8. Re: ASM replication
    947473 Newbie
    Currently Being Moderated
    Thanks a lot Sebastian for your quick reply.

    Now i am able to start the instance in nomount

    Issue was with one parameter. It is cluster_database. After setting Cluster_Database=FALSE i am able to start the instance in nomount.

    I will keep posted about the issues i am facing.

    Following is my updated pfile content

    *.audit_file_dest='D:\app\oracle\admin\dbname\adump'
    *.audit_trail='NONE'
    *.cluster_database=true
    *.compatible='11.2.0.0.0'
    *.control_files='+DATA/dbname/controlfile/current.260.745372527','+FLASH/dbname/controlfile/current.256.745372527'
    *.db_block_size=8192
    *.db_create_file_dest='+DATA'
    *.db_create_online_log_dest_1='+DATA'
    *.db_create_online_log_dest_2='+FLASH'
    *.db_domain=''
    *.db_name='dbname'
    *.db_recovery_file_dest='+FLASH'
    *.db_recovery_file_dest_size=107374182400
    *.diagnostic_dest='D:\app\oracle'
    *.dispatchers='(PROTOCOL=TCP) (SERVICE=dbnameXDB)'
    *.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST'
    *.log_archive_format='dbname_arch_%s_%r_%t.arc'
    *.memory_target=256000000
    *.open_cursors=300
    *.processes=300
    *.remote_login_passwordfile='exclusive'
    *.sec_protocol_error_trace_action='LOG'
    *.sessions=115
    *.trace_enabled=FALSE
    *.undo_tablespace='UNDOTBS1'
    *.cluster_database=FALSE

    Thanks,
    Yusuf
  • 9. Re: ASM replication
    947473 Newbie
    Currently Being Moderated
    Hi Sebastian,

    I recovered the databases successfully.

    Used the almost the same method of duplicating a database.

    Important changes made

    1. In the initialization parameter of DR Database, mentioned the parameter CLUSTER_DATABASE=FALSE
    2. Created a instance using oradim
    3. startup the instance in nomount using the pfile
    3.a Some database instances throwed error related to recovery of particular datafile. In those case, used the command recover datafile <filenum>;
    3.b In Some databases, got ORA-600 errors. Used the command Recover database;
    4. Create spfile from pfile=<location of new pfile>;
    5. Add the databases to the Grid Infrastructure using srvctl add database -d <dbname> -o <Oracle_Home>

    Once more, thanks sebastian for your valuable comments.

    Warm Regards
    Yusuf

Legend

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