联机执行SQL语句进行数据备份的高级特性分析

这篇文章主要讲解了“联机执行SQL语句进行数据备份的高级特性分析”,文中的讲解内容简单清晰,易于学习与理解,下面请大家跟着小编的思路慢慢深入,一起来研究和学习“联机执行SQL语句进行数据备份的高级特性分析”吧!

1.加密备份
DM7提供加密备份的方式保护用户的备份集,没有权限的用户无法访问加密的备份集。备份语句中通过指定IDENTIFIED BY…WITH ENCRYPTION…ENCRYPT WITH…执行加密备份。其中,参数IDENTIFIED BY指定加密密码,长度不超过128字节,若长度超长服务器会报语法分析出错;参数WITH ENCRYPTION指定加密类型,加密类型分为简单加密和复杂加密,简单加密是对备份文件设置口令,但文件内容仍以明文存储,复杂加密则对备份文件进行完全的加密,备份文件以密文方式存储,用户可根据备份数据的重要程度选择加密类型;参数ENCRYPT WITH指定加密算法,不同加密算法具体见参数说明,也可通过“SELECT * FROM V$CIPHERS”语句查询DM7支持的加密算法,其中算法MD5和SHA1不能在此处使用。默认使用的加密算法为AES256_CFB。

加密备份过程中参数IDENTIFIED BY必须指定,参数WITH ENCRYPTION和参数ENCRYPT WITH可不指定,此时WITH ENCRYPTION默认值为1,ENCRYPT WITH默认值为AES256_CFB。例如,以下两种加密备份语句都是合法的:

SQL> backup database to db_rac_backup_encrypt_01 backupset '/dm7/backup/db_rac_backup_encrypt_2020052901' identified by "abcd123456";
executed successfully
used time: 00:00:01.379. Execute id is 85.
SQL> backup database to db_rac_backup_encrypt_02 backupset '/dm7/backup/db_rac_backup_encrypt_2020052902' identified by "abcd123456" encrypt with rc4;
executed successfully
used time: 00:00:01.313. Execute id is 86.
SQL> select sf_bakset_backup_dir_add('disk','/dm7/backup/db_rac_backup_encrypt_2020052901');
LINEID     SF_BAKSET_BACKUP_DIR_ADD('disk','/dm7/backup/db_rac_backup_encrypt_2020052901')
---------- -------------------------------------------------------------------------------
1          1
used time: 2.066(ms). Execute id is 87.
SQL> select sf_bakset_backup_dir_add('disk','/dm7/backup/db_rac_backup_encrypt_2020052902');
LINEID     SF_BAKSET_BACKUP_DIR_ADD('disk','/dm7/backup/db_rac_backup_encrypt_2020052902')
---------- -------------------------------------------------------------------------------
1          1
used time: 1.532(ms). Execute id is 88.
SQL> select * from v$backupset where backup_path like '/dm7/backup/db_rac_backup_encrypt_202005290%';
LINEID     DEVICE_TYPE BACKUP_ID   PARENT_ID   BACKUP_NAME              BACKUP_PATH                                  TYPE        LEVEL       RANGE#      OBJECT_NAME OBJECT_ID   BASE_NAME BACKUP_TIME                 DESC# ENCRYPT_TYPE COMPRESS_LEVEL WITHOUT_LOG USE_PWR     PKG_SIZE    BEGIN_LSN            END_LSN              BKP_NUM     DBF_NUM     PARALLEL_NUM DDL_CLONE   MPP_FLAG    MIN_TRX_START_LSN    MIN_EXEC_VER CUMULATIVE
---------- ----------- ----------- ----------- ------------------------ -------------------------------------------- ----------- ----------- ----------- ----------- ----------- --------- --------------------------- ----- ------------ -------------- ----------- ----------- ----------- -------------------- -------------------- ----------- ----------- ------------ ----------- ----------- -------------------- ------------ -----------
1          DISK        1180634048  -1          DB_RAC_BACKUP_ENCRYPT_01 /dm7/backup/db_rac_backup_encrypt_2020052901 0           0           1           rac         -1                    2020-05-29 16:41:40.000665        1            0              0           0           33554432    50908                51058                2           4           1            0           0           49398                117507596    0
2          DISK        244985784   -1          DB_RAC_BACKUP_ENCRYPT_02 /dm7/backup/db_rac_backup_encrypt_2020052902 0           0           1           rac         -1                    2020-05-29 16:43:00.000380        1            0              0           0           33554432    50908                51064                2           4           1            0           0           49398                117507596    0
used time: 00:00:01.053. Execute id is 89.

