数据库增量备份 - DB INCR DB FULL

最新推荐文章于 2023-02-14 17:30:16 发布
最新推荐文章于 2023-02-14 17:30:16 发布
阅读量1.1k 收藏 1
点赞数
文章标签： 数据库 oracle
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/hezuijiudexiaobai/article/details/125574356
版权 
backup incremental level=0 database;

在这里插入图片描述

backup incremental level=1 database;

在这里插入图片描述

backup incremental level=0 database;

在这里插入图片描述

问题1：1级别增量未显示？
问题2：第二次0级别增量和第一次重合？
在这里插入图片描述

backup database;

在这里插入图片描述

DB INCR -> DB FULL
在这里插入图片描述

delete backup;

在这里插入图片描述

list backup;

List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1       Full    17.95M     DISK        00:00:01     01-JUL-22      
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20220701T151241
        Piece Name: /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oralog/fast_recovery_area/BAIPX/autobackup/2022_07_01/o1_mf_s_1108912361_kcx7mb24_.bkp
  SPFILE Included: Modification time: 01-JUL-22
  SPFILE db_unique_name: BAIPX
  Control File Included: Ckp SCN: 2187017      Ckp time: 01-JUL-22

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2       Full    17.92M     DISK        00:00:01     02-JUL-22      
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: TAG20220702T150938
        Piece Name: /opt/oracle/product/19c/dbhome_1/dbs/stdbyctl.bkp
  Standby Control File Included: Ckp SCN: 2705259      Ckp time: 02-JUL-22

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3       Full    17.95M     DISK        00:00:00     02-JUL-22      
        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: TAG20220702T150941
        Piece Name: /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oralog/fast_recovery_area/BAIPX/autobackup/2022_07_02/o1_mf_s_1108998581_kczvso6x_.bkp
  SPFILE Included: Modification time: 01-JUL-22
  SPFILE db_unique_name: BAIPX
  Control File Included: Ckp SCN: 2705271      Ckp time: 02-JUL-22

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
4       742.57M    DISK        00:00:02     02-JUL-22      
        BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: TAG20220702T152902
        Piece Name: /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oralog/fast_recovery_area/BAIPX/backupset/2022_07_02/o1_mf_annnn_TAG20220702T152902_kczwxyxg_.bkp

  List of Archived Logs in backup set 4
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    3       2151704    01-JUL-22 2444432    02-JUL-22
  1    4       2444432    02-JUL-22 2710116    02-JUL-22
  1    5       2710116    02-JUL-22 2710296    02-JUL-22

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5       Full    17.95M     DISK        00:00:00     02-JUL-22      
        BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: TAG20220702T152906
        Piece Name: /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oralog/fast_recovery_area/BAIPX/autobackup/2022_07_02/o1_mf_s_1108999746_kczwy2dl_.bkp
  SPFILE Included: Modification time: 01-JUL-22
  SPFILE db_unique_name: BAIPX
  Control File Included: Ckp SCN: 2710331      Ckp time: 02-JUL-22

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
6       743.68M    DISK        00:00:02     02-JUL-22      
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20220702T154249
        Piece Name: /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oralog/fast_recovery_area/BAIPX/backupset/2022_07_02/o1_mf_annnn_TAG20220702T154249_kczxqsbo_.bkp

  List of Archived Logs in backup set 6
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    3       2151704    01-JUL-22 2444432    02-JUL-22
  1    4       2444432    02-JUL-22 2710116    02-JUL-22
  1    5       2710116    02-JUL-22 2710296    02-JUL-22
  1    6       2710296    02-JUL-22 2711341    02-JUL-22
  1    7       2711341    02-JUL-22 2713958    02-JUL-22

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7       Full    17.95M     DISK        00:00:00     02-JUL-22      
        BP Key: 7   Status: AVAILABLE  Compressed: NO  Tag: TAG20220702T154252
        Piece Name: /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oralog/fast_recovery_area/BAIPX/autobackup/2022_07_02/o1_mf_s_1109000572_kczxqwmq_.bkp
  SPFILE Included: Modification time: 01-JUL-22
  SPFILE db_unique_name: BAIPX
  Control File Included: Ckp SCN: 2713980      Ckp time: 02-JUL-22

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8       Incr 0  1.25G      DISK        00:00:04     02-JUL-22      
        BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: TAG20220702T161035
        Piece Name: /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oralog/fast_recovery_area/BAIPX/backupset/2022_07_02/o1_mf_nnnd0_TAG20220702T161035_kczzcvxd_.bkp
  List of Datafiles in backup set 8
  File LV Type Ckp SCN    Ckp Time  Abs Fuz SCN Sparse Name
  ---- -- ---- ---------- --------- ----------- ------ ----
  1    0  Incr 2721804    02-JUL-22              NO    /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oradata/BAIPX/datafile/o1_mf_system_kcx49hsc_.dbf
  3    0  Incr 2721804    02-JUL-22              NO    /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oradata/BAIPX/datafile/o1_mf_sysaux_kcx4blz4_.dbf
  4    0  Incr 2721804    02-JUL-22              NO    /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oradata/BAIPX/datafile/o1_mf_undotbs1_kcx4cd47_.dbf
  7    0  Incr 2721804    02-JUL-22              NO    /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oradata/BAIPX/datafile/o1_mf_users_kcx4cf72_.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
