{"id":331,"date":"2020-11-02T09:46:06","date_gmt":"2020-11-02T01:46:06","guid":{"rendered":"http:\/\/www.821121.com\/?p=331"},"modified":"2020-12-11T10:16:57","modified_gmt":"2020-12-11T02:16:57","slug":"%e6%96%b0%e7%89%b9%e6%80%a7%ef%bc%9acdb-pdb%e7%9a%84%e7%bb%b4%e6%8a%a4%e5%91%bd%e4%bb%a4%ef%bc%9a%e5%a4%87%e4%bb%bd%e4%b8%8e%e6%81%a2%e5%a4%8d%ef%bc%885%ef%bc%89pdb%e5%9f%ba%e4%ba%8e%e6%97%b6%e9%97%b4","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=331","title":{"rendered":"\u65b0\u7279\u6027\uff1aCDB\/PDB\u7684\u7ef4\u62a4\u547d\u4ee4\uff1a\u5907\u4efd\u4e0e\u6062\u590d\uff085\uff09PDB\u57fa\u4e8e\u65f6\u95f4\u70b9\u7684\u6062\u590d"},"content":{"rendered":"

\u5b9e\u9a8c\u7b80\u4ecb\uff1aPDB\u57fa\u4e8e\u65f6\u95f4\u70b9\u7684\u6062\u590d\uff0cPDB1_WHS\u6062\u590d\u5230\u4e4b\u524d\u7684\u65f6\u95f4\u70b9\uff0c\u4f46\u4e0d\u5f71\u54cd\u5176\u4ed6\u7684PDB<\/p>\n

\u521b\u5efa\u5b9e\u9a8c\u6570\u636e<\/h2>\n
[root@cat1 ~]# su - oracle\nLast login: Mon May  2 18:19:30 CST 2005 on pts\/0\n[oracle@cat1 ~]$ export ORACLE_SID=whs11\n[oracle@cat1 ~]$ sqlplus \/ as sysdba\n\nSQL*Plus: Release 19.0.0.0.0 - Production on Tue May 3 15:51:40 2005\nVersion 19.3.0.0.0\n\nCopyright (c) 1982, 2019, Oracle.  All rights reserved.\n\nConnected to:\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\nVersion 19.3.0.0.0\n\nSQL> show pdbs\n\n    CON_ID CON_NAME                       OPEN MODE  RESTRICTED\n---------- ------------------------------ ---------- ----------\n         2 PDB$SEED                       READ ONLY  NO\n         3 PDB1_WHS                       READ WRITE NO\n         4 PDB2_WHS                       MOUNTED\n         5 PDB3_WHS                       MOUNTED\nSQL> alter session set container=PDB1_WHS;\n\nSession altered.\n\nSQL> create table test as select * from dba_tables;\n\nTable created.\n\nSQL> select count(*) from test;\n\n  COUNT(*)\n----------\n      2177\n\nSQL> select timestamp_to_scn(sysdate) from dual;\n\nTIMESTAMP_TO_SCN(SYSDATE)\n-------------------------\n                 49827779\n\nSQL> truncate table test;   <--\u6e05\u7a7a\u6570\u636e\n\nTable truncated.\n\nSQL> select count(*) from test;\n\n  COUNT(*)\n----------\n      0\nSQL> alter pluggable database PDB1_WHS close immediate;\n\nPluggable database altered.\n\nSQL> alter session set container=PDB2_WHS;\n\nSession altered.\n\nSQL> startup\nPluggable Database opened.\nSQL> create table test as select * from dba_tables;\n\nTable created.\n\nSQL>  select count(*) from test;\n\n  COUNT(*)\n----------\n      2178<\/code><\/pre>\n
rman\u6062\u590dPDB1_WHS\uff0c\u4e0d\u5f71\u54cdPDB2_WHS<\/h2>\n
[oracle@cat1 ~]$ rman target \/\n\nRecovery Manager: Release 19.0.0.0.0 - Production on Tue May 3 16:05:06 2005\nVersion 19.3.0.0.0\n\nCopyright (c) 1982, 2019, Oracle and\/or its affiliates.  All rights reserved.\n\nconnected to target database: WHS1 (DBID=2406852607)\n\nRMAN> run{\n2> set until scn=49827779;\n3> restore pluggable database PDB1_WHS;\n4> recover pluggable database PDB1_WHS;\n5> alter pluggable database PDB1_WHS open resetlogs;\n6> }\n\nexecuting command: SET until clause\n\nStarting restore at 03-MAY-05\nusing target database control file instead of recovery catalog\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=158 instance=whs11 device type=DISK\n\nchannel ORA_DISK_1: starting datafile backup set restore\nchannel ORA_DISK_1: specifying datafile(s) to restore from backup set\nchannel ORA_DISK_1: restoring datafile 00010 to +DATA1\/WHS1\/B4D31742116320ECE0532900A8C025DC\/DATAFILE\/system.274.1057318913\nchannel ORA_DISK_1: restoring datafile 00011 to +DATA1\/WHS1\/B4D31742116320ECE0532900A8C025DC\/DATAFILE\/sysaux.275.1057318911\nchannel ORA_DISK_1: restoring datafile 00012 to +DATA1\/WHS1\/B4D31742116320ECE0532900A8C025DC\/DATAFILE\/undotbs1.273.1057318911\nchannel ORA_DISK_1: restoring datafile 00013 to +DATA1\/WHS1\/B4D31742116320ECE0532900A8C025DC\/DATAFILE\/undo_2.277.1057318927\nchannel ORA_DISK_1: restoring datafile 00014 to +DATA1\/WHS1\/B4D31742116320ECE0532900A8C025DC\/DATAFILE\/users.278.1057318927\nchannel ORA_DISK_1: reading from backup piece \/rmanbackup\/rman0_WHS1_9_20050503\nchannel ORA_DISK_1: piece handle=\/rmanbackup\/rman0_WHS1_9_20050503 tag=LEVEL0\nchannel ORA_DISK_1: restored backup piece 1\nchannel ORA_DISK_1: restore complete, elapsed time: 00:00:15\nFinished restore at 03-MAY-05\n\nStarting recover at 03-MAY-05\ncurrent log archived\nusing channel ORA_DISK_1\n\nstarting media recovery\n\narchived log for thread 1 with sequence 2 is already on disk as file +DATA1\/WHS1\/ARCHIVELOG\/2005_05_03\/thread_1_seq_2.296.557280929\narchived log for thread 1 with sequence 3 is already on disk as file +DATA1\/WHS1\/ARCHIVELOG\/2005_05_03\/thread_1_seq_3.297.557337933\nmedia recovery complete, elapsed time: 00:00:00\nFinished recover at 03-MAY-05\n\nStatement processed<\/code><\/pre>\n
\u9a8c\u8bc1<\/h2>\n
PDB1_WHS\u6062\u590d\u7684truncate\u524d\uff0cPDB2_WHS\u4e0d\u53d7\u5f71\u54cd<\/p>\n
SQL> show pdbs\n\n    CON_ID CON_NAME                       OPEN MODE  RESTRICTED\n---------- ------------------------------ ---------- ----------\n         2 PDB$SEED                       READ ONLY  NO\n         3 PDB1_WHS                       READ WRITE NO\n         4 PDB2_WHS                       READ WRITE NO\n         5 PDB3_WHS                       MOUNTED\nSQL> alter session set container=PDB1_WHS;\n\nSession altered.\n\nSQL> select count(*) from test;\n\n  COUNT(*)\n----------\n      2177\n\nSQL> alter session set container=PDB2_WHS;\n\nSession altered.\n\nSQL> select count(*) from test;\n\n  COUNT(*)\n----------\n      2178<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
\u5b9e\u9a8c\u7b80\u4ecb\uff1aPDB\u57fa\u4e8e\u65f6\u95f4\u70b9\u7684\u6062\u590d\uff0cPDB1_WHS<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[39],"tags":[],"class_list":["post-331","post","type-post","status-publish","format-standard","hentry","category-39"],"_links":{"self":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/331","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=331"}],"version-history":[{"count":1,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/331\/revisions"}],"predecessor-version":[{"id":332,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/331\/revisions\/332"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=331"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=331"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=331"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}