Mémo

GENERIQUE

Format d’affichage des dates

Depuis sqlplus
SQL> ALTER SESSION SET nls_date_format = 'DD-MON-YYYY HH24:MI:SS';

Depuis l'OS
[oracle]$ export NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'

GESTION COURANTE

Etat de la base

SQL> SELECT dbid, instance_name, name, db_unique_name, status, startup_time, database_role, open_mode, log_mode, host_name, force_logging FROM gv$instance, v$database ;

 DBID      INSTANCE_NAME    NAME   DB_UNIQUE_NAME     STATUS    STARTUP_TIME         DATABASE_ROLE    OPEN_MODE            LOG_MODE
---------- ---------------- ------ ------------------ --------- -------------------- ---------------- -------------------- ------------
 925233132 PROD1            PROD   PROD_EXA1          OPEN      01-JAN-2024 12:03:38 PRIMARY          READ WRITE           ARCHIVELOG
 925233132 PROD2            PROD   PROD_EXA1          OPEN      01-JAN-2024 12:15:47 PRIMARY          READ WRITE           ARCHIVELOG

GESTION DATAGUARD

Etat de la synchronisation Dataguard

SQL> SELECT process, client_process, sequence#, delay_mins, status, thread# FROM gv$managed_standby ;

PROCESS   CLIENT_P  SEQUENCE# DELAY_MINS STATUS          THREAD#
---------        -------- ---------- ---------- ------------ ----------
ARCH         ARCH              0          0 CONNECTED             0
ARCH         ARCH              0          0 CONNECTED             0
ARCH         ARCH             17          0 CLOSING               1
ARCH         ARCH              0          0 CONNECTED             0
RFS          UNKNOWN           0          0 IDLE                  0
RFS          UNKNOWN           0          0 IDLE                  0
MRP0         N/A              482         0 APPLYING_LOG          1
RFS          LGWR             18          0 IDLE                  1
RFS          LGWR            602          0 IDLE                  2