Différences

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

--- oracle:database:rman [04/12/2024 09:51] – mdl
+++ oracle:database:rman [04/12/2024 10:10] (Version actuelle) – mdl
@@ Ligne 19: / Ligne 19: @@
 where status='RUNNING'
 order by session_key;
+SESSION_KEY SESSION_RECID SESSION_STAMP INPUT_TYPE    STATUS               DEV        START_TIME       END_TIME            HRS INBYTES    OUTBYTES
+----------- ------------- ------------- ------------- -------------------- ---------- ---------------- ---------------- ------ ---------- ----------
+          6060    1186690460 ARCHIVELOG    RUNNING              SBT_TAPE   02/12/2024 20:14 04/12/2024 10:49  38.58   525.00K    512.00K
+          6187    1186732699 ARCHIVELOG    RUNNING                         03/12/2024 07:58 04/12/2024 10:49  26.84     0.00K      0.00K
+          6193    1186776020 ARCHIVELOG    RUNNING                         03/12/2024 20:00 04/12/2024 10:49  14.81     0.00K      0.00K
+          6196    1186776141 ARCHIVELOG    RUNNING                         03/12/2024 20:02 04/12/2024 10:49  14.78     0.00K      0.00K
+          6199    1186776200 ARCHIVELOG    RUNNING                         03/12/2024 20:03 04/12/2024 10:49  14.76     0.00K      0.00K
+          6202    1186776260 ARCHIVELOG    RUNNING                         03/12/2024 20:04 04/12/2024 10:49  14.74     0.00K      0.00K
+          6205    1186776321 ARCHIVELOG    RUNNING                         03/12/2024 20:05 04/12/2024 10:49  14.72     0.00K      0.00K
+          6208    1186776380 ARCHIVELOG    RUNNING                         03/12/2024 20:06 04/12/2024 10:49  14.71     0.00K      0.00K
+          6211    1186776441 ARCHIVELOG    RUNNING                         03/12/2024 20:07 04/12/2024 10:49  14.69     0.00K      0.00K
+          6214    1186776498 ARCHIVELOG    RUNNING                         03/12/2024 20:08 04/12/2024 10:49  14.68     0.00K      0.00K
+          6217    1186776560 ARCHIVELOG    RUNNING                         03/12/2024 20:09 04/12/2024 10:49  14.66     0.00K      0.00K
+          6220    1186776618 ARCHIVELOG    RUNNING                         03/12/2024 20:10 04/12/2024 10:49  14.64     0.00K      0.00K
+          6223    1186776680 ARCHIVELOG    RUNNING                         03/12/2024 20:11 04/12/2024 10:49  14.63     0.00K      0.00K
+          6226    1186776740 ARCHIVELOG    RUNNING                         03/12/2024 20:12 04/12/2024 10:49  14.61     0.00K      0.00K
+          6229    1186776801 ARCHIVELOG    RUNNING                         03/12/2024 20:13 04/12/2024 10:49  14.59     0.00K      0.00K
+          6232    1186776858 ARCHIVELOG    RUNNING                         03/12/2024 20:14 04/12/2024 10:49  14.58     0.00K      0.00K
+          6235    1186776923 ARCHIVELOG    RUNNING                         03/12/2024 20:15 04/12/2024 10:49  14.56     0.00K      0.00K
+          6238    1186776978 ARCHIVELOG    RUNNING                         03/12/2024 20:16 04/12/2024 10:49  14.54     0.00K      0.00K
+          6241    1186777043 ARCHIVELOG    RUNNING                         03/12/2024 20:17 04/12/2024 10:49  14.52     0.00K      0.00K
 </code>
  \\
-== Job Detail with SESSION_RECID and SESSION_STAMP==
+== 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
@@ Ligne 51: / Ligne 102: @@
 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>
  \\

Outils

menus et recherche rapide

recherche rapide

statut du site

Outils de la page

meta données pour cette page

Différences