数据备份在线执行SQL语句的高级特性分析

分类：编程技术时间：2024-02-20 15:59 浏览：0 评论：0

本文主要讲解《在线执行SQL语句进行数据备份的高级特性分析》。文章中的讲解内容简单明了，易学易懂。请大家按照小编的思路慢慢深入，一起学习学习《在线执行SQL语句进行数据备份高级功能分析》！

1.加密备份
DM7提供了加密备份方式来保护用户的备份集。未经许可的用户无法访问加密的备份集。通过在备份语句中指定 IDENTIFIED BY...WITH ENCRYPTION...ENCRYPT WITH... 来执行加密备份。其中，参数IDENTIFIED BY指定加密密码，长度不超过128字节。如果长度太长，服务器会报语法分析错误；参数WITH ENCRYPTION指定加密类型。加密类型分为简单加密和复杂加密。简单的加密是for 备份文件。设置密码，但文件内容仍以明文形式存储。复杂的加密对备份文件进行完全加密。备份文件以密文形式存储。用户可以根据备份数据的重要程度选择加密类型；参数ENCRYPTWITH指定加密算法。不同请参见加密算法的参数说明。您还可以通过“SELECT * FROM V$CIPHERS”语句查询DM7支持的加密算法。这里不能使用MD5和SHA1算法。默认使用的加密算法是AES256_CFB。

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

