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.
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:
Post a Comment