@/opt/oracle/product/10.2.0/rdbms/admin/catproc.sql

Vérification que tous les packets spont valides:
select count(*) as nb_package_non_valide from user_objects where object_type='PACKAGE' and status='VALID';

NB_PACKAGE_NON_VALIDE
---------------------
                  445

Après quelques vérifications, malgré les erreur, ça a l'air de fonctionner ...


Nom des fichier de contrôle et leur localisation:
select * from v$controlfile;

/opt/oradata/DBCUG/control01.ctl

Un fichier de contrôle.


Connaitre les fichiers redo-log de ma base:
SELECT * FROM v$logfile;

         1         ONLINE
/opt/oradata/DBCUG/log1a.rdo
NO

         2         ONLINE
/opt/oradata/DBCUG/log2a.rdo
NO

2 fichiers redo log (noms ci dessus).

Le nombre de groupes et de membres:
SELECT group#, sequence#, bytes, members, status FROM v$log;

 GROUP#  SEQUENCE#      BYTES    MEMBERS STATUS
---------- ---------- ---------- ---------- ----------------
         1        201    6291456          1 INACTIVE
         2        202    6291456          1 CURRENT



Mode archivage désactivé. Informations sur les archives log:
ARCHIVE LOG LIST;
SELECT name, log_mode FROM v$database;
SELECT archiver FROM v$instance;

Database log mode              No Archive Mode
Automatic archival             Disabled

Ajout d'un membre au groupe 1 (l'opération peut êytre répétée pour tous les groupes):
alter database add logfile member '/opt/oradata/DBCUG/log3a.rdo' to group 1;

Database altered.

Vérification:
SQL> SELECT * FROM v$logfile;

    GROUP# STATUS  TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
IS_
---
         1         ONLINE
/opt/oradata/DBCUG/log1a.rdo
NO

         2         ONLINE
/opt/oradata/DBCUG/log2a.rdo
NO

         1 INVALID ONLINE
/opt/oradata/DBCUG/log3a.rdo
NO


3 rows selected.

SQL> SELECT group#, sequence#, bytes, members, status FROM v$log;

    GROUP#  SEQUENCE#      BYTES    MEMBERS STATUS
---------- ---------- ---------- ---------- ----------------
         1        201    6291456          2 INACTIVE
         2        202    6291456          1 CURRENT

2 rows selected.


Ajout d'un nouveau groupe:

SQL> alter database add logfile group 3 ('/opt/oradata/DBCUG/log4a.rdo') size 5M;

Database altered.

Vérification de son existance.
SQL> SELECT group#, sequence#, bytes, members, status FROM v$log;

    GROUP#  SEQUENCE#      BYTES    MEMBERS STATUS
---------- ---------- ---------- ---------- ----------------
         1        201    6291456          2 INACTIVE
         2        202    6291456          1 CURRENT
         3          0    5242880          1 UNUSED

3 rows selected.


Suppression du membre ajouté au groupe 1:

SQL> alter database drop logfile member '/opt/oradata/DBCUG/log3a.rdo';

Database altered.

Vérification de la suppression:
SQL> SELECT * FROM v$logfile;

    GROUP# STATUS  TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
IS_
---
         1         ONLINE
/opt/oradata/DBCUG/log1a.rdo
NO

         2         ONLINE
/opt/oradata/DBCUG/log2a.rdo
NO

         3         ONLINE
/opt/oradata/DBCUG/log4a.rdo
NO


3 rows selected.