Some of the Oracle Data Guard related questions are listed below. Q 1 What is data guard in simple language? A 1 Your…
60 CommentsExpert Oracle Posts
RMAN performs backup and recovery tasks on the databases and automates administration of the backup strategies. It greatly simplifies backing up, restoring, and recovering database files.…
11 CommentsEvery Oracle Database has a control file as one of its important file. It is a small binary file that records the physical structure of the database.
The control file includes:
– Database name
– Names and locations of associated datafiles and redo log files
– The timestamp of the database creation
– The current log sequence number
– Checkpoint information
To work with RMAN, you must configure several things, which can be default backup type (disk or tape), the number of channels you want to use, and the degree of parallelism.
When you are testing it on your personal system, you probably can get by with RMAN’s default configuration settings. However, for production jobs involving sophisticated backup strategies, you need to customize RMAN’s configuration settings to fulfill all your requirement. You can configure different backup retention policies, for example, for different databases.
Leave a CommentOracle Recovery Manager (RMAN) satisfies the most pressing demands of performant, manageable backup and recovery, for all Oracle data formats.
RMAN provides a common interface, via command line and Enterprise Manager, for backup tasks across different host operating systems.
Below are some of the commonly used RMAN commands which you can run through RMAN command line.
6 Comments You can grant a user restricted access to the base recovery catalog by granting that user read/write access only to that user’s RMAN metadata, also…
1 CommentIt is always recommended to have the recovery catalog to store RMAN related information. In absence of recovery catalog RMAN stores the information in the…
Leave a CommentSome of the good Database Backup-Recovery & RMAN related questions are listed below. Q 1 What is SCN? A 1 The SCN is an Oracle…
28 CommentsSome of the good Real Applications Cluster (RAC) interview questions:
Q 1. How to setup SCAN in 11gr2 and how it works?
SCAN is a single name defined in DNS that resolves to three IP addresses using a round-robin algorithm. The three IP addresses are on the same subnet as RAC’s default public network in the cluster.
4 Comments
The main background processes which are related to Backup & Recovery process are : A) THE CHECKPOINT PROCESS B) THE LOG WRITER PROCESS C) THE ARCHIVER…
Leave a Comment