9       Incr 0  486.38M    DISK        00:00:01     02-JUL-22      
        BP Key: 9   Status: AVAILABLE  Compressed: NO  Tag: TAG20220702T161035
        Piece Name: /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oralog/fast_recovery_area/BAIPX/E2B9FAFA647138A5E053A5010A649B83/backupset/2022_07_02/o1_mf_nnnd0_TAG20220702T161035_kczzd32v_.bkp
  List of Datafiles in backup set 9
  Container ID: 3, PDB Name: WOQU
  File LV Type Ckp SCN    Ckp Time  Abs Fuz SCN Sparse Name
  ---- -- ---- ---------- --------- ----------- ------ ----
  9    0  Incr 2721818    02-JUL-22              NO    /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oradata/BAIPX/E2B9FAFA647138A5E053A5010A649B83/datafile/o1_mf_system_kcx71njc_.dbf
  10   0  Incr 2721818    02-JUL-22              NO    /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oradata/BAIPX/E2B9FAFA647138A5E053A5010A649B83/datafile/o1_mf_sysaux_kcx71njo_.dbf
  11   0  Incr 2721818    02-JUL-22              NO    /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oradata/BAIPX/E2B9FAFA647138A5E053A5010A649B83/datafile/o1_mf_undotbs1_kcx71njp_.dbf
  12   0  Incr 2721818    02-JUL-22              NO    /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oradata/BAIPX/E2B9FAFA647138A5E053A5010A649B83/datafile/o1_mf_baipx_kcx73702_.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
10      Incr 0  556.57M    DISK        00:00:01     02-JUL-22      
        BP Key: 10   Status: AVAILABLE  Compressed: NO  Tag: TAG20220702T161035
        Piece Name: /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oralog/fast_recovery_area/BAIPX/E2B9662A39002352E0532402F40ABC79/backupset/2022_07_02/o1_mf_nnnd0_TAG20220702T161035_kczzd68z_.bkp
  List of Datafiles in backup set 10
  Container ID: 2, PDB Name: PDB$SEED
  File LV Type Ckp SCN    Ckp Time  Abs Fuz SCN Sparse Name
  ---- -- ---- ---------- --------- ----------- ------ ----
  5    0  Incr 2171525    01-JUL-22              NO    /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oradata/BAIPX/datafile/o1_mf_system_kcx4m11h_.dbf
  6    0  Incr 2171525    01-JUL-22              NO    /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oradata/BAIPX/datafile/o1_mf_sysaux_kcx4m11l_.dbf
  8    0  Incr 2171525    01-JUL-22              NO    /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oradata/BAIPX/datafile/o1_mf_undotbs1_kcx4m11m_.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
