It 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 CommentAuthor: Brijesh Gogia
I’m an experienced Cloud/Oracle Applications/DBA Architect with more than 15 years of full-time DBA/Architect experience. I have gained wide knowledge on Oracle and Non-Oracle software stack running on-prem and on Cloud and have worked on several big projects for multi-national companies. I enjoy working with leading-edge technology and have a passion for Cloud architecture, automation, database performance, and stability. Thankfully my work allows me time for researching new technologies (and to write about them).
[sc name="linkedin"][/sc]
Some 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 CommentWe had implemented SSL on our R12.1.3 instance according to below MOS Note Id: 376700.1 Enabling SSL in Release 12 After starting up application, we…
Leave a CommentWe generally receive few errors related to asmsnmp user while using ASM. Few of them are : Could not validate ASMSNMP password due to following error- “ORA-01031:…
4 CommentsWhat is ‘Gather Statistics’?
————————————-
When the data is updated continuously by updating, inserting or deleting of by users (Functional/Technical/End users), it becomes necessary to gather statistics as the performance of database goes down.
Oracle has provided a nice solution for it. This can be done by simply submitting a request from EBS. Oracle E-Business Suite provides concurrent programs that use the package FND_STATS to gather statistics for your applications database objects.
4 CommentsParallel Concurrent Processing (PCP):
PCP is the method by which we configure the Concurrent Manager in a multi tier environment with 2 or more concurrent nodes. This allows concurrent processing load to be distributed across the nodes and provides high availability in case of node failure. Managers migrate to surviving node (failover)when one of the concurrent nodes goes down and migrate back (failback) when the failed node comes back.
8 CommentsAfter creating 11g R2 RAC database for the EBS R12, we wanted to enable multiplexing for the control files. Oracle recommends multiplexing the control files . We are using ASM for the storage of control files.
At the time of creating the database by dbca we can do multiplexing or we can also do later manually as described below.
Goal:- We have control file in the +DATA disk group and we want to also keep it in another disk group +OCR_VOTE for multiplexing.
Some useful RAC 11G commands are documented below. STOP SEQUENCE COMMAND DESCRIPTION —————————————————————————————— srvctl stop database -d ORCL STOP DATABASE srvctl stop instance -d ORCL…
14 Comments