The RMAN commands used to backup and recovery CDBs and PDBs are the same as those used for non-CDBs, with few variations in the syntax.
The backup and recovery operations performed on non-CDBs can also be performed on CDBs and PDBs. This includes the following:
– Full and incremental backups
– Complete and point-in-time recovery (PITR)
– Reporting operations (such as listing and cross-checking backups)
– Flashback Database
We need take metadata for the existing backups and available to the destination CDB. To export metadata user needs to run DBMS_PDB.EXPORTRMANBACKUP procedure on the source database.
EXECUTE DBMS_PDB.exportrmanbackup();
Or
EXECUTE DBMS_PDB.exportrmanbackup('EMP_PDB');
In case if you are unplug you no need to run this command as unplug already includes the metadata.
Convert NON-CDB to PDB : As we have metadata, now we can covert the NON-CDB instance to PDB.
Step1: Open the non-CDB instance in read-only mode and describe and shutdown
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP OPEN READ ONLY;
SQL> BEGIN
DBMS_PDB.DESCRIBE( pdb_descr_file => '/oracle/empdb.xml');
END;
SQL> SHUTDOWN IMMEDIATE;
Step2: Create the new pluggable database using the non-CDB description file that we have taken in above step
SQL> CREATE PLUGGABLE DATABASE empdb_pdb USING '/oracle/empdb.xml' COPY;
SQL> ALTER SESSION SET CONTAINER= empdb_pdb;
SQL> @$ORACLE_HOME/rdbms/admin/noncdb_to_pdb.sql
SQL> ALTER PLUGGABLE DATABASE OPEN;
SQL> ALTER PLUGGABLE DATABASE SAVE STATE;
Step3:- Restore and recovery using pre-plugin backup
SQL> ALTER PLUGGABLE DATABASE empdb_pdb CLOSE IMMEDIATE;
RMAN> SET PREPLUGIN CONTAINER=db18cpdb;
RMAN> RESTORE PLUGGABLE DATABASE empdb_pdb FROM PREPLUGIN;
RMAN> RECOVER PLUGGABLE DATABASE empdb_pdb FROM PREPLUGIN;
Sometimes users may come across RMAN-06054 error in that case you need to CATALOG the missing archive log and start the recovery again.
RMAN-06054: media recovery requesting unknown archived log for thread 3 sequence 94983
RMAN>SET PREPLUGIN CONTAINER= empdb_pdb;
RMAN>CATALOG PREPLUGIN ARCHIVELOG 'oracle/archivelog/arc_empdb_pdb_3_94983.arc';
RMAN>RECOVER PLUGGABLE DATABASE empdb_pdb FROM PREPLUGIN;
Perform normal recovery and open the database
RMAN>RECOVER PLUGGABLE DATABASE empdb_pdb;
RMAN>ALTER PLUGGABLE DATABASE empdb_pdb OPEN;
Reference:
Check preplugin backups available to the CDB instance
RMAN> LIST PREPLUGIN BACKUP OF PLUGGABLE DATABASE empdb_pdb;
Preplugin backups are usable only on the destination CDB into which you plug in the source non-CDB or PDB
RMAN> RECOVER PLUGGABLE DATABASE empdb_pdb FROM PREPLUGIN;
Sometimes users may come across RMAN-06054 error in that case you need to CATALOG the missing archive log and start the recovery again.
RMAN-06054: media recovery requesting unknown archived log for thread 3 sequence 94983
RMAN>SET PREPLUGIN CONTAINER= empdb_pdb;
RMAN>CATALOG PREPLUGIN ARCHIVELOG 'oracle/archivelog/arc_empdb_pdb_3_94983.arc';
RMAN>RECOVER PLUGGABLE DATABASE empdb_pdb FROM PREPLUGIN;
Perform normal recovery and open the database
RMAN>RECOVER PLUGGABLE DATABASE empdb_pdb;
RMAN>ALTER PLUGGABLE DATABASE empdb_pdb OPEN;
Reference:
Check preplugin backups available to the CDB instance
RMAN> LIST PREPLUGIN BACKUP OF PLUGGABLE DATABASE empdb_pdb;
Preplugin backups are usable only on the destination CDB into which you plug in the source non-CDB or PDB
Regards
Satishbabu Gunukula, Oracle ACE
http://www.oracleracexpert.com
This comment has been removed by the author.
ReplyDeleteGreat Article Artificial Intelligence Projects
DeleteProject Center in Chennai
JavaScript Training in Chennai
JavaScript Training in Chennai
Packers and Movers Chennai Give Safe and Reliable ***Household Shifting Services in Chennai with Reasonable ###Packers and Movers Price Quotation. We Provide Household Shifting, Office Relocation, ✔ ✔ ✔ Local and Domestic Transportation Services, Affordable and Reliable Shifting Service Charges @ Packers And Movers Chennai
ReplyDeleteBet Mr. Santorum's kids just loved finding out what the Left think their name means. Did you dance a little Hitlerian jig when his daughter's hospitalization was announced as the reason for his withdrawal? 123movies
ReplyDeleteGet Shifting/Relocation Quotation from ###Packers and Movers Delhi. Packers and Movers Delhi 100% Affordable and Reliable ***Household Shifting Services. Compare Transportation Charges and Save Time, Verified and Trusted Packers and Movers in Delhi, Cheap and Safe Local, Domestic House Shifting @ Packers And Movers Delhi
ReplyDeletePackers and Movers Gurgaon Provide Reliable, Safe and Certified Service Provider list, Get Free ***Best Price Quotaition and Compare Charges. ???Hassle free Household Shifting Services, High Quality packing Material, Office Relocation, Car Transportaion, ###Local and Domestic Shifting Service @
ReplyDeletePackers And Movers Gurgaon
I like this article.I was searching over search engines and found your blog and its really helps thank you so much @ Packers and Movers mumbai
ReplyDeleteGet Packers and Movers Kolkata List of Top Reliable, 100% Affordable, Verified and Secured Service Provider. Get Free ###Packers and Movers Kolkata Price Quotation instantly and Save Cost and Time. ???Packers and Movers Kolkata Reviews and Compare Charges for household Shifting, Home/Office Relocation, ***Car Transportation, Pet Relocation, Bike SHifting @ Packers and Movers Kolkata
ReplyDeletePackers And Movers Sembiam Chennai
ReplyDeletePackers And Movers Seven Wells Chennai
Packers And Movers Shastri Bhavan Chennai
Packers And Movers Shastri Nagar Chennai
Packers And Movers Shenoy Nagar Chennai
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
ReplyDeleteThank you very much for writing such an interesting article on this topic. This has really made me think and I hope to read more. @ Packers and Movers Kolkata
ReplyDeleteNice image visibility and well written blog. Thanks for sharing. I have recently come across a new online service provider company which provides Shifting Services @ Packers and Movers Kolkata
ReplyDeletePlease Contact Us @ ☎ +91 8290173333
Nice post! This is a very nice blog that I will definitively come back to more times this year! Thanks for informative post.# @ Packers and Movers mumbai
ReplyDeleteI’m happy I located this blog! From time to time, students want to cognitive the keys of productive literary essays composing. Your first-class knowledge about this good post can become a proper basis for such people. nice one
ReplyDeletePMP Certification
PMP Course
PMP Course in Malaysia
PMP Training in Malaysia
Awesome blog. I enjoyed reading your articles. This is truly a great read for me. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work!
ReplyDeletedata analytics course
big data analytics malaysia
big data course
Thanks for sharing this information. I really like your blog post very much. You have really shared a informative and interesting blog post with people..
ReplyDeletedata science course
Packers And Movers Jaipur to Bangalore
ReplyDeletePackers And Movers Jaipur to Delhi
Packers And Movers Jaipur to ahmedabad
Packers And Movers Jaipur to Gurgaon
Packers And Movers Jaipur to Kolkata
You re in point of fact a just right webmaster. The website loading speed is amazing. It kind of feels that you're doing any distinctive trick. Moreover, The contents are masterpiece. you have done a fantastic activity on this subject!
ReplyDeletePMP Certification 360DigiTMG
PMP Course 360DigiTMG
PMP Course in Malaysia 360DigiTMG
PMP Training in Malaysia 360DigiTMG
PMP Training 360DigiTMG
Awesome blog. I enjoyed reading your articles. This is truly a great read for me. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work!
ReplyDeletedata analytics course
big data analytics malaysia
big data course
Pretty good post. I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way I’ll be subscribing to your feed and I hope you post again soon.data science course
ReplyDeleteGreat post i must say and thanks for the information. Education is definitely a sticky subject. However, is still among the leading topics of our time. I appreciate your post and look forward to more. PMP Certification
ReplyDeletePMP Course
PMP Course in Malaysia
PMP Training in Malaysia
PMP Training
What a really awesome post this is. Truly, one of the best posts I've ever witnessed to see in my whole life. Wow, just keep it up.data science course
ReplyDeleteAwesome blog. I enjoyed reading your articles. This is truly a great read for me. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work!
ReplyDeletedata analytics course
big data analytics malaysia
big data course
Nice image visibility and well written blog. Thanks for sharing. I have recently come across a new online service provider company which provides Shifting Services @ Packers And Movers Delhi
ReplyDeletePackers And Movers Greater Noida
Packers And Movers Noida
Packers And Movers Ghaziabad
This is really a pleasant and useful, containing all data furthermore greatly affect the new innovation. Much obliged for sharing it @
ReplyDeletePackers And Movers Gurgaon
Packers And Movers Gurgaon to Bangalore
Packers And Movers Gurgaon to Ahmedabad
Packers And Movers Gurgaon to Jaipur
Kansas City Chiefs vs. Houston Texans Results. The following is a list of all regular season and postseason games played between the
ReplyDeleteSattamatka
Nice post. Agencia detectives España
ReplyDeleteHello there, simply was aware of your blog through Google, and located that it’s really informative. win915
ReplyDeleteI have just found this website while searching over the internet, you have posted valuable information which i like reading. Bandar Slot
ReplyDeleteProducts seems to be original. I can feel the originality form photos. Lsm99
ReplyDeletefirst-rate knowledge, restructure everybody mind merely reference assign assist to to it Situs IDN Poker
ReplyDeleteI have just found this website while searching over the internet, you have posted valuable information which i like reading. design merchandise
ReplyDeleteThis will open a window containing the HTML source code of the page. Inspect an HTML Element: Right-click on an element basic HTML CODE
ReplyDeleteI have just found this website while searching over the internet, you have posted valuable information which i like reading. 토토
ReplyDeleteافضل الخدمات الخاصة باعمال نقل العفش مع الفك والتركيب في الطائف تقدمها افضل شركه نقل عفش بالطائف وهي تعتبر من افضل الشركات المتخصصة في اعمال نقل الاثاث بواسطة فريق عمل مميز ومحترف وسيارات نقل عفش حديثة ومجهزة لأعمال شركات نقل الاثاث بالطائف مقفلة ومبطنة من الداخل وستحصل على افضل خدمات نقل الاثاث بالطائف باحترافية عالية وبالضمان من افضل شركات نقل عفش الطائف المتميزة والمؤهلة
ReplyDeleteفي مكة المكرمة نمتلك افضل شركة تقدم خدمات منزلية جيدة مثل خدمات نقل العفش تجدنا ارخص شركة نقل عفش بمكة لخدمات نقل الاثاث باحترافية وتوجد في مكه افضل شركه مكافحه حشرات بمكه تقدم خدمات رخيصة وتقدم خدمات جيدة وتمتلك عمالة مدربة ومبيدات حشرية آمنة ومضمونة وفعالة وقد تحتاج الى افضل شركة تنظيف كنب بمكة المكرمة المكرمة وهي تقوم بتعقيم منزلك بعد اعمال مكافحة الحشرات داخل المنزل وايضا تحتاج الى افضل شركة تنظيف منازل بمكة المكرمة المتميزة للقيام بأعمال تنظيف المنزل سواء كان مفروشا او جديدا وقبل هذا تحتاج الى تنظيف خزان مياهك بالتواصل مع افضل شركة تنظيف خزانات بمكة التي تهتم وتحافظ على خزانك من التلوث وبالتالي تستخدم مياه نظيفة
ReplyDeleteexciting publicize. i have Been questioning more or less this count number, as a end result thanks for posting. pretty cold publication.It 's in fact very fine and useful say.thank you 먹튀검증 안전놀이터 스포츠중계 꽁머니 먹튀검증 토토사이트 안전놀이터 꽁머니
ReplyDeleteI have just found this website while searching over the internet, you have posted valuable information which i like reading. Click Here
ReplyDeleteClick Here
Click Here
These thoughts just blew my mind. I am glad you have posted this. ผลบอล
ReplyDelete
ReplyDeleteGood post thanks for share information.
b com subjects list
DMLT Course
education rankings by country
Spongebob Essay
Essay on Ragging
We have a site for sports games. 토토사이트 You must be interested. 토토사이트
ReplyDeletesteph curry shoes
ReplyDeletekyrie 7 shoes
stone island outlet
kd shoes
hermes belt
curry 8
yeezy 500
supreme clothing
jordan retro
bape
I have just found this website while searching over the internet, you have posted valuable information which i like reading Slotxo
ReplyDeleteThis site contains a lot of really good information. Lots of useful inaformation. I'll add it to my bookmarks and stop by often.
ReplyDelete안전놀이터
I’m going to read this. I’ll be sure to come back. thanks for sharing. and also This article gives the light in which we can observe the reality. this is very nice one and gives indepth information. thanks for this nice article먹튀검증업체
ReplyDeleteI have read the title which you have made about self hosted. You have made a great effort in making this post which is appreciable 먹튀검증사이트
ReplyDeleteI think this is an informative post and it is very beneficial and knowledgeable. Therefore, I would like to thank you for the endeavors that you have made in writing this article. All the content is absolutely well-researched. Thanks... Status moj whatsApp
ReplyDeleteThanks for sharing this information. I really like your blog post very much. You have really shared a informative and interesting blog post with people.. click here
ReplyDeleteIf you aren’t using SEO Software then you will know the amount of work load involved in creating accounts, confirming emails and submitting your contents to thousands of websites.
ReplyDeleteWith THIS SOFTWARE the link submission process will be the easiest task and completely automated, you will be able to build unlimited number of links and increase traffic to your websites which will lead to a higher number of customers and much more sales for you
카지노사이트
wep.
This is a great inspiring article.I am pretty much pleased with your good work.You put really very helpful information... click here
ReplyDeleteGood day! I know this is kinda off topic however , I’d figured I’d ask.
ReplyDeleteWould you be interested in trading links or maybe guest writing a blog article or 슬롯추천
vice-versa? My blog goes over a lot of the same topics as yours and I believe we could greatly
benefit from each other. If you happen to be interested feel
free to shoot me an e-mail. I look forward
to hearing from you! Great blog by the way! 온라인슬롯
I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well. In fact your creative writing abilities has inspired me to start my own Blog Engine blog now. Really the blogging is spreading its wings rapidly. Your write up is a fine example of it. click here
ReplyDeleteWe stumbled over here by a different website and thought I might check things out. I like what I see so now i am following you. Look forward to finding out about your web page again. bongdo
ReplyDeleteExcellent read, I just passed this onto a friend who was doing a little research on that. And he actually bought me lunch as I found it for him smile Therefore let me rephrase that: Thank you for lunch. 메이저사이트
ReplyDeleteI’m very happy to discover this web site. I need to to thank you for ones time for this particularly wonderful read!! I definitely enjoyed every part of it and i also have you book-marked to check out new information on your web site. 안전놀이터순위
ReplyDeleteI conceive this internet site has got some really good information for everyone :D. “Nothing great was ever achieved without enthusiasm.” by Ralph Waldo Emerson. 스포츠토토사이트
ReplyDeleteWhen I read your article on this topic, my first thought seems to be profound and difficult. My site has a discussion board for articles and photos similar to this topic. If you leave a discussion thread on the topic, it will be reflected. 샌즈카지노
ReplyDeleteHi there, I simply hopped over in your website by way of StumbleUpon. Now not one thing I’d typically learn, but I favored your emotions none the less. Thank you for making something worth reading. 메이저검증
ReplyDeleteI am so happy to read this. This is the kind of manual that needs to be given and not the random misinformation that’s at the other blogs. Appreciate your sharing this greatest doc. 메이저토토
ReplyDeleteNice article.
ReplyDeleteThanks for the info information, I will wait for posts like this and will read them with pleasure.
Don't forget visit my website:
Sports Report
Joshua vs Usyk 2 Live Stream
B2K
It's too bad to check your article late. I wonder what it would be if we met a little faster. I want to exchange a little more, but please visit my site 메이저토토사이트 and leave a message!!
ReplyDelete온라인카지노사이트 I must say, as a lot as I enjoyed reading what you had to say, I couldnt help but lose interest after a while.
ReplyDeleteI really liked your article post.Really looking forward to read more. Great.
ReplyDelete카지노사이트
Everything is very open with a precise explanation of the issues.
ReplyDeleteIt was really informative. Your website is useful. Thank
you for sharing! 토토
토토사이트 After going over a number of the blog posts on your website, I truly appreciate your way
ReplyDeleteof writing a blog. I saved it to my bookmark website list and will be checking back in the
near future. Please check out my web site as well and let me know how you feel.
I’m thinking some of my readers might find a bit of this interesting. Do you mind if I post a clip from this and link back? Thanks 안전놀이터
ReplyDeleteWhen I read your article on this topic, the first thought seems profound and difficult. There is also a bulletin board for discussion of articles and photos similar to this topic on my site, but I would like to visit once when I have time to discuss this topic. sòng bạc
ReplyDeleteMany thanks for the article, I have a lot of spray lining knowledge but always learn something new. Keep up the good work and thank you again. 메이저사이트모음
ReplyDeletethis is good and best urologist in Jaipur
ReplyDeleteI like the helpful info you provide in your articles. I’ll bookmark your blog and check again here frequently. I’m quite sure I’ll learn plenty of new stuff right here! Good luck for the next. 스포츠토토
ReplyDeleteWhy couldn't I have the same or similar opinions as you? T^T I hope you also visit my blog and give us a good opinion.casino online
ReplyDeleteI am a new user of this site so here i saw multiple articles and posts posted by this site,I curious more interest in some of them hope you will give more information on this topics in your next articles. Samsung Galaxy Tab A 8.4 (2020) Price
ReplyDeleteIndeed, this made them think what different exercises are useful for those of us who wind up out and about or have restricted gear choices. satta
ReplyDeleteI read this article. I think You put a lot of effort to create this article. I appreciate your work Oppo Find X2 Price
ReplyDeleteExcellent read, I just passed this onto a friend who was doing a little research on that. And he actually bought me lunch as I found it for him smile Therefore let me rephrase that: Thank you for lunch. 먹튀신고
ReplyDeleteVery nice article, I enjoyed reading your post, very nice share, I want to twit this to my followers. Thanks! satta
ReplyDeleteIndeed, this made them think what different exercises are useful for those of us who wind up out and about or have restricted gear choices. matka
ReplyDeleteThank you so much for providing good quality information.I think it would not have been easy to collect this information and organize it in an easy to understand way.igtok
ReplyDeletevery nice and great article, thanks for sharing with us! satta matka
ReplyDeleteI am someone who works on the web. Sometimes I like to visit overseas sites 메이저안전놀이터 when I have time. Among them, I like the site related to , but your site seems to be optimized for too!! Very good
ReplyDeleteI believe the things you whatever you have enclosed, all the way throughout the post are peaceful striking, good job and great hard work. I found it very striking and enjoyed reading all of it...stay it up, good-looking job. Thanks. andrey belyakov
ReplyDeleteThat's a really impressive new idea! 안전한놀이터 It touched me a lot. I would love to hear your opinion on my site. Please come to the site I run once and leave a comment. Thank you.
ReplyDeleteI have read your post, thank you for sharing, your post is very helpful to me. I hope you will have many good articles to bring to the reader.I want to start a credit card processing company
ReplyDeleteI am incapable of reading articles online very often, but I’m happy I did today. It is very well written, and your points are well-expressed. I request you warmly, please, don’t ever stop writing. North American Bancard Agent Program
ReplyDeleteThat is a great tip particularly to those new to the blogosphere.
ReplyDeleteSimple but very accurate info? Thank you for sharing this one.
A must read post!
Appreciating the hard work you put into your site and detailed information you present.
Wonderful read!
토토사이트
Indeed, this made them think what different exercises are useful for those of us who wind up out and about or have restricted gear choices. مسلسلات رمضان 2022
ReplyDeleteI like the helpful info you provide in your articles. I’ll bookmark your blog and check again here frequently. I’m quite sure I’ll learn plenty of new stuff right here! Good luck for the next. 스포츠토토
ReplyDeleteYou completed a few fine points there. I did a search on the subject and found nearly all persons will go along with with your blog. rolet online
ReplyDeleteKeep up the good work , I read few posts on this web site and I conceive that your blog is very interesting and has sets of fantastic information. japritoto
ReplyDeleteI've been using WordPress on a number of websites for about a year and am worried about switching to another platform. I have heard good things about 토토사이트추천. Is there a way I can transfer all my wordpress content into it? Any help would be really appreciated!
ReplyDeleteที่สุดแห่ง เว็บคาสิโน biobetgaming บริการตลอด 24 ชั่วโมง บริการด้านเกมคาสิโนหลากหลายเช่น บาคาร่าออนไลน์ รูเร็ท แบล็คแจ็ค เสือมังกร ไฮโล และอื่นๆอีกมากมาย ที่มาพร้อมกับโปรโมชั่นโดนใจเน้นๆ ที่นี่ที่
ReplyDelete