11      Full    17.95M     DISK        00:00:00     02-JUL-22      
        BP Key: 11   Status: AVAILABLE  Compressed: NO  Tag: TAG20220702T161049
        Piece Name: /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oralog/fast_recovery_area/BAIPX/autobackup/2022_07_02/o1_mf_s_1109002249_kczzd9d1_.bkp
  SPFILE Included: Modification time: 01-JUL-22
  SPFILE db_unique_name: BAIPX
  Control File Included: Ckp SCN: 2721839      Ckp time: 02-JUL-22

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
12      Incr 1  22.79M     DISK        00:00:01     02-JUL-22      
        BP Key: 12   Status: AVAILABLE  Compressed: NO  Tag: TAG20220702T161328
        Piece Name: /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oralog/fast_recovery_area/BAIPX/backupset/2022_07_02/o1_mf_nnnd1_TAG20220702T161328_kczzk88d_.bkp
  List of Datafiles in backup set 12
  File LV Type Ckp SCN    Ckp Time  Abs Fuz SCN Sparse Name
  ---- -- ---- ---------- --------- ----------- ------ ----
  1    1  Incr 2722680    02-JUL-22              NO    /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oradata/BAIPX/datafile/o1_mf_system_kcx49hsc_.dbf
  3    1  Incr 2722680    02-JUL-22              NO    /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oradata/BAIPX/datafile/o1_mf_sysaux_kcx4blz4_.dbf
  4    1  Incr 2722680    02-JUL-22              NO    /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oradata/BAIPX/datafile/o1_mf_undotbs1_kcx4cd47_.dbf
  7    1  Incr 2722680    02-JUL-22              NO    /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oradata/BAIPX/datafile/o1_mf_users_kcx4cf72_.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
13      Incr 1  96.00K     DISK        00:00:01     02-JUL-22      
        BP Key: 13   Status: AVAILABLE  Compressed: NO  Tag: TAG20220702T161328
        Piece Name: /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oralog/fast_recovery_area/BAIPX/E2B9FAFA647138A5E053A5010A649B83/backupset/2022_07_02/o1_mf_nnnd1_TAG20220702T161328_kczzkcdp_.bkp
  List of Datafiles in backup set 13
  Container ID: 3, PDB Name: WOQU
  File LV Type Ckp SCN    Ckp Time  Abs Fuz SCN Sparse Name
  ---- -- ---- ---------- --------- ----------- ------ ----
  9    1  Incr 2722750    02-JUL-22              NO    /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oradata/BAIPX/E2B9FAFA647138A5E053A5010A649B83/datafile/o1_mf_system_kcx71njc_.dbf
  10   1  Incr 2722750    02-JUL-22              NO    /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oradata/BAIPX/E2B9FAFA647138A5E053A5010A649B83/datafile/o1_mf_sysaux_kcx71njo_.dbf
  11   1  Incr 2722750    02-JUL-22              NO    /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oradata/BAIPX/E2B9FAFA647138A5E053A5010A649B83/datafile/o1_mf_undotbs1_kcx71njp_.dbf
  12   1  Incr 2722750    02-JUL-22              NO    /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oradata/BAIPX/E2B9FAFA647138A5E053A5010A649B83/datafile/o1_mf_baipx_kcx73702_.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
