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;
Subscribe to:
Post Comments (Atom)
Windows (powershell) counterparts of Linux commands
You may find Windows mostly powershell equivalent of frequently used Linux commands here. I will update this post, with newer ones by the ti...
-
Simple but very handy way of taking exports without knowing database password. expdp \'/ as sysdba\' DIRECTORY=DATA_PUMP_DIR DUMPFIL...
-
It seems an easy topic, I prefer being careful with the easy ones... so it is handy to have all you need, in one place and which will lead i...
-
This directory is created in the home directory of the oracle user, after making a local connection. I had tested it as follows: [oracle@geo...
No comments:
Post a Comment