Afin de v\u00e9rifier l’\u00e9tat des enregistrements des archivelog en base, voici une petite requ\u00eate bien pratique :
\n
\n1 – Lancer l’utilitaire TOAD ou celui de votre choix
\n2 – Connectez-vous \u00e0 votre base de donn\u00e9es puis lancer un \u00e9diteur de script
\n3 – Voici les lignes \u00e0 taper :<\/p>\n
select SESSION_KEY, INPUT_TYPE, STATUS,
\nto_char(START_TIME,’dd-mm-yyyy hh24:mi:ss’) as RMAN_Bkup_start_time,
\nto_char(END_TIME,’dd-mm-yyyy hh24:mi:ss’) as RMAN_Bkup_end_time,
\nelapsed_seconds\/3600 Hours from V$RMAN_BACKUP_JOB_DETAILS
\norder by session_key;<\/p>\n
ou<\/p>\n
select SESSION_KEY, INPUT_TYPE, STATUS,
\nto_char(START_TIME,’mm\/dd\/yy hh24:mi’) start_time,
\nto_char(END_TIME,’mm\/dd\/yy hh24:mi’) end_time,
\nelapsed_seconds\/3600 hrs from V$RMAN_BACKUP_JOB_DETAILS
\norder by session_key;<\/p>\n
ou<\/p>\n
SELECT SID, SERIAL#, CONTEXT, SOFAR, TOTALWORK,
\nROUND (SOFAR\/TOTALWORK*100, 2) \u00ab\u00a0% COMPLETE\u00a0\u00bb
\nFROM V$SESSION_LONGOPS
\nWHERE OPNAME LIKE ‘RMAN%’ AND OPNAME NOT LIKE ‘%aggregate%’
\nAND TOTALWORK! = 0 AND SOFAR <> TOTALWORK;<\/p>\n