14      Full    17.95M     DISK        00:00:00     02-JUL-22      
        BP Key: 14   Status: AVAILABLE  Compressed: NO  Tag: TAG20220702T161332
        Piece Name: /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oralog/fast_recovery_area/BAIPX/autobackup/2022_07_02/o1_mf_s_1109002412_kczzkdns_.bkp
  SPFILE Included: Modification time: 01-JUL-22
  SPFILE db_unique_name: BAIPX
  Control File Included: Ckp SCN: 2722764      Ckp time: 02-JUL-22

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
15      Incr 0  1.27G      DISK        00:00:04     02-JUL-22      
        BP Key: 15   Status: AVAILABLE  Compressed: NO  Tag: TAG20220702T161553
        Piece Name: /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oralog/fast_recovery_area/BAIPX/backupset/2022_07_02/o1_mf_nnnd0_TAG20220702T161553_kczzoswb_.bkp
  List of Datafiles in backup set 15
  File LV Type Ckp SCN    Ckp Time  Abs Fuz SCN Sparse Name
  ---- -- ---- ---------- --------- ----------- ------ ----
  1    0  Incr 2723333    02-JUL-22              NO    /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oradata/BAIPX/datafile/o1_mf_system_kcx49hsc_.dbf
  3    0  Incr 2723333    02-JUL-22              NO    /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oradata/BAIPX/datafile/o1_mf_sysaux_kcx4blz4_.dbf
  4    0  Incr 2723333    02-JUL-22              NO    /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oradata/BAIPX/datafile/o1_mf_undotbs1_kcx4cd47_.dbf
  7    0  Incr 2723333    02-JUL-22              NO    /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oradata/BAIPX/datafile/o1_mf_users_kcx4cf72_.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
16      Incr 0  486.38M    DISK        00:00:01     02-JUL-22      
        BP Key: 16   Status: AVAILABLE  Compressed: NO  Tag: TAG20220702T161553
        Piece Name: /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oralog/fast_recovery_area/BAIPX/E2B9FAFA647138A5E053A5010A649B83/backupset/2022_07_02/o1_mf_nnnd0_TAG20220702T161553_kczzp11g_.bkp
  List of Datafiles in backup set 16
  Container ID: 3, PDB Name: WOQU
  File LV Type Ckp SCN    Ckp Time  Abs Fuz SCN Sparse Name
  ---- -- ---- ---------- --------- ----------- ------ ----
  9    0  Incr 2723350    02-JUL-22              NO    /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oradata/BAIPX/E2B9FAFA647138A5E053A5010A649B83/datafile/o1_mf_system_kcx71njc_.dbf
  10   0  Incr 2723350    02-JUL-22              NO    /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oradata/BAIPX/E2B9FAFA647138A5E053A5010A649B83/datafile/o1_mf_sysaux_kcx71njo_.dbf
  11   0  Incr 2723350    02-JUL-22              NO    /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oradata/BAIPX/E2B9FAFA647138A5E053A5010A649B83/datafile/o1_mf_undotbs1_kcx71njp_.dbf
  12   0  Incr 2723350    02-JUL-22              NO    /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oradata/BAIPX/E2B9FAFA647138A5E053A5010A649B83/datafile/o1_mf_baipx_kcx73702_.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
17      Incr 0  556.57M    DISK        00:00:01     02-JUL-22      
        BP Key: 17   Status: AVAILABLE  Compressed: NO  Tag: TAG20220702T161553
        Piece Name: /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oralog/fast_recovery_area/BAIPX/E2B9662A39002352E0532402F40ABC79/backupset/2022_07_02/o1_mf_nnnd0_TAG20220702T161553_kczzp45h_.bkp
  List of Datafiles in backup set 17
  Container ID: 2, PDB Name: PDB$SEED
  File LV Type Ckp SCN    Ckp Time  Abs Fuz SCN Sparse Name
  ---- -- ---- ---------- --------- ----------- ------ ----
  5    0  Incr 2171525    01-JUL-22              NO    /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oradata/BAIPX/datafile/o1_mf_system_kcx4m11h_.dbf
  6    0  Incr 2171525    01-JUL-22              NO    /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oradata/BAIPX/datafile/o1_mf_sysaux_kcx4m11l_.dbf
  8    0  Incr 2171525    01-JUL-22              NO    /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oradata/BAIPX/datafile/o1_mf_undotbs1_kcx4m11m_.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
