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

2025-03-10 技术教程

这篇文章主要讲解了“联机执行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>backupdatabasetodb_rac_backup_encrypt_01backupset'/dm7/backup/db_rac_backup_encrypt_2020052901'identifiedby"abcd123456";executedsuccessfullyusedtime:00:00:01.379.Executeidis85.SQL>backupdatabasetodb_rac_backup_encrypt_02backupset'/dm7/backup/db_rac_backup_encrypt_2020052902'identifiedby"abcd123456"encryptwithrc4;executedsuccessfullyusedtime:00:00:01.313.Executeidis86.SQL>selectsf_bakset_backup_dir_add('disk','/dm7/backup/db_rac_backup_encrypt_2020052901');LINEIDSF_BAKSET_BACKUP_DIR_ADD('disk','/dm7/backup/db_rac_backup_encrypt_2020052901')-----------------------------------------------------------------------------------------11usedtime:2.066(ms).Executeidis87.SQL>selectsf_bakset_backup_dir_add('disk','/dm7/backup/db_rac_backup_encrypt_2020052902');LINEIDSF_BAKSET_BACKUP_DIR_ADD('disk','/dm7/backup/db_rac_backup_encrypt_2020052902')-----------------------------------------------------------------------------------------11usedtime:1.532(ms).Executeidis88.SQL>select*fromv$backupsetwherebackup_pathlike'/dm7/backup/db_rac_backup_encrypt_202005290%';LINEIDDEVICE_TYPEBACKUP_IDPARENT_IDBACKUP_NAMEBACKUP_PATHTYPELEVELRANGE#OBJECT_NAMEOBJECT_IDBASE_NAMEBACKUP_TIMEDESC#ENCRYPT_TYPECOMPRESS_LEVELWITHOUT_LOGUSE_PWRPKG_SIZEBEGIN_LSNEND_LSNBKP_NUMDBF_NUMPARALLEL_NUMDDL_CLONEMPP_FLAGMIN_TRX_START_LSNMIN_EXEC_VERCUMULATIVE---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------1DISK1180634048-1DB_RAC_BACKUP_ENCRYPT_01/dm7/backup/db_rac_backup_encrypt_2020052901001rac-12020-05-2916:41:40.0006651000335544325090851058241004939811750759602DISK244985784-1DB_RAC_BACKUP_ENCRYPT_02/dm7/backup/db_rac_backup_encrypt_2020052902001rac-12020-05-2916:43:00.000380100033554432509085106424100493981175075960usedtime:00:00:01.053.Executeidis89.

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

SQL>backupdatabasetodb_rac_backup_encrypt_03backupset'/dm7/backup/db_rac_backup_encrypt_2020052903'identifiedby"abcd123456"withencryption0;executedsuccessfullyusedtime:00:00:01.313.Executeidis90.SQL>selectsf_bakset_backup_dir_add('disk','/dm7/backup/db_rac_backup_encrypt_2020052903');LINEIDSF_BAKSET_BACKUP_DIR_ADD('disk','/dm7/backup/db_rac_backup_encrypt_2020052903')-----------------------------------------------------------------------------------------11usedtime:1.899(ms).Executeidis91.SQL>select*fromv$backupsetwherebackup_pathlike'/dm7/backup/db_rac_backup_encrypt_202005290%';LINEIDDEVICE_TYPEBACKUP_IDPARENT_IDBACKUP_NAMEBACKUP_PATHTYPELEVELRANGE#OBJECT_NAMEOBJECT_IDBASE_NAMEBACKUP_TIMEDESC#ENCRYPT_TYPECOMPRESS_LEVELWITHOUT_LOGUSE_PWRPKG_SIZEBEGIN_LSNEND_LSNBKP_NUMDBF_NUMPARALLEL_NUMDDL_CLONEMPP_FLAGMIN_TRX_START_LSNMIN_EXEC_VERCUMULATIVE---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------1DISK1180634048-1DB_RAC_BACKUP_ENCRYPT_01/dm7/backup/db_rac_backup_encrypt_2020052901001rac-12020-05-2916:41:40.0006651000335544325090851058241004939811750759602DISK244985784-1DB_RAC_BACKUP_ENCRYPT_02/dm7/backup/db_rac_backup_encrypt_2020052902001rac-12020-05-2916:43:00.0003801000335544325090851064241004939811750759603DISK1995527143-1DB_RAC_BACKUP_ENCRYPT_03/dm7/backup/db_rac_backup_encrypt_2020052903001rac-12020-05-2916:46:17.000633000033554432509085107024100493981175075960usedtime:00:00:01.069.Executeidis92.

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

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

