What are the components of the physical database structure of Oracle database? Three fundamental types of physical files make up an Oracle database: Control files. Datafiles. Redo log files. What are the components of the logical database structure of Oracle database? The logical structure of Oracle database consists of tablespaces and schema objects. What is …
10 Oracle DBA interview questions you should know Read More »
When I was trying to drop a tablespace, I got then below error. ORA-23515: materialized views and/or their indices exist in the tablespace The Oracle documentation has given a clear information about the resolution steps we need to perform. According to Oracle ORA-23515 means. Description ORA-23515: materialized views and/or their indices exist in the tablespace …
ORA-23515: materialized views and/or their indices exist in the tablespace Read More »
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 …