Monday, October 5, 2009

Migrate Database to ASM Using RMAN

We are Using RMAN to relocate non-ASM files to ASM files. The ASM files cannot be accessed through normal OS interfaces.

Step1: Query V$CONTROLFILE and V$LOGFILE to get the file names.
SQL> select * from V$CONTROLFILE;
SQL> select * from V$LOGFILE;

Step 2: Shutdown the database.
SQL> SHUTDOWN IMMEDIATE;

Step3: Modify the target database parameter file:
(i) Remove the CONTROL_FILES parameter from the spfile, so the control files will be created automatically in ASM Disk group mentioned in DB_CREATE_FILE_DEST destination
Using a pfile then set CONTROL_FILES parameter to the appropriate ASM files or aliases.
(ii) Set the DB_CREATE_FILE_DEST and DB_CREATE_ONLINE_LOG_DEST_n parameters to the relevant ASM disk groups.

Step 4: Startup nomount mode and Restore control file
RMAN> STARTUP NOMOUNT;

Restore the control file into the new location.
RMAN> RESTORE CONTROLFILE FROM 'old_controlfile_name';

Step 5: Startup mount mode and backup the Database.
RMAN> ALTER DATABASE MOUNT;

Backup database into ASM disk group.
RMAN> BACKUP AS COPY DATABASE FORMAT '+diskgroup1';

Step 6: Switch database and create or rename Redo log members
Switch all data files to the new ASM Diskgroup location.
RMAN> SWITCH DATABASE TO COPY;
RMAN> SQL “ALTER DATABASE RENAME ‘old_redolog_member’ to ‘+diskgroup2’;
or
Create new redo logs in ASM Disk group and delete the old redo log files.

Step 7: Open Database and create temporary tablespace.
Open database using resetlogs
SQL> ALTER DATABASE OPEN RESETLOGS;

Create temporary tablespace in ASM disk group.
SQL> CREATE TABLESPACE temp1 ADD TEMPFILE ‘+diskgroup1’;

Step 8: Drop old database files.
1. SQL> DROP TABLESPACE ‘old_temporary_tablespace’ including contents and datafiles;
2. Remove all remaining Non-ASM database files using OS commands

Regards
Satishbabu Gunukula
http://www.oracleracexpert.com/