SQL>backupdatabasetodb_rac_backup_encrypt_04backupset'/dm7/backup/db_rac_backup_encrypt_2020052904'identifiedby"abcd123456"withencryption2encryptwithrc4;executedsuccessfullyusedtime:00:00:01.356.Executeidis93.SQL>selectsf_bakset_backup_dir_add('disk','/dm7/backup/db_rac_backup_encrypt_2020052904');LINEIDSF_BAKSET_BACKUP_DIR_ADD('disk','/dm7/backup/db_rac_backup_encrypt_2020052904')-----------------------------------------------------------------------------------------11usedtime:1.868(ms).Executeidis94.SQL>select*fromv$backupsetwherebackup_path='/dm7/backup/db_rac_backup_encrypt_2020052904';LINEIDDEVICE_TYPEBACKUP_IDPARENT_IDBACKUP_NAMEBACKUP_PATHTYPELEVELRANGE#OBJECT_NAMEOBJECT_IDBASE_NAMEBACKUP_TIMEDESC#ENCRYPT_TYPECOMPRESS_LEVELWITHOUT_LOGUSE_PWRPKG_SIZEBEGIN_LSNEND_LSNBKP_NUMDBF_NUMPARALLEL_NUMDDL_CLONEMPP_FLAGMIN_TRX_START_LSNMIN_EXEC_VERCUMULATIVE---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------1DISK141217020-1DB_RAC_BACKUP_ENCRYPT_04/dm7/backup/db_rac_backup_encrypt_2020052904001rac-12020-05-2916:49:56.000930200033554432509085107624100493981175075960usedtime:00:00:01.067.Executeidis95.

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

SQL>backupdatabaseincrementbaseonbackupset'/dm7/backup/db_rac_backup_encrypt_2020052904'backupset'/dm7/backup/db_rac_increment_backup_encrypt_2020052901'identifiedby"abcd123456"withencryption2encryptwithrc4;executedsuccessfullyusedtime:00:00:01.262.Executeidis96.SQL>selectsf_bakset_backup_dir_add('disk','/dm7/backup/db_rac_increment_backup_encrypt_2020052901');LINEIDSF_BAKSET_BACKUP_DIR_ADD('disk','/dm7/backup/db_rac_increment_backup_encrypt_2020052901')---------------------------------------------------------------------------------------------------11usedtime:2.210(ms).Executeidis97.SQL>select*fromv$backupsetwherebackup_path='/dm7/backup/db_rac_increment_backup_encrypt_2020052901';LINEIDDEVICE_TYPEBACKUP_IDPARENT_IDBACKUP_NAMEBACKUP_PATHTYPELEVELRANGE#OBJECT_NAMEOBJECT_IDBASE_NAMEBACKUP_TIMEDESC#ENCRYPT_TYPECOMPRESS_LEVELWITHOUT_LOGUSE_PWRPKG_SIZEBEGIN_LSNEND_LSNBKP_NUMDBF_NUMPARALLEL_NUMDDL_CLONEMPP_FLAGMIN_TRX_START_LSNMIN_EXEC_VERCUMULATIVE--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------1DISK195701720-1DB_INCR_rac_20200529_165327_000906/dm7/backup/db_rac_increment_backup_encrypt_2020052901101rac-1DB_RAC_BACKUP_ENCRYPT_042020-05-2916:53:29.000129200033554432509085108224100493981175075960usedtime:00:00:01.075.Executeidis98.

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>backupdatabasebackupset'/dm7/backup/db_rac_backup_2020052905'tracefile'/dm7/backup/db_rac_trace.log'tracelevel1;executedsuccessfullyusedtime:00:00:01.719.Executeidis99.[dmdba@dmrac1backup]$catdb_rac_trace.log

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

