Month: February 2019

20 February 20198 February 2023

Le licensing Oracle

je peux remarquer assez souvent que pas mal de personnes ne sont pas au courant du fonctionnement du licensing Oracle qui est, il faut l’avouer assez complexe en fonction de la licence que l’on possède.

Les règles sont assez méconnu lorsque l’on parle de virtualisation, surtout avec VMWare. J’aborderai ce point dans un autre post.

Lire la suite!

19 February 201929 May 2020

Using variables in RMAN

When using RMAN catalog it is preferred to use backup script stored in catalog. It is best if scripts can be reused for different retention.

You can use variables in RMAN script this way:

CREATE global script global_backup_full_database 
comment 'backup full of database. Parameter sysdate+n,tag db, tag archivelog'
{
allocate channel c1 TYPE SBT_TAPE PARMS 'BLKSIZE=1048576,SBT_LIBRARY=/usr/lib/ddbda/libddboostora.so, ENV=(CONFIG_FILE=/opt/ddbda/config/oracle_ddbda.cfg)' FORMAT '%d_%U';
backup AS backupset DATABASE filesperset 1 keep until TIME '&amp;1' tag &amp;2;
backup AS backupset archivelog ALL DELETE INPUT filesperset=1 keep until TIME '&amp;1' tag &amp;3;
}

Lire la suite!

15 February 201929 May 2020

List number of archivelogs

You can list the number of archivelogs generated this way:

SELECT trunc(COMPLETION_TIME,'DDD') DAY, SUM(BLOCKS * BLOCK_SIZE)/1024/1024 SIZE_MB, COUNT(*) "NB_Files" 
FROM V$ARCHIVED_LOG 
GROUP BY trunc (COMPLETION_TIME,'DDD') ORDER BY 1;

Lire la suite!

15 February 201929 May 2020

List blocking sessions

Below is a query that list all the blocking sessions in an oracle instance

Lire la suite!