18      Full    17.95M     DISK        00:00:00     02-JUL-22      
        BP Key: 18   Status: AVAILABLE  Compressed: NO  Tag: TAG20220702T161607
        Piece Name: /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oralog/fast_recovery_area/BAIPX/autobackup/2022_07_02/o1_mf_s_1109002567_kczzp7cr_.bkp
  SPFILE Included: Modification time: 01-JUL-22
  SPFILE db_unique_name: BAIPX
  Control File Included: Ckp SCN: 2723375      Ckp time: 02-JUL-22

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
19      784.87M    DISK        00:00:01     02-JUL-22      
        BP Key: 19   Status: AVAILABLE  Compressed: NO  Tag: TAG20220702T161845
        Piece Name: /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oralog/fast_recovery_area/BAIPX/backupset/2022_07_02/o1_mf_annnn_TAG20220702T161845_kczzv61s_.bkp

  List of Archived Logs in backup set 19
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    3       2151704    01-JUL-22 2444432    02-JUL-22
  1    4       2444432    02-JUL-22 2710116    02-JUL-22
  1    5       2710116    02-JUL-22 2710296    02-JUL-22
  1    6       2710296    02-JUL-22 2711341    02-JUL-22
  1    7       2711341    02-JUL-22 2713958    02-JUL-22
  1    8       2713958    02-JUL-22 2724397    02-JUL-22

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
20      Full    17.95M     DISK        00:00:00     02-JUL-22      
        BP Key: 20   Status: AVAILABLE  Compressed: NO  Tag: TAG20220702T161849
        Piece Name: /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oralog/fast_recovery_area/BAIPX/autobackup/2022_07_02/o1_mf_s_1109002729_kczzv9bh_.bkp
  SPFILE Included: Modification time: 01-JUL-22
  SPFILE db_unique_name: BAIPX
  Control File Included: Ckp SCN: 2724423      Ckp time: 02-JUL-22

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
21      Full    1.28G      DISK        00:00:03     02-JUL-22      
        BP Key: 21   Status: AVAILABLE  Compressed: NO  Tag: TAG20220702T162022
        Piece Name: /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oralog/fast_recovery_area/BAIPX/backupset/2022_07_02/o1_mf_nnndf_TAG20220702T162022_kczzy68d_.bkp
  List of Datafiles in backup set 21
  File LV Type Ckp SCN    Ckp Time  Abs Fuz SCN Sparse Name
  ---- -- ---- ---------- --------- ----------- ------ ----
  1       Full 2724793    02-JUL-22              NO    /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oradata/BAIPX/datafile/o1_mf_system_kcx49hsc_.dbf
  3       Full 2724793    02-JUL-22              NO    /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oradata/BAIPX/datafile/o1_mf_sysaux_kcx4blz4_.dbf
  4       Full 2724793    02-JUL-22              NO    /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oradata/BAIPX/datafile/o1_mf_undotbs1_kcx4cd47_.dbf
  7       Full 2724793    02-JUL-22              NO    /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oradata/BAIPX/datafile/o1_mf_users_kcx4cf72_.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
22      Full    486.38M    DISK        00:00:01     02-JUL-22      
        BP Key: 22   Status: AVAILABLE  Compressed: NO  Tag: TAG20220702T162022
        Piece Name: /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oralog/fast_recovery_area/BAIPX/E2B9FAFA647138A5E053A5010A649B83/backupset/2022_07_02/o1_mf_nnndf_TAG20220702T162022_kczzyfd3_.bkp
  List of Datafiles in backup set 22
  Container ID: 3, PDB Name: WOQU
  File LV Type Ckp SCN    Ckp Time  Abs Fuz SCN Sparse Name
  ---- -- ---- ---------- --------- ----------- ------ ----
  9       Full 2724811    02-JUL-22              NO    /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oradata/BAIPX/E2B9FAFA647138A5E053A5010A649B83/datafile/o1_mf_system_kcx71njc_.dbf
  10      Full 2724811    02-JUL-22              NO    /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oradata/BAIPX/E2B9FAFA647138A5E053A5010A649B83/datafile/o1_mf_sysaux_kcx71njo_.dbf
  11      Full 2724811    02-JUL-22              NO    /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oradata/BAIPX/E2B9FAFA647138A5E053A5010A649B83/datafile/o1_mf_undotbs1_kcx71njp_.dbf
  12      Full 2724811    02-JUL-22              NO    /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oradata/BAIPX/E2B9FAFA647138A5E053A5010A649B83/datafile/o1_mf_baipx_kcx73702_.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