若指定了加密密码,但加密类型WITH ENCRYPTION参数指定为0,则为非加密备份,如下所示:

SQL> backup database to db_rac_backup_encrypt_03 backupset '/dm7/backup/db_rac_backup_encrypt_2020052903' identified by "abcd123456" with encryption 0;
executed successfully
used time: 00:00:01.313. Execute id is 90.
SQL> select sf_bakset_backup_dir_add('disk','/dm7/backup/db_rac_backup_encrypt_2020052903');
LINEID     SF_BAKSET_BACKUP_DIR_ADD('disk','/dm7/backup/db_rac_backup_encrypt_2020052903')
---------- -------------------------------------------------------------------------------
1          1
used time: 1.899(ms). Execute id is 91.
SQL> select * from v$backupset where backup_path like '/dm7/backup/db_rac_backup_encrypt_202005290%';
LINEID     DEVICE_TYPE BACKUP_ID   PARENT_ID   BACKUP_NAME              BACKUP_PATH                                  TYPE        LEVEL       RANGE#      OBJECT_NAME OBJECT_ID   BASE_NAME BACKUP_TIME                 DESC# ENCRYPT_TYPE COMPRESS_LEVEL WITHOUT_LOG USE_PWR     PKG_SIZE    BEGIN_LSN            END_LSN              BKP_NUM     DBF_NUM     PARALLEL_NUM DDL_CLONE   MPP_FLAG    MIN_TRX_START_LSN    MIN_EXEC_VER CUMULATIVE
---------- ----------- ----------- ----------- ------------------------ -------------------------------------------- ----------- ----------- ----------- ----------- ----------- --------- --------------------------- ----- ------------ -------------- ----------- ----------- ----------- -------------------- -------------------- ----------- ----------- ------------ ----------- ----------- -------------------- ------------ -----------
1          DISK        1180634048  -1          DB_RAC_BACKUP_ENCRYPT_01 /dm7/backup/db_rac_backup_encrypt_2020052901 0           0           1           rac         -1                    2020-05-29 16:41:40.000665        1            0              0           0           33554432    50908                51058                2           4           1            0           0           49398                117507596    0
2          DISK        244985784   -1          DB_RAC_BACKUP_ENCRYPT_02 /dm7/backup/db_rac_backup_encrypt_2020052902 0           0           1           rac         -1                    2020-05-29 16:43:00.000380        1            0              0           0           33554432    50908                51064                2           4           1            0           0           49398                117507596    0
3          DISK        1995527143  -1          DB_RAC_BACKUP_ENCRYPT_03 /dm7/backup/db_rac_backup_encrypt_2020052903 0           0           1           rac         -1                    2020-05-29 16:46:17.000633        0            0              0           0           33554432    50908                51070                2           4           1            0           0           49398                117507596    0
used time: 00:00:01.069. Execute id is 92.

从encrypt_type列可以看到备份集/dm7/backup/db_rac_backup_encrypt_2020052903为0,也就证明了备份是没有加密的。

下面以数据库完全备份为例,创建加密密码为“abcd123456”,加密算法为“rc4”的复杂类型数据库加密备份,完整步骤如下:
1) 配置归档 。
2) 保证数据库处于OPEN状态。
3) 备份数据库,输入以下语句:

