Deployoracle

While browsing endless Oracle materials, I discovered the following link, which provides quite comprehensive layout of Oracle architecture. 

Foreword

Have a task to replicate data across several Oracle databases? Want to do this automatically, choose what to replicate, apply rules, filters ? There is a solution for that.

Within this article I will try to demonstrate  how you can employ data replication technology within Oracle database called Oracle Streams.

Read more…

Let's say you have a request to provide user with the way to backup an  Oracle database. Such user does not have rights, which could allow him to perform admin tasks on database.

Besides  it must be done without any admin effort, therefore everything must be automated.

In order to satisfy this particular requirement, you can employ sudo.

Read more…

This post will instruct you to quickly automate your Oracle database 10g/11g startup/shutdown on RedHat Linux 5, 64 bit OS.

Read more…

Foreword

Data security was, is and will be one of the biggest  concerns in IT systems. When developing backup strategy, especially where backups need to be taken offsite, it is essential to safeguard from misuse of sensitive data in the event of backup theft or loss.

There are bunch of encryption solutions for backups in place, starting with Oracle Secure Backup, widely used NetBackup or IBM Tivoli Storage Manager solutions, tape drive/library encryption eliminating CPU overhead on host servers and etc.

But all these require additional infrastructure and costs associated with them. 

Oracle database 11g Enterprise Edition has a backup encryption feature which allows to achieve same goals, without significant investment into infrastructure. How to use this functionality I will describe in this post.

Read more…