News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

RMAN recovery from loss of all online redo log files

  • Posted by Gavin Soorma
  • On July 3, 2009
  • 1 Comments
MAA best practices dictates that to avoid such scenarios, we should be multiplexing the online redo log files. Each group should have at least 2 members and each member should be located on a different physical disk. Loss of a single current online redo log file will require us to restore the entire database and […]
Read More
 

Script- Track redo generation by day

  • Posted by Gavin Soorma
  • On June 20, 2009
  • 2 Comments
select trunc(completion_time) rundate ,count(*) logswitch ,round((sum(blocks*block_size)/1024/1024)) "REDO PER DAY (MB)" from v$archived_log group by trunc(completion_time) order by 1;
Read More
 

Redo Log File Switches – By hour of the day

  • Posted by Gavin Soorma
  • On June 18, 2009
  • 0 Comments
prompt prompt "Morning .........." select to_char(first_time,'DD/MON') day, to_char(sum(decode(to_char(first_time,'HH24'),'07',1,0)),'000')"07", to_char(sum(decode(to_char(first_time,'HH24'),'08',1,0)),'000')"08", to_char(sum(decode(to_char(first_time,'HH24'),'09',1,0)),'000')"09", to_char(sum(decode(to_char(first_time,'HH24'),'10',1,0)),'000')"10", to_char(sum(decode(to_char(first_time,'HH24'),'11',1,0)),'000')"11", to_char(sum(decode(to_char(first_time,'HH24'),'12',1,0)),'000')"12", to_char(sum(decode(to_char(first_time,'HH24'),'13',1,0)),'000')"13", to_char(sum(decode(to_char(first_time,'HH24'),'14',1,0)),'000')"14", to_char(sum(decode(to_char(first_time,'HH24'),'15',1,0)),'000')"15", to_char(sum(decode(to_char(first_time,'HH24'),'16',1,0)),'000')"16", to_char(sum(decode(to_char(first_time,'HH24'),'17',1,0)),'000')"17", to_char(sum(decode(to_char(first_time,'HH24'),'18',1,0)),'000')"18" from v$log_history WHERE TRUNC(FIRST_TIME) > TRUNC(SYSDATE) - 7 group by to_char(first_time,'DD/MON'); prompt prompt Prompt "Evening ........" prompt select to_char(first_time,'DD/MON') day, to_char(sum(decode(to_char(first_time,'HH24'),'19',1,0)),'000')"19", to_char(sum(decode(to_char(first_time,'HH24'),'20',1,0)),'000')"20", to_char(sum(decode(to_char(first_time,'HH24'),'21',1,0)),'000')"21", to_char(sum(decode(to_char(first_time,'HH24'),'22',1,0)),'000')"22", to_char(sum(decode(to_char(first_time,'HH24'),'23',1,0)),'000')"23", to_char(sum(decode(to_char(first_time,'HH24'),'00',1,0)),'000') "00", to_char(sum(decode(to_char(first_time,'HH24'),'01',1,0)),'000')"01", to_char(sum(decode(to_char(first_time,'HH24'),'02',1,0)),'000')"02", to_char(sum(decode(to_char(first_time,'HH24'),'03',1,0)),'000')"03", to_char(sum(decode(to_char(first_time,'HH24'),'04',1,0)),'000')"04", to_char(sum(decode(to_char(first_time,'HH24'),'05',1,0)),'000')"05", to_char(sum(decode(to_char(first_time,'HH24'),'06',1,0)),'000')"06" from v$log_history WHERE […]
Read More
 1