DM7使用DMRMAN执行数据库还原和恢复

使用DMRMAN执行数据库还原和恢复
下面介绍在数据文件损坏后如何使用DMRMAN还原和恢复数据库,主要内容包括:
1. 数据库还原
2. 数据库恢复

1. 数据库还原
使用RESTORE命令完成脱机还原操作,在还原语句中指定库级备份集,可以是脱机库级备份集,或是联机库级备份集。数据库的还原包括数据库配置文件还原和数据文件还原,目前可能需要还原的数据库配置文件包括dm.ini、dm.ctl、服务器秘钥文件(dm_service.private或者dm_external.config,若备份库指定usbkey加密,则无秘钥文件)、联机日志文件。语法如下:

RESTORE DATABASE  FROM BACKUPSET '< 备份集目录>'
[DEVICE TYPE DISK|TAPE[PARMS '< 介质参数>']]
[IDENTIFIED BY < 密码> [ENCRYPT WITH < 加密算法>]]
[WITH BACKUPDIR '< 基备份集搜索目录>'{,'< 基备份集搜索目录>'}]
[MAPPED FILE '< 映射文件>'][TASK THREAD < 任务线程数>] [NOT PARALLEL]
[RENAME TO '< 数据库名>'];
::=|
::=''[REUSE DMINI][OVERWRITE]
::= TO '' [OVERWRITE]

DATABASE:指定还原库目标的dm.ini文件路径。
BACKUPSET:指定用于还原目标数据库的备份集目录。若指定为相对路径,会在默认备份目录下搜索备份集。
DEVICE TYPE:指存储备份集的介质类型,支持DISK和TAPE,默认为DISK。DISK表示备份集存储介质为磁盘,TAPE表示存储介质为磁带。
PARMS:介质参数,供第三方存储介质(TAPE类型)管理使用。
IDENTIFIED BY:指定备份时使用的加密密码,供还原过程解密使用。
ENCRYPT WITH:指定备份时使用的加密算法,供还原过程解密使用,若未指定,则使用默认算法。
WITH BACKUPDIR:指定备份集搜索目录。
MAPPED FILE:指定存放还原目标路径的文件,参见3.3.5.2.1 数据库还原。当< 备份集目录>和< 映射文件>指定的路径不一致时,以< 映射文件>指定的路径为主
TASK THREAD:指定还原过程中用于处理解压缩和解密任务的线程个数。若未指定,则默认为4;若指定为0,则调整为1;若指定超过当前系统主机核数,则调整为主机核数。
NOT PARALLEL:指定并行备份集使用非并行方式还原。对于非并行备份集,不论是否指定该关键字,均采用非并行还原。
RENAME TO:指定还原数据库后是否更改库的名字,指定时将还原后的库改为指定的数据库名,默认使用备份集中的db_name作为还原后库的名称。

restore_type:
type1:
1>指定dm.ini还原,要求dm.ini中CTL_PATH必须配置正确,且内容有效;若配置CTL_PATH文件故障,且想利用dm.ini优化配置,则可选择type2还原后,用指定dm.ini覆盖还原后dm.ini,并修改CTL_PATH为当前控制文件路径即可;
2>除dm.ini文件外,其他文件均可不存在;但dm.ini参数配置必须正确,且配置的dm.ctl文件必须是有效的控制文件;
3>数据库配置文件中除已经存在的dm.ini外,先删除控制文件中的数据文件,然后根据overwrite选项,若指定overwrite,其他文件(这些文件不在控制文件中,所以未删除)均采用删除重建的处理,避免存在非法的文件,否则如果这些文件已经存在,则报错;
4>若指定REUSE DMINI,则会将备份集中备份的dm.ini中除路径相关的INI参数外,均拷贝到当前dm.ini上。

type2:
1>所有文件均可不在,system_dbf所在路径需为有效路径,若不存在,restore过程中会自动创建;
2>所有前面提到到数据库配置文件均会在指定的system_dbf所在路径还原,但非单机环境中相关其他文件均不修改或者重建,如MPP中dmmpp.ini、dmmal.ini等;
3>若未指定OVERWRITE,若system_dbf所在路径中存在待还原的库配置文件,则报错;若指定,则将已经存在的文件删除重建;
4>由于RAC环境中dm.ini可能存在多个,且可能不在一个主库上,或者即使在一个主库上也可能不在system_dbf所在路径中,故暂时不支持RAC环境的指定目录还原。

联机日志
上述和中的还原后的联机日志文件至少会有两个,因为源库中的日志文件可能大于等于两个,如果小于两个(被误删的情况)的则补齐为两个。已经存在的联机日志配置,使用原路径,若文件大小非法,则使用缺省大小256M重建;缺少的使用缺省命名和缺省大小256M重建。联机日志文件的命名规则:
1>单机:db_name+(file_id+1).log,其中fil_id + 1,占2个位置,如:db_name=DAMENG,则相应的名称为DAMENG01.log,DAMENG02.log;
2>RAC: rac+(ep_no + 1)_+(file_id+1).log,其中ep_no + 1和file_id+1均占2个位置,如0号节点日志名称为rac01_01.log,rac01_02.log。

使用说明:
通过RESTORE命令还原后的数据库不可用,需进一步执行RECOVER命令,将数据库恢复到备份结束时的状态。数据库备份集分为联机和脱机两种类型。通常情况下,用户会在联机的情况下备份数据库,因此下面以联机数据库备份为例说明使用DMRMAN如何执行数据库还原操作。
1) 联机备份数据库,保证数据库运行在归档模式及OPEN状态。

SQL> backup database '/dm7/data/rac0_config/dm.ini' full to db_rac_full_bak_for_restore backupset '/dm7/backup/db_rac_full_bak_for_restore';
executed successfully
used time: 00:00:01.233. Execute id is 4.

2) 准备目标库。还原目标库可以是已经存在的数据库,也可使用dminit工具初始化一个新库。如下所示:

./dminit path=/opt/dmdbms/data db_name=DAMENG_FOR_RESTORE

如果还原目标库与故障库是同一个,建议先执行故障库的归档修复操作。

3) 校验备份,校验待还原备份集的合法性。校验备份有两种方式,联机和脱机,此处使用脱机校验。

RMAN> check backupset '/dm7/backup/db_rac_full_bak_for_restore';
check backupset '/dm7/backup/db_rac_full_bak_for_restore';
CMD END.CODE:[0]
check backupset successfully.
time used: 12.182(ms)
也可以
SQL> select sf_bakset_check('disk','/dm7/backup/db_rac_full_bak_for_restore');

LINEID     SF_BAKSET_CHECK('disk','/dm7/backup/db_rac_full_bak_for_restore')
---------- -----------------------------------------------------------------
1          1

used time: 14.626(ms). Execute id is 6.

4) 还原数据库。启动DMRMAN,输入以下命令:

RMAN> restore database '/dm7/data/rac0_config/dm.ini' from backupset '/dm7/backup/db_rac_full_bak_for_restore';
restore database '/dm7/data/rac0_config/dm.ini' from backupset '/dm7/backup/db_rac_full_bak_for_restore';
file dm.key not found, use default license!
checking if the RAC database under system path [+DMDATA/data/rac] is running....
EP [0] is checking....
[-12000]:The specified instance has been started

需要停止实例

[dmdba@dmrac1 bin]$ dmrman dcr_ini=/dm7/data/dmdcr.ini
dmrman V7.1.6.46-Build(2018.02.08-89107)ENT
RMAN> restore database '/dm7/data/rac0_config/dm.ini' from backupset '/dm7/backup/db_rac_full_bak_for_restore';
restore database '/dm7/data/rac0_config/dm.ini' from backupset '/dm7/backup/db_rac_full_bak_for_restore';
file dm.key not found, use default license!
checking if the RAC database under system path [+DMDATA/data/rac] is running....
EP [0] is checking....
EP [1] is checking....
RESTORE DATABASE  CHECK......
RESTORE DATABASE , dbf collect......
RESTORE DATABASE , dbf refresh ......
RESTORE BACKUPSET [/dm7/backup/db_rac_full_bak_for_restore] START......
total 5 packages processed...
RESTORE DATABASE , UPDATE ctl file......
RESTORE DATABASE , REBUILD key file......
RESTORE DATABASE , CHECK db info......
RESTORE DATABASE , UPDATE db info......
total 9 packages processed!
CMD END.CODE:[0]
restore successfully.
time used: 12542.797(ms)

2. 数据库恢复

RMAN> recover database '/dm7/data/rac0_config/dm.ini';
recover database '/dm7/data/rac0_config/dm.ini';
checking if the RAC database under system path [+DMDATA/data/rac] is running....
EP [0] is checking....
EP [1] is checking....
EP[0] max_lsn: 72473
EP[0] adjust cur_lsn from [72473] to [73980]
EP 0's ckpt_lsn = 72474
min_ckpt_lsn = 72474
The RAC redo archive log 1 ptx
The RAC redo archive log 2 ptx
The RAC redo archive log 3 ptx
The RAC redo archive log 4 ptx
The RAC redo archive log 5 ptx
The RAC redo archive log 6 ptx
The RAC redo archive log 7 ptx
The RAC redo archive log 8 ptx
The RAC redo archive log 9 ptx
The RAC redo archive log 10 ptx
The RAC redo archive log 11 ptx
The RAC redo archive log 12 ptx
The RAC recover total redo 12 ptx
EP(0) slot ctl page(1, 0, 16) trxid = 9882
EP(1) slot ctl page(1, 0, 17) trxid = 8457
EP[0] Recover LSN from 72474 to 73970.
EP[1] Recover LSN from 73981 to 73980.
Recover from archive log finished, time used:0.029s.
recover successfully!
time used: 3246.961(ms)

启动实例

