这样做，RMAN备份速度可提高6倍！

最新推荐文章于 2021-04-05 06:07:18 发布

数据和云

最新推荐文章于 2021-04-05 06:07:18 发布

阅读量1.2k

点赞数

本文链接：https://blog.csdn.net/enmotech/article/details/106345579

版权

墨墨导读：本文来自读者投稿，详述一则给客户备份优化的实际案例，通过这次优化，数据库性能提高了6倍。数据库现状SQL> select * from v$version;BANN...

摘要由CSDN通过智能技术生成

墨墨导读：本文来自读者投稿，详述一则给客户备份优化的实际案例，通过这次优化，数据库性能提高了6倍。

数据库现状

SQL> select * from v$version;


BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE  11.2.0.4.0  Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production
SQL> set pagesize 0;
select tablespace_name ,sum(bytes)/1024/1024/1024 as GB from dba_data_files group by tablespace_name;
SQL> CMCC10             66.7578125
SYSAUX         .6640625
UNDOTBS1           4.83886719
CMCC3             165.399414
CMCC8             66.7578125
CMCC1             165.399414
CMCC7             66.7578125
USERS             .004882813
CMCC6             165.399414
SYSTEM         .7421875
CMCC2             165.399414
CMCC4             165.399414
CMCC5             165.399414
CMCC9             66.7578125
CMCC11             66.7578125
SQL> alter session set nls_date_format = 'yyyy-mm-dd hh24:mi:ss';
Session altered.
SQL> select max(LAST_ANALYZED) from dba_tables;
2020-02-25 22:20:26

数据文件大小

 du -sh  /test-nvme/oradata/orcl
1.4T  /test-nvme/oradata/orcl

修改linux内核参数shmmax和shmall

修改之前共享内存

[oracle@base-test-01 ~]$ ipcs -m


------ Shared Memory Segments --------
key        shmid      owner      perms      bytes      nattch     status
0x00000000 114458624  oracle     640        4096       0
0x00000000 114491393  oracle     640        4096       0
0x00000000 114524163  oracle     640        4096       0
0x00000000 1212420    root       644        80         2
0x00000000 1245189    root       644        16384      2
0x00000000 1277958    root       644        280        2
0x00000000 297435143  root       600        524288     2          dest
0x00000000 114556936  oracle     640        4096       0
0x00000000 114589705  oracle     640        4096       0
0x00000000 114622474  oracle     640        4096       0
0x00000000 114655243  oracle     640        4096       0
0x00000000 114688012  oracle     640        4096       0
0x00000000 114720781  oracle     640        4096       0
0x00000000 114753550  oracle     640        4096       0
0x00000000 114786319  oracle     640        4096       0
0x00000000 114819088  oracle     640        4096       0
0x00000000 114851857  oracle     640        4096       0
0x00000000 114884626  oracle     640        4096       0
0x00000000 114917395  oracle     640        4096       0
0x00000000 114950164  oracle     640        4096       0
0x00000000 114982933  oracle     640        4096       0
0x00000000 115015702  oracle     640        4096       0
0x00000000 115048471  oracle     640        4096       0
0x00000000 115081240  oracle     640        4096       0
0x00000000 115114009  oracle     640        4096       0
0x00000000 115146778  oracle     640        4096       0
0x00000000 115179547  oracle     640        4096       0
0x00000000 115212316  oracle     640        4096       0
0x00000000 115245085  oracle     640        4096       0
0x00000000 115277854  oracle     640        4096       0
0x00000000 115310623  oracle     640        4096       0
0x00000000 115343392  oracle     640        4096       0
0x00000000 115376161  oracle     640        4096       0
0x00000000 115408930  oracle     640        4096       0
0x00000000 297762851  root       600        4194304    2          dest
0x00000000 297861156  root       600        524288     2          dest
0x00000000 115441701  oracle     640        4096       0
0x00000000 115474470  oracle     640        4096       0
0x00000000 115507239  oracle     640        4096       0
0x00000000 115540008  oracle     640