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