12c-Say goodbye to your backup when dropping your PDB
SQL> drop PLUGGABLE database ZSKMSDB;
Pluggable database dropped.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
4 OSSPORTALDB MOUNTED
SQL>
只能全容器庫恢復了:-----想當然的看問題了!!!
反覆嘗試恢復失敗,最終發現一旦pdb drop後沒法恢復的,天呢!!!
後來vpn**谷歌,發現有個老外有寫到:
RMAN 12c : Say goodbye to your backup when dropping your PDB:
I was working on my presentations for IOUG Collaborate, and I came upon this strange behaviour in RMAN 12c (12.1.0.1.0) which to me, shouldn’t happen. Seems that when you do a DROP PLUGGABLE DATABASE , it is the equivalent of DROP DATABASE INCLUDING BACKUPS. This means that if you need to restore your PDB later on, you won’t have this registered – just be careful when dropping them-----------
http://www.pythian.com/blog/rman-12c-say-goodbye-to-your-backup-when-dropping-your-pdb/
他測試和我測試差不多,結論也一樣:一旦pdb drop後,拿備份根本恢復不了:DROP PLUGGABLE DATABASE =DROP DATABASE INCLUDING BACKUPS.
***********************************************************
If you have a valid RMAN backups then do the following and it will work:
1) Create a new Auxiliary instance, and do a RMAN restore for the following PDBS only : ROOT, PDB$SEED and the Dropped PDB that needs to be restored.
2) Open this newly created Auxiliary instance.
3) You should be able to see all the 3 PDB (root, pdb$seed and dropped PDB) with all the datafiles.
4) Follow the process of unplugging and then plugging in this dropped PDB from the restored auxiliary instance into the original source CDB and you should be all set.
5) Drop the Auxiliary instance now.
***********************************************************************************
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/13750068/viewspace-1177355/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Backup your Linux SystemLinux
- Your Prediction Gets As Good As Your DataGo
- Your title
- Prettier your projectProject
- In your opinion with 6 sentences
- deploy-your-site
- translate-your-site
- talk-to-your-data
- Scan Your Truck Using Nexiq Adapter: Simplifying Your Diagnostic ProcessAPT
- Pay close attention to your download code——Visual Studio trick to run code when buildingUI
- How Good Are Your Opinion 2Go
- Running the app on your deviceAPPdev
- Speed Up Your WordPress Site
- Bugs Fixed for Your PlatformPlatform
- connect your tunnel to CloudflareCloud
- 錯誤內容:You have an error in your SQL syntax; check the manual that corresponds to your MySQL serverErrorMySqlServer
- Project Management - 2) Estimate Your WorkProject
- your Android sdk is missingAndroid
- Build Your Own Cas Service - ProUI
- Discover Your Missed ASM Disks(轉)ASM
- Would you like to develop a story for your character?dev
- Creating your first iOS FrameworkiOSFramework
- Structuring Your TensorFlow ModelsStruct
- RuneScape - To verify your level of combatBAT
- Getting NOW() in your preferred time zone
- Get your Windows product key from a scriptWindows
- EF:split your EDMX file into multiple diagrams
- vncserver: couldn't find "xauth" on your PATHVNCServer
- JQuery Plugin 2 - Passing Options into Your PluginjQueryPlugin
- How to build your custom release bazel version?UI
- Boost Your Strategy With The Content Marketing Tools
- Your Tokens Are Mine: A Suspicious Scam Token in A Top Exchange
- MySQL:Your password does not satisfy the current policy requirementsMySqlUIREM
- squid!Your cache is running out of fileUI
- vncserver: couldn't find "xauth" on your PATH.VNCServer
- Python Analyzing your Gmail with MatplotlibPythonAI
- SQL Server wanting, start your journey now!SQLServer
- Top six reasons to archive your SAP data:Hive