Shulou(Shulou.com)05/31 Report--

How to analyze the PDB level flashback of Oracle 12.2, I believe that many inexperienced people do not know what to do about it. Therefore, this paper summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

Prior to Oracle Database 12.2, flashback database (FLASHBACK DATABASE) operations could only be performed at the CDB level

FLASHBACK DATABASE cdb1 TO RESTORE POINT restore_point1

This obviously leads to a problem that all the PDB in CDB is flashed back, which may not be what we expected.

By 12.2, the flashback feature has been added to allow flashback at the PDB level:

FLASHBACK PLUGGABLE DATABASE pdb1 TO RESTORE POINT restore_point1

This enhancement is undoubtedly closer to the actual needs, making the flashback function more practical.

After reading the above, have you mastered how to analyze the PDB level flashback of Oracle 12.2? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.