SQL>backupdatabasetodb_rac_backup_trace_2020052901backupset'/dm7/backup/db_rac_backup_trace_2020052901'tracelevel2;executedsuccessfullyusedtime:00:00:01.354.Executeidis101.[dmdba@dmrac1log]$pwd/dm7/log[dmdba@dmrac1log]$catdm_SBTTRACE_202005.log2020-05-2917:01:27sbtbackup(type=1,name=db_rac_backup_trace_2020052901.bak)2020-05-2917:01:27sbtwrite(buf!=NULL,buf_len=4096)2020-05-2917:01:27sbtwrite(buf!=NULL,buf_len=5095936)2020-05-2917:01:27sbtwrite(buf!=NULL,buf_len=21496320)2020-05-2917:01:27sbtwrite(buf!=NULL,buf_len=49664)2020-05-2917:01:27sbtclose()2020-05-2917:01:27sbtinfo(!NULL)file[db_rac_backup_trace_2020052901.bak]finished,name:[db_rac_backup_trace_2020052901.bak],createdtime:[2020-05-2917:01:27],expiratedtime:[2105-12-3123:59:59],label:[],comment:[]2020-05-2917:01:27sbtbackup(type=1,name=db_rac_backup_trace_2020052901_1.bak)2020-05-2917:01:27sbtwrite(buf!=NULL,buf_len=4096)2020-05-2917:01:27sbtwrite(buf!=NULL,buf_len=4096)2020-05-2917:01:27sbtclose()2020-05-2917:01:27sbtinfo(!NULL)file[db_rac_backup_trace_2020052901_1.bak]finished,name:[db_rac_backup_trace_2020052901_1.bak],createdtime:[2020-05-2917:01:27],expiratedtime:[2105-12-3123:59:59],label:[],comment:[]2020-05-2917:01:27sbtbackup(type=3,name=db_rac_backup_trace_2020052901.meta)2020-05-2917:01:27sbtwrite(buf!=NULL,buf_len=49152)2020-05-2917:01:27sbtwrite(buf!=NULL,buf_len=4096)2020-05-2917:01:27sbtwrite(buf!=NULL,buf_len=4096)2020-05-2917:01:27sbtwrite(buf!=NULL,buf_len=4096)2020-05-2917:01:27sbtwrite(buf!=NULL,buf_len=4096)2020-05-2917:01:27sbtwrite(buf!=NULL,buf_len=4096)2020-05-2917:01:27sbtwrite(buf!=NULL,buf_len=4096)2020-05-2917:01:27sbtwrite(buf!=NULL,buf_len=512)2020-05-2917:01:27sbtclose()2020-05-2917:01:27sbtinfo(!NULL)file[db_rac_backup_trace_2020052901.meta]finished,name:[db_rac_backup_trace_2020052901.meta],createdtime:[2020-05-2917:01:27],expiratedtime:[2105-12-3123:59:59],label:[],comment:[]

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

