Wednesday, April 23, 2014

RMAN BACKUPS RUNNING with WARNINGS

 CHECK ERROR FOR BACKUPS RUNNING WITH WARNINGS 

1.RUN the below query

select session_key,input_type,status,SESSION_STAMP,to_char(start_time,'yyyy-mm-dd hh24:mi') start_time,to_char(end_time,'yyyy-mm-dd hh24:mi') 

end_time,output_bytes_display,time_taken_display from v$rman_backup_job_details order by session_key desc;


2.Note the TIMESTAMP number

3.RUN the below query for output

select output from v$rman_output where session_stamp=734738844;









No comments:

Post a Comment