07 October 2016
07 October 2016

Explore Oracle Database In-Memory – Part 2

0
Oracle In-Memory is fully compatible with Oracle multitenant database architecture, allowing us to take advantage of fast In-Memory and low-cost storage. This multitenant architecture was also introduced in Oracle 12c, featuring multiple pluggable databases (PDBs) within a container database (CDB). This makes it easy to consolidate databases onto the cloud, deliver a high density of schema-based consolidation without making changes… … Read more
0
21 September 2016
21 September 2016

Explore Oracle Database In-Memory – Part 1

1
The Oracle Database In-Memory option was introduced in Oracle 12c (12.1.0.2 patch set). By using the In-Memory option, businesses can benefit from better decisions made in real time, improved productivity, increased competitiveness and lowered costs. The Oracle In-Memory option is designed to fit both Data warehouse and mixed workload OLTP databases, and can be deployed with any existing application that%… Read more
1
08 July 2015
08 July 2015

Why Virtual Private Catalog?

2
Recovery Manager (RMAN) is the preferred tool to backup and recover the Oracle Database. You can use recovery catalog or the control file of the target database for RMAN Repository, but Recovery Catalog is the preferred method as it offers several advantages over the others, like reporting operations, simple recovery in case of control file damage, and more. Generally in… Read more
2
02 February 2015
02 February 2015

Oracle Database 12c – RMAN New Features: Part 3

1
Oracle Database 12c has new enhancements and additions in Recovery Manager (RMAN).  The Recovery Manager continues to enhance and extend the reliability, efficiency, and availability of Oracle Database Backup and Recovery. In this article series, I will be explaining the new features and how they help the Oracle community. See new features around SYSBACKUP, pluggable databases, and the SQL interfac… Read more
1
30 December 2014
30 December 2014

Oracle GoldenGate 12c New Features – Part 2

1
The Oracle GoldenGate software package delivers low-impact, real-time data integration and transactional data replication across heterogeneous systems for continuous availability, zero-downtime migration, and business intelligence. Oracle GoldenGate 12c empowers organizations to capture, route, transform, and deliver transactional data between heterogeneous databases in real time with minimal overhead.… Read more
1
01 December 2014
01 December 2014

Oracle Database 12c – RMAN New Features: Part 2

1
Oracle Database 12c has new enhancements and additions to Recovery Manager (RMAN).  The Recovery Manager continues to enhance and extend the reliability, efficiency, and availability of Oracle Database Backup and Recovery. In this article series, I will be explaining the new features and how it will help the Oracle community. See new features covered in Part 1 – Oracle Databas… Read more
1
29 October 2014
29 October 2014

Oracle GoldenGate 12c New Features – Part 1

0
The Oracle GoldenGate software package delivers low-impact, real-time data integration and transactional data replication across heterogeneous systems for continuous availability, zero-downtime migration, and business intelligence. Oracle GoldenGate 12c empowers organizations to capture, route, transform, and deliver transactional data between heterogeneous databases in real time with minimal overhead.  In 12c, it is now available with new features for all major operating… Read more
0
29 September 2014
29 September 2014

Oracle Database 12c – RMAN New Features: Part1

10
Oracle Database 12c has new enhancements and additions in Recovery Manager (RMAN).  The Recovery Manager continues to enhance and extend the reliability, efficiency, and availability of Oracle Database Backup and Recovery. In this article series, I will be explaining the new features and how it will help Oracle community. In this article I will cover: SQL Interface Improvements SYSBACKUP Privileg… Read more
10
20 August 2014
20 August 2014

Should you install or clone Oracle Home?

3
What is cloning? Cloning is a process of copying an existing installation to a different server or location. Cloning is similar to an Oracle installation except Oracle universal installation performs the actions in a special mode called “clone mode”. Starting from 10g onwards, Oracle supports cloning and users can easily clone existing Oracle installations. The source and destination servers should… Read more
3
03 July 2014
03 July 2014

Oracle 12c – One Database and One Solution

1
Oracle Database 12c is designed for the cloud and introduces Multitenant Architecture with more than 500 new features. It enables customers to make more efficient use of their resources and reduce IT costs. What is Multitenant Architecture? Oracle 12c now introduces multitenant architecture featuring pluggable databases, which makes it easy to consolidate your databases on to the cloud, deliver hig… Read more
1

Oracle Database Replay for your Workload Test

0
Database replay was introduced in Oracle 11g R1, and it allows you to capture workloads on a Production system and replay them in your Development or test environments while maintaining the unique characteristics of the workload. This enables the user to test a variety of system changes such as hardware/software migration, operating system/ database upgrade, patches, database config changes etc… Read more
0
01 March 2013
01 March 2013

Oracle Database Source Control made easy using Red Gate’s new tool

0
Red Gate is launching new tool “Source Control for Oracle tool” on March 12, 2013. How this tool can help you: Manual processes to script out database objects and check in them into SVN or TFS, can be time consuming and error prone. Source Control for Oracle automates scripting of objects and check-in to SVN or TFS. Developers and DBAs… Read more
0
20 September 2012
20 September 2012

Convert Single Instance to RAC – Part 1: Duplicate DB using RMAN

4
This article is for users of Oracle Database version 10g+ who want to convert their Oracle single instance database to RAC. I will provide detailed procedure for converting non-RAC database to RAC and we will use Oracle Automatic storage management (ASM) as shared storage. In general, if the database is small then you can consider installing a new RAC database… … Read more
4