Ok

En poursuivant votre navigation sur ce site, vous acceptez l'utilisation de cookies. Ces derniers assurent le bon fonctionnement de nos services. En savoir plus.

Professionnel - Page 4

  • Datapump , export query avec date

    http://amit7oracledba.blogspot.com/2013/12/query-parameter-in-datapump-utility.html

  • Table partitionnement

    https://www.oracle-dba-online.com/sql/oracle_table_partition.htm

  • Déterminer la taille d'un LOB

    https://nguyentichthanh.wordpress.com/how-to-determine-the-actual-size-of-the-lob-segments-and-how-to-free-the-deletedunused-space-abovebelow-the-hwm-doc-id-386341-1/

  • Migration 11.2.0.4 vers 12.2.0.1 (en ligne de commande)

    http://www.br8dba.com/tag/upgrade-oracle-database-manually-from-11-2-0-4-to-12-2-0-1/

  • UPgrade 12CR1 to 12CR2

    http://dbaclass.com/article/upgrade-database-from-12-1-0-2-to-12-2-0-1/

     

     

  • Trouver les objets invalides dans la base

    https://blog.devart.com/find-invalid-objects-in-your-databases.html

  • Méthode de sauvegarde PostgreSQL - pgBackRest

    https://pgstef.github.io/2018/01/04/introduction_to_pgbackrest.html

     

    https://fr.slideshare.net/slardiere/pgbackrest-pgdayfr

     

    http://laetitia-avrot.blogspot.com/2017/02/faire-une-sauvegarde-avec-pgbackrest.html

     

    http://laetitia-avrot.blogspot.com/2017/02/restaurer-avec-pgbackrest.html

  • ARE

    calcul de l'are

    https://droit-finances.commentcamarche.com/faq/3561-allocation-chomage-2019-calcul-de-l-indemnite-are-2019

    calcul du salaire journalier de référence

    https://droit-finances.commentcamarche.com/contents/1532-chomage-calcul-du-salaire-journalier-de-reference

     

    Vous avez créé une entreprise et bénéficiez de l'Allocation de Retour à l'Emploi (ARE)

     

    (ARE) et création d'entreprise

     

    Le maintien des allocations chômage en cas de création ou de reprise d’entreprise

     

    Les aides financières proposées par Pôle emploi aux créateurs repreneurs d'entreprise

  • Identifier un fichier trace d'une session

    -- -----------------------------------------------------------------------------------
-- File Name    : https://oracle-base.com/dba/monitoring/identify_trace_file.sql
-- Author       : Tim Hall
-- Description  : Displays the name of the trace file associated with the current session.
-- Requirements : Access to the V$ views.
-- Call Syntax  : @identify_trace_file
-- Last Modified: 17-AUG-2005
-- -----------------------------------------------------------------------------------
SET LINESIZE 100
COLUMN trace_file FORMAT A60

SELECT s.sid,
       s.serial#,
       pa.value || '/' || LOWER(SYS_CONTEXT('userenv','instance_name')) ||    
       '_ora_' || p.spid || '.trc' AS trace_file
FROM   v$session s,
       v$process p,
       v$parameter pa
WHERE  pa.name = 'user_dump_dest'
AND    s.paddr = p.addr
AND    s.audsid = SYS_CONTEXT('USERENV', 'SESSIONID');

  • Tracer une session Oracle

    Avant la 10G :

     

    Activer la trace :

    SQL> EXEC DBMS_SYSTEM.set_sql_trace_in_session(sid=>123, serial#=>1234, sql_trace=>TRUE);

    Désactiver la trace : 
SQL> EXEC DBMS_SYSTEM.set_sql_trace_in_session(sid=>123, serial#=>1234, sql_trace=>FALSE);

    Après la 10G : 

    Activer la trace : 
    SQL> EXEC DBMS_MONITOR.session_trace_enable(session_id=>1234, serial_num=>1234);
SQL> EXEC DBMS_MONITOR.session_trace_enable(session_id =>1234, serial_num=>1234, waits=>TRUE, binds=>FALSE);


    Désactiver la trace : 

    SQL> EXEC DBMS_MONITOR.session_trace_disable(session_id=>1234, serial_num=>1234);

  • Restaurer une base après avoir créé un point de restaure.

    RMAN> shutdown immediate
    RMAN> startup mount
    RMAN> run
    2> {
    3> set until restore point <nomdupointderestaure>;
    4> restore database;
    5> recover database;
    6> }
     
    RMAN> alter database open resetlogs;
    database opened
    RMAN>

  • Dataguard - refresh a physical standby dataguard from primary avec RMAN

     

    Steps to Refresh a Physical Standby Database with Changes Made to the Primary Database

     

    source : https://docs.oracle.com/en/database/oracle/oracle-database/18/spmss/refresh-a-physical-standby-db.html#GUID-828A4953-3F7E-4975-ADA4-5469D6794BB0

     le site inclus les prérequis que l'on oublie souvent:

     

    • Oracle Net connectivity is established between the physical standby database and the primary database.

      You can do this by adding an entry corresponding to the primary database in the tnsnames.ora file of the physical standby database.

    • The password files on the primary database and the physical standby database are the same.

    • The COMPATIBLE parameter in the initialization parameter file of the primary database and physical standby database is set to 12.0.

     

    ...

    4 . (For Active Data Guard only) Perform the following steps to recover redo data and open the physical standby database in read-only mode:

    ALTER DATABASE RECOVER MANAGED STANDBY DATABASE UNTIL CONSISTENT;

    ALTER DATABASE OPEN READ ONLY;

    ...

     

  • Dataguard - start and stop a standby database on server startup

    Source : https://www.orafaq.com/forum/t/122395/

     

    to start a standby database :

     

    #!/bin/bash
ORA_HOME="/opt/oracle/920"
ORA_OWNER="oracle"
SQLCMD="sqlplus '/as sysdba'"
LOGFILE="strt.log"
cat startup.sql | su - $ORA_OWNER  -c "$SQLCMD" > $LOGFILE

     

    to shutdown a standby database :

    #!/bin/bash
ORA_HOME="/opt/oracle/920"
ORA_OWNER="oracle"
SQLCMD="sqlplus '/as sysdba'"
LOGFILE="sht.log"
cat shutdown.sql | su - $ORA_OWNER  -c "$SQLCMD" > $LOGFILE

     

    startup.sql :

    startup nomount;
alter database mount standby database;
alter database recover managed standby database disconnect from session;

     

    shutdown.sql:

    alter database recover managed standby database cancel;
shutdown immediate;
exit