RMAN-06900 RMAN-06901 ORA-04031

==================

--rman 备份报错

RMAN-06900: WARNING: unable to generate V$RMAN_STATUS or V$RMAN_OUTPUT row
RMAN-06901: WARNING: disabling update of the V$RMAN_STATUS and V$RMAN_OUTPUT rows
ORACLE error from target database:
ORA-04031: unable to allocate 16 bytes of shared memory ("shared pool","DATABASE","KKTIN^ae4fab53","kglhin: temp")
ORA-04031: unable to allocate 16 bytes of shared memory ("shared pool","select job, nvl2(last_date, ...","SQLP","tmp")

--连接sqlplus、db已经down

[oracle@localhost 2011_11_08]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Tue Nov 8 10:52:09 2011
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected.
SQL> SQL> SQL> SQL> SQL> SQL> select open_mode from v$database;
select open_mode from v$database
*
ERROR at line 1:
ORA-01012: not logged on
Process ID: 0
Session ID: 0 Serial number: 0

--04031都是和内存有关，重新启动实例，查看内存分配情况

SQL> startup nomount
ORACLE instance started.
Total System Global Area 523108352 bytes
Fixed Size                  1337632 bytes
Variable Size             511706848 bytes
Database Buffers            4194304 bytes
Redo Buffers                5869568 bytes

SQL> show parameter memo
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address             integer     0
memory_max_target                    big integer 500M
memory_target                        big integer 252M
shared_memory_address                integer     0

SQL> show parameter sga
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
lock_sga                             boolean     FALSE
pre_page_sga                         boolean     FALSE
sga_max_size                         big integer 500M
sga_target                           big integer 0

SQL> show parameter shared
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address             integer     0
max_shared_servers                   integer
shared_memory_address                integer     0
shared_pool_reserved_size            big integer 8178892
shared_pool_size                     big integer 0
shared_server_sessions               integer
shared_servers                       integer     1

--这个11g的库使用了11g内存自动管理，一共最多用内存500m
--出现问题是因为share_pool过小
--自动管理时可以给定shared_pool_size参数来限定内存分配时共享池的最小值

SQL> alter system set memory_max_target=500m scope=spfile;
System altered.

SQL> alter system set memory_target=500m scope=spfile;
System altered.

SQL> alter system set sga_max_size=300m scope=spfile;
System altered.

SQL> alter system set shared_pool_size=50m scope=spfile;
System altered.

--重新启动instance，内存重新分配
SQL> shutdown immediate
ORA-01507: database not mounted
ORACLE instance shut down.

SQL> startup
ORACLE instance started.
Total System Global Area 313860096 bytes
Fixed Size                  1336232 bytes
Variable Size             176163928 bytes
Database Buffers          130023424 bytes
Redo Buffers                6336512 bytes
Database mounted.
Database opened.

--备份数据库，因为共享池有足够大小，不在报错

ITPub博客

RMAN-06900 RMAN-06901 ORA-04031

最新文章