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/

149 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
  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

    ReplyDelete
  30. iMyFone TunesMate 2.9.5.1 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:
    https://softserialskey.com/imyfone-tunesmate-iphone-transfer-crack/

    ReplyDelete
  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

    ReplyDelete
  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

    ReplyDelete
  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

    ReplyDelete
  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

    ReplyDelete
  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

    ReplyDelete
  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

    ReplyDelete
  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 Justsofts.com

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

      Panda ANtivirus   

    ReplyDelete
  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

    ReplyDelete

  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



    ReplyDelete
  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

    ReplyDelete
  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

    ReplyDelete
  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

    ReplyDelete
  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.

    ReplyDelete
  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

    ReplyDelete
  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

    ReplyDelete
  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. https://crackplease.com/restoro-license-key/

    ReplyDelete
  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

    ReplyDelete
  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

    ReplyDelete
  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

    ReplyDelete
  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.
    https://protocrack.com/proshow-producer-crack/
    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.
    https://secrack.com/free-netflix-premium-crack/
    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.
    https://thiscrack.com/acoustica-mixcraft-build-crack/

    ReplyDelete
  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

    ReplyDelete
  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

    ReplyDelete
  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

    ReplyDelete
  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

    ReplyDelete
  56. Logic Pro X built-in panel will let you allow to browse the templates through with can open up recent projects.
    https://shehrozpc.com/logic-pro-x-crack/

    ReplyDelete
  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.

    https://ziapc.org/antares-autotune-pro-crack/

    ReplyDelete
  58. https://cracksmad.com/directx-crack/
    DirectX Full Version can support different computers and various graphics cards.

    ReplyDelete
  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

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

    ReplyDelete
  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

    ReplyDelete
  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

    ReplyDelete
  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

    ReplyDelete
  64. I am very impressed with your post because this post is very beneficial for me and provide a new knowledge to me
    https://vstpincrack.com/

    ReplyDelete
  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

    ReplyDelete



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

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

    ReplyDelete
  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
    https://showbizclan.com/20-best-japanese-zombie-movies/

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

    ReplyDelete
  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
    https://cracksmob.com/

    ReplyDelete
  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
    https://zsactivatorskey.com/

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

    ReplyDelete