How to monitor RMAN job

This script is reporting all backups - full, incremental and archivelog.
connect to sqlplus as sysdba and execute:

col STATUS format a9
col hrs format 999.99
select
SESSION_KEY, INPUT_TYPE, STATUS,
to_char(START_TIME,'mm/dd/yy hh24:mi') start_time,
to_char(END_TIME,'mm/dd/yy hh24:mi')   end_time,
elapsed_seconds/3600                   hrs
from V$RMAN_BACKUP_JOB_DETAILS
order by session_key;

Output will be something like this

SESSION_KEY INPUT_TYPE    STATUS    START_TIME     END_TIME           HRS
----------- ------------- --------- -------------- -------------- -------
         39 DB INCR       FAILED    05/25/12 04:32
         42 ARCHIVELOG    FAILED    05/25/12 11:43
         44 ARCHIVELOG    FAILED    05/25/12 15:47
         48 ARCHIVELOG    FAILED    05/25/12 16:50
         50 ARCHIVELOG    FAILED    05/25/12 16:53
         52 ARCHIVELOG    FAILED    05/25/12 17:00
         54 DB INCR       RUNNING   05/25/12 17:06 05/26/12 03:00    9.91

Another usuful script to monitor the bakcup work is:

SELECT
SID, SERIAL#, CONTEXT, SOFAR, TOTALWORK,
       ROUND(SOFAR/TOTALWORK*100,2)
"%_COMPLETE"
FROM V$SESSION_LONGOPS
WHERE OPNAME LIKE 'RMAN%'
  AND OPNAME NOT LIKE
'%aggregate%'
  AND TOTALWORK != 0
  AND SOFAR <>
TOTALWORK

;


The output will be something like this:

       SID    SERIAL#    CONTEXT      SOFAR  TOTALWORK %_COMPLETE
---------- ---------- ---------- ---------- ---------- ----------
       769      39801          1   32408560   61279360      52.89

How to mirror redo log files

Let say we have 3 groups with 1 member each and we want to multiplex them to 3 groups with 3 members each.


sys@MIKI> select member from v$logfile where group#='1';

MEMBER
-----------------------------------------------------------------
C:\APP\MRUHTEL\ORADATA\MIKI\REDO01.LOG

sys@MIKI> select member from v$logfile where group#='2';

MEMBER
-----------------------------------------------------------------
C:\APP\MRUHTEL\ORADATA\MIKI\REDO02.LOG

sys@MIKI> select member from v$logfile where group#='3';

MEMBER
-----------------------------------------------------------------
C:\APP\MRUHTEL\ORADATA\MIKI\REDO03.LOG

Now all we need to do is add members (it is online operation) to each group:

Here I am adding member B to each group:



ys@MIKI> alter database add logfile member 'c:\app\mruhtel\oradata\miki\redo01b.log' to group 1;

atabase altered.

ys@MIKI> alter database add logfile member 'c:\app\mruhtel\oradata\miki\redo02b.log' to group 2;

atabase altered.

ys@MIKI> alter database add logfile member 'c:\app\mruhtel\oradata\miki\redo03b.log' to group 3;

atabase altered.


Here I am adding member C to each group:


sys@MIKI> alter database add logfile member 'c:\app\mruhtel\oradata\miki\redo01c.log' to group 1;

Database altered.

sys@MIKI> alter database add logfile member 'c:\appmruhtel\oradata\miki\redo02c.log' to group 2;

Database altered.

sys@MIKI> alter database add logfile member 'c:\app\mruhtel\oradata\miki\redo03c.log' to group 3;

Database altered.

And voilà


sys@MIKI> select member from v$logfile where group#='1';

MEMBER
--------------------------------------------------------
C:\APP\MRUHTEL\ORADATA\MIKI\REDO01.LOG
C:\APP\MRUHTEL\ORADATA\MIKI\REDO01B.LOG
C:\APP\MRUHTEL\ORADATA\MIKI\REDO01C.LOG



sys@MIKI> select member from v$logfile where group#='2';

MEMBER
-----------------------------------------------------------
C:\APP\MRUHTEL\ORADATA\MIKI\REDO02.LOG
C:\APP\MRUHTEL\ORADATA\MIKI\REDO02B.LOG
C:\APP\MRUHTEL\ORADATA\MIKI\REDO02C.LOG


sys@MIKI> select member from v$logfile where group#='3';

MEMBER
--------------------------------------------------------
C:\APP\MRUHTEL\ORADATA\MIKI\REDO03.LOG
C:\APP\MRUHTEL\ORADATA\MIKI\REDO03B.LOG
C:\APP\MRUHTEL\ORADATA\MIKI\REDO03C.LOG