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/
Subscribe to:
Post Comments (Atom)
i am new to rac, now i am preparing for rac exam,
ReplyDeletei 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
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
DeleteTHANKS FOR GIVING VALUABLE INFORMATION
ReplyDeleteHI SATISH
ReplyDeleteTHIS IS THE FIRST TIME I HAVE SEEN UR BLOG, POSTS ARE VERY USEFULL
Hi Expert!
ReplyDeleteVery nice post. Thanks!
Mahir M. Quluzade
www.mahir-quluzade.com
hi ,
ReplyDeletenice doc. will you please post the steps for 11gr2 non-rac to rac migration.
Please check my articles
ReplyDeletehttp://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
Good post !!
ReplyDeletehttp://chandu208.blogspot.com/
Great and Useful Article.
ReplyDeleteJava Online Training
Java Course Online
Java EE course
Java Course in Chennai
Java Training in Chennai
Java Training Institutes in Chennai
Java Interview Questions
Java Interview Questions
access hotmail.com for hotmail login and hotmail sign in or
ReplyDeletehotmail outlook send mail
ReplyDeletenew year wishes
new year quotes inspirational
wishes for new year
new year greeting cards
new year meme
ReplyDeletechristmas messages for family
christmas quotes love
cute christmas wallpaper
christmas greetings pictures with message
christmas images wallpaper
ReplyDeletefunny thanksgiving pictures free
images of thanksgiving
thanksgiving pictures
coloring pages thanksgiving
thanksgiving wallpapers free
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
ReplyDeleteThis 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.
ReplyDeletehappy 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
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
ReplyDeleteThanksgiving Pictures 2017
ReplyDeleteThanksgiving Images
Happy Thanksgiving Images
Veterans Day Images
Bullet Strike Battlegrounds
ReplyDeleteDownload Bullet Strike Battlegrounds
Bullet Strike Battlegrounds For Apk
Bullet Strike Battlegrounds For Android
Bullet Strike Battlegrounds
Download Bullet Strike Battlegrounds
thank you for sharing
ReplyDeletemsn homepage
sign faceook
smooth skin
Excellent post. My web page:
ReplyDeletehotmail.com sign in
beauty brown skin
facebook app
xbmc
شركة نقل عفش بجدة
ReplyDeleteشركة نقل عفش بالمدينة المنورة
شركة تنظيف بالطائف
Thank you for sharing this information. Love your blog post. Please Keep updating. You can also visit our blog for
ReplyDeleteHappy Christmas Quotes
Happy New Year 2018 Quotes
I really appreciate this article Thanks For Sharing People also like this Awesome post
ReplyDeleteHappy Valentines Pictures
Post very nicely written, and it contains useful facts. I am happy to find your distinguished way of writing the post.
ReplyDeleteValentines Day 2018 Images
Thank you for sharing this information. Love your blog post. Please Keep updating. You can also visit our blog for
ReplyDeleteHappy Valentines Day 2018 Images
Happy Valentines Day 2018 Images
Valentines Day 2018 Images
Thanks for sharing a nice article really such a wonderful site you have done a great job once more thanks a lot
ReplyDeleteImages of Happy Easter
Happy Easter Images
Thanks for sharing a nice article really such a wonderful site you have done a great job once more thanks a lot
ReplyDeleteHappy Easter pictures
hd Easter Images download
easter coloring pictures
easter color pages
Easter Eggs design
Happy Easter HD Photos 2018
ReplyDeleteEaster Poems 2018
Happy Easter Pictures 2018
ReplyDelete
ReplyDeletemothers day quotes and images
happy mothers day images and quotes 2018
happy mother day pictures 2018
happy mothers day messages to friends
mothers day saying
Best Memorial Day Images
ReplyDeleteMemorial Day Images 2018
Memorial Day 2018 Images
Happy Fathers Day Wallpapers
ReplyDeleteMemorial Day Images For Facebook
Memorial Day Blessing Quotes
Mothers Day Greetings
ReplyDeleteMothers Day Pictures for Facebook
Mothers Day Images Free Download
Memorial Day Blessings Quotes
ReplyDeleteHappy Mothers Day Wallpapers
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
ReplyDeletefathers day 2018 images
ReplyDeletefathers day images 2018
happy fathers day images
happy father day images
father day poems
fathers day images and quotes
fathers day whatsapp status
ReplyDeletewhatsapp status poetry
happy fathers day grandpa quotes
funny fathers day poems from daughter
happy fathers day status
happy fathers day 2018
device doctor pro license key
ReplyDeleteYour website has good content. If want more quality content here is the link to it
ReplyDelete4th Of July Wallpapers
Happy 4th Of July Sayings
4th Of July SMS
ReplyDeleteYou have been doing great work by providing this useful information.
lottery.mhada.gov.in
mhada.maharashtra.gov.in
Mhada Lottery 2019
Mhada Lottery 2019 Registration
4th of july Cards Design
ReplyDelete4th of July Images
4th of July Quotes for Family
ReplyDelete4th of July Greetings
Fourth of July Pictures
ReplyDeleteFourth of July Wishes For Friends
4th Of July Messages for Facebook
4th of July Quotes 2018
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.
ReplyDeleteFriendship Day Jokes
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
ReplyDeleteMicromax
ReplyDeletemulti timer serial
i have found one of the best portal for information i was looking for. impressive.
ReplyDeleteHappy Veterans Day 2018 Images
Happy Veterans Day 2018 Pictures
Happy Veterans Day 2018 Images
Happy Veterans Day 2018 Pictures
ReplyDeleteThanksgiving photos 2018
clipart Thanksgiving free
Thanksgiving Memes Tumblr
Happy Thanksgiving Crafts
Thanksgiving Cards ideas
Quotes about Thanksgiving
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.
ReplyDeleteHappy 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
thank you for sharing amazing information
ReplyDeleteLove Quotes for Valentines Day
valentines day quotes for sister
valentines day images with quotes
nice blog post, hats off to you!
ReplyDeletelive nettv apk new version
live nettv for pc
happy national dog day 2019
ReplyDeletenational dog day captions
national dog day facts
national dog day cards
it was nice seeing your blog. You have covered each and everything in detail.Thanks for sharing such nice and informative post.
ReplyDeleteberlin marathon Entry
berlin marathon Route
berlin marathon Results
berlin marathon Lottery
berlin marathon Prize Money
everyday beauty tips
ReplyDeleteeveryday beauty tips
beauty tips and secrets
home made beauty tips
beauty tips and secrets
health tips for men
health tips
health tips
health tips for men
everyday beauty tips
Click Here
ReplyDeleteback brace
Click Here
Click Here
Click Here
st andrew day is coming and will be celebrate on november 30 with full swing https://www.viralhub24.com/
ReplyDeleteSt Andrew Day Greetings
ReplyDeleteBitdefender Total Security 2020 License Key + Crack Total [Updated]
ReplyDeleteBitdefender 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.
back Posture
ReplyDeletePosture Corrector
Click Here
Back Brace
Posture Corrective Brace
back brace
check out
posture corrector brace
As usual epic content. But I think, you do not have enough time to maintain your blog. Try to update your blog regulaly. It's help you bog to boost tarffic.
ReplyDeletebest coffee makers home use
best buy coffee makers
top coffee makers
best rated coffee maker
best rated coffee makers
best coffee maker ever
best coffee machines
best small coffee makers
best coffee makers 2020 reviews
best home coffee makers 2020
what is the best coffee maker
best simple coffee makers 2020
coffee maker reviews
site
ReplyDeleteback brace
posture brace
official site
Johnny Cope
ReplyDeleteDownload now one of the best recovery software crack from HDLicense.com
ReplyDeleteGone 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.
ReplyDeleteI like this website so much it's really awesome.I have also gone through your other posts too and they are also
ReplyDeletevery much appreciate able and I'm just waiting for your next update to come as I like all your posts.
Thanksgiving Images
Thanks for sharing
ReplyDeleteHappy Thanksgiving Images
Thanksgiving Images
have a look
ReplyDeleteSite
chimney
site
kitchen chimney
click here
official site
indian chimney
see this
ReplyDeletefully automatic washing machine
check this out
click here
have a look
site
check this out
site
Hasleo Data Recovery Crack
ReplyDeletePDF Password Remover Crack
Smallpdf Crack
UltraISO Crack
LUXONIX Purity Crack
FabFilter Crack
Miroslav Philharmonik 2 VST Crack
EZkeys Crack Mac
I am very impressed with your post because this post is very beneficial for me and provide a new knowledge to me
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.
ReplyDeleteThanks For Wondershare Dr.Fone Toolkit crack You can also visit my Website Crackmods.com
ReplyDeleteHappy Veterans Day 2020As we know that Veterans Day 2020 was coming up let’s talk about Veterans Day.
ReplyDeleteVHappy Veterans Day Images
Thank You Veterans Day Quotes 2020
Please let me know if you’re looking for an author for your weblog.
ReplyDeleteYou 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
iMyFone TunesMate 2.9.5.1 Crack: This is a new design for your iPhone Manager and iTunes.
ReplyDeleteThis 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/
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
ReplyDeleteI just want to thank you again. I'm not sure what I can do without the technology you find on this topic.
ReplyDeleteIt'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
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
ReplyDeleteNice 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.
ReplyDeleteCyber Security Course in Bangalore
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!
ReplyDeleteCyber Security Training in Bangalore
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
ReplyDeleteAOMEI Partition Assistant Crack
Nice Post thanks. You can also visit my Blog... Folder Lock For Windows 10
ReplyDeleteThanks 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
ReplyDeleteWOnder Share Uno Convertor
ReplyDeleteThese Are the Software's Have You Seen These Amazing Links Check it out Please out
Panda ANtivirus
I'm really impressed with your writing skills, as smart as the structure of your weblog.
ReplyDeleteIs 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
ReplyDeleteCold weather! Some are very useful!
Thanks for reading this article
other sites are also good.
ibeesoft data recovery crack
allplayer crack
bootstrap studio crack
Great, submit, very informative.
ReplyDeleteI 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
Very cool! Some very valid points!
ReplyDeleteI appreciate you writing this revaluation and
the rest of the page is very good too.
mobaxterm crack
winrar crack
ReplyDeleteiobit uninstaller
system mechanic pro crack
wondershare mobiletrans crack
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
ReplyDeleteSometimes 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.
ReplyDeleteIt 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.
ReplyDeleteRestoro Torrent
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
ReplyDeleteThanks 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/
ReplyDeleteI really love your blog.. Great colors & theme.
ReplyDeleteDid 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
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
ReplyDeleteAdobe 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
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