71 comments:

  1. i am new to rac, now i am preparing for rac exam,
    i have seen ur site, helpful post.
    i am also having a blog in the name
    www.oracleinstance.blogspot.com

    regards,
    rajeshkumar govindarajan
    oracle rac dba
    conscientadbs
    cochin. india

    ReplyDelete
    Replies
    1. Great Article Cyber Security Projects projects for cse Networking Security Projects JavaScript Training in Chennai JavaScript Training in Chennai The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training

      Delete
  2. THANKS FOR GIVING VALUABLE INFORMATION

    ReplyDelete
  3. HI SATISH
    THIS IS THE FIRST TIME I HAVE SEEN UR BLOG, POSTS ARE VERY USEFULL

    ReplyDelete
  4. Hi Expert!

    Very nice post. Thanks!

    Mahir M. Quluzade
    www.mahir-quluzade.com

    ReplyDelete
  5. hi ,
    nice doc. will you please post the steps for 11gr2 non-rac to rac migration.

    ReplyDelete
  6. Please check my articles

    http://www.oracleracexpert.com/2012/10/convert-single-instance-to-rac-part1.html
    http://www.oracleracexpert.com/2012/11/convert-single-instance-to-rac-part2.html

    Regards,
    Satish

    ReplyDelete
  7. Good post !!
    http://chandu208.blogspot.com/

    ReplyDelete
  8. Really a great addition. I have read this marvelous post. Thanks for sharing information about it. I really like that. Thanks so lot for your convene.* gmail sign up

    ReplyDelete
  9. This is so good to see. We have do more things like this for the military families. They are protecting us and we need to support them in this way.

    happy birthday sister images
    good night message for her
    birthday message for wife
    birthday quotes for husband
    birthday wishes for friend female
    birthday wishes for sister

    ReplyDelete
  10. In ShoreTel the database engine, is now MySQL. The question becomes how many simultaneous database access (read, modify, write) transactions can the MySQL server handle at one time?mysql dashboards

    ReplyDelete
  11. Thank you for sharing this information. Love your blog post. Please Keep updating. You can also visit our blog for
    Happy Christmas Quotes
    Happy New Year 2018 Quotes

    ReplyDelete
  12. I really appreciate this article Thanks For Sharing People also like this Awesome post
    Happy Valentines Pictures

    ReplyDelete
  13. Post very nicely written, and it contains useful facts. I am happy to find your distinguished way of writing the post.
    Valentines Day 2018 Images

    ReplyDelete
  14. Thank you for sharing this information. Love your blog post. Please Keep updating. You can also visit our blog for
    Happy Valentines Day 2018 Images
    Happy Valentines Day 2018 Images
    Valentines Day 2018 Images

    ReplyDelete
  15. Thanks for sharing a nice article really such a wonderful site you have done a great job once more thanks a lot
    Images of Happy Easter
    Happy Easter Images

    ReplyDelete
  16. Thanks for sharing a nice article really such a wonderful site you have done a great job once more thanks a lot


    Happy Easter pictures
    hd Easter Images download
    easter coloring pictures
    easter color pages
    Easter Eggs design

    ReplyDelete
  17. Thanks for sharing this video, it is really helpful. If you are interested in product key please visit my website: windows 7 ultimate product key

    ReplyDelete
  18. Your website has good content. If want more quality content here is the link to it
    4th Of July Wallpapers
    Happy 4th Of July Sayings
    4th Of July SMS

    ReplyDelete
  19. The blog and best that is extremely useful to keep I can share the ideas of the future as this is really what I was looking for, I am very comfortable and pleased to come here. Thank you very much.
    Friendship Day Jokes

    ReplyDelete
  20. This is one the best website i have ever visited. Thanks for sharing this amazing article, will definitely subscribe myself for new stuff. Hindi Speeches For Students

    ReplyDelete
  21. Hey, I like the way you write this post and the thing is I was looking for this content over the various site but I was not getting exact words or phrase which I was searching for but I found on your site, thanks and keep going on.
    Happy Diwali Wishes
    Happy Diwali Wishes
    Happy Diwali Wishes
    Merry Christmas Wishes
    Happy New Year Wishes
    Republic Day Essay 2019
    Republic Day Essay 2019
    Happy Republic Day Quotes 2019
    Happy Holi Wishes 2019

    ReplyDelete
  22. it was nice seeing your blog. You have covered each and everything in detail.Thanks for sharing such nice and informative post.

    berlin marathon Entry
    berlin marathon Route
    berlin marathon Results
    berlin marathon Lottery
    berlin marathon Prize Money

    ReplyDelete
  23. st andrew day is coming and will be celebrate on november 30 with full swing https://www.viralhub24.com/

    ReplyDelete
  24. Bitdefender Total Security 2020 License Key + Crack Total [Updated]


    Bitdefender Total Security 2020 Key furnishes the maximum stage of customizations for the users. It's included a characteristic that instantly adjusts to security options that were balanced. This system has put to use consumer interface that gives a whole good deal of customization relevant on the security towards malicious and contaminated products. Bitdefender Total Security 2020 is considered the most recent security bundle. Its initial model was designed about fifteen many years back. The quality of every version that later turned considerably better and superior. It's got antivirus programs and extensive online security suites. It is actually geared up to keep up your Windows PC sound and harmless.

    ReplyDelete
  25. Download now one of the best recovery software crack from HDLicense.com

    ReplyDelete
  26. Gone through this wonderful coures called Salesforce Certification Training in Dallas who are offering fully practical course, who parent is Salesforce Training in USA and they have students at Salesforce Training classes in Canada institutes.

    ReplyDelete
  27. I like this website so much it's really awesome.I have also gone through your other posts too and they are also
    very much appreciate able and I'm just waiting for your next update to come as I like all your posts.
    Thanksgiving Images

    ReplyDelete
  28. Lumion Pro Crack this https://crackother.com/wp-admin/post.php?post=1006&action=edit you can draw, sketch, view effects, and import videos to bring out an artist's flair in real life. In other words, it is an architectural tool for assembling data from multiple resources.

    ReplyDelete