SQL> backup database to db_rac_backup_encrypt_04 backupset '/dm7/backup/db_rac_backup_encrypt_2020052904' identified by "abcd123456" with encryption 2 encrypt with rc4;
executed successfully
used time: 00:00:01.356. Execute id is 93.
SQL> select sf_bakset_backup_dir_add('disk','/dm7/backup/db_rac_backup_encrypt_2020052904');
LINEID     SF_BAKSET_BACKUP_DIR_ADD('disk','/dm7/backup/db_rac_backup_encrypt_2020052904')
---------- -------------------------------------------------------------------------------
1          1
used time: 1.868(ms). Execute id is 94.
SQL> select * from v$backupset where backup_path='/dm7/backup/db_rac_backup_encrypt_2020052904';
LINEID     DEVICE_TYPE BACKUP_ID   PARENT_ID   BACKUP_NAME              BACKUP_PATH                                  TYPE        LEVEL       RANGE#      OBJECT_NAME OBJECT_ID   BASE_NAME BACKUP_TIME                 DESC# ENCRYPT_TYPE COMPRESS_LEVEL WITHOUT_LOG USE_PWR     PKG_SIZE    BEGIN_LSN            END_LSN              BKP_NUM     DBF_NUM     PARALLEL_NUM DDL_CLONE   MPP_FLAG    MIN_TRX_START_LSN    MIN_EXEC_VER CUMULATIVE
---------- ----------- ----------- ----------- ------------------------ -------------------------------------------- ----------- ----------- ----------- ----------- ----------- --------- --------------------------- ----- ------------ -------------- ----------- ----------- ----------- -------------------- -------------------- ----------- ----------- ------------ ----------- ----------- -------------------- ------------ -----------
1          DISK        141217020   -1          DB_RAC_BACKUP_ENCRYPT_04 /dm7/backup/db_rac_backup_encrypt_2020052904 0           0           1           rac         -1                    2020-05-29 16:49:56.000930        2            0              0           0           33554432    50908                51076                2           4           1            0           0           49398                117507596    0
used time: 00:00:01.067. Execute id is 95.

对于增量备份加密,如果基备份存在加密,则使用的加密算法和加密密码必须与基备份中一致;如果基备份未进行加密处理,则对增量备份使用的加密密码和算法没有特殊要求。

SQL> backup database increment base on backupset '/dm7/backup/db_rac_backup_encrypt_2020052904' backupset '/dm7/backup/db_rac_increment_backup_encrypt_2020052901' identified by "abcd123456" with encryption 2 encrypt with rc4;
executed successfully
used time: 00:00:01.262. Execute id is 96.
SQL> select sf_bakset_backup_dir_add('disk','/dm7/backup/db_rac_increment_backup_encrypt_2020052901');
LINEID     SF_BAKSET_BACKUP_DIR_ADD('disk','/dm7/backup/db_rac_increment_backup_encrypt_2020052901')
---------- -----------------------------------------------------------------------------------------
1          1
used time: 2.210(ms). Execute id is 97.
SQL> select * from v$backupset where backup_path='/dm7/backup/db_rac_increment_backup_encrypt_2020052901';
LINEID     DEVICE_TYPE BACKUP_ID   PARENT_ID   BACKUP_NAME                        BACKUP_PATH                                            TYPE        LEVEL       RANGE#      OBJECT_NAME OBJECT_ID   BASE_NAME                BACKUP_TIME                 DESC# ENCRYPT_TYPE COMPRESS_LEVEL WITHOUT_LOG USE_PWR     PKG_SIZE    BEGIN_LSN            END_LSN              BKP_NUM     DBF_NUM     PARALLEL_NUM DDL_CLONE   MPP_FLAG    MIN_TRX_START_LSN    MIN_EXEC_VER CUMULATIVE
---------- ----------- ----------- ----------- ---------------------------------- ------------------------------------------------------ ----------- ----------- ----------- ----------- ----------- ------------------------ --------------------------- ----- ------------ -------------- ----------- ----------- ----------- -------------------- -------------------- ----------- ----------- ------------ ----------- ----------- -------------------- ------------ -----------
1          DISK        195701720   -1          DB_INCR_rac_20200529_165327_000906 /dm7/backup/db_rac_increment_backup_encrypt_2020052901 1           0           1           rac         -1          DB_RAC_BACKUP_ENCRYPT_04 2020-05-29 16:53:29.000129        2            0              0           0           33554432    50908                51082                2           4           1            0           0           49398                117507596    0
used time: 00:00:01.075. Execute id is 98.

