Today I will show how to configure e-mail alerts in OEM 12c.
I did one implementation in one client last week, all databases are monitored with OEM 12c, this is a very good tool.
The scopes of OEM 12c are not limited only at database level.
We will create commun alert for full tablespaces.
Let’s start: Continue reading
Today I will show, how to prepare the Solaris 11.2 for install Oracle Database 12c (18.104.22.168).
I am still familiarizing with Solaris systems, to me it has been a good experience.
I am discovering very good features about Solaris systems. This is a simple post, with few steps you can be prepare.
To complete the steps you will need the following prerequisites Continue reading
Hello, everyone! Today I will show you how to restore a database on another server with different directory structures and in the sequence change the database name. This operation is very common to tests procedure restore and recovery. I always used this process for many environments for evidences of restore.
Let’s start: Continue reading
Oracle Data Redaction is new a feature that provides the security of data from application end users
modifying sensitive data contained in SQL query results before the results returned the applications.
The Oracle Data Redaction is completely different from Oracle Data Masking. Continue reading
Oracle Database 12c brings a new feature that enables you to easily limit the result set to a specific number or percentage of rows. For me this feature it is very interesting and does my job more easy when I need to develope some query to the clients
Oracle Database 12c have a new feature: In-Database Archiving. I will make a brief summary about this feature.
In-Archive Database: Gives the ability to keep both active operational data and non-active data in the same database tables. Continue reading
Hello, I will make an overview about the Oracle Multitenant the new option in Oracle Database 12c.
This new architecture enables you to have many pluggable databases inside a single Oracle Database with this option allows the DBA to consolidate many databases into a single RDBMS installation. Continue reading
Today I will make a brief post about flashback data archive.
Flashback data archives it is like a repository composty by one or more areas, one of which can be the default, assign a default retention period for objects in the repository, and then mark the appropriate tables for tracking. Continue reading
In many cases you probably need to restore a database to a point in the past.
Errors that won’t be reversed only with a flashback table or perhaps you do not have
the flashback feature configured for the database.
You can use restore point with a specific time in the past or using the SCN number.
To capture the SCN of the database you can the query below:
Today, I will talk about a little of image copies. An image copy is an exact copy of a tablespace’s datafile, an archive redo log file or a control file.
This type of backup can be written only to disk. In case of recovery the time from restoration is less because the file is already on disk.
An image copy can be used like a full backup or a backup level 0, all used and an unused blocks are taken during this type of backup operation.
Also the command SWITCH will be used to perform fast recovery operation.
Let’s stat Continue reading