这篇文章主要讲解了“联机执行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