Showing posts with label ORACLE. Show all posts
Showing posts with label ORACLE. Show all posts

Sunday, 4 December 2022

How to Multiplex Control Files in Oracle Database

 How to Multiplex Control Files in Oracle Database?


After this article, you will have the understanding of,
  • How to add one or more control files in oracle database? 
  • Why do we require control file multiplexing? 
  • Why is it important to have multiple copies of control files in your oracle base?

Control files serve a very important role and are very crucial for database working because of the information stored inside them. You can't take the risk of losing your control file especially when the database is running. When database is properly shutdown, even if you lose your control file, you can recreate it without much trouble. But the general idea is to secure the control file but taking regular backups and also multiplexing the same. By multiplexing, we simply mean to keep multiple copies of the same file in different locations.

Monday, 24 August 2020

Difference between Direct Path Load and Conventional Load

Difference between Direct Path Load and Conventional Load

This article will help you quickly understand the concept of direct  path load and conventional load within Oracle Database. 

So to begin, SQL*Loader provides 2 methods for loading data,

  • Conventional Path Load (This is by default used)
  • Direct Path load

Tuesday, 26 June 2018

Overview to Oracle Instance Memory Structures - SGA Explained

What is SGA or System Global Area in Oracle Database? A complete explanation guide to Oracle Memory Structures? Various components of SGA Explained in detail.



SGA also known as Shared Global Area is a very important part of Oracle Memory Architecture. As I have mentioned in one of my previous posts regarding the Explanation of Oracle Database Server that SGA is the part of Oracle Instance which includes some memory components and some background process which work together to keep the Oracle Database Server running.

Overview to Oracle Process Architecture - Background Process Explained

What are the Background Processes that run in Oracle Server? What is their functionality?

Oracle Server uses multiple background processes which help in handling different processes simultaneously. These processes are capable of handling single user request or multiple user requests depending upon the environment need. These background processes are nothing but some consolidated functions which are handled by multiple database programs running for each and every user process. Background processes asynchronously perform I/O and monitor other Oracle Database processes to provide increased parallelism for better performance and reliability.

Saturday, 7 April 2018

Possible network disconnect with primary database | Oracle Standby

Possible network disconnect with primary database in Oracle Standby Alert Log


Issue:

After starting the log shipping in Standby from Primary, the below mentioned warnings/errors started popping up in the Standby Alert log:

RFS[418]: Possible network disconnect with primary database
RFS[421]: Possible network disconnect with primary database
Thu Sep 21 11:07:50 2017
RFS[400]: Possible network disconnect with primary database
Thu Sep 21 11:07:53 2017
RFS[411]: Possible network disconnect with primary database

Sunday, 25 March 2018

Understanding System Monitor Process in Oracle Database

Quick reference to System Monitor (SMON) process in Oracle Database

What is a System Monitor SMON Process in Oracle Architecture and What it does?

System Monitor Process SMON in Oracle Architecture

Thursday, 22 March 2018

Understanding Log Writer Process LGWr in Oracle Database

Quick Overview to Log Writer Process LGWr- Oracle Database

What is LGWr process in Oracle Database? What is the use of LGWr process and how it works?

Log Writer Process LGWr in Oracle Architecture

Wednesday, 21 March 2018

Understanding DBWr process and it's significance - Oracle Database

Quick reference to Database Writer Process (DBWr) in Oracle Database

What is a DBWr process? What is it's significance in Oracle Database? When and how this process is called?

Database Writer Process DBWr in Oracle Architecture

Tuesday, 17 October 2017

Catalog backup files in RMAN | Oracle Database

Catalog the backup files in Oracle RMAN Repository

How to Catalog files in Oracle RMAN Repository? How to add files in RMAN Catalog?

Recovery Manager Catalog Oracle Database

ORA-01110 ORA-01180: cannot create datafile | Oracle Database

 ORA-01110 & ORA-01180: can not create datafile in Oracle Database

ORA-01110 ORA-01180 Oracle Errors

Thursday, 12 October 2017

ORA-00245: control file backup failed | Oracle RAC | Solved