SQL>backupdatabasetodb_rac_backup_trace_2020052903backupset'/dm7/backup/db_rac_backup_trace_2020052903'tracefile'/dm7/backup/db_rac_trace.log'tracelevel2;executedsuccessfullyusedtime:00:00:01.321.Executeidis104.[dmdba@dmrac1backup]$catdb_rac_trace.log2020-05-2917:15:13sbtrestore(filepath=/dm7/backup/db_rac_backup_trace_2020052902/db_rac_backup_trace_2020052902.meta)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=4096)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=45056)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=25088)2020-05-2917:15:13sbtclose()2020-05-2917:15:13sbtrestore(filepath=/dm7/backup/ts_main_increment_bak_20200529_01/ts_main_increment_bak_20200529_01.meta)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=4096)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=45056)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=8704)2020-05-2917:15:13sbtclose()2020-05-2917:15:13sbtrestore(filepath=/dm7/backup/db_rac_backup_encrypt_2020052904/db_rac_backup_encrypt_2020052904.meta)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=4096)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=45056)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=25088)2020-05-2917:15:13sbtclose()2020-05-2917:15:13sbtrestore(filepath=/dm7/backup/db_backup_20200528_01/db_backup_20200528_01.meta)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=4096)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=45056)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=25088)2020-05-2917:15:13sbtclose()2020-05-2917:15:13sbtrestore(filepath=/dm7/backup/db_rac_backup_encrypt_2020052903/db_rac_backup_encrypt_2020052903.meta)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=4096)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=45056)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=25088)2020-05-2917:15:13sbtclose()2020-05-2917:15:13sbtrestore(filepath=/dm7/backup/db_backup_20200529_01/db_backup_20200529_01.meta)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=4096)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=45056)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=25088)2020-05-2917:15:13sbtclose()2020-05-2917:15:13sbtrestore(filepath=/dm7/backup/db_rac_backup_encrypt_2020052902/db_rac_backup_encrypt_2020052902.meta)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=4096)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=45056)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=25088)2020-05-2917:15:13sbtclose()2020-05-2917:15:13sbtrestore(filepath=/dm7/backup/db_backup_20200528_04/db_backup_20200528_04.meta)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=4096)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=45056)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=25088)2020-05-2917:15:13sbtclose()2020-05-2917:15:13sbtrestore(filepath=/dm7/backup/db_backup_20200528_02/db_backup_20200528_02.meta)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=4096)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=45056)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=25088)2020-05-2917:15:13sbtclose()2020-05-2917:15:13sbtrestore(filepath=/dm7/backup/db_rac_backup_2020052905/db_rac_backup_2020052905.meta)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=4096)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=45056)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=25088)2020-05-2917:15:13sbtclose()2020-05-2917:15:13sbtrestore(filepath=/dm7/backup/db_backup_20200528_06/db_backup_20200528_06.meta)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=4096)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=45056)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=182272)2020-05-2917:15:13sbtclose()2020-05-2917:15:13sbtrestore(filepath=/dm7/backup/ts_main_full_bak_20200529_02/ts_main_full_bak_20200529_02.meta)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=4096)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=45056)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=8704)2020-05-2917:15:13sbtclose()2020-05-2917:15:13sbtrestore(filepath=/dm7/backup/db_rac_increment_backup_encrypt_2020052901/db_rac_increment_backup_encrypt_2020052901.meta)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=4096)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=45056)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=25088)2020-05-2917:15:13sbtclose()2020-05-2917:15:13sbtrestore(filepath=/dm7/backup/ts_main_increment_bak_20200529_02/ts_main_increment_bak_20200529_02.meta)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=4096)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=45056)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=8704)2020-05-2917:15:13sbtclose()2020-05-2917:15:13sbtrestore(filepath=/dm7/backup/ts_main_full_bak_20200529_01/ts_main_full_bak_20200529_01.meta)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=4096)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=45056)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=8704)2020-05-2917:15:13sbtclose()2020-05-2917:15:13sbtrestore(filepath=/dm7/backup/db_backup_20200528_05/db_backup_20200528_05.meta)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=4096)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=45056)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=25088)2020-05-2917:15:13sbtclose()2020-05-2917:15:13sbtrestore(filepath=/dm7/backup/db_increment_backup_20200529_01/db_increment_backup_20200529_01.meta)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=4096)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=45056)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=25088)2020-05-2917:15:13sbtclose()2020-05-2917:15:13sbtrestore(filepath=/dm7/backup/ts_main_increment_bak_2020052903/ts_main_increment_bak_2020052903.meta)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=4096)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=45056)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=8704)2020-05-2917:15:13sbtclose()2020-05-2917:15:13sbtrestore(filepath=/dm7/backup/db_rac_backup_encrypt_2020052901/db_rac_backup_encrypt_2020052901.meta)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=4096)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=45056)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=25088)2020-05-2917:15:13sbtclose()2020-05-2917:15:13sbtrestore(filepath=/dm7/backup/db_backup_20200528_03/db_backup_20200528_03.meta)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=4096)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=45056)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=25088)2020-05-2917:15:13sbtclose()2020-05-2917:15:13sbtrestore(filepath=/dm7/backup/db_increment_backup_20200529_02/db_increment_backup_20200529_02.meta)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=4096)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=45056)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=25088)2020-05-2917:15:13sbtclose()2020-05-2917:15:13sbtrestore(filepath=/dm7/backup/db_rac_backup_trace_2020052901/db_rac_backup_trace_2020052901.meta)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=4096)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=45056)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=25088)2020-05-2917:15:13sbtclose()2020-05-2917:15:13sbtrestore(filepath=+DMDATA/data/rac/bak/ts_backup_main_01/ts_backup_main_01.meta)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=4096)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=45056)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=8704)2020-05-2917:15:13sbtclose()2020-05-2917:15:13sbtrestore(filepath=+DMDATA/data/rac/bak/tab_t1_bak_01/tab_t1_bak_01.meta)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=4096)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=45056)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=5632)2020-05-2917:15:13sbtclose()2020-05-2917:15:13sbtrestore(filepath=+DMDATA/data/rac/bak/table_tab_01_backup_20200529/table_tab_01_backup_20200529.meta)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=4096)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=45056)2020-05-2917:15:13sbtread(buf!=NULL,buf_len=5632)2020-05-2917:15:13sbtclose()2020-05-2917:15:13sbtend(del_flag=FALSE)2020-05-2917:15:13sbtbackup(type=1,name=db_rac_backup_trace_2020052903.bak)2020-05-2917:15:13sbtwrite(buf!=NULL,buf_len=4096)2020-05-2917:15:13sbtwrite(buf!=NULL,buf_len=5095936)2020-05-2917:15:13sbtwrite(buf!=NULL,buf_len=21496320)2020-05-2917:15:13sbtwrite(buf!=NULL,buf_len=49664)2020-05-2917:15:13sbtclose()2020-05-2917:15:13sbtinfo(!NULL)file[db_rac_backup_trace_2020052903.bak]finished,name:[db_rac_backup_trace_2020052903.bak],createdtime:[2020-05-2917:15:13],expiratedtime:[2105-12-3123:59:59],label:[],comment:[]2020-05-2917:15:13sbtbackup(type=1,name=db_rac_backup_trace_2020052903_1.bak)2020-05-2917:15:13sbtwrite(buf!=NULL,buf_len=4096)2020-05-2917:15:13sbtwrite(buf!=NULL,buf_len=2560)2020-05-2917:15:13sbtclose()2020-05-2917:15:13sbtinfo(!NULL)file[db_rac_backup_trace_2020052903_1.bak]finished,name:[db_rac_backup_trace_2020052903_1.bak],createdtime:[2020-05-2917:15:13],expiratedtime:[2105-12-3123:59:59],label:[],comment:[]2020-05-2917:15:13sbtbackup(type=3,name=db_rac_backup_trace_2020052903.meta)2020-05-2917:15:13sbtwrite(buf!=NULL,buf_len=49152)2020-05-2917:15:13sbtwrite(buf!=NULL,buf_len=4096)2020-05-2917:15:13sbtwrite(buf!=NULL,buf_len=4096)2020-05-2917:15:13sbtwrite(buf!=NULL,buf_len=4096)2020-05-2917:15:13sbtwrite(buf!=NULL,buf_len=4096)2020-05-2917:15:13sbtwrite(buf!=NULL,buf_len=4096)2020-05-2917:15:13sbtwrite(buf!=NULL,buf_len=4096)2020-05-2917:15:13sbtwrite(buf!=NULL,buf_len=512)2020-05-2917:15:13sbtclose()2020-05-2917:15:13sbtinfo(!NULL)file[db_rac_backup_trace_2020052903.meta]finished,name:[db_rac_backup_trace_2020052903.meta],createdtime:[2020-05-2917:15:13],expiratedtime:[2105-12-3123:59:59],label:[],comment:[]2020-05-2917:15:13sbtend(del_flag=FALSE)

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