[root@dmrac1 backup]# service DmServicerac1 start
Starting DmServicerac1: [ OK ]

[root@dmrac2 init.d]# service DmServicerac2 start
Starting DmServicerac2: [ OK ]

 

DM7使用DMRMAN工具执行备份集映射文件导出

使用DMRMAN工具执行备份集映射文件导出
备份集映射文件,又称为mapped file。备份集映射文件导出,是备份管理的主要功能,是将备份集中各数据文件的原始路径或者调整后的路径生成到一个本地文件中,可通过关键字MAPPED FILE应用于表空间和库的还原操作中。本节主要对如何将备份集中数据文件路径导出到本地进行描述。内容包括:
1. 概述
2. 备份集映射文件导出

1. 概述
DMRMAN中使用DUMP命令导出映射文件。不支持导出到DMASM文件系统中。语法如下:

DUMP BACKUPSET '< 备份集目录>'
[DEVICE TYPE< 介质类型> [PARMS '< 介质参数>']]
[DATABASE ''|TO'']
MAPPED FILE '< 映射文件路径>';

备份集目录:待导出映射文件的目标备份集,仅支持库级和表空间级备份。
介质类型:指存储备份集的设备类型,暂支持DISK和TAPE。
介质参数:介质类型为TAPE时,第三方介质管理实现所需的参数字符串。
INI_PATH:备份集还原到目标库的INI路径。若指定,则根据INI对应库的系统目录调整数据文件路径;若不指定,则保持备份集中数据文件的原始路径。
SYSTEM_DIR:数据库目录中SYSTEM.DBF数据文件所在目录,作为数据库系统目录处理。

数据文件路径指定INI_PATH或者SYSTEM_DIR调整策略:若指定INI_PATH,则取出配置中SYSTEM_PATH作为数据库系统目录,若指定SYSTEM_DIR,则直接作为数据库系统目录。对于库备份集,与还原过程(2.1.2.1节)中数据库文件路径构造策略描述一致。对于表空间级备份集仅支持原库还原,若指定INI_PATH或者SYSTEM_DIR,则认为需要构造,构造策略与库备份集中数据文件路径构造策略一致。

映射文件路径:输出到本地的目标映射文件路径。用户指定的文件不能为已经存在的文件,否则报错。文件生成之后,允许手动调整数据文件路径到其他路径,真正使用映射文件时,会再次校验。不支持导出到DMASM文件系统中。

2. 导出备份集映射文件
本节举例说明如何使用DMRMAN的DUMP命令导出备份集数据文件路径到映射文件,主要内容包括:
1. 导出原始路径
2. 导出指定INI_PATH调整后的路径

1.导出原始路径
导出备份集中数据文件的原始路径。

RMAN> dump backupset '/dm7/backup/db_rac_bak_2020060901' device type disk mapped file '/dm7/backup/db_rac_bak_2020060901_mapped.txt';
dump backupset '/dm7/backup/db_rac_bak_2020060901' device type disk mapped file '/dm7/backup/db_rac_bak_2020060901_mapped.txt';
dump mapped file successfully.
time used: 10.006(ms)

[dmdba@dmrac1 backup]$ more db_rac_bak_2020060901_mapped.txt
/**************************************************************/
/***  Delete the unnecessary modified groups                 **/
/***  Modify the data_path or mirror_path only in one group  **/
/**************************************************************/

/**=============================================================**/
/*[rac_SYSTEM_FIL_0]*/
fil_id         = 0
ts_id          = 0
ts_name        = SYSTEM
data_path      = +DMDATA/data/rac/system.dbf
mirror_path    =

/**=============================================================**/
/*[rac_ROLL_FIL_0]*/
fil_id         = 0
ts_id          = 1
ts_name        = ROLL
data_path      = +DMDATA/data/rac/roll.dbf
mirror_path    =

/**=============================================================**/
/*[rac_MAIN_FIL_0]*/
fil_id         = 0
ts_id          = 4
ts_name        = MAIN
data_path      = +DMDATA/data/rac/main.dbf
mirror_path    =

/**=============================================================**/
/*[rac_TS_FOR_DBF_FIL_0]*/
fil_id         = 0
ts_id          = 5
ts_name        = TS_FOR_DBF
data_path      = +DMDATA/data/rac/ts_for_dbf_01.dbf
mirror_path    =

/**=============================================================**/
/*[rac_TS_FOR_DBF_FIL_1]*/
fil_id         = 1
ts_id          = 5
ts_name        = TS_FOR_DBF
data_path      = +DMDATA/data/rac/ts_for_dbf_02.dbf
mirror_path    =

/***************************** END ****************************/

2.导出指定INI_PATH调整后的路径
指定INI_PATH,导出调整后的数据文件路径到映射文件。

RMAN> dump backupset '/dm7/backup/db_rac_bak_2020060901' device type disk database '/dm7/data/rac0_config/dm.ini' mapped file '/dm7/backup/db_rac_bak_2020060901_mapped1.txt';
dump backupset '/dm7/backup/db_rac_bak_2020060901' device type disk database '/dm7/data/rac0_config/dm.ini' mapped file '/dm7/backup/db_rac_bak_2020060901_mapped1.txt';
dump mapped file successfully.
time used: 14.793(ms)

DM7使用DMRMAN工具导入备份集

使用DMRMAN工具导入备份集
导入备份集是备份管理的主要功能,下面主要对如何导入备份集进行描述。内容包括:
1. 概述
2. 导入备份集
1. 概述
DMRMAN中使用LOAD命令导入备份集。
语法如下:

LOAD BACKUPSETSFROM DEVICE TYPE< 介质类型> [PARMS '< 介质参数>'][WITH BACKUPDIR '< 备份集搜索目录>'{,'< 备份集搜索目录>'}] TO BACKUPDIR '< 备份集存放目录>';

介质类型:指存储备份集的设备类型,暂支持DISK和TAPE。
介质参数:介质类型为TAPE时,第三方介质管理实现所需的参数字符串。
备份集存放目录:指从TAPE上导出的备份集meta文件存放到本地磁盘的目标目录,要求为空或不存在。

2. 导入备份集
本节举例说明如何使用DMRMAN的LOAD命令导入备份集,主要内容包括:
1. 导出磁盘上备份集
2. 导出磁带上所有的备份集

1.导出磁盘上备份集
导出磁盘上备份集的meta文件。

RMAN>LOAD BACKUPSETS FROM DEVICE TYPE DISK TO BACKUPDIR '/mnt/dm7src/bak_dir';

2.导出磁带上所有的备份集
导出磁带/dev/nst0上所有备份集的meta文件到目录/mnt/hgfs/dm7src/bak_dir。

RMAN>LOAD BACKUPSETS FROM DEVICE TYPE TAPE TO BACKUPDIR '/mnt/hgfs/dm7src/bak_dir';
LOAD BACKUPSETS FROM DEVICE TYPE TAPE TO BACKUPDIR '/mnt/hgfs/dm7src/bak_dir';
load backupsets failed.error code:-10000
[-10000]:[错误码:-20022]磁带打开失败

退出dmrman,设置环境变量TAPE,值为/dev/nst0。

[root@192 debug]# export TAPE=/dev/nst0
[root@192 debug]#echo $TAPE
/dev/nst0

启动dmrman,再次执行:

[root@192 debug]# ./dmrman
dmrman V7.1.3.141-Build(2014.09.09-48301trunc)
RMAN>LOAD BACKUPSETS FROM DEVICE TYPE TAPE TO BACKUPDIR '/mnt/hgfs/dm7src/bak_dir';
LOAD BACKUPSETS FROM DEVICE TYPE TAPE TO BACKUPDIR '/mnt/hgfs/dm7src/bak_dir';
load meta file [SBT_TEST_T-20140909192629000000-4966] to path [/mnt/hgfs/dm7src/bak_dir/0/0.meta]...
load meta file [SBT_TEST_T-20140909192629000000-4966] to path [/mnt/hgfs/dm7src/bak_dir/0/0.meta]...success
load meta file [SBT_TEST_T2-20140909192746000000-9983] to path [/mnt/hgfs/dm7src/bak_dir/1/1.meta]...
load meta file [SBT_TEST_T2-20140909192746000000-9983] to path [/mnt/hgfs/dm7src/bak_dir/1/1.meta]...success
load backupsets successfully.

退出dmrman,查看本地磁盘目录/mnt/hgfs/dm7src/bak_dir:

[root@192 debug]# ls -1 /mnt/hgfs/dm7src/bak_dir
total 0
drwxrwxrwx 1 root root 0 Sep 11 00:23 0
drwxrwxrwx 1 root root 0 Sep 11 00:23 1
[root@192 debug]# ls -1 /mnt/hgfs/dm7src/bak_dir/0
total 12
-rwxrwxrwx 1 root root 24576 Sep 11 00:23 0.meta
[root@192 debug]# ls -1 /mnt/hgfs/dm7src/bak_dir/1
total 12
-rwxrwxrwx 1 root root 24576 Sep 11 00:23 1.meta

DM7使用DMRMAN工具删除备份集

使用DMRMAN工具删除备份集
备份集删除是备份管理的主要功能,下面主要对如何删除备份进行描述。内容包括:
1. 概述
2. 删除备份集

1. 概述
DMRMAN中使用REMOVE命令删除备份集,可删除指定备份集,也可批量删除备份集。单个备份集删除时并行备份中的子备份集不允许单独删除;在指定备份集搜集目录中,发现存在引用目标备份集作为基备份的需要执行级联删除,默认报错。批量删除备份集时,跳过收集到的单独的子备份集。语法如下:

REMOVE BACKUPSET '< 备份集目录>'
[DEVICE TYPE< 介质类型> [PARMS '< 介质参数>']][< database_bakdir_lst_stmt>][CASCADE];
REMOVE [DATABASE | TABLESPACE[] | TABLE ""."" | ARCHIVELOG|ARCHIVE LOG] BACKUPSETS
[]
{[UNTIL TIME '< 截止时间串>'] | [BEFOREn]}
::= DEVICE TYPE< 介质类型> [PARMS '< 介质参数>']
::= DATABASE '' |
WITH BACKUPDIR '< 备份集搜索目录>' {, '< 备份集搜索目录>' } |
DATABASE '' WITH BACKUPDIR '< 备份集搜索目录>' {, '< 备份集搜索目录>' }

BACKUPSET:指定待删除的备份集目录。
DATABASE:指定数据库dm.ini文件路径,若指定,则该数据库的默认备份目录作为备份集搜索目录之一。
DEVICE TYPE:指存储备份集的介质类型,支持DISK和TAPE,默认DISK。DISK表示备份集存储介质磁盘,TAPE表示存储介质为磁带。若未指定,则DISK和TAPE介质上满足条件备份集均会删除。
PARMS:介质类型为TAPE时,第三方介质管理实现所需的参数字符串。
CASCADE:当目标备份集已经被其他备份集引用为基备份集,默认不允许删除,若指定CASCADE,则递归删除所有引用的增量备份。DATABASE|TABLESPACE|TABLE|ARCHIVELOG|ARCHIVE LOG:指定删除备份集的类型,分别为库级、表空间级、表级备份,以及归档级别,其中ARCHVELOG和ARCHIVE LOG等价。若不指定,全部删除。指定TABLESPACE时,若指定目标表空间名,则仅会删除满足条件的指定表空间名称的表空间备份集,否则,删除所有满足条件的表空间级备份集;指定TABLE时,若指定目标表名,则仅会删除满足条件的指定表名的表备份集;否则,删除所有满足条件的表备份集。
UNTIL TIME:删除备份集生成的最大时间,即删除指定时间之前的备份集,若未指定,则删除所有备份集。
BEFOREn:删除距离当前时间前n天产生的备份集;n取值范围0~365,单位:天。
WITH BACKUPDIR:备份集搜索目录,用于搜索指定目录下的所有备份集。

2. 删除备份集
下面举例说明如何使用DMRMAN的REMOVE命令删除备份集,主要内容包括:
1. 删除特定的备份集
2. 批量删除所有备份集
3. 批量删除指定时间之前的备份集

1.删除特定的备份集
使用REMOVE BACKUPSET…命令可删除特定备份集,每次只能删除一个备份集。若删除备份集已经被引用为其他备份集的基备份且未指定CASCADE,则报错。

RMAN> remove backupset '/dm7/backup/db_rac_bak';
remove backupset '/dm7/backup/db_rac_bak';
CMD END.CODE:[0]
remove backupset successfully.
time used: 30.542(ms)

如果备份集在数据库默认备份目录下还可使用以下方式删除备份集:
RMAN> remove backupset 'DB_rac_FULL_20200608_160009_000828';
remove backupset 'DB_rac_FULL_20200608_160009_000828';
CMD END.CODE:[0]
remove backupset successfully.
time used: 57.206(ms)

如果备份集为其他备份集的基备份且备份集都在数据库默认备份目录下还可使用以下方式删除备份集:

RMAN> backup database '/dm7/data/rac0_config/dm.ini' full backupset '/dm7/backup/db_rac_bak_for_remove_01';
backup database '/dm7/data/rac0_config/dm.ini' full backupset '/dm7/backup/db_rac_bak_for_remove_01';
checking if the RAC database under system path [+DMDATA/data/rac] is running....
EP [0] is checking....
EP [1] is checking....
EP[0] max_lsn: 58852
EP[0] adjust cur_lsn from [58852] to [58867]
BACKUP DATABASE [rac], execute......
CMD CHECK LSN......
BACKUP DATABASE [rac], collect dbf......
CMD CHECK ......
DBF BACKUP SUBS......
total 1 packages processed...
total 2 packages processed...
total 3 packages processed...
total 4 packages processed...
total 5 packages processed...
DBF BACKUP MAIN......
BACKUPSET [/dm7/backup/db_rac_bak_for_remove_01] END, CODE [0]......
META GENERATING......
total 9 packages processed...
total 9 packages processed!
CMD END.CODE:[0]
backup successfully!
time used: 3683.477(ms)

–增量备份之前,启动数据库,以便成功生成增量备份

RMAN> backup database '/dm7/data/rac0_config/dm.ini' increment backupset '/dm7/backup/db_rac_bak_for_remove_01_incr';
backup database '/dm7/data/rac0_config/dm.ini' increment backupset '/dm7/backup/db_rac_bak_for_remove_01_incr';
checking if the RAC database under system path [+DMDATA/data/rac] is running....
EP [0] is checking....
EP [1] is checking....
EP[0] max_lsn: 61871
EP[0] adjust cur_lsn from [61871] to [61888]
BACKUP DATABASE [rac], execute......
CMD CHECK LSN......
BACKUP DATABASE [rac], collect dbf......
CMD CHECK ......
DBF BACKUP SUBS......
total 1 packages processed...
total 2 packages processed...
total 3 packages processed...
total 4 packages processed...
total 5 packages processed...
DBF BACKUP MAIN......
BACKUPSET [/dm7/backup/db_rac_bak_for_remove_01_incr] END, CODE [0]......
META GENERATING......
total 9 packages processed...
total 9 packages processed!
CMD END.CODE:[0]
backup successfully!
time used: 3563.746(ms)


RMAN> remove backupset '/dm7/backup/db_rac_bak_for_remove_01_incr' database '/dm7/data/rac0_config/dm.ini' cascade;
remove backupset '/dm7/backup/db_rac_bak_for_remove_01_incr' database '/dm7/data/rac0_config/dm.ini' cascade;
CMD END.CODE:[0]
remove backupset successfully.
time used: 23.623(ms)

2.批量删除所有备份集
使用REMOVE BACKUPSETS…命令可批量删除备份集。批量删除可选择删除的备份类型,数据库备份、表空间备份、表备份,以及归档备份,不指定则全部删除。下面示例为删除/dm7/backup目录下的所有备份集,可以是联机生成的备份集,也可以脱机DMRMAN工具生成的备份集。

RMAN> backup database '/dm7/data/rac0_config/dm.ini' full backupset '/dm7/backup/db_rac_bak_for_remove_02';
backup database '/dm7/data/rac0_config/dm.ini' full backupset '/dm7/backup/db_rac_bak_for_remove_02';
checking if the RAC database under system path [+DMDATA/data/rac] is running....
EP [0] is checking....
EP [1] is checking....
EP[0] max_lsn: 61871
EP[0] adjust cur_lsn from [61871] to [61888]
BACKUP DATABASE [rac], execute......
CMD CHECK LSN......
BACKUP DATABASE [rac], collect dbf......
CMD CHECK ......
DBF BACKUP SUBS......
total 1 packages processed...
total 2 packages processed...
total 3 packages processed...
total 4 packages processed...
total 5 packages processed...
DBF BACKUP MAIN......
BACKUPSET [/dm7/backup/db_rac_bak_for_remove_02] END, CODE [0]......
META GENERATING......
total 9 packages processed...
total 9 packages processed!
CMD END.CODE:[0]
backup successfully!
time used: 3415.539(ms)

RMAN> remove backupsets with backupdir '/dm7/backup/';
remove backupsets with backupdir '/dm7/backup/';
CMD END.CODE:[-10000],DESC:[Fail in mml(-10000)]
CMD END.CODE:[0]
remove backupset successfully.
time used: 1041.430(ms)

3.批量删除指定时间之前的备份集
REMOVE BACKUPSETS…UNTIL TIME命令用来批量删除指定时间的备份集。通常情况下,用户并不想删除指定目录下所有的备份集,这时可以选择只删除指定时间之前的备份。如何确定删除备份的时间点,需要结合用户的备份计划合理指定。若用户每周做一次完全备份,每天进行增量备份,那么删除的时间可指定为7天前的某个特定时间。假设今天的日期为2020-06-09,要删除7天前/dm7/backup目录下的所有备份在DMRMAN中输入以下命令:

RMAN> remove backupsets with backupdir '/dm7/backup/' until time '2020-06-09 15:20:00';
remove backupsets with backupdir '/dm7/backup/' until time '2020-06-09 15:20:00';
CMD END.CODE:[-10000],DESC:[Fail in mml(-10000)]
CMD END.CODE:[0]
remove backupset successfully.
time used: 1020.600(ms)

DM7使用DMRMAN工具查看备份集

使用DMRMAN工具查看备份集
1. 概述
DMRMAN中使用SHOW命令可以查看备份集的信息,包括:
1. 备份集的数据库信息
2. 备份集的元信息
3. 备份集中文件信息(如备份数据文件DBF和备份片文件)
4. 备份集中表信息(仅对表备份集有效)
若指定具体备份集目录,则会生成相应的备份集链表信息。
语法如下:

SHOW BACKUPSET '< 备份集目录>' [][RECURSIVE] [] []
[];
|SHOW BACKUPSETS [] 
[] [] [];
::= DATABASE '' |
WITH BACKUPDIR '< 备份集搜索目录>'{,'< 备份集搜索目录>'} |
DATABASE '' WITH BACKUPDIR '< 备份集搜索目录>'{, '< 备份集搜索目录>'}
::= DEVICE TYPE DISK|TAPE [PARMS '< 介质参数>']
::= INFO DB[,META][,FILE] [,TABLE]
::= USE DB_MAGIC 
::= TO '< 输出文件路径>' [FORMAT TXT | FORMAT XML]