23      Full    556.57M    DISK        00:00:01     02-JUL-22      
        BP Key: 23   Status: AVAILABLE  Compressed: NO  Tag: TAG20220702T162022
        Piece Name: /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oralog/fast_recovery_area/BAIPX/E2B9662A39002352E0532402F40ABC79/backupset/2022_07_02/o1_mf_nnndf_TAG20220702T162022_kczzyjh9_.bkp
  List of Datafiles in backup set 23
  Container ID: 2, PDB Name: PDB$SEED
  File LV Type Ckp SCN    Ckp Time  Abs Fuz SCN Sparse Name
  ---- -- ---- ---------- --------- ----------- ------ ----
  5       Full 2171525    01-JUL-22              NO    /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oradata/BAIPX/datafile/o1_mf_system_kcx4m11h_.dbf
  6       Full 2171525    01-JUL-22              NO    /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oradata/BAIPX/datafile/o1_mf_sysaux_kcx4m11l_.dbf
  8       Full 2171525    01-JUL-22              NO    /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oradata/BAIPX/datafile/o1_mf_undotbs1_kcx4m11m_.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
24      Full    17.95M     DISK        00:00:00     02-JUL-22      
        BP Key: 24   Status: AVAILABLE  Compressed: NO  Tag: TAG20220702T162035
        Piece Name: /opt/oracle/qfusion/volumes/qfusion-admin_baipx-435cb0-0/oralog/fast_recovery_area/BAIPX/autobackup/2022_07_02/o1_mf_s_1109002835_kczzymno_.bkp
  SPFILE Included: Modification time: 01-JUL-22
  SPFILE db_unique_name: BAIPX
  Control File Included: Ckp SCN: 2724899      Ckp time: 02-JUL-22
