April 2015 »

Data Guard Flashback

Redundant data saving is usual for almost every database nowadays, and it does not matter if it is a RAID-1 (mirroring) or RAID-5 or anything like that. Nevertheless critical databases must be saved by a copy. This is why: By corruption of data the mirroring could be damaged as well. A data backup is not sufficient, because the restore would take too long in case of an error. Logical mistakes ([inlinecode]DROP[/inlinecode] or [inlinecode]TRUNCATE TABLE[/inlinecode]) could not be recognized or eliminated by a disk mirroring. To create such a copy there are at least two different methods: Creating an identical copy […]

Oracle

Oracle 12c Unified Auditing – Part 2

Unified Auditing was introduced with Oracle 12c 12.1.0.1 and one idea is to combine standard auditing (AUD$) with fine grained auditing (FGA_LOG$). AUD$ and FGA_LOG$ still exists and if you like you can use your existing and well accepted auditing procedures. Some documents stated that the same auditing which was introduced with Oracle 11g is still running but that’s not one hundred percent true. If you don’t change the standard database setup the “old” AUD$ table exist but will stay empty in contrast to 11g. A new partitioned table with a somewhat cryptic name (CLI_SWP$2dc5e8db$1$1) is populated in the schema

Oracle 12c Unified Auditing – Part 2 Blogbeitrag lesen »

By Johannes Ahrends • 16. April 2015 • 4 minutes of reading