BACKUPSET:指定显示目标备份集信息,若同时指定RECURSIVE,则显示以该备份集为最新备份集递归显示完整的备份集链表;否则,仅显示指定备份集本身信息。若为完全备份,则仅显示该备份集自身信息。

DATABASE:指定数据库dm.ini文件路径,若指定,则该数据库的默认备份目录作为备份集搜索目录之一。

WITH BACKUPDIR:备份集搜索目录,最大长度为256个字节。若查看完全备份的备份集信息且指定的备份集路径为相对路径可通过设置此参数搜索备份集;若查看的为增量备份集信息,设置该参数除上述功能外还用于搜索基备份集。

: 指定介质类型和介质参数,介质类型支持DISK和TAPE,默认DISK。

:指定显示备份集信息内容,可以组合指定,若未指定,则显示全部。具体说明如下:
1. DB 表示仅显示备份集的数据库信息;
2. META表示仅显示备份集的元信息;
3. FILE表示仅显示备份集中文件信息,如备份数据文件DBF和备份片文件;
4. TABLE 表示显示备份集中表信息,仅对表备份集有效。

:SHOW BACKUPSETS可以指定仅显示指定DB_MAGIC即指定数据库的备份集信息。

:指定备份集信息输出的目标文件路径,若不指定,仅控制台打印。文件格式有两种类型,TXT和XML格式,默认是TXT格式。不支持输出到DMASM文件系统中。指定的文件不能为已经存在的文件,否则报错。

2. 备份信息查看
SHOW命令支持查看单个备份集信息也支持批量查看多个备份集的信息。本节主要举例说明如何执行简单的常用的查看备份集信息操作,包括:
1. 查看指定的备份集信息
2. 批量显示备份集信息
3. 查看指定数据库所有备份集的信息
4. 指定显示部分备份集信息
5. 以xml格式输出备份信息到文件

1.查看指定的备份集信息
SHOW BACKUPSET…命令用于显示特定的备份集信息,每次只能显示一个备份集。当仅需要查看某个特定备份集信息时可以使用此命令。执行
步骤如下:

[dmdba@dmrac1 bin]$ dmrman
dmrman V7.1.6.46-Build(2018.02.08-89107)ENT
RMAN> show backupset '/dm7/backup/db_rac_bak';
show backupset '/dm7/backup/db_rac_bak';




system path:           +DMDATA/data/rac
db magic:              -991931850
permanent magic:       450923536
rac node:              2
page check:            0
rlog encrypt:          0
external cipher[id/name]:  0/
external hash[id/name]:  0/
length in char:        0
use new hash:          1
page size:             8 KB
extent size:           16
case sensitive:        1
log page size:         512 B
unicode_flag/charset:  0
data version:          0x7000A
sys version:           V7.1.6.46-Build(2018.02.08-89107)ENT
enable policy:         0
archive flag:          1
blank_pad_mode:        0
crc_check:             TRUE


backupset sig:         BA
backupset version:     4009
database name:         rac
backup name:           DB_RAC_BAK
backupset description:
backupset ID :         1109894076
parent backupset ID:     -1
META file size :       293376
compressed level:      0
encrypt type:          0
parallel num:          4
backup range:          database
mpp_timestamp:         1590824489
ddl_clone:             FALSE
mpp_flag:              FALSE
backup level:          online
backup type:           full
without log:           FALSE
START_LSN:             51236
START_SEQ:             1870
END_LSN:               51298
END_SEQ:               15673
base START_LSN:        -1
base END_LSN:          -1
base name:
base backupset:
backup time:           2020-05-30 15:41:35
min trx start lsn:     49398
min exec ver:          0x0701060C
pkg size:              0x02000000



RAC EP:            0
RAC status:          OK
RAC begin lsn:       51287
RAC begin seq:       15668
RAC end lsn:         51298
RAC end seq:         15673
RAC base begin lsn:  -1
RAC base begin seq:  -1
RAC base end lsn:    -1
RAC base end seq:    -1

RAC EP:            1
RAC status:          OK
RAC begin lsn:       51236
RAC begin seq:       1870
RAC end lsn:         51235
RAC end seq:         1869
RAC base begin lsn:  -1
RAC base begin seq:  -1
RAC base end lsn:    -1
RAC base end seq:    -1


backupset directory: /dm7/backup/db_rac_bak
backupset name:        db_rac_bak
backup data file num:  1
backup piece num:      1


$file_seq |$size(KB) |$pos_desc                                               |$content_type
0         |8         |db_rac_bak.bak                                          |LOG


$file_seq |$group_id |$group_name                      |$file_id  |$file_path                       |$mirror_path                     |$file_len


$file_seq |$file_path                       |$file_len           |$begin_lsn          |$begin_seqno        |$begin_rpag_off     |$end_lsn            |$end_seqno          |$create_time        |$close_time
1         |                                 |3072                |51286               |15668               |8                   |51298               |15673               |0000-00-00 00:00:00 |0000-00-00 00:00:00




system path:           +DMDATA/data/rac
db magic:              -991931850
permanent magic:       450923536
rac node:              2
page check:            0
rlog encrypt:          0
external cipher[id/name]:  0/
external hash[id/name]:  0/
length in char:        0
use new hash:          1
page size:             8 KB
extent size:           16
case sensitive:        1
log page size:         512 B
unicode_flag/charset:  0
data version:          0x7000A
sys version:           V7.1.6.46-Build(2018.02.08-89107)ENT
enable policy:         0
archive flag:          1
blank_pad_mode:        0
crc_check:             TRUE


backupset sig:         BA
backupset version:     4009
database name:         rac
backup name:           DB_RAC_BAK_2
backupset description:
backupset ID :         66095816
parent backupset ID:     1109894076
META file size :       57856
compressed level:      0
encrypt type:          0
parallel num:          1
backup range:          database
mpp_timestamp:         1590824489
ddl_clone:             FALSE
mpp_flag:              FALSE
backup level:          online
backup type:           full
without log:           FALSE
START_LSN:             51236
START_SEQ:             1870
END_LSN:               51235
END_SEQ:               1869
base START_LSN:        -1
base END_LSN:          -1
base name:
base backupset:
backup time:           2020-05-30 15:41:35
min trx start lsn:     49398
min exec ver:          0x0701060C
pkg size:              0x02000000



RAC EP:            0
RAC status:          OK
RAC begin lsn:       51287
RAC begin seq:       15668
RAC end lsn:         -1
RAC end seq:         -1
RAC base begin lsn:  -1
RAC base begin seq:  -1
RAC base end lsn:    -1
RAC base end seq:    -1

RAC EP:            1
RAC status:          OK
RAC begin lsn:       51236
RAC begin seq:       1870
RAC end lsn:         -1
RAC end seq:         -1
RAC base begin lsn:  -1
RAC base begin seq:  -1
RAC base end lsn:    -1
RAC base end seq:    -1


backupset directory: /dm7/backup/db_rac_bak/db_rac_bak_2
backupset name:        db_rac_bak_2
backup data file num:  1
backup piece num:      1


$file_seq |$size(KB) |$pos_desc                                               |$content_type
0         |85        |db_rac_bak_2.bak                                        |DATA


$file_seq |$group_id |$group_name                      |$file_id  |$file_path                       |$mirror_path                     |$file_len
3         |4         |MAIN                             |0         |+DMDATA/data/rac/main.dbf        |                                 |134217728


$file_seq |$file_path                       |$file_len           |$begin_lsn          |$begin_seqno        |$begin_rpag_off     |$end_lsn            |$end_seqno          |$create_time        |$close_time






system path:           +DMDATA/data/rac
db magic:              -991931850
permanent magic:       450923536
rac node:              2
page check:            0
rlog encrypt:          0
external cipher[id/name]:  0/
external hash[id/name]:  0/
length in char:        0
use new hash:          1
page size:             8 KB
extent size:           16
case sensitive:        1
log page size:         512 B
unicode_flag/charset:  0
data version:          0x7000A
sys version:           V7.1.6.46-Build(2018.02.08-89107)ENT
enable policy:         0
archive flag:          1
blank_pad_mode:        0
crc_check:             TRUE


backupset sig:         BA
backupset version:     4009
database name:         rac
backup name:           DB_RAC_BAK_3
backupset description:
backupset ID :         -1127735780
parent backupset ID:     1109894076
META file size :       57856
compressed level:      0
encrypt type:          0
parallel num:          1
backup range:          database
mpp_timestamp:         1590824489
ddl_clone:             FALSE
mpp_flag:              FALSE
backup level:          online
backup type:           full
without log:           FALSE
START_LSN:             51236
START_SEQ:             1870
END_LSN:               51235
END_SEQ:               1869
base START_LSN:        -1
base END_LSN:          -1
base name:
base backupset:
backup time:           2020-05-30 15:41:35
min trx start lsn:     49398
min exec ver:          0x0701060C
pkg size:              0x02000000



RAC EP:            0
RAC status:          OK
RAC begin lsn:       51287
RAC begin seq:       15668
RAC end lsn:         -1
RAC end seq:         -1
RAC base begin lsn:  -1
RAC base begin seq:  -1
RAC base end lsn:    -1
RAC base end seq:    -1

RAC EP:            1
RAC status:          OK
RAC begin lsn:       51236
RAC begin seq:       1870
RAC end lsn:         -1
RAC end seq:         -1
RAC base begin lsn:  -1
RAC base begin seq:  -1
RAC base end lsn:    -1
RAC base end seq:    -1


backupset directory: /dm7/backup/db_rac_bak/db_rac_bak_3
backupset name:        db_rac_bak_3
backup data file num:  1
backup piece num:      1


$file_seq |$size(KB) |$pos_desc                                               |$content_type
0         |13        |db_rac_bak_3.bak                                        |DATA


