How to Recover Controlfile without Backup?

recover controlfile without backup

Hello Friends, In this article we are going to discus how to recover our controlfile without backup. Suppose if your controlfile is deleted accidently and you don’t have any backup then what is the why to recover them. So here you can find out the manual re-creation method to your deleted controlfiles. No need to … Read more

How to create a database link

how to create db link

How to create DB Link In this article, I’m going to show you how to create DB Link step by step. How to create a database link, A database link is a schema object in one database that enables you to access objects on another database. The other database need not be an Oracle Database … Read more

What is SQL, DBMS, and RDBMS

What is SQL DBMS and RDBMS

What is SQL, DBMS and RDBMS Hello friends, in this article we going to discuss what is SQL ( Structured Query Language), DBMS (Database Management System), and RDBMS (Relational Database Management System), also understand what is the difference between DBMS and RDBMS. What is SQL? SQL (Structured Query Language) is used for Data Manipulation and … Read more

Using SQL Select Statements

use SQL select statement

How to use SQL select statement? In this article, we are going to learn how to use SQL select statement to retrieve data from tables or views. In the database, data stored in tables format and if you want to check that data then you should know how to use Oracle SQL statements. Important points for … Read more

How to Install ORACLE 12c R1 on ORACLE Linux 7 step by step

How to Install ORACLE 12c R1 on ORACLE Linux 7 step by step

In this post, I’m going to demonstrate to you how to install ORACLE 12c Release 1 (12.1) on ORACLE LINUX-7 64 bit step by step. For ORACLE 12c  installation minimum 2GB swap required. Download ORACLE 12c R1 software form www.oracle.com accept OTN License Agreement, it’s download in two parts and it’s a zip file. Start Oracle Installation … Read more

How to Restore RMAN Backup with a Different Database Name

How to Restore RMAN Backup with a Different Database Name

Hello friends, in this article I’m going to demonstrate to you Restore RMAN Backup with a Different Database Name on New Server step by step guide. Steps to Clone database to different DB name use RMAN Full or Level 0 Database RMAN backup. Controlfile backup. spfile backup. Password file backup. Taking Full or Level 0 … Read more

How to Partitioning in existing table using EXCHANGE PARTITION

How to Partitioning in existing table using EXCHANGE PARTITION

Partitioning in existing table Hello, friends in this article we are going to disuse how to partitioning in the existing table using EXCHANGE PARTITION. If you want to learn more about partition click here. In this article, we are going to perform the below actions. Create a sample table and insert some records in this … Read more

Transport Tablespace from Linux to Windows in ORACLE 11g & 10g

Transport Tablespace from Linux to Windows in ORACLE 11g & 10

Transport tablespace from Linux to windows platform step by step In this tutorial, I’m going to show you how Transport tablespace from Linux to windows platform, in oracle Database we can transport tablespace and Database from one platform to another platform. In this topic, I’m using Redhat Linux 6 (64 bit) and Microsoft Windows 7 … Read more

How to Transport Database from Linux to windows?

How to Transport Database from Linux to windows

Transport Database from Linux to Windows Hello, friends in this article we are going to discuss How to Transport Database from Linux to windows. Transportable Database (TDB) requires all the datafiles format must be converted to the targeted platform format. How Migrate Database from Linux to windows? During TDB, the datafiles conversion can take place one … Read more

How to Convert the NON-CDB database to CDB

How to Convert the NON-CDB database to CDB

In this article, I’m going to show you how to convert a NON-CDB database into cdb database. Convert non-container database to multitenant pluggable database with Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 – 64bit. Run following commands on both machines. Output from Non-cdb database Output from cdb database Output from cdb database Run following commands … Read more