Archive

Archive for the ‘rman’ Category

How to see grid like backup report with SQL

March 14, 2012 Leave a comment

In order to see the backup status historically from database side, you may check below SQL. I used in 11.2.0.2.

SELECT b.session_key,
b.session_recid,
b.session_stamp,
b.command_id,
b.status,
b.start_time,
b.END_TIME,
b.time_taken_display,
b.input_type,
b.output_device_type,
b.input_bytes_display,
b.output_bytes_display,
b.output_bytes_per_sec_display
FROM V$RMAN_BACKUP_JOB_DETAILS b
WHERE (b.start_time > to_date(‘04.12.2011 19:00′,’dd.mm.yyyy hh24:mi’))
order by b.start_time desc;

Advertisements
Don Charisma

because anything is possible with Charisma

Carol no Mundo!

Aventuras de uma intercambista a trabalho pelo mundo!

Blog do PHP

Oracle DBA for rookies!

nimaidba

Welcome to the world of Oracle with me....

Tech

News and reviews from the world of gadgets, gear, apps and the web

WordPress.com

WordPress.com is the best place for your personal blog or business site.

Gurcan Orhan's ODI and DWH Blog

Some words about Oracle Data Integrator and Data Warehousing.