$file_seq |$group_id |$group_name                      |$file_id  |$file_path                       |$mirror_path                     |$file_len
4         |5         |TS_FOR_DBF                       |0         |+DMDATA/data/rac/ts_for_dbf_01.dbf|                                 |134217728


$file_seq |$file_path                       |$file_len           |$begin_lsn          |$begin_seqno        |$begin_rpag_off     |$end_lsn            |$end_seqno          |$create_time        |$close_time






system path:           +DMDATA/data/rac
db magic:              -991931850
permanent magic:       450923536
rac node:              2
page check:            0
rlog encrypt:          0
external cipher[id/name]:  0/
external hash[id/name]:  0/
length in char:        0
use new hash:          1
page size:             8 KB
extent size:           16
case sensitive:        1
log page size:         512 B
unicode_flag/charset:  0
data version:          0x7000A
sys version:           V7.1.6.46-Build(2018.02.08-89107)ENT
enable policy:         0
archive flag:          1
blank_pad_mode:        0
crc_check:             TRUE


backupset sig:         BA
backupset version:     4009
database name:         rac
backup name:           DB_RAC_BAK_0
backupset description:
backupset ID :         -287144791
parent backupset ID:     1109894076
META file size :       61952
compressed level:      0
encrypt type:          0
parallel num:          1
backup range:          database
mpp_timestamp:         1590824489
ddl_clone:             FALSE
mpp_flag:              FALSE
backup level:          online
backup type:           full
without log:           FALSE
START_LSN:             51236
START_SEQ:             1870
END_LSN:               51235
END_SEQ:               1869
base START_LSN:        -1
base END_LSN:          -1
base name:
base backupset:
backup time:           2020-05-30 15:41:35
min trx start lsn:     49398
min exec ver:          0x0701060C
pkg size:              0x02000000



RAC EP:            0
RAC status:          OK
RAC begin lsn:       51287
RAC begin seq:       15668
RAC end lsn:         -1
RAC end seq:         -1
RAC base begin lsn:  -1
RAC base begin seq:  -1
RAC base end lsn:    -1
RAC base end seq:    -1

RAC EP:            1
RAC status:          OK
RAC begin lsn:       51236
RAC begin seq:       1870
RAC end lsn:         -1
RAC end seq:         -1
RAC base begin lsn:  -1
RAC base begin seq:  -1
RAC base end lsn:    -1
RAC base end seq:    -1


backupset directory: /dm7/backup/db_rac_bak/db_rac_bak_0
backupset name:        db_rac_bak_0
backup data file num:  2
backup piece num:      1


$file_seq |$size(KB) |$pos_desc                                               |$content_type
0         |5005      |db_rac_bak_0.bak                                        |DATA


$file_seq |$group_id |$group_name                      |$file_id  |$file_path                       |$mirror_path                     |$file_len
1         |0         |SYSTEM                           |0         |+DMDATA/data/rac/system.dbf      |                                 |134217728
5         |5         |TS_FOR_DBF                       |1         |+DMDATA/data/rac/ts_for_dbf_02.dbf|                                 |134217728


$file_seq |$file_path                       |$file_len           |$begin_lsn          |$begin_seqno        |$begin_rpag_off     |$end_lsn            |$end_seqno          |$create_time        |$close_time






system path:           +DMDATA/data/rac
db magic:              -991931850
permanent magic:       450923536
rac node:              2
page check:            0
rlog encrypt:          0
external cipher[id/name]:  0/
external hash[id/name]:  0/
length in char:        0
use new hash:          1
page size:             8 KB
extent size:           16
case sensitive:        1
log page size:         512 B
unicode_flag/charset:  0
data version:          0x7000A
sys version:           V7.1.6.46-Build(2018.02.08-89107)ENT
enable policy:         0
archive flag:          1
blank_pad_mode:        0
crc_check:             TRUE


backupset sig:         BA
backupset version:     4009
database name:         rac
backup name:           DB_RAC_BAK_1
backupset description:
backupset ID :         -1045365472
parent backupset ID:     1109894076
META file size :       57856
compressed level:      0
encrypt type:          0
parallel num:          1
backup range:          database
mpp_timestamp:         1590824489
ddl_clone:             FALSE
mpp_flag:              FALSE
backup level:          online
backup type:           full
without log:           FALSE
START_LSN:             51236
START_SEQ:             1870
END_LSN:               51235
END_SEQ:               1869
base START_LSN:        -1
base END_LSN:          -1
base name:
base backupset:
backup time:           2020-05-30 15:41:35
min trx start lsn:     49398
min exec ver:          0x0701060C
pkg size:              0x02000000



RAC EP:            0
RAC status:          OK
RAC begin lsn:       51287
RAC begin seq:       15668
RAC end lsn:         -1
RAC end seq:         -1
RAC base begin lsn:  -1
RAC base begin seq:  -1
RAC base end lsn:    -1
RAC base end seq:    -1

RAC EP:            1
RAC status:          OK
RAC begin lsn:       51236
RAC begin seq:       1870
RAC end lsn:         -1
RAC end seq:         -1
RAC base begin lsn:  -1
RAC base begin seq:  -1
RAC base end lsn:    -1
RAC base end seq:    -1


backupset directory: /dm7/backup/db_rac_bak/db_rac_bak_1
backupset name:        db_rac_bak_1
backup data file num:  1
backup piece num:      1


$file_seq |$size(KB) |$pos_desc                                               |$content_type
0         |20997     |db_rac_bak_1.bak                                        |DATA


$file_seq |$group_id |$group_name                      |$file_id  |$file_path                       |$mirror_path                     |$file_len
2         |1         |ROLL                             |0         |+DMDATA/data/rac/roll.dbf        |                                 |134217728


$file_seq |$file_path                       |$file_len           |$begin_lsn          |$begin_seqno        |$begin_rpag_off     |$end_lsn            |$end_seqno          |$create_time        |$close_time




show backupsets successfully.
time used: 14.325(ms)

显示的备份集信息分为三类,依次是元数据信息(META INFO)、文件信息(FILE INFO)和数据库信息(DB INFO)。用户可根据自身需要只显示部分备份集信息,本节下文中会有介绍。

2.批量显示备份集信息
SHOW BACKUPSETS…命令用于批量显示指定搜索目录下的备份集信息。如需要查看的多个备份集不在同一个目录下,可通过多次指定WITH BACKUPDIR参数同时查看所有的备份集。操作如下:

RMAN> backup database '/dm7/data/rac0_config/dm.ini';
backup database '/dm7/data/rac0_config/dm.ini';
checking if the RAC database under system path [+DMDATA/data/rac] is running....
EP [0] is checking....
EP [1] is checking....
EP[0] max_lsn: 58852
EP[0] adjust cur_lsn from [58852] to [58867]
BACKUP DATABASE [rac], execute......
CMD CHECK LSN......
BACKUP DATABASE [rac], collect dbf......
CMD CHECK ......
DBF BACKUP SUBS......
total 1 packages processed...
total 2 packages processed...
total 3 packages processed...
total 4 packages processed...
total 5 packages processed...
DBF BACKUP MAIN......
BACKUPSET [+DMDATA/data/rac/bak/DB_rac_FULL_20200608_160009_000828] END, CODE [0]......
META GENERATING......
total 9 packages processed...
total 9 packages processed!
CMD END.CODE:[0]
backup successfully!
time used: 16303.415(ms)
RMAN> backup database '/dm7/data/rac0_config/dm.ini' full backupset '/dm7/backup/db_rac_full_bak_2020060801';
backup database '/dm7/data/rac0_config/dm.ini' full backupset '/dm7/backup/db_rac_full_bak_2020060801';
checking if the RAC database under system path [+DMDATA/data/rac] is running....
EP [0] is checking....
EP [1] is checking....
EP[0] max_lsn: 58852
EP[0] adjust cur_lsn from [58852] to [58867]
BACKUP DATABASE [rac], execute......
CMD CHECK LSN......
BACKUP DATABASE [rac], collect dbf......
CMD CHECK ......
DBF BACKUP SUBS......
total 1 packages processed...
total 2 packages processed...
total 3 packages processed...
total 4 packages processed...
total 5 packages processed...
DBF BACKUP MAIN......
BACKUPSET [/dm7/backup/db_rac_full_bak_2020060801] END, CODE [0]......
META GENERATING......
total 9 packages processed...
total 9 packages processed!
CMD END.CODE:[0]
backup successfully!
time used: 3570.343(ms)


RMAN> show backupsets with backupdir '+DMDATA/data/rac/bak','/dm7/backup';
show backupsets with backupdir '+DMDATA/data/rac/bak' , '/dm7/backup';
CMD END.CODE:[0]








system path:           +DMDATA/data/rac
db magic:              -991931850
permanent magic:       450923536
rac node:              2
page check:            0
rlog encrypt:          0
external cipher[id/name]:  0/
external hash[id/name]:  0/
length in char:        0
use new hash:          1
page size:             8 KB
extent size:           16
case sensitive:        1
log page size:         512 B
unicode_flag/charset:  0
data version:          0x7000A
sys version:           V7.1.6.46-Build(2018.02.08-89107)ENT
enable policy:         0
archive flag:          1
blank_pad_mode:        0
crc_check:             TRUE


backupset sig:         BA
backupset version:     4009
database name:         rac
backup name:           DB_FULL_rac_20200608_160623_000096
backupset description:
backupset ID :         186522112
parent backupset ID:     -1
META file size :       74240
compressed level:      0
encrypt type:          0
parallel num:          1
backup range:          database
mpp_timestamp:         1591603580
ddl_clone:             FALSE
mpp_flag:              FALSE
backup level:          offline
backup type:           full
without log:           FALSE
START_LSN:             58853
START_SEQ:             16611
END_LSN:               58867
END_SEQ:               16610
base START_LSN:        -1
base END_LSN:          -1
base name:
base backupset:
backup time:           2020-06-08 16:06:24
min trx start lsn:     58853
min exec ver:          0x0701060C
pkg size:              0x02000000



