3zecisi3 ... DBA experiences
Wednesday, May 30, 2018
Oracle 12.2 docker install on RHEL 7
›
#yum install yum-utils \ device-mapper-persistent-data \ lvm2 # yum-config-manager \ --add-repo \ https://download.docker.com/linux/cen...
1 comment:
Monday, January 15, 2018
Unix - Find and delete all files in a path
›
/usr/bin/find . -name "*.aud*" -print -exec rm {} \;
Wednesday, November 15, 2017
SQL Server - Check how database recovery will take
›
DECLARE @DBName VARCHAR(64) = 'DCIS' DECLARE @ErrorLog AS TABLE([LogDate] CHAR(24), [ProcessInfo] VARCHAR(64), [TEXT] VARCHAR(MAX...
Thursday, October 26, 2017
Oracle - Create restore points in Data Guard environment
›
*************** On Standby SQL> select db_unique_name, database_role, open_mode, flashback_on,dataguard_broker, guard_status, protect...
Tuesday, November 22, 2016
Oracle - Rotate/backup listener.log file
›
Stop log generation into listener logfile [host11:oracle:/home/oracle]lsnrctl LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.4.0 ...
Oracle - Rotate/backup listener.log file
›
Stop log generation into listener logfile [host11:oracle:/home/oracle]lsnrctl LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.4.0 ...
Thursday, November 17, 2016
SQL Server - Execute dynamic SQL with parameters
›
Example of procedure running an dynamic SQL based on procedure's parameter: CREATE PROCEDURE [dbo].[SP_DYNAMIC_SQL_TEST] (@V_PARAM...
›
Home
View web version
