Wednesday, 16 July 2014

RMAN Backup fails with DBGSQL: TARGET - RMAN-03014 ORA-01008 sqlcode = 1008

Rman backup script fails with

Error:
DBGSQL:     TARGET> select  nvl(max(al.recid), '0'),nvl(max(al.recid), 0)   into  :txtparmvalue, :parmvalue   from  v$archived_log al  where  al.status in
 ('X', 'A')    and  al.is_recovery_dest_file = 'YES'    and  al.creator = 'RMAN'
DBGSQL:        sqlcode = 1008

......
RMAN-03014: implicit resync of recovery catalog failed
ORA-01008: not all variables bound


Work around:

SQL> alter system flush shared_pool;

After flushing shared pool rerun the backup script.

No comments: