Tuesday, April 22, 2014

Oracle 11g (11.2.0.2) Rman Backups failed with DBGSQL

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
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
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

Got above errors for RMAN backup and investigated for any change in scripts.
even RMAN> SHOW ALL;
Failed with above info.

Even both RMAN Client and servers versions are of same versions and target database is not upgraded recently.

A little bit of google fixed with below command


SQL> ALTER SYSTEM FLUSH SHARED_POOL;

No comments:

Post a Comment