meta données pour cette page
  •  

Différences

Ci-dessous, les différences entre deux révisions de la page.

Lien vers cette vue comparative

Les deux révisions précédentesRévision précédente
Prochaine révision		Révision précédente
oracle:database:rman [04/12/2024 09:43] – mdloracle:database:rman [04/12/2024 10:10] (Version actuelle) – mdl
Ligne 4: Ligne 4:
 <code PLSQL> <code PLSQL>
 set lines 200 pages 2000 set lines 200 pages 2000
-col STATUS format a25+col STATUS format a20
 col dev format a10 col dev format a10
 col START_TIME format a16 col START_TIME format a16
Ligne 11: Ligne 11:
 col INBYTES format a10 col INBYTES format a10
 col OUTBYTES format a10 col OUTBYTES format a10
-select SESSION_KEY, INPUT_TYPE, STATUS, output_device_type DEV, +select SESSION_KEY,SESSION_RECID, SESSION_STAMP,INPUT_TYPE, STATUS, output_device_type DEV, 
-to_char(START_TIME,'mm/dd/yy hh24:mi') start_time, +to_char(START_TIME,'dd/mm/yyyy hh24:mi') start_time, 
-to_char(END_TIME,'mm/dd/yy hh24:mi') end_time,+to_char(END_TIME,'dd/mm/yyyy hh24:mi') end_time,
 elapsed_seconds/3600 hrs, elapsed_seconds/3600 hrs,
 input_bytes_display inbytes, output_bytes_display outbytes input_bytes_display inbytes, output_bytes_display outbytes
