Installation of Oracle 11g software on Linux

Step 1: Create required groups & users. oinstall is a primary group and dba is a secondary group. -m is used to create home directory for user -g is used define primary group for a user, here primary group is oinstall -G is used to define secondary group for a …

Read More »

Data Guard Protection Modes

Three Types of Data guard Protection Modes Maximum Availability This mode provides the highest level of data protection that is possible without compromising the availability of a primary database.The transactions do not commit until all redo data needed to recover those transactions has been written to the online redo log …

Read More »

Oracle Logical Standby Databases

Logical Standby Databases A logical standby database is initially created as an identical copy of the primary database, but it later can be altered to have a different structure. The logical standby database is updated by executing SQL statements. This allows users to access the standby database for queries and …

Read More »

Standby Database Types

Standby Database Types A standby database is a transactionally consistent copy of an Oracle production database that is initially created from a backup copy of the primary database. Once the standby database is created and configured, Data Guard automatically maintains the standby database by transmitting primary database redo data to …

Read More »

Introduction to Oracle DataGuard

Introduction to Oracle DataGuard Oracle Data Guard ensures high availability, data protection, and disaster recovery for enterprise data. Data Guard provides a comprehensive set of services that create, maintain, manage, and monitor one or more standby databases to enable production Oracle databases to survive disasters and data corruptions. Data Guard …

Read More »

Creating and Managing RMAN Virtual Private Catalogs

rman virtual private catalogs

RMAN Virtual Private Catalogs About Virtual Private Catalogs By default, all of the users of an RMAN recovery catalog have full privileges to insert, update, and delete any metadata in the catalog. For example, if the administrators of two unrelated databases share the same recovery catalog, each administrator could, whether …

Read More »

Configuring the RMAN Backup Retention Policy

Rman Backup Retention Policy

RMAN Backup Retention Policy The backup retention policy specifies which backups must be retained to meet your data recovery requirements. This policy can be based on a recovery window or redundancy. Use the CONFIGURE RETENTION POLICY command to specify the retention policy. Configuring a Redundancy-Based Retention Policy The REDUNDANCY parameter of …

Read More »

RMAN Channels

RMAN Channels The RMAN client directs database server sessions to perform all backup and recovery tasks. What constitutes a session depends on the operating system. For example, on Linux, a server session corresponds to a server process, whereas on Windows it corresponds to a thread within the database service. The …

Read More »
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.

Your information will never be shared
Sign-up for exclusive content. Be the first to hear about DBA Centre Blogs.