Ao tentar utilizar o RMAN para realizar backups online, backup archive, etc. Se a Shared Pool estiver fragmentada ou simplesmente cheia, o RMAN apresentará o seguinte erro:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 08/07/2013 02:08:35
RMAN-03014: implicit resync of recovery catalog failed
ORA-01008: not all variables bound
Para solucionar o problema, basta conectar via SQL*Plus na instância e efetuar um flush na Shared Pool da seguinte forma:
/> sqlplus "/ as sysdba"
SQL*Plus: Release 11.2.0.2.0 Production on Wed Aug 7 02:16:45 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> alter system flush shared_pool;
System altered.
É isso.
Até o próximo artigo.