ORA-00245: control file backup failed; target is likely on a local file system

The Cause and Resolution to ORA-00245


ORA-00245 RMAN Backup Failure Oracle Errors

Tuesday, 10 October 2017

Monday, 9 October 2017

Using Fast Start Parallel Rollback in Oracle | Oracle Parameters

Using Fast Start Parallel Rollback in Oracle Database

Oracle Parameters - Fast Start Parallel Rollback - Oracle Database

CREATE, DROP or ADD Tempfile in Oracle Database

CREATE, DROP or ADD Temporary datafile in Oracle Database

Managing Temporary tablespace in Oracle Database

We all are aware of the TEMP Tablespace which is a very useful part of oracle database to perform all the temporary operations liking sorting etc. Below shown are some commands to manage these temporary tablespaces or datafiles:

To view information about Temporary Tablespaces and Tempfiles,

SQL>select * from dba_temp_files;
SQL>select * from v$tempfile;

To view information about free space in tempfiles,

SQL>select * from V$TEMP_SPACE_HEADER;

To create a new Temporary Tablespace,

SQL> create temporary tablespace TEMP tempfile '/u02/database/mydb/temp_01.dbf' SIZE 500m autoextend on next 10M maxsize unlimited;

To drop an existing Temporary Tablespace,

SQL> Drop tablespace TEMP including contents and datafiles;

To add Tempfile in Temporary Tablespace,

SQL> Alter tablespace temp add tempfile '/u02/database/mydb/temp_02.dbf' size 50m reuse autoextend on next 1m maxsize 500m;

Wednesday, 26 July 2017

RMAN Incremental Backup Script for Oracle Database

RMAN Incremental Backup Script for Oracle Database - Level 1 Backup


RMAN Script to take Incremental Oracle database Backup (L1) as well as delete the unwanted backups and archive logs

Please find below the script:


run {
    allocate channel ch1 type disk connect 'sys/********@db_name' ;
    allocate channel ch2 type disk connect 'sys/********@db_name' ;
    allocate channel ch3 type disk connect 'sys/********@db_name' ;
    allocate channel ch4 type disk connect 'sys/********@db_name' ;
    allocate channel ch5 type disk connect 'sys/********@db_name' ;
    allocate channel ch6 type disk connect 'sys/********@db_name' ;

RMAN Script to take full database Backup | Oracle Database

RMAN Script to take full database Backup L0- Oracle Database


RMAN Script to take full Oracle database Backup or also called as Level 0 Backup as well as delete the unwanted backups and archive logs

Please find below the script:


run {
    allocate channel ch1 type disk connect 'sys/********@db_name' ;
    allocate channel ch2 type disk connect 'sys/********@db_name' ;
    allocate channel ch3 type disk connect 'sys/********@db_name' ;
    allocate channel ch4 type disk connect 'sys/********@db_name' ;
    allocate channel ch5 type disk connect 'sys/********@db_name' ;
    allocate channel ch6 type disk connect 'sys/********@db_name' ;

Monday, 24 July 2017

Different Logs Locations in Oracle RAC Environment | Oracle Database

Different Logs Locations in Oracle RAC Environment | Oracle Database

In a single instance Oracle Database Environment (without ASM), it is easier to track different logs which helps you find information regarding different running processes, active or inactive sessions, active/inactive transactions, Start/Shutdown instances, errors or issues and a lot of more details. But in case of a Oracle RAC Environment, we have a lot of more Oracle Components in the Architecture which increases the workspace for a DBA and it gets trouble-full to memorize everything. In case of issues in Oracle RAC Environment, it gets very difficult as there are a number of running processes and threads which will be having their individual logs to shows their activity status. 

AWR, ADDM and ASH Reports Quick Reference | Oracle Database

Difference between AWR, ADDM and ASH Reports in Oracle Performance Tuning

What is AWR (Automatic Workload Repository) Report in Oracle Database and what kind of information does it provide? What is ADDM (Automatic Database Diagnostic Monitoring) Report in Oracle Database and what kind of Information does it provide? What is ASH (Active Session History) Report and what kind of Information does it provide in Oracle Database?