Database Backup and Recovery (MOSC)

MOSC Banner

RMAN report commands failing.

edited Feb 1, 2013 2:53AM in Database Backup and Recovery (MOSC) 2 commentsAnswered ✓
I am using RMAN 11.2.0.3 and databases are 11.2.0.3 as well.

rman > connect  catalog user/pwd@catalogdb
> connect target user/pwd@targetdb
 
RMAN> report need backup days 2;

Report of files whose recovery needs more than 2 days of archived logs
File Days  Name
---- ----- -----------------------------------------------------
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of report command at 01/23/2013 14:11:00
ORA-01455: converting column overflows integer datatype

I saw two similar bugs but I don't think I have hit them.

select db_id , piece#, bp_key, start_time, completion_time 
from rman.RC_BACKUP_PIECE 
where db_id=<DBID of database> mydbid and
start_time >  completion_time ---- returns Zero rows.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center