In this post, we are going to discuss complete backup and recovery strategies in Oracle database 11g. There are different types we can take a database backup. The reasons why Oracle has introduced so many backup options are 1.logical backup cannot be considered as the main backup option since we don’t have the concept of …
In this post, we are going to perform an activity on audit table. We are going to explore various auditing types in Oracle 11g. According to Oracle, Auditing is the monitoring and recording of selected user database actions. In standard auditing, you use initialization parameters and the AUDITNOAUDIT SQL statements to audit SQL statements, privileges, and schema objects, …
In this post, we will discuss Startup and shutdown modes of Oracle database. The startup modes include startup open, startup mount, startup nomount and shutdown modes include shutdown abort, shutdown transactional, shutdown normal, shutdown immediate. Startup and shutdown modes oracle database Startup modes nomount state: This stage is only used when first creating a database …
In this Structure of a Database post, we will learn about the physical database design. An Oracle database is a set of files that store Oracle data in persistent disk storage. This section discusses the database files generated when you issue a CREATE DATABASE statement: Oracle database is nothing but the physical files, the following are …
In Oracle 11g, each Oracle database has a list of valid database users. To access a database, a user must run a database application and connect to the database instance using a valid user name defined in the database. This section explains how to manage users for a database Oracle 11g User Management There are …
What is a control file? An Oracle control file is a binary file necessary for the database to start and operate successfully. oracle scans the content of the control file in the mount state for the physical location of datafile and redo log files. Oracle continuously updates the control file during the functionality of the …
In this post, we will discuss one of the important physical files in Oracle database that is Online Redo Log File. The activity for the online redo log file can be found here Oracle 11g Online Redo Log File Management What is an Online Redo Log File The most crucial structure for recovery operations is the …
In this post, we will discuss the step by step guide to create a temporary tablespace and drop existing temporary tablespace. Steps to create a new temporary tablespace. Check the existing temporary tablespace. Create a new temporary tablespace. Make the newly created temporary tablespace as default. Kill the existing sessions which are using existing temporary …
In this post, we will discuss networking concepts in Oracle Database 11g. The post will cover different types of networking concepts like listener.ora, tnsnames.ora and sqlnet.ora we also learn about materialized views and different types of materialized views. Oracle Networking Oracle Networking facilitates accessing of data existing on a remote server whether it is client …
In this post, we are going to learn how to configure listener.ora, tnsnames.ora and how to create a materialized views Configure Oracle Networking Configure listener.ora A listener is configured with one or more listening protocol addresses, information about supported services, and parameters that control its run-time behavior. The listener configuration is stored in a configuration …
Configure Listener.ora and tnsnames.ora in orcle Read More »