SQL> backup数据库到由“abcd123456”标识的 db_rac_backup_encrypt_01 备份集“/dm7/backup/db_rac_backup_encrypt_2023052901”；执行成功，使用时间：00:00:01.379。执行 id 为 85。SQL> 备份数据库到 db_rac_backup_encrypt_02 备份集 '/dm7/backup/db_rac_backup_encrypt_2023052902'，由“abcd123456”标识，使用 rc4 加密；执行成功，使用时间：00:00:01.313。执行 id 为 86.SQL> select sf_bakset_backup_dir_add('disk','/dm7/ backup/db_rac_backup_encrypt_2023052901');LINEID SF_BAKSET_BACKUP_DIR_ADD('disk','/dm7/backup/db_rac_backup_encrypt_2023052901')--------- ---------------------------------------------------------------- -------------------------------- --------------------1 ('磁盘','/dm7/备份/db_rac_backup_encrypt_2023052902')-------------------------------------------------------- ----- ------------------------------------------------------1 1已用时间：1.532（毫秒）。执行 ID 为 88.sql> Select*from v$Backupset where backup_path like '/dm7/backup/db_rackup_encrypt_202305290%'; E backup_id Parent_id Backup_name 备份路径类型级别范围#Object_name Object_id & NBsp;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 累积------------ ------------ - -------- ----------------------------------------- --------------------------------- ----------- ------ - ---- ----------- ----------- ----------- --------- --- - ---------------------- ----- ---------- ---------- - --- ----------- ------------ ----------- -------------- ------------ ------ --------------- ----------- ------ ----- ---------- -- ---------- ----------- ------------ ------ ---------- -- -----------1 磁盘 1180634048 -1 DB_RAC_BACKUP_ENCRYPT_01 /dm7/backup/db_rac_backup_encrypt_2023052901 0 0 1公共服务提供商； 0 0 0 0 33554432 50908 51058 2 4 1 0 0 0 49398 117507596 02DISK 244985784 -1 DB_RAC_BACKUP_ENCRYPT_02 /dm7/backup/db_rac_backup_encrypt_2023052902 0 0 1 RAC -1 2023-05-29 16:43:00.000380 1 0 0 0 0p;33554432 50908 51064 2 4 4 1 0 0 0 49398                                                                                                                                                                                                                                            没有使用它是非加密备份，如下：
SQL> 将数据库备份到 db_rac_backup_encrypt_03 备份集 '/dm7/backup/db_rac_backup_encrypt_2023052903' 由“abcd123456 标识” " 加密为 0；执行成功使用时间：00:00:01.313。执行 id 为 90.SQL> select sf_bakset_backup_dir_add('disk','/dm7/backup/db_rac_backup_encrypt_2023052903') ;LINEID SF_BAKSET_BACKUP_DIR_ADD('磁盘','/dm7/backup/db_rac_backup_encrypt_2023052903')------------------------------------ ------ -------------------------------------------------------- ------ 1 1使用时间：1.899(ms)。执行 id 为 91.SQL> select * from v$backupset where backup_path like '/dm7/backup/db_rac_backup_encrypt_202305290%';LINEID DEVICE_TYPE BACKUP_ID PARENT_ID BACKUP_NAME   Backup_Path Type Level Range#Object_name Object_id Base_name Backup_time Desc#ENCRYPE compress_level Without_PWR PKG_SIZE Be Gin _lsn 结束_lsn bkp_num dbf_num parall_num ddl_clone mpp_flag mIN_TRX_START_LSN MIN_EXEC_VER 累积---------- ----------- ----------- ----------- ---- ---------------------------------------------------------- ------ --------------- ----------- ----------- ------- ---- --- -------- ----------- --------- -------------- ------- ----- ----- ------------ -------------- ------- ---- --- -------- ----------- -------------------- ---- ------- --------- ----------- ----------- ------- ----- -- ---- ----------- ------------------ ---------- --- --------1 磁盘 1180634048 -1 DB_RAC_BACKUP_ENCRYPT_01 /dm7/backup/db_rac_backup_encrypt_2023052901 0 0 1 rac -1 2023-05-29 16:41:40.000665 1 0 0 0 33554432 50908 51058 2 4; 1 0 0 49398 117507596 02 磁盘 244985784 -1 DB_RAC_BACKUP_ENCRYPT_02 /dm7/backup/db_rac_backup_encrypt_2023052902 0                                                                                                                                                   nbsp; 2023-05-29 16:43:00.000380 1 0 0 0 33554432 50908 51064 2 4 1 0 0 49398 0 0 1 RAC -1 2023-05-29 16:46:17.000633 0 0 0 0 33554432 50908 51070 2 4 1 0 0 023052903为0，证明备份没有加密。 
下面以数据库完整备份为例，创建一个复杂数据库的加密备份，加密密码为“abcd123456”，加密算法为“rc4”。完整步骤如下：
1）配置归档。 
2) 确保数据库是处于打开状态。 
3) 备份数据库，输入以下语句：
SQL>备份数据库到db_rac_backup_encrypt_04 backupset '/dm7/backup/db_rac_backup_encrypt_2023052904'identified by "abcd123456" with crypto 2 encrypt with rc4;成功执行使用时间：00:00:01.356。执行id为93.SQL> select sf_bakset_backup_dir_add('disk','/dm7/backup/db_rac_backup_encrypt_2023052904');LINEID SF_BAKSET_BACKUP_DIR_ADD('disk','/dm7/backup /db_rac_backup_encrypt_2023052904')--- ------- -------------------------------------------------------- ------ ------------------------------1 1使用时间：1.868(ms)。执行id为94。 SQL> SELECT*From V$BackupSet WHERE BACKUP_PATH = '/DM7/BACKUP/DB_RAC_BACKUP_ENCRYPT_2023052904'; Lineid Device_Type Backup_id Parent_id_id Backup_name Backup_Path 类型级别 Range#Object_name Object_ID BASE_NAME BACKUP_TIME DESC#Encrypt_Type compress_level Without_PWR PWR P Kg_size BEGIN_LSN         END_LSN------ -------------------------------------------------------- -------------- ---------------------------------- ---------- ---- ------ ------ ----- ----------- ----------- --------- -- ------------ ------------- ----- ------------ -------- -------- ------ ----- ----------- ----------- --------- --------- --- ------------------ ----------- --------- -------------- - ----------- ----------- ----------- --- ---- ----- -----------1   磁盘 141217020 -1 DB_RAC_BACKUP_ENCRYPT_04 /dm7/backup/db_rac_backup_encrypt_2023052904 0 0 1 rac -1 2023-05-29 16:49:56.000930 2 0 0 0 0 33554432 50908 51076 2 4 1 0 0 49398 117507596 0已使用时间：00：00：01.067。执行 ID 为 95。 
  加密增量备份。密码必须与基础备份一致；如果基础备份不加密，则对加密密码和算法没有特殊要求用于增量备份。 