RAC EP:            0
RAC status:          OK
RAC begin lsn:       58853
RAC begin seq:       16611
RAC end lsn:         58867
RAC end seq:         16610
RAC base begin lsn:  -1
RAC base begin seq:  -1
RAC base end lsn:    -1
RAC base end seq:    -1

RAC EP:            1
RAC status:          OK
RAC begin lsn:       58868
RAC begin seq:       2492
RAC end lsn:         58867
RAC end seq:         2491
RAC base begin lsn:  -1
RAC base begin seq:  -1
RAC base end lsn:    -1
RAC base end seq:    -1


backupset directory: /dm7/backup/db_rac_full_bak_2020060801
backupset name:        db_rac_full_bak_2020060801
backup data file num:  5
backup piece num:      1


$file_seq |$size(KB) |$pos_desc                                               |$content_type
0         |26103     |db_rac_full_bak_2020060801.bak                          |DATA


$file_seq |$group_id |$group_name                      |$file_id  |$file_path                       |$mirror_path                     |$file_len
1         |0         |SYSTEM                           |0         |+DMDATA/data/rac/system.dbf      |                                 |134217728
2         |1         |ROLL                             |0         |+DMDATA/data/rac/roll.dbf        |                                 |134217728
3         |4         |MAIN                             |0         |+DMDATA/data/rac/main.dbf        |                                 |134217728
4         |5         |TS_FOR_DBF                       |0         |+DMDATA/data/rac/ts_for_dbf_01.dbf|                                 |134217728
5         |5         |TS_FOR_DBF                       |1         |+DMDATA/data/rac/ts_for_dbf_02.dbf|                                 |134217728


$file_seq |$file_path                       |$file_len           |$begin_lsn          |$begin_seqno        |$begin_rpag_off     |$end_lsn            |$end_seqno          |$create_time        |$close_time






system path:           +DMDATA/data/rac
db magic:              -991931850
permanent magic:       450923536
rac node:              2
page check:            0
rlog encrypt:          0
external cipher[id/name]:  0/
external hash[id/name]:  0/
length in char:        0
use new hash:          1
page size:             8 KB
extent size:           16
case sensitive:        1
log page size:         512 B
unicode_flag/charset:  0
data version:          0x7000A
sys version:           V7.1.6.46-Build(2018.02.08-89107)ENT
enable policy:         0
archive flag:          1
blank_pad_mode:        0
crc_check:             TRUE


backupset sig:         BA
backupset version:     4009
database name:         rac
backup name:           DB_FULL_rac_20200608_160009_000828
backupset description:
backupset ID :         1835676274
parent backupset ID:     -1
META file size :       74240
compressed level:      0
encrypt type:          0
parallel num:          1
backup range:          database
mpp_timestamp:         1591603207
ddl_clone:             FALSE
mpp_flag:              FALSE
backup level:          offline
backup type:           full
without log:           FALSE
START_LSN:             58853
START_SEQ:             16611
END_LSN:               58867
END_SEQ:               16610
base START_LSN:        -1
base END_LSN:          -1
base name:
base backupset:
backup time:           2020-06-08 16:00:17
min trx start lsn:     58853
min exec ver:          0x0701060C
pkg size:              0x02000000



RAC EP:            0
RAC status:          OK
RAC begin lsn:       58853
RAC begin seq:       16611
RAC end lsn:         58867
RAC end seq:         16610
RAC base begin lsn:  -1
RAC base begin seq:  -1
RAC base end lsn:    -1
RAC base end seq:    -1

RAC EP:            1
RAC status:          OK
RAC begin lsn:       58868
RAC begin seq:       2492
RAC end lsn:         58867
RAC end seq:         2491
RAC base begin lsn:  -1
RAC base begin seq:  -1
RAC base end lsn:    -1
RAC base end seq:    -1


backupset directory: +DMDATA/data/rac/bak/DB_rac_FULL_20200608_160009_000828
backupset name:        DB_rac_FULL_20200608_160009_000828
backup data file num:  5
backup piece num:      1


$file_seq |$size(KB) |$pos_desc                                               |$content_type
0         |26103     |DB_rac_FULL_20200608_160009_000828.bak                  |DATA


$file_seq |$group_id |$group_name                      |$file_id  |$file_path                       |$mirror_path                     |$file_len
1         |0         |SYSTEM                           |0         |+DMDATA/data/rac/system.dbf      |                                 |134217728
2         |1         |ROLL                             |0         |+DMDATA/data/rac/roll.dbf        |                                 |134217728
3         |4         |MAIN                             |0         |+DMDATA/data/rac/main.dbf        |                                 |134217728
4         |5         |TS_FOR_DBF                       |0         |+DMDATA/data/rac/ts_for_dbf_01.dbf|                                 |134217728
5         |5         |TS_FOR_DBF                       |1         |+DMDATA/data/rac/ts_for_dbf_02.dbf|                                 |134217728


$file_seq |$file_path                       |$file_len           |$begin_lsn          |$begin_seqno        |$begin_rpag_off     |$end_lsn            |$end_seqno          |$create_time        |$close_time






system path:           +DMDATA/data/rac
db magic:              -991931850
permanent magic:       450923536
rac node:              2
page check:            0
rlog encrypt:          0
external cipher[id/name]:  0/
external hash[id/name]:  0/
length in char:        0
use new hash:          1
page size:             8 KB
extent size:           16
case sensitive:        1
log page size:         512 B
unicode_flag/charset:  0
data version:          0x7000A
sys version:           V7.1.6.46-Build(2018.02.08-89107)ENT
enable policy:         0
archive flag:          1
blank_pad_mode:        0
crc_check:             TRUE


backupset sig:         BA
backupset version:     4009
database name:         rac
backup name:           DB_RAC_BAK
backupset description:
backupset ID :         1109894076
parent backupset ID:     -1
META file size :       293376
compressed level:      0
encrypt type:          0
parallel num:          4
backup range:          database
mpp_timestamp:         1590824489
ddl_clone:             FALSE
mpp_flag:              FALSE
backup level:          online
backup type:           full
without log:           FALSE
START_LSN:             51236
START_SEQ:             1870
END_LSN:               51298
END_SEQ:               15673
base START_LSN:        -1
base END_LSN:          -1
base name:
base backupset:
backup time:           2020-05-30 15:41:35
min trx start lsn:     49398
min exec ver:          0x0701060C
pkg size:              0x02000000



RAC EP:            0
RAC status:          OK
RAC begin lsn:       51287
RAC begin seq:       15668
RAC end lsn:         51298
RAC end seq:         15673
RAC base begin lsn:  -1
RAC base begin seq:  -1
RAC base end lsn:    -1
RAC base end seq:    -1

RAC EP:            1
RAC status:          OK
RAC begin lsn:       51236
RAC begin seq:       1870
RAC end lsn:         51235
RAC end seq:         1869
RAC base begin lsn:  -1
RAC base begin seq:  -1
RAC base end lsn:    -1
RAC base end seq:    -1


backupset directory: /dm7/backup/db_rac_bak
backupset name:        db_rac_bak
backup data file num:  1
backup piece num:      1


$file_seq |$size(KB) |$pos_desc                                               |$content_type
0         |8         |db_rac_bak.bak                                          |LOG


$file_seq |$group_id |$group_name                      |$file_id  |$file_path                       |$mirror_path                     |$file_len


$file_seq |$file_path                       |$file_len           |$begin_lsn          |$begin_seqno        |$begin_rpag_off     |$end_lsn            |$end_seqno          |$create_time        |$close_time
1         |                                 |3072                |51286               |15668               |8                   |51298               |15673               |0000-00-00 00:00:00 |0000-00-00 00:00:00




system path:           +DMDATA/data/rac
db magic:              -991931850
permanent magic:       450923536
rac node:              2
page check:            0
rlog encrypt:          0
external cipher[id/name]:  0/
external hash[id/name]:  0/
length in char:        0
use new hash:          1
page size:             8 KB
extent size:           16
case sensitive:        1
log page size:         512 B
unicode_flag/charset:  0
data version:          0x7000A
sys version:           V7.1.6.46-Build(2018.02.08-89107)ENT
enable policy:         0
archive flag:          1
blank_pad_mode:        0
crc_check:             TRUE


backupset sig:         BA
backupset version:     4009
database name:         rac
backup name:           DB_RAC_BAK_2
backupset description:
backupset ID :         66095816
parent backupset ID:     1109894076
META file size :       57856
compressed level:      0
encrypt type:          0
parallel num:          1
backup range:          database
mpp_timestamp:         1590824489
ddl_clone:             FALSE
mpp_flag:              FALSE
backup level:          online
backup type:           full
without log:           FALSE
START_LSN:             51236
START_SEQ:             1870
END_LSN:               51235
END_SEQ:               1869
base START_LSN:        -1
base END_LSN:          -1
base name:
base backupset:
backup time:           2020-05-30 15:41:35
min trx start lsn:     49398
min exec ver:          0x0701060C
pkg size:              0x02000000



RAC EP:            0
RAC status:          OK
RAC begin lsn:       51287
RAC begin seq:       15668
RAC end lsn:         -1
RAC end seq:         -1
RAC base begin lsn:  -1
RAC base begin seq:  -1
RAC base end lsn:    -1
RAC base end seq:    -1

RAC EP:            1
RAC status:          OK
RAC begin lsn:       51236
RAC begin seq:       1870
RAC end lsn:         -1
RAC end seq:         -1
RAC base begin lsn:  -1
RAC base begin seq:  -1
RAC base end lsn:    -1
RAC base end seq:    -1


