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…
Tag: Database Administration
How to Auto Start Instance of Oracle Database on Windows Server
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
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…
How to Add or Delete Route in Oracle Linux
IP routing involves forwarding of IP datagrams. Its a simple process in which the host sends the IP datagram directly to the destination if the destination host is connected. For example, through a point to point link or through a shared network. If the destination host is not directly connected then the host sends the…
How to Increase Swap Space Size in Linux System
Swap space in Linux is used when the amount of physical memory (RAM) is full. If the system needs more memory resources and the RAM is full, inactive pages in memory are moved to the swap space. While swap space can help machines with a small amount of RAM, it should not be considered a…
MySQL Data File Size Decrease
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
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
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
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…
Oracle Data Pump (expdp and impdp) in Oracle
Oracle Data Pump is faster and more flexible alternative to the “exp” and “imp” backup system used in previous Oracle versions. impdp and expdp commands use Oracle Directory for processing of backups. Create Directory CONN SYS AS SYSDBA CREATE OR REPLACE DIRECTORY dirname AS ‘/u01/backup/’; GRANT READ, WRITE ON DIRECTORY dirname TO backupuser; Tables Export…