Skip to main content

Posts

DB - Fast Recovery Area

Let's  distillate  a bit the Fast Recovery Area (FRA)   Central location for backup data Logs Archive logs Backups Control file Location (either) ASM filesystem Allow RMAN Retention policies Parameters ( location and size) DB_RECOVERY_FILE_DEST DB_RECOVERY_DEST_SIZE FRA - Maintenance other notes The maintenance is done automatically, and if is properly sized are not expected issues Use the RMAN commands to remove backups and file copies that are not required. If gets full - database stops RMAN> REPORT OBSOLETE  RMAN> DELETE OBSOLETE  Get Info SQL> show parameter DB_RECOVERY_FILE_DEST NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_recovery_file_dest string /u01/app/oracle/flash_recovery_area db_recovery_file_dest_size big integer 3852M SQL> col name form a30 SQL> col value form a30 SQL> select name, v...
Post a Comment
Read more

WMS - Dest ID

English Version Em Oracle Retail os armazens ( e outras facilities ) tem um ID unico. Neste caso especifico WMS, o RIB vai mandar informacao especifica para esse armazem. Esse ID , tera que estar no RMS, ficheiro TAFRs , e no WMS. A query em baixo retorma essa informacao , na base de dados do WMS, esse ID. set lines 20 col description a30 col description form a30 set lines 200 select l.facility_id,description,dc_dest_id from transshipment_setup t, facility l where l.facility_id = t.facility_id; Obrigado pela leitura, espero que este post o tenha ajudado. Rogerio Referencias e Mais Info : https://docs.oracle.com/cd/E82085_01/1303/operations_guide/Chapter%207%20-%20Message%20and%20Routing%20(TAFR).htm https://docs.oracle.com/cd/E12456_01/rwms/pdf/141/html/impg/wms-integration.htm
Post a Comment
Read more

WMS – Dest ID

Versao Portuguesa In Oracle Retail the warehouses ( and other facilities as stores ) have a unique identify. Specific to the WMS, RIB sends/redirects specific information using that ID . That information needs to be in : RMS, TAFRs file and WMS. The bellow query can be used to identify the WMS ID . set lines 20 col description a30 col description form a30 set lines 200 select l.facility_id,description,dc_dest_id from transshipment_setup t, facility l where l.facility_id = t.facility_id; Thank you for reading, hope this post was helpful. Rogerio Futher Reading : https://docs.oracle.com/cd/E82085_01/1303/operations_guide/Chapter%207%20-%20Message%20and%20Routing%20(TAFR).htm https://docs.oracle.com/cd/E12456_01/rwms/pdf/141/html/impg/wms-integration.htm
Post a Comment
Read more