Ligne 19: Ligne 19:
 where status='RUNNING' where status='RUNNING'
 order by session_key; order by session_key;
 +
 +SESSION_KEY SESSION_RECID SESSION_STAMP INPUT_TYPE    STATUS               DEV        START_TIME       END_TIME            HRS INBYTES    OUTBYTES
 +----------- ------------- ------------- ------------- -------------------- ---------- ---------------- ---------------- ------ ---------- ----------
 +       6060          6060    1186690460 ARCHIVELOG    RUNNING              SBT_TAPE   02/12/2024 20:14 04/12/2024 10:49  38.58   525.00K    512.00K
 +       6187          6187    1186732699 ARCHIVELOG    RUNNING                         03/12/2024 07:58 04/12/2024 10:49  26.84     0.00K      0.00K
 +       6193          6193    1186776020 ARCHIVELOG    RUNNING                         03/12/2024 20:00 04/12/2024 10:49  14.81     0.00K      0.00K
 +       6196          6196    1186776141 ARCHIVELOG    RUNNING                         03/12/2024 20:02 04/12/2024 10:49  14.78     0.00K      0.00K
 +       6199          6199    1186776200 ARCHIVELOG    RUNNING                         03/12/2024 20:03 04/12/2024 10:49  14.76     0.00K      0.00K
 +       6202          6202    1186776260 ARCHIVELOG    RUNNING                         03/12/2024 20:04 04/12/2024 10:49  14.74     0.00K      0.00K
 +       6205          6205    1186776321 ARCHIVELOG    RUNNING                         03/12/2024 20:05 04/12/2024 10:49  14.72     0.00K      0.00K
 +       6208          6208    1186776380 ARCHIVELOG    RUNNING                         03/12/2024 20:06 04/12/2024 10:49  14.71     0.00K      0.00K
 +       6211          6211    1186776441 ARCHIVELOG    RUNNING                         03/12/2024 20:07 04/12/2024 10:49  14.69     0.00K      0.00K
 +       6214          6214    1186776498 ARCHIVELOG    RUNNING                         03/12/2024 20:08 04/12/2024 10:49  14.68     0.00K      0.00K
 +       6217          6217    1186776560 ARCHIVELOG    RUNNING                         03/12/2024 20:09 04/12/2024 10:49  14.66     0.00K      0.00K
 +       6220          6220    1186776618 ARCHIVELOG    RUNNING                         03/12/2024 20:10 04/12/2024 10:49  14.64     0.00K      0.00K
 +       6223          6223    1186776680 ARCHIVELOG    RUNNING                         03/12/2024 20:11 04/12/2024 10:49  14.63     0.00K      0.00K
 +       6226          6226    1186776740 ARCHIVELOG    RUNNING                         03/12/2024 20:12 04/12/2024 10:49  14.61     0.00K      0.00K
 +       6229          6229    1186776801 ARCHIVELOG    RUNNING                         03/12/2024 20:13 04/12/2024 10:49  14.59     0.00K      0.00K
 +       6232          6232    1186776858 ARCHIVELOG    RUNNING                         03/12/2024 20:14 04/12/2024 10:49  14.58     0.00K      0.00K
 +       6235          6235    1186776923 ARCHIVELOG    RUNNING                         03/12/2024 20:15 04/12/2024 10:49  14.56     0.00K      0.00K
 +       6238          6238    1186776978 ARCHIVELOG    RUNNING                         03/12/2024 20:16 04/12/2024 10:49  14.54     0.00K      0.00K
 +       6241          6241    1186777043 ARCHIVELOG    RUNNING                         03/12/2024 20:17 04/12/2024 10:49  14.52     0.00K      0.00K
 +
 </code> </code>
 + \\
  
 +== Kill runing jobs ==
 +<code PLSQL>
 +### Check what Session will be killed
 +select s.sid, s.serial#, s.username,
 +       to_char(s.logon_time,'DD-MON HH24:MI:SS') logon_time,
 +       p.pid oraclepid, p.spid "ServerPID", s.process "ClientPID",
 +       s.program clientprogram, s.module, s.machine, s.osuser,
 +       s.status, s.last_call_et
 +from  v$session s, v$process p
 +where s.paddr=p.addr
 +and s.program like 'rman%'
 +order by s.sid
 +
 +### Generate simple command
 +select '! kill -9 '||p.spid  kill_rman_process
 +from  v$session s, v$process p
 +where s.paddr=p.addr
 +and s.program like 'rman%'
 +order by s.sid
 +
 +
 +KILL_RMAN_PROCESS
 +----------------------------------
 +! kill -9 2516
 +! kill -9 2517
 +! kill -9 2497
 +</code>
 + \\
 +== Job Summary with SESSION_RECID and SESSION_STAMP==
 +<code PLSQL>
 +set lines 220
 +set pages 1000
 +col backup_type for a4 heading "TYPE"
 +col controlfile_included heading "CF?"
 +col incremental_level heading "INCR LVL"
 +col pieces for 999 heading "PCS"
 +col elapsed_seconds heading "ELAPSED|SECONDS"
 +col device_type for a10 trunc heading "DEVICE|TYPE"
 +col compressed for a4 heading "ZIP?"
 +col output_mbytes for 9,999,999 heading "OUTPUT|MBYTES"
 +col input_file_scan_only for a4 heading "SCAN|ONLY"
 +select
 +d.bs_key, d.backup_type, d.controlfile_included, d.incremental_level, d.pieces,
 +to_char(d.start_time, 'yyyy-mm-dd hh24:mi:ss') start_time,
 +to_char(d.completion_time, 'yyyy-mm-dd hh24:mi:ss') completion_time,
 +d.elapsed_seconds, d.device_type, d.compressed, (d.output_bytes/1024/1024) output_mbytes, s.input_file_scan_only
 +from V$BACKUP_SET_DETAILS d
 +join V$BACKUP_SET s on s.set_stamp = d.set_stamp and s.set_count = d.set_count
 +where session_recid = &SESSION_RECID
 +and session_stamp = &SESSION_STAMP
 +order by d.start_time;
 +
 +                                                                            ELAPSED DEVICE              OUTPUT SCAN
 +    BS_KEY TYPE CF?   INCR LVL  PCS START_TIME       COMPLETION_TIME        SECONDS TYPE       ZIP?     MBYTES ONLY
 +---------- ---- --- ---------- ---- ---------------- ------------------- ---------- ---------- ---- ---------- ----
 +      3336 L    NO                1 2024-12-02 20:14 2024-12-02 20:15:25         41 SBT_TAPE   YES           1 NO
 +
 +</code>
 + \\
 +
 +== Job Detail with SESSION_RECID and SESSION_STAMP ==
 +<code PLSQL>
 +set lines 200
 +set pages 1000
 +select output
 +from GV$RMAN_OUTPUT
 +where session_recid = &SESSION_RECID
 +and session_stamp = &SESSION_STAMP
 +order by recid;
 +
 +OUTPUT
 +----------------------------------------------------------------------------------------------------------------------------------
 +connected to target database: C1DIGDEV (DBID=1272122079)
 +connected to recovery catalog database
 +PL/SQL package RMAN_C1DIGDEV.DBMS_RCVCAT version 19.21.00.00. in RCVCAT database is not current
 +PL/SQL package RMAN_C1DIGDEV.DBMS_RCVMAN version 19.21.00.00 in RCVCAT database is not current
 +
 +
 +resync only records later than timestamp 1186107934
 +RMAN configuration parameters for database with db_unique_name C1DIGDEV are:
 +CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
 +CONFIGURE BACKUP OPTIMIZATION ON;
 +CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
 +CONFIGURE CONTROLFILE AUTOBACKUP ON;
 +CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO '%F';
 +CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
 +CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 4 BACKUP TYPE TO COMPRESSED BACKUPSET;
 +CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
 +CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
 +CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
 +CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
 +CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
 +CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 2 G;
 +CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' MAXPIECESIZE 2 G;
 +CONFIGURE MAXSETSIZE TO UNLIMITED; # default
 +CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
 +CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
 +CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE;
 +CONFIGURE RMAN OUTPUT TO KEEP FOR 90 DAYS;
 +CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO 'SBT_TAPE';
 +CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/dbs/snapcf_C1DIGDEV1.f'; # default
 +[...]
 +Finished backup at 02-DEC-24
 +
 +Starting Control File and SPFILE Autobackup at 02-DEC-24
 +released channel: ch00
 +RMAN-00571: ===========================================================
 +RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
 +RMAN-00571: ===========================================================
 +RMAN-03009: failure of Control File and SPFILE Autobackup command on ch00 channel at 12/04/2024 10:57:29
 +ORA-19506: failed to create sequential file, name="c-1272122079-20241202-ff", parms=""
 +ORA-27027: sbtremove2 returned error
 +ORA-19511: non RMAN, but media manager or vendor specific failure, error text:
 +   Failed to remove, c-1272122079-20241202-ff, from image catalog.
 +</code>
 + \\
 == Past 24 hours jobs == == Past 24 hours jobs ==
 <code PLSQL> <code PLSQL>