Category: Databases

Create Linked Server for Oracle in SQL Server 2008 R2

Posted on by Fatih Acar

If you want to fetch data from Oracle to SQL Server, you can use Linked Servers features in SQL Server Database. Linked Server is like a database link (Dblink). Installation steps Install Oracle Client on SQL Server database server Restart SQL Server database service Configure OraOLEDB.Oracle provider in SQL Server database Create user for remote…

Fine Grained Auditing (FGA) in Oracle

Posted on by Fatih Acar

Fine Grained Auditing (FGA), introduced with Oracle9i, can be understood as ‘policy-based auditing’. As opposed to the standard auditing functionality, FGA lets you specify the conditions necessary for an audit record. FGA policies are programatically bound to the object (table, view) by using the ‘dbms_fga’ package. You have to have a valid set of Fine-Grained…

How to Auto Start Instance of Oracle Database on Windows Server

Posted on by Fatih Acar

Oracle database is not startted when you restart windows server, then you can change regedit parameter for auto start. Each time you install Oracle products into a new Oracle home on your computer, HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_HOME_NAME is created. This subkey contains parameter values for most Oracle products. HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_HOME_NAME includes the following parameters for an Oracle home directory….

MsSQL Server Recovery Models Features

Posted on by Fatih Acar

SQL Server backup and restore operations occur within the context of the recovery model of the database. Recovery models are designed to control transaction log maintenance. A recovery model is a database property that controls how transactions are logged, whether the transaction log requires (and allows) backing up, and what kinds of restore operations are…

MySQL Database Import And Export Operations

Posted on by Fatih Acar

Take Backup With Data Open Command Prompt (cmd) # mysqldump -u dbusername -p db_name > /tmp/db_fullbackup.sql Take Only Metadata Backup # mysqldump -u dbusername -p –no-data db_name > /tmp/db_backupmetadata.sql or # mysqldump -u dbusername -p -d db_name > /tmp/db_backupmetadata.sql Restore Database Metadata From Backup # mysql -u dbusername -p db_name < /tmp/db_backupmetadata.sql Restore Database From...

MySQL Data File Size Decrease

Posted on by Fatih Acar

If ibdata1 data file size is too big, you can decrease this file. My scenario is that my database have a table and size is 100 GB, I want to take backup and delete all data with decrease datafile size. If I use truncate command, this is not decrease ibdata1 size. I can use backup…

Oracle Flashback Database Technology in Oracle 11g

Posted on by Fatih Acar

FLASHBACK DATABASE Technology to rewind the database to a target time, SCN or log sequence number. This command works by undoing changes made by Oracle Database to the datafiles that exist when you run the command. Flashback can fix logical failures, but not physical failures. Thus, you cannot use the command to recover from disk…

Limits of Oracle Data Guard

Posted on by Fatih Acar

Important situations of Oracle Data Guard Nologging or unrecoverable operations are not applied to standby – so be cautious in using those options. Alarming data block corruption error messages are reported if a user attempts to access any nologging or unrecoverable data blocks. ‘Drop tablespace’, ‘drop datafile’, ‘rename datafile’, and add/drop online redo log files…

How to Add Standby Logfile in Oracle

Posted on by Fatih Acar

If you want to use real-time apply Oracle Data Guard, you have to add standby logfile to standby database. Show Logfiles Before Add SQL> select * from gv$logfile; INST_ID GROUP# STATUS TYPE MEMBER IS_RECOVERY_DEST_FILE 1 3 ONLINE +DATA/testdb/onlinelog/group_3.14134123 NO 1 1 ONLINE +DATA/testdb/onlinelog/group_1.35116731 NO 1 2 ONLINE +DATA/testdb/onlinelog/group_2.32513245 NO 1 4 ONLINE +DATA/testdb/onlinelog/group_4.12255335 NO 1…