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


Windows 2016 - Install AZ CLI & KUBECTL

#AZ CLI msiexec /i https://aka.ms/installazurecliwindows #Kubectl curl.exe -LO "https://dl.k8s.io/release/v1.30.1/bin/windows/amd64...