Month: February 2019

Oracle Database Licensing: Editions and License Metrics

by

This article is an English translation of the original post published on 20 February 2019. It outlines Oracle Database editions and the licensing metrics discussed in the original article. Historical note: The licensing statements below are translated from a 2019 article and have not been validated as current licensing advice. Entitlements depend on the applicable … Read more

Using variables in RMAN

by

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 … Read more

List number of archivelogs

by

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;