Hoy vamos a ver una entrada especial para dummies.
\nVamos a utilizar esta entrada para ir recopliando algunas de las consultas utiles que podemos necesitar relaccionadas con rman .
\nMe gustaria decir que estas consultas son mias, pero varias de ellas han sido recopiladas a lo largo del tiempo , bien ca trabajo propio, como de casos con Oracle como de algunas webs que me han ayudado, con lo que, si alguien encuentra alguna y recooce a su propietario,e stare encantado de enlazarlo en caso que lo requiera <\/p>\n
\r\nset pagesize 200\r\nset linesize 200\r\ncol COMMAND_ID format a20;\r\ncol status format a20;\r\ncol Gb format 99999999;\r\n col OBJECT_TYPE format a20;\r\n\r\nSelect COMMAND_ID,\r\nstatus,\r\nround(output_bytes \/1024\/1024,2)Gb ,\r\nstart_time,end_time ,\r\nOBJECT_TYPE,round((end_time-start_time )*24,1) Duracion\r\n from v$rman_status \r\nwhere \r\nOBJECT_TYPE in ('DB FULL','DB INCR') \r\nand output_bytes > 0 \r\norder by start_time desc ;\r\n<\/pre>\n Ver los jobs de RMAN que ha habido <\/h1>\n\r\nset lines 220\r\nset pages 1000\r\ncol cf for 9,999\r\ncol df for 9,999\r\ncol elapsed_seconds heading \"ELAPSED|SECONDS\"\r\ncol i0 for 9,999\r\ncol i1 for 9,999\r\ncol l for 9,999\r\ncol output_mbytes for 9,999,999 heading \"OUTPUT|MBYTES\"\r\ncol session_recid for 999999 heading \"SESSION|RECID\"\r\ncol session_stamp for 99999999999 heading \"SESSION|STAMP\"\r\ncol status for a10 trunc\r\ncol time_taken_display for a10 heading \"TIME|TAKEN\"\r\ncol output_instance for 9999 heading \"OUT|INST\"\r\nselect\r\n j.session_recid, j.session_stamp,\r\n to_char(j.start_time, 'yyyy-mm-dd hh24:mi:ss') start_time,\r\n to_char(j.end_time, 'yyyy-mm-dd hh24:mi:ss') end_time,\r\n (j.output_bytes\/1024\/1024) output_mbytes, j.status, j.input_type,\r\n decode(to_char(j.start_time, 'd'), 1, 'Sunday', 2, 'Monday',\r\n 3, 'Tuesday', 4, 'Wednesday',\r\n 5, 'Thursday', 6, 'Friday',\r\n 7, 'Saturday') dow,\r\n j.elapsed_seconds, j.time_taken_display,\r\n x.cf, x.df, x.i0, x.i1, x.l,\r\n ro.inst_id output_instance\r\nfrom V$RMAN_BACKUP_JOB_DETAILS j\r\n left outer join (select\r\n d.session_recid, d.session_stamp,\r\n sum(case when d.controlfile_included = 'YES' then d.pieces else 0 end) CF,\r\n sum(case when d.controlfile_included = 'NO'\r\n and d.backup_type||d.incremental_level = 'D' then d.pieces else 0 end) DF,\r\n sum(case when d.backup_type||d.incremental_level = 'D0' then d.pieces else 0 end) I0,\r\n sum(case when d.backup_type||d.incremental_level = 'I1' then d.pieces else 0 end) I1,\r\n sum(case when d.backup_type = 'L' then d.pieces else 0 end) L\r\n from\r\n V$BACKUP_SET_DETAILS d\r\n join V$BACKUP_SET s on s.set_stamp = d.set_stamp and s.set_count = d.set_count\r\n where s.input_file_scan_only = 'NO'\r\n group by d.session_recid, d.session_stamp) x\r\n on x.session_recid = j.session_recid and x.session_stamp = j.session_stamp\r\n left outer join (select o.session_recid, o.session_stamp, min(inst_id) inst_id\r\n from GV$RMAN_OUTPUT o\r\n group by o.session_recid, o.session_stamp)\r\n ro on ro.session_recid = j.session_recid and ro.session_stamp = j.session_stamp\r\nwhere j.start_time > trunc(sysdate)-&NUMBER_OF_DAYS\r\norder by j.start_time;\r\n<\/pre>\n Operaciones acrivas de Rman <\/h1>\n\r\nset linesize 200;\r\nset pagesize 9000;\r\n column STATUS FORMAT A15;\r\n column APPLIED FORMAT A4;\r\nCOLUMN NAME format a20;\r\ncolumn DB_UNIQUE_NAME format a20;\r\nCOLUMN sequence# CLEAR;\r\ncolumn OPEN_MODE format a10;\r\ncolumn name format a100;\r\ncol OPNAME for a40;\r\nset linesize 220 pagesize 10000\r\ncol OPNAME for a40\r\nselect OPNAME,SOFAR\/TOTALWORK*100 PCT, trunc(TIME_REMAINING\/60) MIN_RESTANTES,\r\ntrunc(ELAPSED_SECONDS\/60) MIN_ATEAGORA\r\nfrom v$session_longops where TOTALWORK>0 and OPNAME like '%RMAN%';\r\n\r\n\r\n select OPNAME,SOFAR\/TOTALWORK*100 PCT, trunc(TIME_REMAINING\/60) MIN_RESTANTES,\r\n trunc(ELAPSED_SECONDS\/60) MIN_ATEAGORA\r\n from v$session_longops where TOTALWORK>0 and OPNAME like '%RMAN: incremental datafile%';\r\n<\/pre>\nEn fin, como dije en un principio, simplemente una recopilacion de consultas utiles <\/p>\n","protected":false},"excerpt":{"rendered":"
Hoy vamos a ver una entrada especial para dummies. Vamos a utilizar esta entrada para ir recopliando algunas de las consultas utiles que podemos necesitar relaccionadas con rman . Me gustaria decir que estas consultas son mias, pero varias de … Sigue leyendo