RMAN Backup

rman target / catalog rman/rman@rcat
RMAN> list backup summary;
RMAN> delete backup tag RMAN10G_LEVEL1_120908_17_30;
RMAN> delete noprompt backupset tag RMAN_LEVEL1_131108_17_10;
RMAN> crosscheck archivelog all;
RMAN> delete noprompt expired archivelog all;


backup incremental level ${LEVEL} cumulative tag ${TAG} database plus archivelog delete all input;


delete noprompt obsolete;
list backup of archivelog all;
RMAN>crosscheck backuppiece '\\192.168.1.162\BACKUP\FINPROD\DB_T619092194_S12_P1';


and


RMAN>crosscheck backuppiece '\\192.168.1.162\BACKUP\FINPROD\DB_T619093015_S13_P1';


then


RMAN>delete obsolete;




DELETE_CMD="delete noprompt backup of database completed before 'sysdate-1';"


delete noprompt backup of database completed before 'sysdate-0';


SELECT sid, spid, client_info 
     FROM v$process p, v$session s 
     WHERE p.addr = s.paddr 
     AND client_info LIKE '%id=rman%';


While the job is running, execute a script containing the following SQL statement: 


    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
     /


SELECT sid, seconds_in_wait AS sec_wait, event FROM v$session_wait
       2  WHERE wait_time = 0
       3  ORDER BY sid;


run {
          allocate channel t1 type disk;
          debug io;
          backup database;
          debug off;
         }


retrieve backup information
-----------------------------
select to_char(s.completion_time, 'Mon DD YYYY HH24:MI:SS')  BACKUP_DATE_TIME, 
        s.bs_key, 
        s.pieces, 
        s.status, 
        s.db_id, 
        p.piece#,  
        p.bp_key
 from rman.rc_backup_set s, 
      rman.rc_backup_piece p, 
      rman.rc_database_incarnation i
 where s.bs_key = p.bs_key
   and i.current_incarnation = 'YES'
   and s.completion_time = p.completion_time
   and s.db_id = p.db_id
 order by s.completion_time DESC;


RMAN> list backupset of database;


RMAN> list backupset of database completed before '22-NOV-00';


list backup summary;


--- Check RMAN backup running or not  --------


chkdbbackuprunning()
{
    sqlplus -s '/as sysdba' <
    set echo on head off
    select trim(count(1)) from
    (select status from v\$backup_async_io where status='IN PROGRESS'
    union all
    select status from v\$backup_sync_io where status='IN PROGRESS');
EOF
grep -v "^$"
}


backup validate database archivelog all;


% rman target backup_admin/backup_admin nocatalog msglog rman_full_backup_db_online_ORA920.log


RMAN> backup database plus archivelog delete input;
RMAN> delete noprompt force obsolete;
RMAN> exit;