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")
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
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
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
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.
System altered.
SQL> alter system set memory_target=500m scope=spfile;
System altered.
System altered.
SQL> alter system set sga_max_size=300m scope=spfile;
System altered.
System altered.
SQL> alter system set shared_pool_size=50m scope=spfile;
System altered.
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博客 ” ,链接:http://blog.itpub.net/13177610/viewspace-710414/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/13177610/viewspace-710414/