喝醉酒的小白
关注
Oracle技术之EXP_FULL_DATABASE
weixin_34032827的博客
07-03 2156
没有EXP_FULL_DATABASE角色，会出现下面错误：ORA-31631: privileges are requiredORA-39149: cannot link privileged user to non-privileged userSQL> create database link pdbl connect to rman identified by ...
Oracle DB 备份和恢复的概念
一抹曦阳-Oracle
10-11 8233
• 确定Oracle DB 中可能发生的故障类型 • 说明优化实例恢复的方法 • 说明检查点、重做日志文件和归档日志文件的重要性 • 配置快速恢复区 • 配置ARCHIVELOG模式   部分工作内容 数据库管理员的职责包括： • 尽量避免数据库出现故障 • 延长平均故障间隔时间(MTBF) • 通过冗余方式保护关键组件 • 缩短平均恢复时间(MTTR) • 最
rman 定时增量全备
EVISWANG的博客
12-02 608
[oracle@tiger script]$ crontab -l 0 0 * * 0,3 /u01/rman/script/rman_db_inr0.sh 0 0 * * 1,2,4-6 /u01/rman/script/rman_db_inr1.sh [oracle@tiger script]$  [oracle@tiger script]$ cat rman_db_inr0.sh
V$RMAN_BACKUP_JOB_DETAILS
喝醉酒的小白
01-27 2778
记录rman备份的相关信息
v$v$RMAN_BACKUP_JOB_DETAILS 的OUTPUT_DEVICE_TYP 是DB INCR
cuixunan6912的博客
04-14 382
col INPUT_BYTES_PER_SEC_DISPLAY format a15; col OUTPUT_BYTES_PER_SEC_DISPLAY format a15; col TIME_TAKEN_DISPL...
使用RMAN 备份与恢复数据库
唐唐的专栏
09-05 1690
我的备份和恢复都是在归档模式下完成的，本文开头部分需要启停数据库，因此请不要在生产环境上操作，如果在生产环境上操作由此产生的任何问题与博主无关。 1.检查数据库是否为归档模式： oracle@linux:~> sqlplus / as sysdba; 红框中所示为非归档模式，停止数据库，使用如下命令开启归档模式，并设置为自动归档： SQL> alter database archiv
MySQL--基于Xtrabackup+Shell+Crond实现的数据库（全量+增量）热备份方案
热门推荐
JustinQin
08-27 3万+
学习背景 不管你是正在上学，还是已经工作了，想必多多少少都听说过删库跑路、rm -rf的情况，主要指的就是被有意或无意的删除掉了数据库的数据，而数据是整个业务最重要的价值体现，如果你的公司或者项目组没有一个成熟的数据库数据备份方案，一旦发生意外，我只能说年轻人，大意了吧，没有备份数据库！！！ 一、Xtrabackup介绍 官方介绍文档 简单总结下来就是XtraBackup是Percona旗下的一款产品，支持MySQL数据库的热备份（在线不停机），并且是免费、开源，适用所有MySQL版本，非阻塞、紧密
金仓数据库Kingbase ES如何进行增量备份与恢复
mee1234的博客
03-07 5396
背景：在数据库运维过程中对大量数据进行备份，每次全量备份，随着业务数据不断积累，全量备份后的文件大小也会逐渐增加，需要占用大量的存储空间，这种情况下如果能对数据进行增量备份就显得格外重要。增量备份按备份的粒度一般可分为文件级别的增量备份和块级别的增量备份。 增量备份仅选择上一次全量或差异或增量备份后，发生了变化的文件或数据块。优点是更加地节省空间。缺点是还原时，需要本次增量备份以及前次备份、再前次备份、直到串行依赖到一次全量备份。 文件增量备份，备份的对象是发生变化的数据文件。块...
Oracle数据库定时增量备份脚本
漫谈数据 程序人生
06-08 891
创建一个目录放备份脚本 mkdir rman_scripts 创建RMAN删除脚本 vim delete_rman.dat 键入以下内容: ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE disk; run{ allocate channel d1 device type disk; allocate channel d2 device type disk; delete obsolete recovery window of 7days; releas
达梦数据库创建备份作业
qq_41270538的博客
02-14 615
达梦数据库创建备份作业
IXP435
04-16
网络处理器资料，有需要的看看
IPX425.zip
03-05
文件内容包括： ixp42x-product-line-network-processors-datasheet.pdf IXP425 brief.pdf 在Intel Ixp425网络处理器上构建嵌入式Linux系统.pdf Intel® IXP42X Product Line of Network Processors and IXC1100 Control Plane Processor Developer’s Manual
达梦数据库备份与还原
weixin_45455246的博客
09-29 1394
达梦数据库的备份与还原
oracle重建spfile,oracle spfile 丢失，简单恢复案例！
weixin_33139275的博客
04-03 1162
如果系统的spfile丢失，在有备份的情况下，可以直接进行恢复的，在生产环境中，rman的设置和备份集的设置可能和实验环境不一样，不过还是大同小异，我们先来看一下测试环境的基本情况：C#oracle@linux-fz9d:~> rman target /Recovery Manager: Release 12.1.0.1.0 - Production on Wed Oct 30 11:32:...
关于rman增量备份
gumengkai的博客
12-11 1312
oracle中，增量备份即只备份从之前某个指定的备份以来变化的数据块。可以分为累计增量备份(cumulative)和差异(differential)增量备份，默认为累计增量备份(恢复时间段)，其中差异增量备份指备份自上一次同级别或是上一次更高级别的备份完成以后的的数据库发生改变的数据块，而累计增量备份则是自上一次上一级增量备份以来数据库发生改变的数据块。 增量备份一般分为0级和1级，0级备份是后
达梦数据库配置自动备份和自动删除过期备份文件方法
牛排煎黑椒的博客
03-03 1789
达梦数据库配置自动备份和自动删除过期备份文件方法 设置每周日晚上23点进行整库备份，并且删除备份日期超过30天的备份文件 DISQL创建方法： 以下是设置自动备份的DDL语句： call SP_JOB_CONFIG_START('DB_FULL_BACKUP'); call SP_ADD_JOB_STEP('DB_FULL_BACKUP', '全库备份', 6, '03030300/dm8/backup', 3, 3, 0, 0, NULL, 0); call SP_ADD_JOB_SCHEDULE('
Oracle Database 12c RMAN全量+增量备份+归档日志恢复详解
lvshaorong的博客
09-22 1万+
介绍了Oracle Database 12c使用RMAN进行全量备份，增量备份，归档日志备份，并通过各种备份+归档日志恢复到任意时间点的方法。包括单独恢复表空间的方法。
增量备份的一些小细节总结
gujunpu的专栏
12-19 926
哪些对象支持增量备份  If you specify INCREMENTAL, then in the backupSpec clause you must set one of the following parameters: DATAFILE, DATAFILECOPY, TABLESPACE, or DATABASE. RMAN does not support incremental
RMAN增量备份
喝醉酒的小白
05-17 2877
RMAN增量备份 概念 增量备份只备份自特定的先前备份之后变化的数据块。 每个数据块上都包含一个SCN，SCN可以标识最近一次对于Block的变更。在增量备份的过程中，RMAN读取每一个数据块的SCN之前的备份SCN相比较，从而判断出Block是否发生了变化，然后据此进行备份。但是需要注意的是，在大型数据库中，RMAN的扫描时间可能会极其漫长，所以如何采用增量备份仍然需要慎重，在Oracle 10g中，为了改变这一状况，Oracle引入了Block ChangeTracking 新特性来解决这一问题。 增量
mysqldump增量备份数据库
最新发布
11-28
mysqldump是MySQL数据库备份工具，可以用于备份整个数据库或单个表。mysqldump增量备份数据库的方法如下： 1.首先创建一个全量备份，使用以下命令： ```shell mysqldump -u username -p --databases dbname > dbname_full_backup.sql ``` 其中，username是MySQL数据库的用户名，dbname是要备份的数据库名，-p选项会提示输入密码。 2.创建一个用于存储增量备份的目录，例如： ```shell mkdir /path/to/incremental/backup ``` 3.使用以下命令创建一个增量备份： ```shell mysqldump -u username -p --databases dbname --no-create-info --skip-triggers --single-transaction --flush-logs | gzip > /path/to/incremental/backup/dbname_incr_backup_$(date +%F_%T).sql.gz ``` 其中，--no-create-info选项表示只备份数据而不备份表结构，--skip-triggers选项表示不备份触发器，--single-transaction选项表示使用事务来确保备份的一致性，--flush-logs选项表示刷新二进制日志以便备份程序可以访问新的日志文件。 4.将增量备份文件和全量备份文件一起恢复到新的MySQL服务器上，使用以下命令： ```shell gunzip -c dbname_full_backup.sql.gz | mysql -u username -p dbname mysqlbinlog binlog.00000X | mysql -u username -p dbname gunzip -c dbname_incr_backup.sql.gz | mysql -u username -p dbname ``` 其中，gunzip命令用于解压缩备份文件，mysqlbinlog命令用于解析二进制日志文件，最后一个命令用于将增量备份文件恢复到新的MySQL服务器上。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值