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.

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

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

Step 5: Startup mount mode and backup the Database.

Backup database into ASM disk group.

Step 6: Switch database and create or rename Redo log members
Switch all data files to the new ASM Diskgroup location.
RMAN> SQL “ALTER DATABASE RENAME ‘old_redolog_member’ to ‘+diskgroup2’;
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

Create temporary tablespace in ASM disk group.

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

Satishbabu Gunukula


  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

    rajeshkumar govindarajan
    oracle rac dba
    cochin. india

    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



  4. Hi Expert!

    Very nice post. Thanks!

    Mahir M. Quluzade

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

  6. Please check my articles


  7. Good post !!

  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

  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

  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

  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

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

  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

  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

  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

  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

  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

  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

  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

  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

  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

  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

  23. st andrew day is coming and will be celebrate on november 30 with full swing

  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.

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

  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.

  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

  28. Lumion Pro Crack this 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.

  29. Please let me know if you’re looking for an author for your weblog.
    You have some really good posts and I believe I would be a good asset.
    If you ever want to take some of the load off, I’d love to
    write some content for your blog in exchange for a link back to mine.
    Please send me an email if interested. Thanks!
    tomabo mp4 downloader crack
    passport photo maker crack
    texpad crack
    parallels desktop crack plus keygen

  30. iMyFone TunesMate Crack: This is a new design for your iPhone Manager and iTunes.
    This software handles all the limitations and limits of iTunes. iTunes collects information about errors and unexpected crashes.
    Download it free From Here:

  31. It has created a trend in the technology industry. Day-by-day with new customers signing contracts, more and more Salesforce administrators, developer and consultants are in demand. Salesforce training in Chennai

  32. I just want to thank you again. I'm not sure what I can do without the technology you find on this topic.
    It's a very scary problem in my opinion, although looking at the specific pattern you apply to this problem made
    me cry with joy. I am now happy for your advice and I sincerely hope you are aware of what you want to bring to
    a great job through blog posts. You may never meet us all.
    4k video downloader crack
    fontlab crack
    capture one pro crack
    kmspico activator windows 7

  33. Once your initial trial group have completed their training, they are now ready to become mentors and role models for a second group of employees. Salesforce training in Hyderabad

  34. Nice Information Your first-class knowledge of this great job can become a suitable foundation for these people. I did some research on the subject and found that almost everyone will agree with your blog.
    Cyber Security Course in Bangalore

  35. Writing in style and getting good compliments on the article is hard enough, to be honest, but you did it so calmly and with such a great feeling and got the job done. This item is owned with style and I give it a nice compliment. Better!
    Cyber Security Training in Bangalore

  36. By using field-level information safety technologies, it may get via to the main of any dividing issue on your hard disk drive. Red Dead Redemption 2 Download PC Game

    AOMEI Partition Assistant Crack

  37. Thanks for sharing such a great post. You can also check out Tenorshare ReiBoot Pro Crack for Free. You can also visit my Website

  38. WOnder Share Uno Convertor     
    These Are the  Software's Have You Seen These Amazing Links Check it out Please out 

      Panda ANtivirus   

  39. I'm really impressed with your writing skills, as smart as the structure of your weblog.
    Is this a paid topic or do you change it yourself?
    However, stopping by with great quality writing, it's hard to see any good blog today.

    outbyte pc repair key crack
    advanced system optimizer crack
    avast secureline vpn crack
    express vpn crack


  40. Cold weather! Some are very useful!
    Thanks for reading this article
    other sites are also good.

    ibeesoft data recovery crack
    allplayer crack
    bootstrap studio crack

  41. Great, submit, very informative.
    I ponder why the opposite experts of this sector don’t realize this.
    You must proceed your writing.
    I’m confident, you have
    a great readers’ base already!
    virtual dj pro crack
    total vedio converter crack
    jriver media center crack
    ableton live 10 1 0 suite crack

  42. Very cool! Some very valid points!
    I appreciate you writing this revaluation and
    the rest of the page is very good too.
    mobaxterm crack

  43. Get Packers and Movers Jaipur List of Top Reliable, 100% Affordable, Verified and Secured Service Provider. Get Free ###Packers and Movers Jaipur Price Quotation instantly and Save Cost and Time. Packers and Movers Jaipur ✔✔✔Reviews and Compare Charges for household Shifting, Home/Office Relocation, ***Car Transportation, Pet Relocation, Bike SHifting @ Packers And Movers Jaipur

  44. Sometimes it is even easy to forget to install an Internet application. Additionally, many potentially unwanted applications (PUAs) masquerade as legitimate utilities. To help users ensure that they are only running the legitimate programs they want on their system, Restoro License Key at productscrack will automatically provide a list of detected (post-installation) third-party programs, as well as PUAs.

  45. It is easy to repair a computer with Restoro Torrent because the software uses remarkable technology – it contains a remote database of genuine and updated Windows system files, which can replace broken files on the scanned system. The database is continuously updated, so there is no need to worry that the replaced files are not up to date.
    Restoro Torrent

  46. winzip driver updater crackwebsiteI really enjoy reading your post about this Posting. This sort of clever work and coverage! Keep up the wonderful works guys, thanks for sharing

  47. Thanks for sharing. Restoro License Key Free 2020 Professional Windows System Repair Tool works as an all-in-one program, capable of restoring broken or missing registry entries and fixing settings, removing junk files, removing faulty files, fixing startup programs, etc. When the computer starts to malfunction or displays various error messages, many users use the above method – reinstall Windows.

  48. I really love your blog.. Great colors & theme.
    Did you develop this website yourself? Please reply
    back as I’m hoping to create my own site and would love to know
    where you got this from or just what the theme is named.
    Thank you!
    malwarebytes anti malware crack
    lansweeper crack
    imyfone d back crack
    kaspersky internet security crack

  49. Stellar Converter Crack is a one-stop answer for all of your audio and video conversion needs. The audio-video ratio converter converts films. audio documents into many codecs and also offers utilities for video editing. creating GIF’s inserting metadata and much more for audio-video patch overlay overlays for videos is well known among users of YouTube, Instant Chat, and Instagram.ProtoCrack
    Adobe Premiere Pro Crack is the innovative video editing software for film, television, and the Internet. With creative tools, integration with other apps and services, and the power of Adobe Sensei, you can turn your video into high-quality movies and videos. With Premiere Rush, you can create and edit new projects from any device. The automated tools supported by Adobe Sensei save time so you can focus on your story. Secrack
    Miracle Box Crack is a practical problem-solving tool for Android. It is easy to work on Windows, MAC, and Android devices for support. Miracle Box Pro is a great software for designing jobs on an intuitive platform. It’s good for cellphones. At the same time, you can get fantastic ash performance for the phones. You can also unlock the process. It is a continuous tool that repairs only several devices.ProtoCrack

  50. Thanks for the post. Very interesting post. This is my first-time visit here. I found so many interesting stuff in your blog. Keep posting. abbyy finereader crack

  51. ProShow Producer Crack is the latest professional multimedia slideshow software. they
    allow us to create photo and video slideshows with incredible styles. Compared to
    Earlier versions have many new features. ProShow like keyframes, masking, and adjustment effects. These effects can be used for adjustment.
    Free Netflix Premium Crack: Download The Freezable team proudly presents the Grabbing software! Grabbing, dedicating, and efficient software for downloading the entire Freezable Netflix download series, TV commercials, documentaries, movies, track the use of the fastest Freezable multi-stream application engine. With our fantastic app, you can download and watch any Netflix video offline on any tool without consuming internet traffic and without disturbing Netflix limits.
    Acoustica Mixcraft Crack was developed by musicians for musicians and is unequaled in the industry in terms of user-friendliness and performance. Record your tracks in record time and mix them with an incredibly intuitive interface, super-fast audio engine, real-time pitch change technology, and near-universal support for third-party plug-ins, audio interfaces, and controller hardware.

  52. Nice message, I am reviewing this blog all the time and it impressed me a lot!
    Very useful information, especially the last step: I tend to deal with this kind of information. I am looking for this
    Extra information for a long time. Thank you and good luck.
    microsoft toolkit activator latest
    exhale vst crack
    format factory full crack

  53. Excellent post. I was checking constantly this blog and I am impressed!
    Extremely helpful info specifically the last part
    I care for such info much. I was seeking this particular info for a very long time.
    Thank you and good luck.
    norton antivirus crack
    iobit malware fighter crack
    avast secureline vpn crack
    poweriso crack
    radmin vpn crack
    nero backitup crack

  54. Hi there it’s me, I am also visiting this web page on a regular
    basis, this web site is actually good and the users are truly
    sharing fastidious thoughts.
    avast premier crack
    coreldraw graphics suite crack
    tik tok apk

  55. Restoro allows users to fix all Windows errors without resorting to DIY methodologies. In fact, the program can even support the dreaded Blue Screen of Death (BSOD). The constant system updating that Restoro enables means that protected systems are less likely to encounter errors. Restoro Crack 2021

  56. Logic Pro X built-in panel will let you allow to browse the templates through with can open up recent projects.

  57. Antares AutoTune Pro is the latest software to detect keys and measurement of your music on a vast scale. By using this tool, you can easily send information.

    DirectX Full Version can support different computers and various graphics cards.

  59. cleanmymac-x-crack
    can be an outstanding tool for optimizing and cleaning your Mac. This program gives you the ability safe stabilize clear to keep up and maximize your own body.
    new crack

  60. solarplusmore offers Emergency 15V Jump Starter with Air Compressor portable air compressor. in one with charger for Laptop and SmartPhone

  61. For those who want to learn more about this topic, this is the right website. You know
    a lot of difficulties in arguing with you. (Not like that, personally, I must...haha) Over
    the centuries, you have changed the subject.
    renee passnow pro crack
    nitro pro crack
    zd soft screen recorder crack
    malwarebytes anti malware crack
    ccleaner crack
    download adobe audition cc crack
    adobe pagemaker crack

  62. Thanks for provide great informatic and looking beautiful blog, really nice required information & the things i never imagined and i would request, wright more blog and blog post like that for us. Thanks you once agian lumion-pro-crack-free-download

  63. Such a great and nice information about softwares. This site gonna help me alot for finding and using many softwares. Kindly make this like of content and update us. Thanks for sharing us JetBrains RubyMine Crack Kindly click on here and visit our website and read more.
    JetBrains RubyMine Crack
    GridinSoft Anti-malware Crack
    Cuphead Crack
    iSkysoft Data Recovery Crack
    Bulk Image Downloader Crack

  64. I am very impressed with your post because this post is very beneficial for me and provide a new knowledge to me

  65. Here's the softwares that you can use free. You guys just visit our site and get all the latest and older softwares Smadav Pro Crack Kindly click on here and visit our website and read more.
    Smadav Pro Crack
    Zoiper Crack Apk Free Download
    CloudMounter Crack
    Apple Keynote Crack
    Firefox Crack Free


  66. it is the best website for all of us. it provides all types of software which we need. you can visit this website.

  67. ZoneAlarm Mobile Security Great Article. I am learning to be social on SM and learning to blog etc.

  68. best and top rated japanese zombie movie listed on our blog. these are one of the lates ratings and audiance choice please vist us

  69. Смотрите бесплатно Русская групповуха онлайн в HD качестве

  70. Its really strong for you as shown by a general point of view all window programming establishment. This site is overwhelming its article are major and gets. I appreciated and bookmark this site on my chrome. This is where you can get all window software for your pc and mac. This site help you in installing, keygen, patch, serial key, serial number, activation code and so forward

  71. Its truly solid for you as displayed by an overall perspective all window programming foundation. This site is overpowering its article are major and gets. I appreciated and bookmark this site on my chrome. This is the place where you can get all window software for your pc and mac. This site help you in installing, keygen, patch, serial key, serial number, activation code and so forward

  72. Get instant relief with MoisturizingDry Mouth Spray, order now to breath fresh with aroma.