backupset directory: /dm7/backup/db_rac_bak/db_rac_bak_2
backupset name:        db_rac_bak_2
backup data file num:  1
backup piece num:      1


$file_seq |$size(KB) |$pos_desc                                               |$content_type
0         |85        |db_rac_bak_2.bak                                        |DATA


$file_seq |$group_id |$group_name                      |$file_id  |$file_path                       |$mirror_path                     |$file_len
3         |4         |MAIN                             |0         |+DMDATA/data/rac/main.dbf        |                                 |134217728


$file_seq |$file_path                       |$file_len           |$begin_lsn          |$begin_seqno        |$begin_rpag_off     |$end_lsn            |$end_seqno          |$create_time        |$close_time






system path:           +DMDATA/data/rac
db magic:              -991931850
permanent magic:       450923536
rac node:              2
page check:            0
rlog encrypt:          0
external cipher[id/name]:  0/
external hash[id/name]:  0/
length in char:        0
use new hash:          1
page size:             8 KB
extent size:           16
case sensitive:        1
log page size:         512 B
unicode_flag/charset:  0
data version:          0x7000A
sys version:           V7.1.6.46-Build(2018.02.08-89107)ENT
enable policy:         0
archive flag:          1
blank_pad_mode:        0
crc_check:             TRUE


backupset sig:         BA
backupset version:     4009
database name:         rac
backup name:           DB_RAC_BAK_3
backupset description:
backupset ID :         -1127735780
parent backupset ID:     1109894076
META file size :       57856
compressed level:      0
encrypt type:          0
parallel num:          1
backup range:          database
mpp_timestamp:         1590824489
ddl_clone:             FALSE
mpp_flag:              FALSE
backup level:          online
backup type:           full
without log:           FALSE
START_LSN:             51236
START_SEQ:             1870
END_LSN:               51235
END_SEQ:               1869
base START_LSN:        -1
base END_LSN:          -1
base name:
base backupset:
backup time:           2020-05-30 15:41:35
min trx start lsn:     49398
min exec ver:          0x0701060C
pkg size:              0x02000000



RAC EP:            0
RAC status:          OK
RAC begin lsn:       51287
RAC begin seq:       15668
RAC end lsn:         -1
RAC end seq:         -1
RAC base begin lsn:  -1
RAC base begin seq:  -1
RAC base end lsn:    -1
RAC base end seq:    -1

RAC EP:            1
RAC status:          OK
RAC begin lsn:       51236
RAC begin seq:       1870
RAC end lsn:         -1
RAC end seq:         -1
RAC base begin lsn:  -1
RAC base begin seq:  -1
RAC base end lsn:    -1
RAC base end seq:    -1


backupset directory: /dm7/backup/db_rac_bak/db_rac_bak_3
backupset name:        db_rac_bak_3
backup data file num:  1
backup piece num:      1


$file_seq |$size(KB) |$pos_desc                                               |$content_type
0         |13        |db_rac_bak_3.bak                                        |DATA


$file_seq |$group_id |$group_name                      |$file_id  |$file_path                       |$mirror_path                     |$file_len
4         |5         |TS_FOR_DBF                       |0         |+DMDATA/data/rac/ts_for_dbf_01.dbf|                                 |134217728


$file_seq |$file_path                       |$file_len           |$begin_lsn          |$begin_seqno        |$begin_rpag_off     |$end_lsn            |$end_seqno          |$create_time        |$close_time






system path:           +DMDATA/data/rac
db magic:              -991931850
permanent magic:       450923536
rac node:              2
page check:            0
rlog encrypt:          0
external cipher[id/name]:  0/
external hash[id/name]:  0/
length in char:        0
use new hash:          1
page size:             8 KB
extent size:           16
case sensitive:        1
log page size:         512 B
unicode_flag/charset:  0
data version:          0x7000A
sys version:           V7.1.6.46-Build(2018.02.08-89107)ENT
enable policy:         0
archive flag:          1
blank_pad_mode:        0
crc_check:             TRUE


backupset sig:         BA
backupset version:     4009
database name:         rac
backup name:           DB_RAC_BAK_0
backupset description:
backupset ID :         -287144791
parent backupset ID:     1109894076
META file size :       61952
compressed level:      0
encrypt type:          0
parallel num:          1
backup range:          database
mpp_timestamp:         1590824489
ddl_clone:             FALSE
mpp_flag:              FALSE
backup level:          online
backup type:           full
without log:           FALSE
START_LSN:             51236
START_SEQ:             1870
END_LSN:               51235
END_SEQ:               1869
base START_LSN:        -1
base END_LSN:          -1
base name:
base backupset:
backup time:           2020-05-30 15:41:35
min trx start lsn:     49398
min exec ver:          0x0701060C
pkg size:              0x02000000



RAC EP:            0
RAC status:          OK
RAC begin lsn:       51287
RAC begin seq:       15668
RAC end lsn:         -1
RAC end seq:         -1
RAC base begin lsn:  -1
RAC base begin seq:  -1
RAC base end lsn:    -1
RAC base end seq:    -1

RAC EP:            1
RAC status:          OK
RAC begin lsn:       51236
RAC begin seq:       1870
RAC end lsn:         -1
RAC end seq:         -1
RAC base begin lsn:  -1
RAC base begin seq:  -1
RAC base end lsn:    -1
RAC base end seq:    -1


backupset directory: /dm7/backup/db_rac_bak/db_rac_bak_0
backupset name:        db_rac_bak_0
backup data file num:  2
backup piece num:      1


$file_seq |$size(KB) |$pos_desc                                               |$content_type
0         |5005      |db_rac_bak_0.bak                                        |DATA


$file_seq |$group_id |$group_name                      |$file_id  |$file_path                       |$mirror_path                     |$file_len
1         |0         |SYSTEM                           |0         |+DMDATA/data/rac/system.dbf      |                                 |134217728
5         |5         |TS_FOR_DBF                       |1         |+DMDATA/data/rac/ts_for_dbf_02.dbf|                                 |134217728


$file_seq |$file_path                       |$file_len           |$begin_lsn          |$begin_seqno        |$begin_rpag_off     |$end_lsn            |$end_seqno          |$create_time        |$close_time






system path:           +DMDATA/data/rac
db magic:              -991931850
permanent magic:       450923536
rac node:              2
page check:            0
rlog encrypt:          0
external cipher[id/name]:  0/
external hash[id/name]:  0/
length in char:        0
use new hash:          1
page size:             8 KB
extent size:           16
case sensitive:        1
log page size:         512 B
unicode_flag/charset:  0
data version:          0x7000A
sys version:           V7.1.6.46-Build(2018.02.08-89107)ENT
enable policy:         0
archive flag:          1
blank_pad_mode:        0
crc_check:             TRUE


backupset sig:         BA
backupset version:     4009
database name:         rac
backup name:           DB_RAC_BAK_1
backupset description:
backupset ID :         -1045365472
parent backupset ID:     1109894076
META file size :       57856
compressed level:      0
encrypt type:          0
parallel num:          1
backup range:          database
mpp_timestamp:         1590824489
ddl_clone:             FALSE
mpp_flag:              FALSE
backup level:          online
backup type:           full
without log:           FALSE
START_LSN:             51236
START_SEQ:             1870
END_LSN:               51235
END_SEQ:               1869
base START_LSN:        -1
base END_LSN:          -1
base name:
base backupset:
backup time:           2020-05-30 15:41:35
min trx start lsn:     49398
min exec ver:          0x0701060C
pkg size:              0x02000000



RAC EP:            0
RAC status:          OK
RAC begin lsn:       51287
RAC begin seq:       15668
RAC end lsn:         -1
RAC end seq:         -1
RAC base begin lsn:  -1
RAC base begin seq:  -1
RAC base end lsn:    -1
RAC base end seq:    -1

RAC EP:            1
RAC status:          OK
RAC begin lsn:       51236
RAC begin seq:       1870
RAC end lsn:         -1
RAC end seq:         -1
RAC base begin lsn:  -1
RAC base begin seq:  -1
RAC base end lsn:    -1
RAC base end seq:    -1


backupset directory: /dm7/backup/db_rac_bak/db_rac_bak_1
backupset name:        db_rac_bak_1
backup data file num:  1
backup piece num:      1


$file_seq |$size(KB) |$pos_desc                                               |$content_type
0         |20997     |db_rac_bak_1.bak                                        |DATA


$file_seq |$group_id |$group_name                      |$file_id  |$file_path                       |$mirror_path                     |$file_len
2         |1         |ROLL                             |0         |+DMDATA/data/rac/roll.dbf        |                                 |134217728


$file_seq |$file_path                       |$file_len           |$begin_lsn          |$begin_seqno        |$begin_rpag_off     |$end_lsn            |$end_seqno          |$create_time        |$close_time








show backupsets successfully.
time used: 18.070(ms)

3.查看指定数据库所有备份集的信息
如果指定的备份搜索目录下包含不同数据库的备份集,而我们只想查看某个特定数据库的所有备份集信息,此时可以使用SHOW BACKUPSETS…USE DB_MAGIC命令实现。具体操作如下:

1)备份不同的数据库到不同的目录下。

