{"id":302,"date":"2020-10-26T12:01:39","date_gmt":"2020-10-26T04:01:39","guid":{"rendered":"http:\/\/www.821121.com\/?p=302"},"modified":"2020-12-11T10:15:59","modified_gmt":"2020-12-11T02:15:59","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%881%ef%bc%89%e5%8d%95%e7%8b%ac%e5%a4%87%e4%bb%bdpdb","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=302","title":{"rendered":"\u65b0\u7279\u6027\uff1aCDB\/PDB\u7684\u7ef4\u62a4\u547d\u4ee4\uff1a\u5907\u4efd\u4e0e\u6062\u590d\uff081\uff09\u5355\u72ec\u5907\u4efdPDB"},"content":{"rendered":"

\u5355\u72ec\u5907\u4efdPDB<\/h2>\n

\u5173\u952e\u8bcd\u4e3apluggable database PDB1_WHS<\/p>\n

RMAN> backup as compressed backupset  incremental level=0 pluggable database PDB1_WHS  format '\/rmanbackup\/rman0_%d_%s_%T' tag='level0' plus archivelog;\n\nStarting backup at 02-MAY-05\ncurrent log archived\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=395 instance=whs11 device type=DISK\nchannel ORA_DISK_1: starting compressed archived log backup set\nchannel ORA_DISK_1: specifying archived log(s) in backup set\ninput archived log thread=2 sequence=1 RECID=1 STAMP=557258812\ninput archived log thread=1 sequence=16 RECID=3 STAMP=557259632\ninput archived log thread=2 sequence=2 RECID=2 STAMP=557258827\nchannel ORA_DISK_1: starting piece 1 at 02-MAY-05\nchannel ORA_DISK_1: finished piece 1 at 02-MAY-05\npiece handle=\/u01\/app\/oracle\/product\/19.3.0\/db_1\/dbs\/01gje6rg_1_1 tag=TAG20050502T182032 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\nFinished backup at 02-MAY-05\n\nStarting backup at 02-MAY-05\nusing channel ORA_DISK_1\nchannel ORA_DISK_1: starting compressed incremental level 0 datafile backup set\nchannel ORA_DISK_1: specifying datafile(s) in backup set\ninput datafile file number=00011 name=+DATA1\/WHS1\/B4D31742116320ECE0532900A8C025DC\/DATAFILE\/sysaux.275.1057318911\ninput datafile file number=00010 name=+DATA1\/WHS1\/B4D31742116320ECE0532900A8C025DC\/DATAFILE\/system.274.1057318911\ninput datafile file number=00012 name=+DATA1\/WHS1\/B4D31742116320ECE0532900A8C025DC\/DATAFILE\/undotbs1.273.1057318911\ninput datafile file number=00013 name=+DATA1\/WHS1\/B4D31742116320ECE0532900A8C025DC\/DATAFILE\/undo_2.277.1057318927\ninput datafile file number=00014 name=+DATA1\/WHS1\/B4D31742116320ECE0532900A8C025DC\/DATAFILE\/users.278.1057318927\nchannel ORA_DISK_1: starting piece 1 at 02-MAY-05\nchannel ORA_DISK_1: finished piece 1 at 02-MAY-05\npiece handle=\/rmanbackup\/rman0_WHS1_2_20050502 tag=LEVEL0 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:15\nFinished backup at 02-MAY-05\n\nStarting backup at 02-MAY-05\ncurrent log archived\nusing channel ORA_DISK_1\nchannel ORA_DISK_1: starting compressed archived log backup set\nchannel ORA_DISK_1: specifying archived log(s) in backup set\ninput archived log thread=1 sequence=17 RECID=4 STAMP=557259651\nchannel ORA_DISK_1: starting piece 1 at 02-MAY-05\nchannel ORA_DISK_1: finished piece 1 at 02-MAY-05\npiece handle=\/u01\/app\/oracle\/product\/19.3.0\/db_1\/dbs\/03gje6s3_1_1 tag=TAG20050502T182051 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\nFinished backup at 02-MAY-05\n\nStarting Control File and SPFILE Autobackup at 02-MAY-05\npiece handle=\/u01\/app\/oracle\/product\/19.3.0\/db_1\/dbs\/c-2406852607-20050502-00 comment=NONE\nFinished Control File and SPFILE Autobackup at 02-MAY-05\n\nRMAN> list backup;\n\nList of Backup Sets\n===================\n\nBS Key  Size       Device Type Elapsed Time Completion Time\n------- ---------- ----------- ------------ ---------------\n1       6.88M      DISK        00:00:01     02-MAY-05      \n        BP Key: 1   Status: AVAILABLE  Compressed: YES  Tag: TAG20050502T182032\n        Piece Name: \/u01\/app\/oracle\/product\/19.3.0\/db_1\/dbs\/01gje6rg_1_1\n\n  List of Archived Logs in backup set 1\n  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time\n  ---- ------- ---------- --------- ---------- ---------\n  1    16      49683875   01-MAY-05 49786269   02-MAY-05\n  2    1       2149681    24-NOV-20 49784912   02-MAY-05\n  2    2       49784912   02-MAY-05 49785026   02-MAY-05\n\nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ ---------------\n2       Incr 0  97.85M     DISK        00:00:11     02-MAY-05      \n        BP Key: 2   Status: AVAILABLE  Compressed: YES  Tag: LEVEL0\n        Piece Name: \/rmanbackup\/rman0_WHS1_2_20050502\n  List of Datafiles in backup set 2\n  Container ID: 3, PDB Name: PDB1_WHS\n  File LV Type Ckp SCN    Ckp Time  Abs Fuz SCN Sparse Name\n  ---- -- ---- ---------- --------- ----------- ------ ----\n  10   0  Incr 49786295   02-MAY-05              NO    +DATA1\/WHS1\/B4D31742116320ECE0532900A8C025DC\/DATAFILE\/system.274.1057318911\n  11   0  Incr 49786295   02-MAY-05              NO    +DATA1\/WHS1\/B4D31742116320ECE0532900A8C025DC\/DATAFILE\/sysaux.275.1057318911\n  12   0  Incr 49786295   02-MAY-05              NO    +DATA1\/WHS1\/B4D31742116320ECE0532900A8C025DC\/DATAFILE\/undotbs1.273.1057318911\n  13   0  Incr 49786295   02-MAY-05              NO    +DATA1\/WHS1\/B4D31742116320ECE0532900A8C025DC\/DATAFILE\/undo_2.277.1057318927\n  14   0  Incr 49786295   02-MAY-05              NO    +DATA1\/WHS1\/B4D31742116320ECE0532900A8C025DC\/DATAFILE\/users.278.1057318927\n\nBS Key  Size       Device Type Elapsed Time Completion Time\n------- ---------- ----------- ------------ ---------------\n3       7.50K      DISK        00:00:00     02-MAY-05      \n        BP Key: 3   Status: AVAILABLE  Compressed: YES  Tag: TAG20050502T182051\n        Piece Name: \/u01\/app\/oracle\/product\/19.3.0\/db_1\/dbs\/03gje6s3_1_1\n\n  List of Archived Logs in backup set 3\n  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time\n  ---- ------- ---------- --------- ---------- ---------\n  1    17      49786269   02-MAY-05 49786309   02-MAY-05\n\nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ ---------------\n4       Full    18.89M     DISK        00:00:02     02-MAY-05      \n        BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: TAG20050502T182052\n        Piece Name: \/u01\/app\/oracle\/product\/19.3.0\/db_1\/dbs\/c-2406852607-20050502-00\n  SPFILE Included: Modification time: 02-MAY-05\n  SPFILE db_unique_name: WHS1\n  Control File Included: Ckp SCN: 49786322     Ckp time: 02-MAY-05<\/code><\/pre>\n
\u5355\u72ec\u5907\u4efdPDB\u7684\u8868\u7a7a\u95f4<\/h2>\n
RMAN> backup tablespace PDB1_WHS:users format '\/rmanbackup\/rmantbs_%d_%s_%T';\n\nStarting backup at 02-MAY-05\nusing channel ORA_DISK_1\nchannel ORA_DISK_1: starting full datafile backup set\nchannel ORA_DISK_1: specifying datafile(s) in backup set\ninput datafile file number=00014 name=+DATA1\/WHS1\/B4D31742116320ECE0532900A8C025DC\/DATAFILE\/users.278.1057318927\nchannel ORA_DISK_1: starting piece 1 at 02-MAY-05\nchannel ORA_DISK_1: finished piece 1 at 02-MAY-05\npiece handle=\/rmanbackup\/rmantbs_WHS1_7_20050502 tag=TAG20050502T183011 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\nFinished backup at 02-MAY-05\n\nStarting Control File and SPFILE Autobackup at 02-MAY-05\npiece handle=\/u01\/app\/oracle\/product\/19.3.0\/db_1\/dbs\/c-2406852607-20050502-02 comment=NONE\nFinished Control File and SPFILE Autobackup at 02-MAY-05<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
\u5355\u72ec\u5907\u4efdPDB \u5173\u952e\u8bcd\u4e3apluggable dat<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[],"class_list":["post-302","post","type-post","status-publish","format-standard","hentry","category-oracle-12c"],"_links":{"self":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/302","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=302"}],"version-history":[{"count":2,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/302\/revisions"}],"predecessor-version":[{"id":305,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/302\/revisions\/305"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=302"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=302"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=302"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}