SQL> 备份数据库增量基于由“abcd123456”标识的备份集“/dm7/backup/db_rac_backup_encrypt_2023052904”备份集“/dm7/backup/db_rac_increment_backup_encrypt_2023052901”，加密2使用rc4加密；成功执行使用时间：00 :00:01.262。执行id为96.SQL> select sf_bakset_backup_dir_add('disk','/dm7 /backup/db_rac_increment_backup_encrypt_2023052901');LINEID SF_BAKSET_BACKUP_DIR_ADD('disk','/dm7/backup/db_rac_increment_backup_encrypt_202305290 1')---------- ---------------------------------------------------------------- ---------------- ----------------------1 1使用时间：2.210(ms)。执行 id 为 97.SQL> select * from v$backupset where backup_path='/dm7 /backup/db_rac_increment_backup_encrypt_2023052901';LINEID   DEVICE_TYPE BACKUP_ID PARENT_ID BACKUP_NAME BACKUP_PATH BACKUP_PATH TYPE LEVEL RANGE# OBJECT_NAME OBJECT_ID BASE_NAME BACKUP_TIME DESC# ENCRYPT_TYPE COMPRESS_LEVEL NOT_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 磁盘 195701720 -1 DB_INCR_RAC_20230529_165327_000906/DM7/DB_RAC_BACRMENT_BACKUP_ENCRYPT _2023052901 1 0 1 1 rac -1 DB_RAC_BACKUP_ENCRYPT_04 2023-05-29 16: 53:29.000129 2 0 0    0 33554432 50908 51082 2 4 1 0 0 49398 117507596 0使用时间：00:00:01.075。执行ID为98。
  2.设置跟踪日志文件
 DM7支持设置跟踪跟踪日志文件。日志记录了调用prSBT接口的过程。用户可以通过查看日志来跟踪备份和恢复过程。 