RMAN> backup database '/dm_home/dmdbms/data/dmks1/dm.ini' backupset '/dm_home/dmdbms/data/bak/db_dmks1_bak_2020060801';
backup database '/dm_home/dmdbms/data/dmks1/dm.ini' backupset '/dm_home/dmdbms/data/bak/db_dmks1_bak_2020060801';
file dm.key not found, use default license!
checking if the database under system path [/dm_home/dmdbms/data/dmks1] is running...[4].
checking if the database under system path [/dm_home/dmdbms/data/dmks1] is running...[3].
checking if the database under system path [/dm_home/dmdbms/data/dmks1] is running...[2].
checking if the database under system path [/dm_home/dmdbms/data/dmks1] is running...[1].
checking if the database under system path [/dm_home/dmdbms/data/dmks1] is running...[0].
checking if the database under system path [/dm_home/dmdbms/data/dmks1] is running, write dmrman info.
EP[0] max_lsn: 61665
BACKUP DATABASE [dmks1], execute......
CMD CHECK LSN......
BACKUP DATABASE [dmks1], collect dbf......
CMD CHECK ......
DBF BACKUP SUBS......
total 1 packages processed...
total 2 packages processed...
total 3 packages processed...
DBF BACKUP MAIN......
BACKUPSET [/dm_home/dmdbms/data/bak/db_dmks1_bak_2020060801] END, CODE [0]......
META GENERATING......
total 7 packages processed...
total 7 packages processed!
CMD END.CODE:[0]
backup successfully!
time used: 8043.221(ms)


RMAN> backup database '/dm_home/dmdbms/data/dmks2/dm.ini' backupset '/dm_home/dmdbms/backup/db_dmks2_bak_2020060801';
backup database '/dm_home/dmdbms/data/dmks2/dm.ini' backupset '/dm_home/dmdbms/backup/db_dmks2_bak_2020060801';
checking if the database under system path [/dm_home/dmdbms/data/dmks2] is running...[4].
checking if the database under system path [/dm_home/dmdbms/data/dmks2] is running...[3].
checking if the database under system path [/dm_home/dmdbms/data/dmks2] is running...[2].
checking if the database under system path [/dm_home/dmdbms/data/dmks2] is running...[1].
checking if the database under system path [/dm_home/dmdbms/data/dmks2] is running...[0].
checking if the database under system path [/dm_home/dmdbms/data/dmks2] is running, write dmrman info.
EP[0] max_lsn: 33904
BACKUP DATABASE [dmks2], execute......
CMD CHECK LSN......
BACKUP DATABASE [dmks2], collect dbf......
CMD CHECK ......
DBF BACKUP SUBS......
total 1 packages processed...
total 2 packages processed...
total 3 packages processed...
DBF BACKUP MAIN......
BACKUPSET [/dm_home/dmdbms/backup/db_dmks2_bak_2020060801] END, CODE [0]......
META GENERATING......
total 7 packages processed...
total 7 packages processed!
CMD END.CODE:[0]
backup successfully!
time used: 8047.711(ms)

2) 查看指定数据库备份集的信息,获取DB_MAGIC信息。

RMAN> show backupset '/dm_home/dmdbms/backup/db_dmks2_bak_2020060801';
show backupset '/dm_home/dmdbms/backup/db_dmks2_bak_2020060801';




system path:           /dm_home/dmdbms/data/dmks2
db magic:              1486708862
permanent magic:       1155586847
rac node:              1
page check:            0
rlog encrypt:          0
external cipher[id/name]:  0/
external hash[id/name]:  0/
length in char:        0
use new hash:          1
page size:             8 KB
extent size:           16
case sensitive:        1
log page size:         512 B
unicode_flag/charset:  0
data version:          0x7000A
sys version:           V7.1.6.46-Build(2018.02.08-89107)ENT
enable policy:         0
archive flag:          0
blank_pad_mode:        0
crc_check:             TRUE


backupset sig:         BA
backupset version:     4009
database name:         dmks2
backup name:           DB_FULL_dmks2_20200608_165451_000348
backupset description:
backupset ID :         -479813328
parent backupset ID:     -1
META file size :       66048
compressed level:      0
encrypt type:          0
parallel num:          1
backup range:          database
mpp_timestamp:         1591606486
ddl_clone:             FALSE
mpp_flag:              FALSE
backup level:          offline
backup type:           full
without log:           FALSE
START_LSN:             33905
START_SEQ:             14010
END_LSN:               33904
END_SEQ:               14009
base START_LSN:        -1
base END_LSN:          -1
base name:
base backupset:
backup time:           2020-06-08 16:54:53
min trx start lsn:     33905
min exec ver:          0x0701060C
pkg size:              0x02000000


backupset directory: /dm_home/dmdbms/backup/db_dmks2_bak_2020060801
backupset name:        db_dmks2_bak_2020060801
backup data file num:  3
backup piece num:      1


$file_seq |$size(KB) |$pos_desc                                               |$content_type
0         |5606      |db_dmks2_bak_2020060801.bak                             |DATA


$file_seq |$group_id |$group_name                      |$file_id  |$file_path                       |$mirror_path                     |$file_len
1         |0         |SYSTEM                           |0         |/dm_home/dmdbms/data/dmks2/SYSTEM.DBF|                                 |22020096
2         |1         |ROLL                             |0         |/dm_home/dmdbms/data/dmks2/ROLL.DBF|                                 |134217728
3         |4         |MAIN                             |0         |/dm_home/dmdbms/data/dmks2/MAIN.DBF|                                 |134217728


$file_seq |$file_path                       |$file_len           |$begin_lsn          |$begin_seqno        |$begin_rpag_off     |$end_lsn            |$end_seqno          |$create_time        |$close_time


show backupsets successfully.
time used: 6.251(ms)

通过查看备份集信息可知,数据库/dm_home/dmdbms/data/dmks2的DB_MAGIC值为-1486708862

3) 查看指定目录下数据库/dm_home/dmdbms/data/dmks2的所有备份集信息。

RMAN> show backupsets with backupdir '/dm_home/dmdbms/backup' use db_magic 1486708862;
show backupsets with backupdir '/dm_home/dmdbms/backup' use db_magic 1486708862;
CMD END.CODE:[0]
[602]:no backupsets searched in specified directories

4.指定查看备份集的元数据信息

SHOW BACKUPSET...INFO META命令用于查看备份集的元数据信息。操作步骤如下:
RMAN> show backupset '/dm_home/dmdbms/backup/db_dmks2_bak_2020060801' info meta;
show backupset '/dm_home/dmdbms/backup/db_dmks2_bak_2020060801' info meta;




backupset sig:         BA
backupset version:     4009
database name:         dmks2
backup name:           DB_FULL_dmks2_20200608_165451_000348
backupset description:
backupset ID :         -479813328
parent backupset ID:     -1
META file size :       66048
compressed level:      0
encrypt type:          0
parallel num:          1
backup range:          database
mpp_timestamp:         1591606486
ddl_clone:             FALSE
mpp_flag:              FALSE
backup level:          offline
backup type:           full
without log:           FALSE
START_LSN:             33905
START_SEQ:             14010
END_LSN:               33904
END_SEQ:               14009
base START_LSN:        -1
base END_LSN:          -1
base name:
base backupset:
backup time:           2020-06-08 16:54:53
min trx start lsn:     33905
min exec ver:          0x0701060C
pkg size:              0x02000000


show backupsets successfully.
time used: 5.915(ms)

这里获取的是单个备份集的元数据信息,也可以使用SHOW BACKUPSETS…INFO META命令批量获取元数据信息。同样地,我们可以使用类似的命令指定获取备份集的数据库信息、文件信息和表信息,或这些信息的任意组合。

5.以xml格式输出备份信息到文件
DMRMAN可以将显示的备份集信息输出到文件,目前支持的格式包括TXT和XML,默认为TXT文件格式。使用SHOW BACKUPSETS…TO ‘file_path’ FORMAT XML命令可将备份信息以XML格式显示并输出到文件,如下所示:

RMAN> show backupset '/dm_home/dmdbms/backup/db_dmks2_bak_2020060801' to '/home/dmdba/db_dmks2.txt' format xml;
show backupset '/dm_home/dmdbms/backup/db_dmks2_bak_2020060801' to '/home/dmdba/db_dmks2.txt' format xml;
< ?xml version="1.0" encoding="UTF-8"?>

        
                
                /dm_home/dmdbms/backup/db_dmks2_bak_2020060801
                DISK
                
                        BA
                        4009
                        dmks2
                        DB_FULL_dmks2_20200608_165451_000348
                        
                        -479813328
                        -1
                        66048
                        0
                        0
                        1
                        database
                        1591606486
                        FALSE
                        FALSE
                        offline
                        full
                        FALSE
                        33905
                        14010
                        33904
                        14009
                        -1
                        -1
                        
                        
                        2020-06-08 16:54:53
                        33905
                        0x0701060C
                        0x02000000
                
                
                        /dm_home/dmdbms/backup/db_dmks2_bak_2020060801
                        db_dmks2_bak_2020060801
                        3
                        1
                        
                                0
                                5740032
                                db_dmks2_bak_2020060801.bak
                                DATA
                        
                        
                                1
                                0
                                SYSTEM
                                0
                                /dm_home/dmdbms/data/dmks2/SYSTEM.DBF
                                
                                22020096
                        
                        
                                2
                                1
                                ROLL
                                0
                                /dm_home/dmdbms/data/dmks2/ROLL.DBF
                                
                                134217728
                        
                        
                                3
                                4
                                MAIN
                                0
                                /dm_home/dmdbms/data/dmks2/MAIN.DBF
                                
                                134217728
                        
                
                
                        /dm_home/dmdbms/data/dmks2
                        -1486708862
                        -1155586847
                        1
                        0
                        0
                        0
                        
                        0
                        
                        0
                        1
                        8192
                        16
                        TRUE
                        512
                        0
                        0
                        0x7000A
                        V7.1.6.46-Build(2018.02.08-89107)ENT 
                        FALSE
                        FALSE
                        0
                        TRUE
                
                
        

show backupsets successfully.
time used: 7.438(ms)

Proudly powered by WordPress | Indrajeet by Sus Hill.