1、备份还原环境
备份所在服务器(源) | 备份存放目录(源) | 备份异机还原服务器(目标) | 备份存放目录(目标) |
192.168.1.31 | /dm/dmback | 192.168.1.32 | /dm/dmback |
2、做一次全量备份+增量备份+归档日志备份
192.168.1.31:
#做全备
SQL> BACKUP DATABASE TO WEEKLY_FULL_BAK BACKUPSET
'/dm/dmback/db_fullbak_01' DEVICE TYPE DISK BACKUPINFO 'db_fullbak' MAXPIECESIZE 300 COMPRESSED LEVEL 1 PARALLEL 4;
操作已执行
SQL> insert into test select * from test;
影响行数 1159
已用时间: 19.098(毫秒). 执行号:1803.
SQL> commit;
操作已执行
已用时间: 3.741(毫秒). 执行号:1804.
SQL> alter system switch logfile;
操作已执行
已用时间: 23.495(毫秒). 执行号:0.
SQL> select count(*) from test;
行号 COUNT(*)
---------- --------------------
1 2318
做增量备份:
SQL> BACKUP DATABASE INCREMENT WITH BACKUPDIR '/dm/dmback/' BACKUPSET '/dm/dmback/db_increment_bak_02';
操作已执行
#创建test3测试表
SQL> create table test3 (id number,name varchar2(20));
操作已执行
已用时间: 16.750(毫秒). 执行号:1901.
SQL> insert into test3 values(1,'test01');commit;
DMSQL 过程已成功完成
已用时间: 3.295(毫秒). 执行号:1902.
SQL> alter system switch logfile;
操作已执行
已用时间: 15.731(毫秒). 执行号:0.
SQL> select * from test3;
行号 ID NAME
---------- -- ------
1 1 test01
#查看归档日志
[dmdba@Kylin01 dmback]$ ls -rlt /dm/dmarch/
总用量 538292
-rw-r--r-- 1 dmdba dinstall 339968 5月 17 11:58 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-17_11-27-25.log
-rw-r--r-- 1 dmdba dinstall 9728 5月 17 11:58 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-17_11-58-03.log
-rw-r--r-- 1 dmdba dinstall 9216 5月 17 11:59 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-17_11-58-36.log
-rw-r--r-- 1 dmdba dinstall 2431488 5月 17 15:56 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-17_11-59-06.log
-rw-r--r-- 1 dmdba dinstall 111104 5月 20 00:00 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-19_23-52-17.log
-rw-r--r-- 1 dmdba dinstall 249344 5月 20 12:06 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-20_11-45-05.log
-rw-r--r-- 1 dmdba dinstall 595456 5月 21 09:53 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-20_20-23-20.log
-rw-r--r-- 1 dmdba dinstall 1538560 5月 21 11:56 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-21_09-53-16.log
-rw-r--r-- 1 dmdba dinstall 677376 5月 27 00:13 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-26_23-30-54.log
-rw-r--r-- 1 dmdba dinstall 294400 5月 27 09:58 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-27_09-32-15.log
-rw-r--r-- 1 dmdba dinstall 1828864 6月 1 00:01 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-27_21-05-46.log
-rw-r--r-- 1 dmdba dinstall 445952 6月 1 12:04 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_11-50-15.log
-rw-r--r-- 1 dmdba dinstall 1511424 6月 1 17:33 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_15-25-16.log
-rw-r--r-- 1 dmdba dinstall 2856448 6月 1 20:59 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_17-33-53.log
-rw-r--r-- 1 dmdba dinstall 144384 6月 1 21:11 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_20-59-34.log
-rw-r--r-- 1 dmdba dinstall 18944 6月 1 21:13 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_21-11-52.log
-rw-r--r-- 1 dmdba dinstall 29184 6月 1 21:15 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_21-13-13.log
-rw-r--r-- 1 dmdba dinstall 805888 6月 1 22:33 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_21-15-28.log
-rw-r--r-- 1 dmdba dinstall 406016 6月 1 23:11 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_22-33-10.log
-rw-r--r-- 1 dmdba dinstall 536870912 6月 1 23:11 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_23-11-21.log
[dmdba@Kylin01 dmback]$
#备份归档日志:
[dmdba@Kylin01 dmback]$ disql sysdba/dameng123
服务器[LOCALHOST:5236]:处于普通打开状态
登录使用时间 : 3.118(ms)
disql V8
SQL> BACKUP ARCHIVE LOG ALL BACKUPSET '/dm/dmback/arch_bak_01';
操作已执行
已用时间: 00:00:03.795. 执行号:2400.
注意:其中ID为2的数据是,备份归档日志之后插入到test3表的。
SQL> insert into test3 values(2,'test02');commit;
DMSQL 过程已成功完成
已用时间: 2.639(毫秒). 执行号:1903.
SQL> select * from test3;
行号 ID NAME
---------- -- ------
1 1 test01
2 2 test02
SQL> alter system switch logfile;
SQL> exit
#查看归档日志
SQL> exit
[dmdba@Kylin01 dmback]$ ls -rlt /dm/dmarch/
总用量 538328
-rw-r--r-- 1 dmdba dinstall 339968 5月 17 11:58 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-17_11-27-25.log
-rw-r--r-- 1 dmdba dinstall 9728 5月 17 11:58 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-17_11-58-03.log
-rw-r--r-- 1 dmdba dinstall 9216 5月 17 11:59 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-17_11-58-36.log
-rw-r--r-- 1 dmdba dinstall 2431488 5月 17 15:56 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-17_11-59-06.log
-rw-r--r-- 1 dmdba dinstall 111104 5月 20 00:00 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-19_23-52-17.log
-rw-r--r-- 1 dmdba dinstall 249344 5月 20 12:06 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-20_11-45-05.log
-rw-r--r-- 1 dmdba dinstall 595456 5月 21 09:53 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-20_20-23-20.log
-rw-r--r-- 1 dmdba dinstall 1538560 5月 21 11:56 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-21_09-53-16.log
-rw-r--r-- 1 dmdba dinstall 677376 5月 27 00:13 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-26_23-30-54.log
-rw-r--r-- 1 dmdba dinstall 294400 5月 27 09:58 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-27_09-32-15.log
-rw-r--r-- 1 dmdba dinstall 1828864 6月 1 00:01 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-27_21-05-46.log
-rw-r--r-- 1 dmdba dinstall 445952 6月 1 12:04 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_11-50-15.log
-rw-r--r-- 1 dmdba dinstall 1511424 6月 1 17:33 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_15-25-16.log
-rw-r--r-- 1 dmdba dinstall 2856448 6月 1 20:59 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_17-33-53.log
-rw-r--r-- 1 dmdba dinstall 144384 6月 1 21:11 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_20-59-34.log
-rw-r--r-- 1 dmdba dinstall 18944 6月 1 21:13 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_21-11-52.log
-rw-r--r-- 1 dmdba dinstall 29184 6月 1 21:15 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_21-13-13.log
-rw-r--r-- 1 dmdba dinstall 805888 6月 1 22:33 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_21-15-28.log
-rw-r--r-- 1 dmdba dinstall 406016 6月 1 23:11 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_22-33-10.log
-rw-r--r-- 1 dmdba dinstall 18944 6月 1 23:12 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_23-11-21.log
-rw-r--r-- 1 dmdba dinstall 15360 6月 1 23:13 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_23-12-36.log
-rw-r--r-- 1 dmdba dinstall 536870912 6月 1 23:13 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_23-13-25.log
#查看备份
[dmdba@Kylin01 dmback]$ ls -rlt /dm/dmback/
总用量 0
drwxr-xr-x 2 dmdba dinstall 228 5月 27 00:12 dexp_back
drwxr-xr-x 6 dmdba dinstall 149 6月 1 20:55 db_fullbak_01
drwxr-xr-x 2 dmdba dinstall 102 6月 1 20:59 db_increment_bak_02
drwxr-xr-x 2 dmdba dinstall 47 6月 1 22:33 arch_bak
drwxr-xr-x 2 dmdba dinstall 53 6月 1 23:12 arch_bak_01
拷贝31服务器(备份源)的备份集到32服务器(目标):
[dmdba@Kylin01 dmback]$ scp -r db_* dmdba@192.168.1.32:/dm/dmback/
[dmdba@Kylin01 dmback]$ scp -r arch_bak_01 dmdba@192.168.1.32:/dm/dmback/
拷贝31服务器的参数文件到32服务器:
[dmdba@Kylin01 CB]$ scp *.ini dmdba@192.168.1.32:/dm/dmdata/CB/
3、异机还原备份(利用备份的归档日志还原,数据没有恢复到最新)
192.168.1.32:
#32服务器先初始化好一个空库(此处略)
#还原步骤
restore database '/dm/dmdata/CB/dm.ini' from backupset '/dm/dmback/db_fullbak_01';
restore database '/dm/dmdata/CB/dm.ini' from backupset '/dm/dmback/db_increment_bak_02';
recover database '/dm/dmdata/CB/dm.ini' from backupset '/dm/dmback/db_increment_bak_02';
RESTORE ARCHIVE LOG FROM BACKUPSET '/dm/dmback/arch_bak_01' TO ARCHIVEDIR '/dm/dmarch' OVERWRITE 2;
recover database '/dm/dmdata/CB/dm.ini' WITH ARCHIVEDIR '/dm/dmarch';
recover database '/dm/dmdata/CB/dm.ini' update db_magic;
[dmdba@Kylin02 dmback]$ dmrman
dmrman V8
#还原全备
RMAN> restore database '/dm/dmdata/CB/dm.ini' from backupset '/dm/dmback/db_fullbak_01';
restore database '/dm/dmdata/CB/dm.ini' from backupset '/dm/dmback/db_fullbak_01';
file dm.key not found, use default license!
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
[Percent:100.00%][Speed:0.00M/s][Cost:00:00:04][Remaining:00:00:00]
restore successfully.
time used: 00:00:04.248
#还原增量备份
RMAN> restore database '/dm/dmdata/CB/dm.ini' from backupset '/dm/dmback/db_increment_bak_02';
restore database '/dm/dmdata/CB/dm.ini' from backupset '/dm/dmback/db_increment_bak_02';
Database mode = 2, oguid = 0
Database mode = 2, oguid = 0
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
[Percent:100.00%][Speed:0.00M/s][Cost:00:00:02][Remaining:00:00:00]
restore successfully.
time used: 00:00:02.964
#从备份集恢复数据:
RMAN> recover database '/dm/dmdata/CB/dm.ini' from backupset '/dm/dmback/db_increment_bak_02';
recover database '/dm/dmdata/CB/dm.ini' from backupset '/dm/dmback/db_increment_bak_02';
Database mode = 2, oguid = 0
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
EP[0]'s cur_lsn[79866], file_lsn[79866]
[Percent:100.00%][Speed:0.00PKG/s][Cost:00:00:00][Remaining:00:00:00]
recover successfully!
time used: 00:00:02.628
OVERWRITE参数说明:还原归档时,指定归档日志已经存在时的处理方式。可取值 1、2、3。1:
跳过已存在的归档日志,继续其他日志的还原。跳过的日志信息会生成一条日志记录在安装
目录的 log 目录中的 dm_BAKRES_年月.log 日志文件中。2:直接报错返回。3:强制覆
盖已存在的归档日志。缺省为 1。
#还原备份的归档日志到/dm/dmarch归档目录
RMAN> RESTORE ARCHIVE LOG FROM BACKUPSET '/dm/dmback/arch_bak_01' TO ARCHIVEDIR '/dm/dmarch' OVERWRITE 2;
RESTORE ARCHIVE LOG FROM BACKUPSET '/dm/dmback/arch_bak_01' TO ARCHIVEDIR '/dm/dmarch' OVERWRITE 2;
[Percent:100.00%][Speed:0.00M/s][Cost:00:00:00][Remaining:00:00:00]
restore successfully.
time used: 930.256(ms)
[dmdba@Kylin02 dmback]$ ls -rlt /dm/dmarch/
总用量 538312
-rw-r--r-- 1 dmdba dinstall 339968 6月 1 23:17 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-17_11-27-25.log
-rw-r--r-- 1 dmdba dinstall 9728 6月 1 23:17 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-17_11-58-03.log
-rw-r--r-- 1 dmdba dinstall 9216 6月 1 23:17 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-17_11-58-36.log
-rw-r--r-- 1 dmdba dinstall 2431488 6月 1 23:17 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-17_11-59-06.log
-rw-r--r-- 1 dmdba dinstall 111104 6月 1 23:17 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-19_23-52-17.log
-rw-r--r-- 1 dmdba dinstall 249344 6月 1 23:17 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-20_11-45-05.log
-rw-r--r-- 1 dmdba dinstall 595456 6月 1 23:17 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-20_20-23-20.log
-rw-r--r-- 1 dmdba dinstall 1538560 6月 1 23:17 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-21_09-53-16.log
-rw-r--r-- 1 dmdba dinstall 677376 6月 1 23:17 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-26_23-30-54.log
-rw-r--r-- 1 dmdba dinstall 294400 6月 1 23:17 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-27_09-32-15.log
-rw-r--r-- 1 dmdba dinstall 1828864 6月 1 23:17 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-27_21-05-46.log
-rw-r--r-- 1 dmdba dinstall 445952 6月 1 23:17 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_11-50-15.log
-rw-r--r-- 1 dmdba dinstall 1511424 6月 1 23:17 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_15-25-16.log
-rw-r--r-- 1 dmdba dinstall 2856448 6月 1 23:17 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_17-33-53.log
-rw-r--r-- 1 dmdba dinstall 144384 6月 1 23:17 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_20-59-34.log
-rw-r--r-- 1 dmdba dinstall 18944 6月 1 23:17 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_21-11-52.log
-rw-r--r-- 1 dmdba dinstall 29184 6月 1 23:17 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_21-13-13.log
-rw-r--r-- 1 dmdba dinstall 805888 6月 1 23:17 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_21-15-28.log
-rw-r--r-- 1 dmdba dinstall 406016 6月 1 23:17 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_22-33-10.log
-rw-r--r-- 1 dmdba dinstall 18944 6月 1 23:17 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_23-11-21.log
-rw-r--r-- 1 dmdba dinstall 536870912 6月 1 23:17 ARCHIVE_LOCAL1_0x25ED327E_EP0_2023-06-01_23-17-36.log
#在/dm/dmarch归档日志目录应用归档日志
RMAN> recover database '/dm/dmdata/CB/dm.ini' WITH ARCHIVEDIR '/dm/dmarch';
recover database '/dm/dmdata/CB/dm.ini' WITH ARCHIVEDIR '/dm/dmarch';
file dm.key not found, use default license!
Database mode = 2, oguid = 0
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
EP[0]'s cur_lsn[81037], file_lsn[81037]
[Percent:100.00%][Speed:15040.00PKG/s][Cost:00:00:00][Remaining:00:00:00]
recover successfully!
time used: 787.571(ms)
#更新魔术
RMAN> recover database '/dm/dmdata/CB/dm.ini' update db_magic;
recover database '/dm/dmdata/CB/dm.ini' update db_magic;
Database mode = 2, oguid = 0
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
EP[0]'s cur_lsn[83847], file_lsn[83847]
recover successfully!
time used: 00:00:01.220
RMAN> exit
#启动数据库
[dmdba@Kylin02 dmback]$ DmServiceCB start
Starting DmServiceCB: [ OK ]
验证:
[dmdba@Kylin02 dmback]$ disql sysdba/dameng123
服务器[LOCALHOST:5236]:处于普通打开状态
登录使用时间 : 2.868(ms)
disql V8
SQL> select * from test3;
行号 ID NAME
---------- -- ------
1 1 test01
已用时间: 2.346(毫秒). 执行号:500.
因为其中ID为2的数据是备份归档日志之后插入到test3表的,如果要恢复到最新的数据需要将31服务器的归档日志拷贝到32服务器。
SQL> select count(*) from test;
行号 COUNT(*)
---------- --------------------
1 2318
已用时间: 1.061(毫秒). 执行号:501.
SQL>
4、利用备份源所在库的最新归档日志异机还原到最新数据
[dmdba@Kylin02 ~]$ dmrman
dmrman V8
#还原全备
RMAN> restore database '/dm/dmdata/CB/dm.ini' from backupset '/dm/dmback/db_fullbak_01';
restore database '/dm/dmdata/CB/dm.ini' from backupset '/dm/dmback/db_fullbak_01';
file dm.key not found, use default license!
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
[Percent:100.00%][Speed:0.00M/s][Cost:00:00:03][Remaining:00:00:00]
restore successfully.
time used: 00:00:03.606
#还原增量备份
RMAN> restore database '/dm/dmdata/CB/dm.ini' from backupset '/dm/dmback/db_increment_bak_02';
restore database '/dm/dmdata/CB/dm.ini' from backupset '/dm/dmback/db_increment_bak_02';
Database mode = 2, oguid = 0
Database mode = 2, oguid = 0
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
[Percent:100.00%][Speed:0.00M/s][Cost:00:00:02][Remaining:00:00:00]
restore successfully.
time used: 00:00:02.872
#从备份集恢复数据
RMAN> recover database '/dm/dmdata/CB/dm.ini' from backupset '/dm/dmback/db_increment_bak_02';
recover database '/dm/dmdata/CB/dm.ini' from backupset '/dm/dmback/db_increment_bak_02';
Database mode = 2, oguid = 0
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
EP[0]'s cur_lsn[79866], file_lsn[79866]
[Percent:100.00%][Speed:0.00PKG/s][Cost:00:00:00][Remaining:00:00:00]
recover successfully!
time used: 00:00:02.768
#还原备份的归档日志到/dm/dmarch归档目录
RMAN> RESTORE ARCHIVE LOG FROM BACKUPSET '/dm/dmback/arch_bak_01' TO ARCHIVEDIR '/dm/dmarch' OVERWRITE 2;
RESTORE ARCHIVE LOG FROM BACKUPSET '/dm/dmback/arch_bak_01' TO ARCHIVEDIR '/dm/dmarch' OVERWRITE 2;
[Percent:100.00%][Speed:0.00M/s][Cost:00:00:00][Remaining:00:00:00]
restore successfully.
time used: 643.080(ms)
查看还原的归档日志:
[dmdba@Kylin02 ~]$ ls -rlt /dm/dmarch
总用量 14024
-rw-r--r-- 1 dmdba dinstall 339968 6月 2 11:12 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-17_11-27-25.log
-rw-r--r-- 1 dmdba dinstall 9728 6月 2 11:12 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-17_11-58-03.log
-rw-r--r-- 1 dmdba dinstall 9216 6月 2 11:12 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-17_11-58-36.log
-rw-r--r-- 1 dmdba dinstall 2431488 6月 2 11:12 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-17_11-59-06.log
-rw-r--r-- 1 dmdba dinstall 111104 6月 2 11:12 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-19_23-52-17.log
-rw-r--r-- 1 dmdba dinstall 249344 6月 2 11:12 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-20_11-45-05.log
-rw-r--r-- 1 dmdba dinstall 595456 6月 2 11:12 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-20_20-23-20.log
-rw-r--r-- 1 dmdba dinstall 1538560 6月 2 11:12 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-21_09-53-16.log
-rw-r--r-- 1 dmdba dinstall 677376 6月 2 11:12 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-26_23-30-54.log
-rw-r--r-- 1 dmdba dinstall 294400 6月 2 11:12 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-27_09-32-15.log
-rw-r--r-- 1 dmdba dinstall 1828864 6月 2 11:12 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-27_21-05-46.log
-rw-r--r-- 1 dmdba dinstall 445952 6月 2 11:12 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_11-50-15.log
-rw-r--r-- 1 dmdba dinstall 1511424 6月 2 11:12 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_15-25-16.log
-rw-r--r-- 1 dmdba dinstall 2856448 6月 2 11:12 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_17-33-53.log
-rw-r--r-- 1 dmdba dinstall 144384 6月 2 11:12 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_20-59-34.log
-rw-r--r-- 1 dmdba dinstall 18944 6月 2 11:12 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_21-11-52.log
-rw-r--r-- 1 dmdba dinstall 29184 6月 2 11:12 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_21-13-13.log
-rw-r--r-- 1 dmdba dinstall 805888 6月 2 11:12 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_21-15-28.log
-rw-r--r-- 1 dmdba dinstall 406016 6月 2 11:12 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_22-33-10.log
-rw-r--r-- 1 dmdba dinstall 18944 6月 2 11:12 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_23-11-21.log
[dmdba@Kylin02 ~]$
拷贝31服务器ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_23-11-21.log之后的归档日志到32服务器:
[dmdba@Kylin01 dmarch]$ scp ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_23-12-36.log dmdba@192.168.1.32:/dm/dmarch/
Authorized users only. All activities may be monitored and reported.
dmdba@192.168.1.32's password:
ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_23-12-36.log 100% 15KB 2.8MB/s 00:00
[dmdba@Kylin01 dmarch]$ scp ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_23-13-25.log dmdba@192.168.1.32:/dm/dmarch/
Authorized users only. All activities may be monitored and reported.
dmdba@192.168.1.32's password:
ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_23-13-25.log 100% 308KB 14.9MB/s 00:00
[dmdba@Kylin01 dmarch]$ scp ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-02_10-58-01.log dmdba@192.168.1.32:/dm/dmarch/
Authorized users only. All activities may be monitored and reported.
dmdba@192.168.1.32's password:
ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-02_10-58-01.log 100% 512MB 28.1MB/s 00:18
查看192.168.1.32服务器上归档日志:
[dmdba@Kylin02 ~]$ ls -rlt /dm/dmarch
总用量 538636
-rw-r--r-- 1 dmdba dinstall 339968 6月 2 11:12 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-17_11-27-25.log
-rw-r--r-- 1 dmdba dinstall 9728 6月 2 11:12 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-17_11-58-03.log
-rw-r--r-- 1 dmdba dinstall 9216 6月 2 11:12 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-17_11-58-36.log
-rw-r--r-- 1 dmdba dinstall 2431488 6月 2 11:12 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-17_11-59-06.log
-rw-r--r-- 1 dmdba dinstall 111104 6月 2 11:12 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-19_23-52-17.log
-rw-r--r-- 1 dmdba dinstall 249344 6月 2 11:12 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-20_11-45-05.log
-rw-r--r-- 1 dmdba dinstall 595456 6月 2 11:12 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-20_20-23-20.log
-rw-r--r-- 1 dmdba dinstall 1538560 6月 2 11:12 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-21_09-53-16.log
-rw-r--r-- 1 dmdba dinstall 677376 6月 2 11:12 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-26_23-30-54.log
-rw-r--r-- 1 dmdba dinstall 294400 6月 2 11:12 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-27_09-32-15.log
-rw-r--r-- 1 dmdba dinstall 1828864 6月 2 11:12 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-05-27_21-05-46.log
-rw-r--r-- 1 dmdba dinstall 445952 6月 2 11:12 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_11-50-15.log
-rw-r--r-- 1 dmdba dinstall 1511424 6月 2 11:12 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_15-25-16.log
-rw-r--r-- 1 dmdba dinstall 2856448 6月 2 11:12 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_17-33-53.log
-rw-r--r-- 1 dmdba dinstall 144384 6月 2 11:12 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_20-59-34.log
-rw-r--r-- 1 dmdba dinstall 18944 6月 2 11:12 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_21-11-52.log
-rw-r--r-- 1 dmdba dinstall 29184 6月 2 11:12 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_21-13-13.log
-rw-r--r-- 1 dmdba dinstall 805888 6月 2 11:12 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_21-15-28.log
-rw-r--r-- 1 dmdba dinstall 406016 6月 2 11:12 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_22-33-10.log
-rw-r--r-- 1 dmdba dinstall 18944 6月 2 11:12 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_23-11-21.log
-rw-r--r-- 1 dmdba dinstall 15360 6月 2 11:16 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_23-12-36.log
-rw-r--r-- 1 dmdba dinstall 314880 6月 2 11:17 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-01_23-13-25.log
-rw-r--r-- 1 dmdba dinstall 536870912 6月 2 11:17 ARCHIVE_LOCAL1_0x57D78794_EP0_2023-06-02_10-58-01.log
[dmdba@Kylin02 ~]$ dmrman
dmrman V8
#应用归档日志
RMAN> recover database '/dm/dmdata/CB/dm.ini' WITH ARCHIVEDIR '/dm/dmarch';
recover database '/dm/dmdata/CB/dm.ini' WITH ARCHIVEDIR '/dm/dmarch';
file dm.key not found, use default license!
Database mode = 2, oguid = 0
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
EP[0]'s cur_lsn[81037], file_lsn[81037]
[Percent:100.00%][Speed:963.52PKG/s][Cost:00:00:00][Remaining:00:00:00]
recover successfully!
time used: 00:00:02.283
#更新魔术
RMAN> recover database '/dm/dmdata/CB/dm.ini' update db_magic;
recover database '/dm/dmdata/CB/dm.ini' update db_magic;
Database mode = 2, oguid = 0
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
EP[0]'s cur_lsn[85161], file_lsn[85161]
recover successfully!
time used: 00:00:01.094
RMAN>
#启动数据库
[dmdba@Kylin02 ~]$ DmServiceCB start
Starting DmServiceCB: [ OK ]
验证:
[dmdba@Kylin02 ~]$ disql sysdba/dameng123
服务器[LOCALHOST:5236]:处于普通打开状态
登录使用时间 : 6.570(ms)
disql V8
SQL> select * from test3;
行号 ID NAME
---------- -- ------
1 1 test01
2 2 test02
SQL> select count(*) from test;
行号 COUNT(*)
---------- --------------------
1 2318
已用时间: 0.945(毫秒). 执行号:501.
SQL>
可以看到将31服务器(备份源)上最新的归档日志拷贝到32服务器(目标服务器)上进行恢复后,数据已经恢复到最新。