2.设置跟踪日志文件
DM7备份时支持设置跟踪日志文件,日志记录了SBT接口的调用过程,用户通过查看日志可跟踪备份还原过程。

与生成跟踪日志文件相关的参数有两个:TRACE FILE和TRACE LEVEL。TRACE FILE用于指定生成的跟踪日志文件路径,TRACE LEVEL表示是否启用TRACE。TRACE LEVEL有效值包括1和2。1表示不启用TRACE功能,2表示启用,系统默认值为1。

指定参数TRACE FILE但TRACE LEVEL值设置为1即不启用TRACE功能,会生成TRACE文件,但不会写入TRACE信息。如下所示:

SQL> backup database backupset '/dm7/backup/db_rac_backup_2020052905' trace file '/dm7/backup/db_rac_trace.log' trace level 1;
executed successfully
used time: 00:00:01.719. Execute id is 99.
[dmdba@dmrac1 backup]$ cat db_rac_trace.log

TRACE LEVEL值设置为2即启用TRACE功能,但若TRACE FILE没有指定,系统默认在执行码路径的log目录下生成DM_SBTTRACE_年月.log文件。如下所示:

SQL> backup database to db_rac_backup_trace_2020052901 backupset '/dm7/backup/db_rac_backup_trace_2020052901' trace level 2;
executed successfully
used time: 00:00:01.354. Execute id is 101.
[dmdba@dmrac1 log]$ pwd
/dm7/log
[dmdba@dmrac1 log]$ cat dm_SBTTRACE_202005.log
2020-05-29 17:01:27 sbtbackup(type=1, name=db_rac_backup_trace_2020052901.bak)
2020-05-29 17:01:27 sbtwrite(buf != NULL, buf_len = 4096)
2020-05-29 17:01:27 sbtwrite(buf != NULL, buf_len = 5095936)
2020-05-29 17:01:27 sbtwrite(buf != NULL, buf_len = 21496320)
2020-05-29 17:01:27 sbtwrite(buf != NULL, buf_len = 49664)
2020-05-29 17:01:27 sbtclose()
2020-05-29 17:01:27 sbtinfo(!NULL)
file [db_rac_backup_trace_2020052901.bak] finished, name:[db_rac_backup_trace_2020052901.bak],created time:[2020-05-29 17:01:27],expirated time:[2105-12-31 23:59:59],label:[],comment:[]
2020-05-29 17:01:27 sbtbackup(type=1, name=db_rac_backup_trace_2020052901_1.bak)
2020-05-29 17:01:27 sbtwrite(buf != NULL, buf_len = 4096)
2020-05-29 17:01:27 sbtwrite(buf != NULL, buf_len = 4096)
2020-05-29 17:01:27 sbtclose()
2020-05-29 17:01:27 sbtinfo(!NULL)
file [db_rac_backup_trace_2020052901_1.bak] finished, name:[db_rac_backup_trace_2020052901_1.bak],created time:[2020-05-29 17:01:27],expirated time:[2105-12-31 23:59:59],label:[],comment:[]
2020-05-29 17:01:27 sbtbackup(type=3, name=db_rac_backup_trace_2020052901.meta)
2020-05-29 17:01:27 sbtwrite(buf != NULL, buf_len = 49152)
2020-05-29 17:01:27 sbtwrite(buf != NULL, buf_len = 4096)
2020-05-29 17:01:27 sbtwrite(buf != NULL, buf_len = 4096)
2020-05-29 17:01:27 sbtwrite(buf != NULL, buf_len = 4096)
2020-05-29 17:01:27 sbtwrite(buf != NULL, buf_len = 4096)
2020-05-29 17:01:27 sbtwrite(buf != NULL, buf_len = 4096)
2020-05-29 17:01:27 sbtwrite(buf != NULL, buf_len = 4096)
2020-05-29 17:01:27 sbtwrite(buf != NULL, buf_len = 512)
2020-05-29 17:01:27 sbtclose()
2020-05-29 17:01:27 sbtinfo(!NULL)
file [db_rac_backup_trace_2020052901.meta] finished, name:[db_rac_backup_trace_2020052901.meta],created time:[2020-05-29 17:01:27],expirated time:[2105-12-31 23:59:59],label:[],comment:[]

