This feature is useful in the following scenarios:
- Object has Logical corruption or dropped
- There is no sufficient undo to perform Flashback table
- DDL operation modified the structure and you want to recover the data (Flashback cannot rewind the structural changes)
- Recover a small number of tables to a point-in-time
The conditions must be met to perform table/ table Partition recovery:
Before you prepare to recover the tables and table partitions,
- Database must be in ARCHIVELOG mode and read-write mode
- At least one full backup is available along with archived logs
- Enough disk space is available on the database server for auxiliary instance
- If present, any dependent objects to include in recovery
- At least 1 Gigabyte extra in memory for the auxiliary database
- Tables and table partitions on standby databases cannot be recovered.
- Tables with named NOT NULL constraints cannot be recovered with the REMAP option. · COMPATIBLE parameter must be set to 11.1.0 or higher to recover table partition
RMAN enables recovery of selected tables without affecting remaining database objects. During the recovery process RMAN creates an auxiliary database, which is used to recover the tables or table partitions to a specified point-in-time. User need to specify the auxiliary database location using AUXILIARY DESTINATION clause in the RECOVERY command or SET NEWNAME command.Please find the steps performed by RMAN during the recovery process:
1. Determine the backup which has the tables or table partitions that needs to recover to specified point-in-time
2. Create auxiliary database and recovery the tables or table partitions until specified point-in-time
3. Take a data dump export with recovered tables or table partitions
4. Import the dump into target database
5. Rename the recovered tables or table partitions in the target database
Please find an example to recovery TABLE1 table.
RECOVER TABLE TESTUSER.TABLE1
UNTIL SCN 384840289
AUXILIARY DESTINATION '/TEMP/ORCLDB/recover'
DATAPUMP DESTINATION '/TEMP/ORCLDB/dumpfiles'
DUMP FILE 'testdump.dat';
If source table exists then user can specify NOTABLEIMPORT or REMAP TABLE. Also user can use UNTIL TIME or UNTIL SEQUENCE clause to specify point-in-time recovery.
Please find an example to recovery TABLE1 table as TABLE1_REC to the state that it was 2 days before the current date.
RECOVER TABLE TESTUSER.TABLE1
UNTIL TIME ‘SYSDATE-2’
AUXILIARY DESTINATION '/TEMP/ORCLDB/recover'
REMAP TABLE 'TESTUSER'.'TABLE1':'TABLE1_REC';
There are some limitations recovering tables and table partitions:
- We cannot recover table and table partitions belongs of SYS schema
- We cannot recover table or table partitions from SYSAUX,SYSTEM tablespace Tables
- We cannot recover tables with named NOT NULL constraint using REMAP option.
- We cannot recover Table/Table partitions ON STANDBY database
- We cannot recovery table partitions if version is prior Oracle Database 11g R1
Refer below link for
Flashback and Database Point-in-Time Recovery
http://docs.oracle.com/database/121/BRADV/rcmflash.htm#g1016666
RMAN Tablespace point-in-time Recovery (TSPITR)
http://docs.oracle.com/database/121/BRADV/rcmtspit.htm#CIHGGAFH
Thanks,
RMAN Tablespace point-in-time Recovery (TSPITR)
http://docs.oracle.com/database/121/BRADV/rcmtspit.htm#CIHGGAFH
Thanks,
Satishbabu Gunukula, Oracle ACE
http://www.oracleracexpert.com
visit to our website for Hp printers help
ReplyDeleteHP Printer customer support number
hp printer customer care number
hp printer technical support number
hp service centre USA
hp store contact number
hp service centre near me
HP Printer tech support phone number USA
Great Article Artificial Intelligence Projects
DeleteProject Center in Chennai
JavaScript Training in Chennai
JavaScript Training in Chennai
ReplyDeleteدينا نقل عفش جدة دينا نقل عفش جدة
افضل شركة نقل عفش من جدة الى الرياض شركة نقل عفش من جدة الى الرياض
شركة نقل عفش من جدة الى دبي شركة شحن عفش من جدة الى الامارات
ارخص معلم دهانات بالرياض
شركة تركيب واجهات حجر بالرياض
ارخص شركة نقل عفش بمكة
شركة نقل عفش من جدة الى الاردن شركة شحن عفش من جدة الى الاردن
Railway Recruitment Board is conducting examination for NTPC posts. RRB NTPC 2019 Result will release on the official website of Railway Recruitment Board.
ReplyDeleteAl-Ghurair is similar to a small lattice with a solid structure and a furrow of heavy, coarse hair. Thirty centimeters, his face white and has a broad black line on both sides, his body is gray, his ears are very small
ReplyDeleteAnd also his eyes, and in fact he hardly uses his eyes but depends primarily on his hearing and sharp sense of smell at him, Its skin is softer and softer, so that the badger can bite the dog that bites it if the dog, for example, bites it. If the badger senses fear or excitation, he will smell like musk.
The largest Arabic entertainment site in the world
if you want more just look here "koktale"
Yet, one should also keep in mind that it is also a great opportunity for a candidate to present themselves in a very favorable light. Here is the list of the most effective techniques in case one needs help with writing a presentation for an interview
ReplyDeleteif you want more just look here "presentations online"
List of Best Carpenters Service Near me in Bangalore - Top Rated Carpenter in Bangalore, Book Carpenter Services Online in Bangalore, Book Carpentry Services Online at Home In Bangalore. Get Free Best Price Quotes Carpenters Service in Bangalore Compare Charges, Save Money And Time @ Carpenters in Bangalore
ReplyDeleteList of Best House Painters Service Near me in Bangalore - Top Rated House Painters in Bangalore, Book House Painters Services Online in Bangalore, Wall Painters in Bangalore. Best Price Quotes House Painters Service in Bangalore Compare Charges, Save Money And Time @ House Painters in Bangalore
ReplyDeleteList of Best Plumbers Services Near me in Bangalore - Top Rated Plumbers in Bangalore, Book Plumbing Services Online in Bangalore, Get Certified Technician at Your Doorstep for Plumbers Services. Best Price Quotes Plumbers Service in Bangalore Compare Charges, Save Money And Time @ Plumbers in Bangalore
ReplyDeleteList of Best Electronic Service Near me in Bangalore - Top Rated Electrician in Bangalore, Book Electronic Services Online in Bangalore, Get Certified Technician at Your Doorstep for Electronic Services. Best Price Quotes Electronic Service in Bangalore Compare Charges, Save Money And Time @ Electricians in Bangalore
ReplyDeleteشركة مكافحة الحمام بالمدينة المنورة
ReplyDeleteWe are popular as Florist Service in Gurgaon from last 10 Years, we also offers fresh flowers cakes and latest gifts across Gurgaon. Send flowers online and Offline from flower shop for your loved ones and availlable for corporate gifting with fastest delivery.
ReplyDeleteFlorist Service in Gurgaon
Online Florist Services in Gurgaon
Packers and Movers Hyderabad Give Certified and Verified Service Providers, Cheap and Best ###Office Relocation Charges, ***Home Shifting, ✔✔✔Goods Insurance worth Rs. 10,000, Assurance for Local and Domestic House Shifting. Safe and Reliable Household Shifting Services in Hyderabad with Reasonable Packers and Movers Price Quotation @ Packers And Movers Hyderabad
ReplyDeleteAttend The Analytics Training Institute From ExcelR. Practical Analytics Training Institute Sessions With Assured Placement Support From Experienced Faculty. ExcelR Offers The Analytics Training Institute.
ReplyDeleteExcelR Analytics Training Institute
Hire Best Packers And Movers Mumbai for hassle-free Household Shifting, ***Office Relocation, ###Car Transporation, Loading Unloading, packing Unpacking at affordable ✔✔✔ Price Quotation. Top Rated, Safe and Secure Service Providers who can help you with 24x7 and make sure a Untroubled Relocation Services at Cheapest/Lowest Rate
ReplyDeletePackers And Movers Mumbai
من اجود وارخص الشركات التي توجد في منطقة مكة المكرمة والتي تعمل في مجال نقل العفش مع الفك والتركيب تلك الشركة الجيدة التي تقدم خدمات جيدة وتسمى افضل شركة نقل اثاث بجدة ايضا وهي التي تختص بنقل العفش من بيت الى بيت آخر في مدينة جدة وما جاورها من مناطق تابعة لها وقد نضطر قبل نقل العفش الى المكان الجديد الى تنظيف المنزل الجديد قبل النقل من افضل شركات منطقة مكة المكرمة التي تعمل في مجال تنظيف وتعقيم المنازل تلك الشركة الجيدة التي تقدم خدمات جيدة في تنظيف المنازل من الداخل ومن الخارج وتسمى شركة تنظيف منازل بجدة وهي التي تختص بأعمال التنظيف للمنازل الجديدة والمفروشة ومن الأفضل ان تقوم بعمل مكافحة للحشرات بالتواصل مع افضل واقوى الشركات التي تقدم خدمات مكافحة حشرات المنزل البق والصراصير والنمل والعته تلك التي تستخدم مبيدات آمنة وفعالة ومضمونة مثل افضل شركه مكافحه الصراصير بجده التي تتعامل في مكافحة الحشرات وتستخدم مبيدات آمنة ومضمونة ونحتاج ايضا الى تنظيف الخزان وذلك بالتعرف على اكبر وافضل واقوى شركات تنظيف خزانات المياه بجدة تلك التي تقوم بأعمال تنظيف وتعقيم خزانات المياه في جدة بمنتهى الدقة والاحترافية وتقدم ايضا شركه نظافة الخزانات بجده افضل الخدمات الجيدة في تنظيف وتعقيم الخزانات لكي تحافظ على الماء نظيفا ومعقما اطول فترة زمنية ممكنة لكي تكون مياهك نظيفة فان شركه نظافة منازل مستعدة لاستقبال مكالمتكم في أي وقت وطلب الخدمة
ReplyDeleteمن اجود وارخص الشركات التي توجد في منطقة مكة المكرمة والتي تعمل في مجال نقل العفش مع الفك والتركيب تلك الشركة الجيدة التي تقدم خدمات جيدة وتسمى افضل شركة نقل عفش بجدة ايضا وهي التي تختص بنقل العفش من بيت الى بيت آخر في مدينة جدة وما جاورها من مناطق تابعة لها وقد نضطر قبل نقل العفش الى المكان الجديد الى تنظيف المنزل الجديد قبل النقل من افضل شركات منطقة مكة المكرمة التي تعمل في مجال تنظيف وتعقيم المنازل تلك الشركة الجيدة التي تقدم خدمات جيدة في تنظيف المنازل من الداخل ومن الخارج وتسمى شركة تنظيف شقق بجدة وهي التي تختص بأعمال التنظيف للمنازل الجديدة والمفروشة ومن الأفضل ان تقوم بعمل مكافحة للحشرات بالتواصل مع افضل واقوى الشركات التي تقدم خدمات مكافحة حشرات المنزل البق والصراصير والنمل والعته تلك التي تستخدم مبيدات آمنة وفعالة ومضمونة مثل افضل شركه مكافحه حشرات بجده التي تتعامل في مكافحة الحشرات وتستخدم مبيدات آمنة ومضمونة ونحتاج ايضا الى تنظيف الخزان وذلك بالتعرف على اكبر وافضل واقوى شركات تنظيف خزانات المياه بجدة تلك التي تقوم بأعمال تنظيف وتعقيم خزانات المياه في جدة بمنتهى الدقة والاحترافية وتقدم ايضا شركه تنظيف خزانات بجده افضل الخدمات الجيدة في تنظيف وتعقيم الخزانات لكي تحافظ على الماء نظيفا ومعقما اطول فترة زمنية
ReplyDeleteExcellent Blog! I would like to thank for the efforts you have made in writing this post. I am hoping the same best work from you in the future as well. I wanted to thank you for this websites! Thanks for sharing. Great websites!
ReplyDeletedata science course in mumbai
I just got to this amazing site not long ago. I was actually captured with the piece of resources you have got here. Big thumbs up for making such wonderful blog page!
ReplyDeletedata analytics courses
In this page, all essential information on latest and upcoming railway recruitment 2020 recruitment is presented in the tabular form which is very user-friendly and easy to understand...
ReplyDeleteyou can also get latest 1mg Coupons offer
ReplyDeleteIf you have applied for a new government job or want to get some information about an exam, then you can get the exact updates of every information with Sarkari Jobs, with the right Sarkari Exam notification and much more.
ReplyDeleteGood job by admin to share this information
ReplyDeleteThis is a wonderful article, Given so much info in it, Thanks for sharing. CodeGnan offers courses in new technologies and makes sure students understand the flow of work from each and every perspective in a Real-Time environmen python training in vijayawada. , data scince training in vijayawada . , java training in vijayawada. ,
ReplyDeletewonderful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article resolved my all queries. keep it up.
ReplyDeletedata analytics course in Bangalore
I'm not one of those perusers that remarks on articles frequently, yet yours truly constrained me. There's a ton of fascinating substance with regards to this article is intriguing and intense.
ReplyDeleteSEO services in kolkata
Best SEO services in kolkata
SEO company in kolkata
Best SEO company in kolkata
Top SEO company in kolkata
Top SEO services in kolkata
SEO services in India
SEO copmany in India
You should have a great deal of pride recorded as a hard copy quality substance. I'm dazzled with the measure of strong data you have written in your article. I want to understand more.
ReplyDeleteOnline Teaching Platforms
Online Live Class Platform
Online Classroom Platforms
Online Training Platforms
Online Class Software
Virtual Classroom Software
Online Classroom Software
Learning Management System
Learning Management System for Schools
Learning Management System for Colleges
Learning Management System for Universities
Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
ReplyDeleteCorrelation vs Covariance
Simple linear regression
data science interview questions
By reading this article, many things have piled up in my mind which made me to think about it.
ReplyDeleteSAP training in Kolkata
SAP course in kolkata
SAP training institute in Kolkata
You have put some high quality and valuable information here that any reader would love to read. I sincerely share many of your views in this article.
ReplyDeleteSAP training in Mumbai
SAP course in Mumbai
SAP training institute Mumbai
Thanks for the information about call centers. It is always great to read about this ever changing industry.
ReplyDeleteDenial management software
Denials management software
Hospital denial management software
Self Pay Medicaid Insurance Discovery
Uninsured Medicaid Insurance Discovery
Medical billing Denial Management Software
Self Pay to Medicaid
Charity Care Software
Patient Payment Estimator
Underpayment Analyzer
Claim Status
Since this is much scientific than spiritual, let's speak in terms of science. I will try not to put a lot of scientific terminology so that a common man or woman could understand the content easily. artificial intelligence training in hyderabad
ReplyDeleteThis is my first visit to your blog! We are a team of volunteers and new
ReplyDeleteinitiatives in the same niche. Blog gave us useful information to work. You
have done an amazing job!
artificial intelligence training in Bangalore
Attend The Course in Data Analytics From ExcelR. Practical Course in Data Analytics Sessions With Assured Placement Support From Experienced Faculty. ExcelR Offers The Course in Data Analytics.
ReplyDeleteCourse in Data Analytics
Attend The Data Analyst Course From ExcelR. Practical Data Analyst Course Sessions With Assured Placement Support From Experienced Faculty. ExcelR Offers The Data Analyst Course.
ReplyDeleteData Analyst Course
Attend The Data Analyst Course From ExcelR. Practical Data Analyst Course Sessions With Assured Placement Support From Experienced Faculty. ExcelR Offers The Data Analyst Course.
ReplyDeleteData Analyst Course
I realize that, the skills that the companies wants now are different from the skills that I have learnt during my degree course, for the reason that all the companies are digital orientated. digital marketing course in hyderabad
ReplyDeleteUnlike data science, machine learning is a set of techniques that allow computers to make decisions based on the given data. And these techniques derive results that can perform much better without the need of programming rules. best AI course
ReplyDeleteAmazing Article ! I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
ReplyDeleteSimple Linear Regression
Correlation vs covariance
data science interview questions
KNN Algorithm
Logistic Regression explained
very well explained. I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
ReplyDeleteLogistic Regression explained
Correlation vs Covariance
Simple Linear Regression
data science interview questions
KNN Algorithm
Great tips and very easy to understand. This will definitely be very useful for me when I get a chance to start my blog.
ReplyDeleteData Science Training in Hyderabad
What an extremely wonderful post this is. Genuinely, perhaps the best post I've at any point seen to find in as long as I can remember. Goodness, simply keep it up.
ReplyDeletedigital marketing course in delhi
Instagram stories allow businesses to interact with their customers and prospects by making a series of images in order to tell a story. Each story you create should enhance your brand and make your value proposition clear. fitur instagram
ReplyDeleteThis was incredibly an exquisite implementation of your ideas ExcelR Business Analytics Courses
ReplyDelete