与生成跟踪日志文件相关的参数有两个：TRACE FILE 和 TRACE LEVEL。 TRACE FILE用于指定生成的跟踪日志文件路径，TRACE LEVEL表示TRACE是否启用。 TRACE LEVEL的有效值包括1和2。1表示禁用TRACE功能，2表示启用TRACE功能，系统默认值为1。
指定参数TRACE FILE但设置TRACE LEVEL值为1表示TRACE功能未开启。将生成TRACE文件，但不会写入TRACE信息。如下图：
SQL>备份数据库backupset '/dm7/backup/db_rac_backup_2023052905'跟踪文件'/dm7/backup/db_rac_trace.log'跟踪级别1；执行成功使用时间：00:00:01.719。执行id为99。[dmdba@dmrac1 backup]$ cat db_rac_trace.log
将TRACE LEVEL值设置为2以启用TRACE功能，但如果TRACE F不指定ILE，系统默认在执行代码路径下的log目录下生成DM_SBTTRACE_year-month.log文件。如下图：
SQL>备份数据库到db_rac_backup_trace_2023052901 backupset '/dm7/backup/db_rac_backup_trace_2023052901'跟踪级别2；执行成功使用时间：00:00:01.354。执行 ID 为 10 1.[dmdba@dmrac1 log ]$ pwd/dm7/log[dmdba@dmrac1 log]$ cat dm_SBTTRACE_202305.log2023-05-29 17:01:27 sbtbackup(type=1, name=db_rac_backup_trace_2023052901.bak) 2023-05-29 17:01:27 sbtwrite(buf != NULL, buf_len = 4096)2023-05-29 17: 01:27 sbtwrite(buf != NULL, buf_len = 5095936)2023-05-29 17:01 :27 sbtwrite(buf != NULL, buf_len = 21496320)2023-05-29 17:01:27 sbtwrite(buf != NULL, buf_len = 49664)2023-05-29 17:01:27 sbtclose()2023-05 -29 17:01:27 sbtinfo(!NULL)文件[db_rac_backup_trace_2023052901.bak]完成，名称：[db_rac_backup_trace_20 23052901.bak]，创建时间：[2023-05-29 17:01:27]，过期时间：[2105 -12-31 23:59:59]，标签：[]，评论：[]2023-05-29 17:01: 27 sbtbackup(类型=1，名称=db_rac_backup_trace_2023052901_1.bak)2023-05-29 17:01:27 sbtwrite(buf！= NULL，buf_len = 4096)2023-05-29 17： 01:27 sbtwrite(buf != NULL, buf_len = 4096)2023-05-29 17:01:27 sbtclose()2023-05-29 17:01:27 sbtinfo(!NULL)文件 [db_rac_backup_trace_2023052901_1.bak] 完成，名称：[db_rac_back up_trace_2023052901_1. bak],创建时间:[2023-05-29 17:01:27],过期时间:[2105-12-31 23:59:59],标签:[],评论:[]2023-05-29 17 ：01：27 sbtbackup（类型= 3，名称= db_rac_backup_trace_2023052901.meta）2023-05-29 17:01:27 sbtwrite（buf！= NULL，buf_len = 49152）2023-05-29 17:01:27 sbtwrite（buf != NULL, buf_len = 4096)2023-05-29 17:01:27 sbtwrite(buf != NULL, buf_len = 4096)2023-05-29 17:01:27 sbtwrite(buf != NULL, buf_len = 4096) 2023-05-29 17:01:27 sbtwrite(buf != NULL, buf_len = 4096)2023-05-29 17:01:27 sbtwrite(buf != NULL, buf_len = 4096)2023-05-29 17:01 :27 sbtwrite(buf != NULL, buf_len = 4096)2023-05-29 17:01:27 sbtwrite(buf != NULL, buf_len = 512)2023-05-29 17:01:27 sbtclose()2023-05-29 17:01:27 sbtinfo(!NULL)文件[db_rac_backup_trace_2023052901.meta]完成，名称：[db_rac_backup_trace_2023052901.meta]，创建时间：[2023-05-29 17 :01:27],过期时间:[2105-12-31 23:59:59],标签:[],评论:[]
如果TRACE FILE使用相对路径，则日志文件为在同一目录中执行代码期间生成。 
以数据库全量备份为例，设置备份跟踪日志文件的步骤如下：
1) 配置归档，参见3.1节。 
2) 确保数据库处于OPEN状态。 
3) 备份数据库，输入以下语句：
SQL> 备份数据库到 db_rac_backup_trace_2023052903 backupset '/dm7/backup/db_rac_backup_trace_2023052903' 跟踪文件 '/dm7/backup/db_rac_trace.log'跟踪级别 2；成功执行使用时间：00:00:01.321。执行 ID 为 104。[dmdba@dmrac1 备份]$ cat db_rac_trace.log2023-05-29 17:15:13 sbtrestore(filepath=/dm7/backup/db_rac_backup_trace_2023052902/db_rac_backup_trace_2023052902.meta)2023-05-29 17:15:1 3 sbtread(buf != NULL, buf_len = 4096)2023-05-29 17:15:13 sbtread(buf != NULL, buf_len = 4505 6)2023年-05-29 17:15:13 sbtread(buf != NULL, buf_len = 25088)2023-05-29 17:15:13 sbtclose()2023-05-29 17:15:13 sbtrestore(filepath=/dm7/备份/ts_main_increment_bak_20230529_01/ts_main_increment_bak_20230529_01.meta)2023-05-29 17:15:1 3 sbtread(buf != NULL, buf_len = 4096)2023-05-29 17:15:13 sbtread （buf！= NULL，buf_len = 45056 )2023-05-29 17:15:13 sbtread(buf != NULL, buf_len = 8704)2023-05-29 17:15:13 sbtclose()2023-05-29 17:15:13 sbtrestore(filepath=/ dm7/backup/db_rac_backup_encrypt_2023052904/db_rac_backup_encrypt_2023052904.meta)2023-05-29 17:15:13 sbtread(buf != NULL, buf_len = 4096)2023-05-29 17:15:13 sbtread( buf ！= NULL，buf_len = 45056) 2023-05-29 17:15:13 sbtread(buf != NULL, buf_len = 25088)2023-05-29 17:15:13 sbtclose()2023-05-29 17:15:13 sbtrestore(filepath= /dm7 /backup/db_backup_20230528_01/db_backup_20230528_01.meta)2023-05-29 17:15:13 sbtread(buf != NULL, buf_len = 4096)2023-05-29 17:15:13 sbtread(buf != N ULL, buf_len = 45056 )2023-05-29 17: 15:13 sbtread(buf != NULL, buf_len = 25088)2023-05-29 17:15:13 sbtclose()2023-05-29 17:15:13 sbtrestore(filepath=/dm7/backup/db_rac_backup_encrypt_2023052903/db_rac_backup _加密_2023052903。元)2023-05-29 17:15:13 sbtread(buf != NULL, buf_len = 4096)2023-05-29 17:15:13 sbtread(buf != NULL, buf_len = 45056)2023-05-29 17 :15:13 sbtread(buf != NULL, buf_len = 25088) 2023-05-29 17:15:13 sbtclose()2023-05-29 17:15:13 sbtrestore(filepath=/dm7/backup/db_backup_20230529_01/db_backup_202 30529_01 .meta)2023-05-29 17:15:13 sbtread( buf != NULL, buf_len = 4096)2023-05-29 17:15:13 sbtread(buf != NULL, buf_len = 45056)2023-05-29 17:15:13 sbtread(buf！= NULL，buf_len = 25088)2023-05-29 17:15:13 sbtclose()2023-05-29 17:15:13 sbtrestore(filepath=/dm7/backup/db_rac_backup_encrypt_2023052902/ db_rac_backup_encrypt_2023052902.meta)2023-05-29 17:15:13 sbtread (buf != NULL, buf_len = 4096)2023-05-29 17:15:13 sbtread(buf != NULL, buf_len =45056)2023-05-29 17:15:13 sbtread(buf != NULL, buf_len = 25088)2023-05- 29 17:15:13 sbtclose()2023-05-29 17:15:13 sbtrestore(文件路径= /dm7/backup/db_backup_20230528_04/db_backup_20230528_04.meta)2023-05-29 17:15:13 sbtread(buf ! = 空, buf_len = 4096)2023-05-29 17:15:13 sbtread(buf != NULL, buf_len = 45056)2023-05-29 17:15:13 sbtread(buf != NULL, buf_len = 25088)2023-05 -29 17:15:13 sbtclose()2023-05-29 17:15:13 sbtrestore(文件路径=/dm7/backup/db_backup_20230528_02/db_backup_20230528_02.meta)2023-05-29 17:15:13 sbtread(buf ! =空，buf_len = 4096）2023-05-29 17:15:13 sbtread（buf！= NULL，buf_len = 45056）2023-05-29 17:15:13 sbtread（buf！= NULL，buf_len = 25088）2023- 05-29 17:15:13 sbtclose()2023-05-2917:15:13 sbtrestore(filepath=/dm7/backup/db_rac_backup_2023052905/db_rac_backup_2023052905.meta)2023-05-29 17:15:13 sbtread(缓冲！=空，buf_len = 4096）2023-05-29 17:15: 13 sbtread（buf！= NULL，buf_len = 45056）2023-05-29 17:15:13 sbtread(buf != NULL, buf_len = 25088)2023-05-29 17:15:13 sbtclose()2023-05-29 17:15:13 sbtrestore(filepath=/dm7/backup/db_backup_20230528_06/db_backup_20230528 _06.元） 2023-05-29 17:15:13 sbtread(buf != NULL, buf_len = 4096)2023-0 5-29 17:15 :13 sbtread(buf != NULL, buf_len = 45056)2023-05-29 17: 15:13 sbtread(buf！= NULL，buf_len = 182272)2023-05-29 17:15:13 sbtclose()2023-05-29 17:15:13 sbtrestore(filepath=/dm7/backup/ts_main_full_bak_20230529_02/ts_ main_full_bak_20230529_02。元)2023-05-29 17:15:13 sbtread(buf != NULL, buf_len = 4096)2023-05-29 17:15:13 sbtread(buf != NULL, buf_len = 45056)2023-05-29 17 :15:13 sbtread(buf != NULL , buf_len = 8704)2023-05-29 17:15:13 sbtclose()2023-05-29 17:15:13 sbtrestore(filepath=/dm7/backup/db_rac_increment_backup_encrypt_2023052901/db_ rac_increment_backup_encrypt_202 3052901.meta)2023-05-29 17:15:13 sbtread(buf != NULL, buf_len = 4096)2023-05-29 17:15:13 sbtread(buf != NULL, buf_len = 45056)2023-05- 29 17:15:13 sbtread(buf！= NULL，buf_len = 25088)2023-05-29 17:15:13 sbtclose()2023-05-29 17:15:13 sbtrestore(filepath=/dm7/backup/ts_main_increment_bak_20230529_02/ts_main_increment_bak_202305 29_02.met a)2023-05-29 17 : 15:13 sbtread(buf != NULL, buf_len = 4096)2023-05-29 17:15:13 sbtread(buf != NULL, buf_len = 45056)2023-05-29 17:15:13 sbtread(buf !=空，buf_len = 8704)2023-05-29 17:15:13 sbtclose()2023-05-29 17:15:13 sbtrestore(filepath=/dm7/backup/ts_main_full_bak_20230529_01/ts_main_full_bak_20230529_01 .meta)2023-05-29 17 :15:13 sbtread(buf != NULL, buf_len = 4096)2023-05-29 17:15:13 sbtread(buf != NULL, buf_len = 45056)2023-05-29 17:15:13 sbtread(buf ! = NULL, buf_len = 8704)2023-05-29 17:15:13 sbtclose() 2023-05-29 17:15:13 sbtrestore(filepath=/dm7/backup/db_backup_20230528_05/db_backup_20230528_05.meta)2023-0 5-29 17:15:13 sbtread(buf != NULL, buf_len = 409 6)2023-05-29 17:15:13 sbtread(buf != NULL, buf_len = 45056)2023-05-29 17:15:13 sbtread( buf！= NULL，buf_len = 25088)2023-05-29 17:15:13 sbtclose()2023-05-2917:15:13 sbtrestore（文件路径=/dm7/backup/db_increment_backup_20230529_01/db_increment_backup_20230529_01.meta）2023-05-29 17:15:13 sbtread（buf！= NULL，buf_len = 4096）2023 -05-29 17:15： 13 sbtread(buf != NULL, buf_len = 45056)2023-05-29 17:15:13 sbtread(buf != NULL, buf_len = 25088)2023-05-29 17:15:13 sbtclose()2023-05- 29 17:15:13 sbtrestore（文件路径=/dm7/backup/ts_main_increment_bak_2023052903/ts_main_increment_bak_20230 52903.meta）2023-05-29 17:15:13 sbtread（buf！= NULL，buf_len = 409 6)2023-05-29 17: 15:13 sbtread(buf != NULL, buf_len = 45056)2023-05-29 17:15:13 sbtread(buf != NULL, buf_len = 8704)2023-05-29 17:15:13 sbtclose()2023- 05-29 17:15:13 sbtrestore（文件路径=/dm7/backup/db_rac_backup_encrypt_2023052901/db_rac_backup_encrypt_2023052901.meta）2023-05-29 17:15:13 sbtread（buf！= NULL，buf_len = 4096）20 23-05-29 17 : 15:13 sbtread(buf != NULL, buf_len = 45056)2023-05-29 17:15:13 sbtread(buf != NULL, buf_len = 25088)2023-05-29 17:15:13 sbtclose()2023 -05-29 17:15: 13 sbtrestore(filepath=/dm7/backup/db_backup_20230528_03/db_backup_20230528_03.meta)2023-05-29 17:15:13 sbtread(buf != NULL, buf_len = 4096)2023-05-29 17:1 5:13 sbtread(buf ! =空，buf_len = 45056）2023-05-29 17:15:13 sbtread（buf！= NULL，buf_len = 25088）2023-05-29 17:15:13 sbtclose（）2023-05-29 17:15 :13 sbtrestore（文件路径=/dm7/backup/db_increment_backup_20230529_02/db_increment_backup_20230529_02.meta）2023-05-29 17:15:13 sbtread（buf！= NULL，buf_len = 4096）2023-05-29 17:1 5:13 sbtread(buf ! = NULL, buf_len = 45056)2023-05-29 17:15:13 sbtread(buf != NULL, buf_len = 25088)2023-05-29 17:15:13 sbtclose()2023-05-29 17:15: 13 sbtrestore（文件路径=/dm7/backup/db_rac_backup_trace_2023052901/db_rac_backup_trace_2023052901.meta）2023-05-29 17:15：13 sbtread（buf！= NULL，buf_len = 4096）2023-05-29 17:15:13 sbtread（buf != NULL, buf_len = 45056)2023-05-29 17:15:13 sbtread(buf != NULL, buf_len = 25088)2023-05-29 17:15:13 sbtclose()2023-05-29 17:15 :13 sbtrestore(文件路径=+DMDATA/data/rac/bak/ts_backup_main_01/ts_backup_main_01.meta)2023-05-29 17:15:13 sbtread(buf != NULL, buf_len = 4096)2023-05-29 17:15:13 sbtread(buf != NULL, buf_len = 45056)2023-05- 29 17:15:13 sbtread(buf != NULL, buf_len = 8704)2023-05-29 17:15:13 sbtclose()2023-05-29 17:15:13 sbtrestore( filepath=+DMDATA/data/rac /bak/tab_t1_bak_01/tab_t1_bak_01.meta)2023-05-29 17:15:13 sbtread(buf != NULL, buf_len = 4096)2023-05-29 17:15:13 sbtread( buf != NULL, buf_len = 45056 )2023-05-29 17:15:13 sbtread(buf != NULL, buf_len = 5632)2023-05-29 17:15:13 sbtclose()2023-05-29 17:15:13 sbtrestore(filepath=+ DMDATA/data/rac/bak/table_tab_01_backup_20230529/table_tab_01_backup_20230529.meta)2023-05-29 17:15:13 sbtread(buf != NULL, buf_len = 4096)2023-05-29 17:15:13 sbtread(缓冲！=空，buf_len = 45056）2023-05-29 17:15:13 sbtread（buf！= NULL，buf_len = 5632）2023-05-29 17:15:13 sbtclose（）2023-05-29 17:15:13 sbtend(del_flag=FALSE)2023-05-29 17:15:13 sbtbackup(类型=1，名称=db_rac_backup_trace_2023052903.bak)2023-05-29 17:15:13 sbtwrite(buf != NULL, buf_len = 4096)2023-05-29 17:15:13 sbtwrite(buf != NULL, buf_len = 5095936)2023-05-29 17:15:13 sbtwrite(buf != NULL, buf_len = 21496320)2023-05- 29 17:15:13 sbtwrite(buf != NULL, buf_len = 49664)2023-05-29 17:15:13 sbtclose()2023-05-29 17:15:13 sbtinfo(!NULL)文件 [db_rac_backup_trace_2023052903.bak ] 完成，名称：[db_rac_backup_trace_2023052903.bak]，创建时间：[2023-05-29 17:15:13]，过期时间：[2105-12-31 23:5 9:59]，标签：[]，评论：[]2023-05-29 17:15:13 sbtbackup(类型=1，名称=db_rac_backup_trace_2023052903_1.bak)2023-05-29 17:15:13 sbtwrite(buf！= NULL，buf_len = 4096)2023-05- 29 17:15:13 sbtwrite(buf != NULL, buf_len = 2560)2023-05-29 17:15:13 sbtclose()2023-05-29 17:15:13 sbtinfo(!NULL)文件 [db_rac_backup_trace_2023052903_1.bak ] 完成，名称：[db_rac_backup_trace_2023052903_1.bak]，创建时间：[2023-05-29 17:15:13]，过期时间：[2105-12-31 23:59 :59]，标签：[]，评论： []2023-05-29 17:15:13 sbtbackup(类型=3，名称=db_rac_backup_trace_2023052903.meta)2023-05-29 17:15:13 sbtwrite(buf != NULL, buf_len = 49152)2023-05-29 17:15:13 sbtwrite(buf != NULL, buf_len = 4096)2023-05-29 17:15:13 sbtwrite(buf != NULL, buf_len = 4096)2023-05-29 17:15:13 sbtwrite(buf != NULL, buf_len = 4096)2023-05-29 17:15:13 sbtwrite(buf != NULL, buf_len = 4096)2023-05-29 17 :15:13 sbtwrite(buf != NULL, buf_len = 4096)2023-05-29 17:15:13 sbtwrite(buf != NULL, buf_len = 4096)2023-05-29 17:15:13 sbtwrite (buf ! = null，buf_len = 512）2023-05-29 17:15:13 sbtclose（）2023-05-29 17:15:13 sbtinfo（！null）file [db_racbackup_backup_trace_trace_trace_trace_202302903.meta]完成],创建时间:[2023-05-29 17:15:13],过期时间:[2105-12-31 23:59:59],标签:[],评论:[]2023-05-29 17: 15:13 sbtend(del_flag=FALSE)
感谢您的阅读。以上就是《数据备份SQL语句在线执行高级特性分析》的内容。经过文章的学习，相信大家会对高级有更深入的了解数据备份SQL语句在线执行的特征分析。具体用法需要在实践中验证。在此，小编将为大家推送更多相关知识点的文章，欢迎关注！