oracle max pool size=512,【学习笔记】Oracle数据库rman备份与large_pool_size的关系详解...

【学习笔记】Oracle数据库rman备份与large_pool_size的关系详解

时间:2016-11-28 21:56   来源:Oracle研究中心   作者:网络   点击:

次

天萃荷净

Oracle研究中心学习笔记：关于使用rman进行备份时，是否使用large pool，存在一个误区，很多人认为使用rman进行备份时，一定用的是large pool，包括我的同事也这样认为，其实不然。

SQL> archive log list;

DATABASE log mode              Archive Mode

Automatic archival             Enabled

Archive destination            /home/ora10g/archivelog

Oldest online log SEQUENCE     216

NEXT log SEQUENCE TO archive   218

CURRENT log SEQUENCE           218

SQL> SHOW parameter disk

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

asm_diskgroups                       string

asm_diskstring                       string

disk_asynch_io                       BOOLEAN     TRUE

SQL> SHOW parameter dbwr_io_slaves

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

dbwr_io_slaves                       INTEGER     0

[ora10g@killdb bdump]$ rman target /

Recovery Manager: Release 10.2.0.5.0 - Production on Tue Jan 3 05:31:43 2012

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: ROGER (DBID=2466925865)

RMAN> allocate channel for maintenance type disk;

using target database control file instead of recovery catalog

allocated channel: ORA_MAINT_DISK_1

channel ORA_MAINT_DISK_1: sid=138 devtype=DISK

SQL> SELECT * FROM v$sgastat WHERE pool='large pool';

POOL         NAME                            BYTES

------------ -------------------------- ----------

LARGE pool   PX msg pool                    262144

LARGE pool   free memory                   3932160

SQL> SELECT * FROM v$sgastat WHERE name LIKE '%KSFQ%';

POOL         NAME                            BYTES

------------ -------------------------- ----------

shared pool  X$KSFQP ANCHOR                     52

shared pool  KSFQ buffer pool                 2376

SQL> ALTER system SET disk_asynch_io=FALSE scope=spfile;

System altered.

SQL> shOracleоutdown immediate;

DATABASE closed.

DATABASE dismounted.

ORACLE instance shut down.

SQL> startup

ORA-00000: normal, successful completion

SQL> conn /AS sysdba

Connected TO an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area  167772160 bytes

Fixed SIZE                  1272600 bytes

Variable SIZE             104858856 bytes

DATABASE Buffers           58720256 bytes

Redo Buffers                2920448 bytes

DATABASE mounted.

DATABASE opened.

SQL> SHOW parameter dbwr_io_slaves

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

dbwr_io_slaves                       INTEGER     2

SQL> SHOW parameter disk

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

asm_diskgroups                       string

asm_diskstring                       string

disk_asynch_io                       BOOLEAN     FALSE

SQL> SELECT * FROM v$sgastat WHERE name LIKE '%KSFQ%';

POOL         NAME                            BYTES

------------ -------------------------- ----------

shared pool  X$KSFQP ANCHOR                     52

shared pool  KSFQ buffer pool                 2376

[ora10g@killdb bdump]$ rman target /

Recovery Manager: Release 10.2.0.5.0 - Production on Tue Jan 3 05:34:47 2012

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: ROGER (DBID=2466925865)

RMAN> allocate channel for maintenance type disk;

using target database control file instead of recovery catalog

allocated channel: ORA_MAINT_DISK_1

channel ORA_MAINT_DISK_1: sid=143 devtype=DISK

SQL> SELECT * FROM v$sgastat WHERE name LIKE '%KSFQ%';

POOL