LIM'S 우당탕탕 LIFE

DB 환경 : Oracle Database 19.10.0.0 방법 : 오라클 19c 일별, 시간별 아카이브 갯수 및 용량 확인rac 일별 아카이브 발생 갯수 및 용량 확인12345678910111213141516SQL> select to_char(completion_time,'yyyy/mm/dd') day, thread#, round(sum(blocks*block_size)/1024/1024/1024) gb,count(*) archives_generated from v$archived_log where standby_dest='NO' group by to_char(completion_time,'yyyy/mm/dd'), thread# order by 1; DAY          THREAD#        ..

Archive log mode 조회 (sys 계정으로)SQL > archive log listDatabase log mode No Archive ModeAutomatic archival DisabledArchive destination /u01/app/oracle/product/11g/dbs/archOldest online log sequence 399Current log sequence 401 Archive log mode 변경1. DB ShutdownSQL> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.2. star..