Sunday, July 1, 2012

Enable Archive logs



Oracle DB, Enable archive log mode


# DB Param
ALTER SYSTEM SET LOG_ARCHIVE_DEST_1 = 'LOCATION=/u01/app/oracle/archivelogs' SCOPE=BOTH;
ALTER SYSTEM SET LOG_ARCHIVE_FORMAT = 'DEV_%t_%s_%r.dbf' SCOPE=SPFILE;

# DB server
sqlplus / as sysdba
ARCHIVE LOG LIST;
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER DATABASE ARCHIVELOG;
ALTER DATABASE OPEN;
ARCHIVE LOG LIST;
SELECT log_mode FROM v$database;

# Test Aarchive log
ALTER SYSTEM SWITCH LOGFILE


Azure AKS - Diag Logs - KQL

AzureDiagnostics | where Category == "kube-audit" | summarize requests = count() by bin(TimeGenerated, 5m), userAgent_s | orde...