Categories
Database Development

datapump Imports

I am trying to do an import using data pump, but I am struggling to come up with the right options. The export was taken as a schema export. I am trying to import just the tables, with no other database objects. I am currently using INCLUDE=TABLE TABLE_EXISTS_ACTION=REPLACE REMAP_SCHEMA= REMAP_TABLESPACE= This is correctly importing the […]

Categories
Database Development

Is it safe to rely on transactions in Firebird 2.5 Embedded DB in case of power outage?

How it’s safe to say that the following list of action will never be reflected in DB in case of power outage somewhere in the middle of #2 line, before transaction is committed? #1 begin transaction #2 delete record in table A that cascade deletes another record in table B #3 update another record in […]

Categories
Database Development

High PREEMPTIVE_OS Wait Stats [duplicate]

How to reduce PREEMPTIVE_OS_AUTHENTICATIONOPS wait type stats in SQL Server, any advice on it would be greatly appreciated. Thanks

Categories
Database Development

mysql upgrade from 5.6 to 5.7, how to config mysql backup

we have a lot of mysql database running from 5.6 to 5.7 , we use netbackup to backup mysql , the local script (mysql_backup.sh) is as belows: /opt/mysql/meb-4.1.3/bin/mysqlbackup –login-path=root –backup-image=sbt:bkpsbtNB$backuptime –sbt-lib-path=/usr/openv/netbackup/bin/libobk.so64 –sbt-environment="NB_ORA_SERV=pnbumaster,NB_ORA_CLIENT=prmbsage_svc,NB_ORA_POLICY=mysql_cdeskdb,NB_ORA_SCHED=Default-Application-Backup,ORACLE_HOME=/age/mysql" –backup-dir=/usr/openv/meb_bkdir/ backup-to-image –socket=/age/mysql/data-5.7.29/mysql.sock –port=3306 >> $MYSQL_LOG_FILE every time we have upgrade database , we should re-config mysql_backup.sh is there any method to auto […]

Categories
Database Development

Intermittent SQL Delegated Authentication Errors

Here is an odd issue that is causing me to lose all my hair. Every few days or so our delegated authentication from one SQL server to another fails with the error: Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’. The SQL server logs show: "Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’. Reason: Could not find […]

Categories
Database Development

What does MariaDB use for an IV?

I have been using MySQL 5.6 in development environment and MariaDB 5.6 in production until I needed to use encryption. MySQL 5.6 has multiple encryption modes and allows AES-256-CBC. MariaDB 5.6 only uses ECB. So, I was working towards and upgrade to MariaDB 10, and noticed that the AES_ENCRYPT() and AES_DECRYPT() functions don’t use an […]

Categories
Database Development

Oracle 12cR2 RMAN – ORA-01547, ORA-01194, RMAN-06054

Oracle 12cR2. Error: channel default: deleting archived log(s) archived log file name=+RECO/…/thread_1_seq_166200.26582.1054942673 RECID=62 STAMP=1054943183 archived log file name=+RECO/…/thread_1_seq_166201.11529.1054941077 thread=1 sequence=166201 channel default: deleting archived log(s) archived log file name=+RECO/…/thread_2_seq_223357.10403.1054942671 RECID=58 STAMP=1054943182 unable to find archived log archived log thread=2 sequence=223358 Oracle Error: ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below ORA-01194: file […]

Categories
Database Development

Debug why Postgres wants to use an uninstalled extension for a function

I recently moved a Postgres function app_user_id from an old, custom extension called intpair into a new, custom extension called heap_exts. This worked well except for machines I restored from a Postgres backup. Here’s the error: db=> select app_user_id(1, 2); ERROR: could not access file "$libdir/intpair": No such file or directory intpair is not installed […]

Categories
Database Development

SQL server memory pressure

First observed few months ago at end-user’s laptop (rather slow i3 CPU, 4GB RAM, SSD) with SQL 2014 Express. The problem persists with SQL 2019, even with clean Windows 10 1903 installation. The database has 250MB so pretty small even for Express Edition. Application mostly works smooth, but there are time to time very looong […]

Categories
Database Development

SQL Log Shipping – What is the date time format used by transaction log file name?

Looking at my SQL log shipping file name of Q:\Backups\LogShipping\MyAudit\MyAudit_20201027165400.trn What date time format is the transaction log expressed in (local military time, UTC time)?