Backup Monitoring, Index Monitoring

Contents:- Backup Monitoring, Index Monitoring

Backup Monitoring

$> rman target /

Rman>run

{

Allocate channel c1 type disk;

Set command id to ‘mitesh’;

Backup datafile 6;

Release channel c1;

}

Toad>

select sid,spid,client_info from v$process p, V$session s where p.addr=s.paddr and client_info like '%id=mitesh%';

Query the V$session_longops view to get the status of the copy..

select sid,serial#,context,sofar,totalwork,round(sofar/totalwork*100,2) "%complete" fromV$session_longops where opname like 'RMAN:%' and opname not like 'RMAN:aggregate%' and totalwork!=0;

Index Monitoring

There is one primary key index on id column of the item table.

SQL> alter index item_id_pk monitoring usage;

SQL> select * from item where id=101;

SQL> select * from V$object_usage;