若TRACE FILE使用相对路径,日志文件生成在执行码同级目录下。
以数据库完全备份为例,为备份设置跟踪日志文件的操作步骤如下:
1) 配置归档,参考3.1节。
2) 保证数据库处于OPEN状态。
3) 备份数据库,输入以下语句:

SQL> backup database to db_rac_backup_trace_2020052903 backupset '/dm7/backup/db_rac_backup_trace_2020052903' trace file '/dm7/backup/db_rac_trace.log' trace level 2;
executed successfully
used time: 00:00:01.321. Execute id is 104.
[dmdba@dmrac1 backup]$ cat db_rac_trace.log
2020-05-29 17:15:13 sbtrestore(filepath=/dm7/backup/db_rac_backup_trace_2020052902/db_rac_backup_trace_2020052902.meta)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 4096)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 45056)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 25088)
2020-05-29 17:15:13 sbtclose()
2020-05-29 17:15:13 sbtrestore(filepath=/dm7/backup/ts_main_increment_bak_20200529_01/ts_main_increment_bak_20200529_01.meta)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 4096)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 45056)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 8704)
2020-05-29 17:15:13 sbtclose()
2020-05-29 17:15:13 sbtrestore(filepath=/dm7/backup/db_rac_backup_encrypt_2020052904/db_rac_backup_encrypt_2020052904.meta)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 4096)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 45056)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 25088)
2020-05-29 17:15:13 sbtclose()
2020-05-29 17:15:13 sbtrestore(filepath=/dm7/backup/db_backup_20200528_01/db_backup_20200528_01.meta)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 4096)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 45056)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 25088)
2020-05-29 17:15:13 sbtclose()
2020-05-29 17:15:13 sbtrestore(filepath=/dm7/backup/db_rac_backup_encrypt_2020052903/db_rac_backup_encrypt_2020052903.meta)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 4096)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 45056)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 25088)
2020-05-29 17:15:13 sbtclose()
2020-05-29 17:15:13 sbtrestore(filepath=/dm7/backup/db_backup_20200529_01/db_backup_20200529_01.meta)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 4096)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 45056)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 25088)
2020-05-29 17:15:13 sbtclose()
2020-05-29 17:15:13 sbtrestore(filepath=/dm7/backup/db_rac_backup_encrypt_2020052902/db_rac_backup_encrypt_2020052902.meta)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 4096)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 45056)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 25088)
2020-05-29 17:15:13 sbtclose()
2020-05-29 17:15:13 sbtrestore(filepath=/dm7/backup/db_backup_20200528_04/db_backup_20200528_04.meta)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 4096)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 45056)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 25088)
2020-05-29 17:15:13 sbtclose()
2020-05-29 17:15:13 sbtrestore(filepath=/dm7/backup/db_backup_20200528_02/db_backup_20200528_02.meta)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 4096)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 45056)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 25088)
2020-05-29 17:15:13 sbtclose()
2020-05-29 17:15:13 sbtrestore(filepath=/dm7/backup/db_rac_backup_2020052905/db_rac_backup_2020052905.meta)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 4096)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 45056)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 25088)
2020-05-29 17:15:13 sbtclose()
2020-05-29 17:15:13 sbtrestore(filepath=/dm7/backup/db_backup_20200528_06/db_backup_20200528_06.meta)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 4096)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 45056)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 182272)
2020-05-29 17:15:13 sbtclose()
2020-05-29 17:15:13 sbtrestore(filepath=/dm7/backup/ts_main_full_bak_20200529_02/ts_main_full_bak_20200529_02.meta)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 4096)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 45056)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 8704)
2020-05-29 17:15:13 sbtclose()
2020-05-29 17:15:13 sbtrestore(filepath=/dm7/backup/db_rac_increment_backup_encrypt_2020052901/db_rac_increment_backup_encrypt_2020052901.meta)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 4096)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 45056)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 25088)
2020-05-29 17:15:13 sbtclose()
2020-05-29 17:15:13 sbtrestore(filepath=/dm7/backup/ts_main_increment_bak_20200529_02/ts_main_increment_bak_20200529_02.meta)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 4096)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 45056)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 8704)
2020-05-29 17:15:13 sbtclose()
2020-05-29 17:15:13 sbtrestore(filepath=/dm7/backup/ts_main_full_bak_20200529_01/ts_main_full_bak_20200529_01.meta)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 4096)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 45056)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 8704)
2020-05-29 17:15:13 sbtclose()
2020-05-29 17:15:13 sbtrestore(filepath=/dm7/backup/db_backup_20200528_05/db_backup_20200528_05.meta)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 4096)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 45056)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 25088)
2020-05-29 17:15:13 sbtclose()
2020-05-29 17:15:13 sbtrestore(filepath=/dm7/backup/db_increment_backup_20200529_01/db_increment_backup_20200529_01.meta)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 4096)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 45056)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 25088)
2020-05-29 17:15:13 sbtclose()
2020-05-29 17:15:13 sbtrestore(filepath=/dm7/backup/ts_main_increment_bak_2020052903/ts_main_increment_bak_2020052903.meta)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 4096)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 45056)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 8704)
2020-05-29 17:15:13 sbtclose()
2020-05-29 17:15:13 sbtrestore(filepath=/dm7/backup/db_rac_backup_encrypt_2020052901/db_rac_backup_encrypt_2020052901.meta)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 4096)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 45056)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 25088)
2020-05-29 17:15:13 sbtclose()
2020-05-29 17:15:13 sbtrestore(filepath=/dm7/backup/db_backup_20200528_03/db_backup_20200528_03.meta)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 4096)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 45056)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 25088)
2020-05-29 17:15:13 sbtclose()
2020-05-29 17:15:13 sbtrestore(filepath=/dm7/backup/db_increment_backup_20200529_02/db_increment_backup_20200529_02.meta)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 4096)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 45056)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 25088)
2020-05-29 17:15:13 sbtclose()
2020-05-29 17:15:13 sbtrestore(filepath=/dm7/backup/db_rac_backup_trace_2020052901/db_rac_backup_trace_2020052901.meta)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 4096)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 45056)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 25088)
2020-05-29 17:15:13 sbtclose()
2020-05-29 17:15:13 sbtrestore(filepath=+DMDATA/data/rac/bak/ts_backup_main_01/ts_backup_main_01.meta)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 4096)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 45056)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 8704)
2020-05-29 17:15:13 sbtclose()
2020-05-29 17:15:13 sbtrestore(filepath=+DMDATA/data/rac/bak/tab_t1_bak_01/tab_t1_bak_01.meta)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 4096)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 45056)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 5632)
2020-05-29 17:15:13 sbtclose()
2020-05-29 17:15:13 sbtrestore(filepath=+DMDATA/data/rac/bak/table_tab_01_backup_20200529/table_tab_01_backup_20200529.meta)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 4096)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 45056)
2020-05-29 17:15:13 sbtread(buf != NULL, buf_len = 5632)
2020-05-29 17:15:13 sbtclose()
2020-05-29 17:15:13 sbtend(del_flag=FALSE)
2020-05-29 17:15:13 sbtbackup(type=1, name=db_rac_backup_trace_2020052903.bak)
2020-05-29 17:15:13 sbtwrite(buf != NULL, buf_len = 4096)
2020-05-29 17:15:13 sbtwrite(buf != NULL, buf_len = 5095936)
2020-05-29 17:15:13 sbtwrite(buf != NULL, buf_len = 21496320)
2020-05-29 17:15:13 sbtwrite(buf != NULL, buf_len = 49664)
2020-05-29 17:15:13 sbtclose()
2020-05-29 17:15:13 sbtinfo(!NULL)
file [db_rac_backup_trace_2020052903.bak] finished, name:[db_rac_backup_trace_2020052903.bak],created time:[2020-05-29 17:15:13],expirated time:[2105-12-31 23:59:59],label:[],comment:[]
2020-05-29 17:15:13 sbtbackup(type=1, name=db_rac_backup_trace_2020052903_1.bak)
2020-05-29 17:15:13 sbtwrite(buf != NULL, buf_len = 4096)
2020-05-29 17:15:13 sbtwrite(buf != NULL, buf_len = 2560)
2020-05-29 17:15:13 sbtclose()
2020-05-29 17:15:13 sbtinfo(!NULL)
file [db_rac_backup_trace_2020052903_1.bak] finished, name:[db_rac_backup_trace_2020052903_1.bak],created time:[2020-05-29 17:15:13],expirated time:[2105-12-31 23:59:59],label:[],comment:[]
2020-05-29 17:15:13 sbtbackup(type=3, name=db_rac_backup_trace_2020052903.meta)
2020-05-29 17:15:13 sbtwrite(buf != NULL, buf_len = 49152)
2020-05-29 17:15:13 sbtwrite(buf != NULL, buf_len = 4096)
2020-05-29 17:15:13 sbtwrite(buf != NULL, buf_len = 4096)
2020-05-29 17:15:13 sbtwrite(buf != NULL, buf_len = 4096)
2020-05-29 17:15:13 sbtwrite(buf != NULL, buf_len = 4096)
2020-05-29 17:15:13 sbtwrite(buf != NULL, buf_len = 4096)
2020-05-29 17:15:13 sbtwrite(buf != NULL, buf_len = 4096)
2020-05-29 17:15:13 sbtwrite(buf != NULL, buf_len = 512)
2020-05-29 17:15:13 sbtclose()
2020-05-29 17:15:13 sbtinfo(!NULL)
file [db_rac_backup_trace_2020052903.meta] finished, name:[db_rac_backup_trace_2020052903.meta],created time:[2020-05-29 17:15:13],expirated time:[2105-12-31 23:59:59],label:[],comment:[]
2020-05-29 17:15:13 sbtend(del_flag=FALSE)

感谢各位的阅读,以上就是“联机执行SQL语句进行数据备份的高级特性分析”的内容了,经过本文的学习后,相信大家对联机执行SQL语句进行数据备份的高级特性分析这一问题有了更深刻的体会,具体使用情况还需要大家实践验证。这里是亿速云,小编将为大家推送更多相关知识点的文章,欢迎关注!

原创文章,作者:carmelaweatherly,如若转载,请注明出处:https://blog.ytso.com/203726.html

(0)
上一篇 2021年11月28日
下一篇 2021年11月28日

相关推荐

发表回复

登录后才能评论