Overview for oracle

Oracle 12c - Temporal Validity

 

Temporal validity feature allows you to add a valid time dimension to the table data by specifiying the start and end datetimes of the period for which the data should be valid and visible.
 
Flashback query clauses ASOF, VERSIONS can be used to query the data valid for a specified period of time. You can also control the data visibility at the session level by using the DBMS_FLASHBACK_ARCHIVE.enable_at_valid_time procedure.
 

Read more

Written by rajkiran on Monday June 9, 2014

Image: 2018-06/circuits-1.jpg

Oracle 12c - In-Database Archiving

In-Database Archiving, one of the many exciting 12c features, allows you to selectively archive the data that is no longer needed for the application, yet you can keep it online along with other active data within the same database for the audit compliance.  
In order to access the archived data, all you need to do is just change the visibility setting for the session. This will greatly save you from all the tedious process of the tape backup restore and loading the data back to the database.
Even though the archived data is not displayed by default, it is still residing within the same table and will still be validated for all the constraint rules similar to the active data. Also, it is recommended to compress the archived data to prevent any application query and backup performance issues.
Here is a small demo for this feature.

Read more

Written by rajkiran on Monday June 9, 2014

Image: 2018-06/earphone-1.jpg

Oracle 12c - PDB Administration

 

 

Here are some of the examples showing various PDB Administration activities...

 
{slider Create a new PDB From SEED}
 
 

Read more

Written by rajkiran on Monday June 9, 2014

Image: 2018-06/faucet-2.jpg

Oracle 12c - Non-CDB & CDB

In 12c, for the database creation, you have the option to choose either a non-container database (non-CDB --> pre12c architecture) or a Container database (CDB --> 12c multitenancy architecture). You can easily migrate a non-CDB database into a CDB database. However, You will not be able to migrate a CDB database back to the old architecture, non-CDB database.

By default, database will be created in pre12c mode. "Enable Pluggable Database" clause needs to be used inorder to make it as a CDB.

Read more

Written by rajkiran on Monday June 9, 2014

Image: 2018-06/budha-1.jpg

Oracle 12c - Multi Tenancy Architecture

The most exciting feature in 12c is the multi tenancy architecture which will greatly benefit in the database consolidation with reduction in the overhead of resources needed for maintaining multiple instances and easing up lot of DBA administration activities
For backward compatibility, 12c still supports the traditional architecture. You have to explicitly choose the new architecture option when creating new database.

Read more

Written by rajkiran on Sunday June 8, 2014

Image: 2018-06/ripple-2.jpg

Oracle 12c - Oracle Home Cloning

This note is about cloning and configuring an existing Oracle Home to a new location either on the same server or a different server. Cloning is much quicker especially when you are required to setup multiple database installations.

In this example, an existing Oracle Home on the server, 'kirlinc' is cloned to another server, 'kirlinb' with a different Oracle Home directory.

kirlinc: /data/oracle/app/oracle/product/12.1.0 --> kirlinb:/data/oracle/app/oracle/product/12R1

Read more

Written by rajkiran on Sunday June 8, 2014

Image: 2018-06/faucet-1.jpg