Restore control file without backup
DESCRIPTION: In this article we are going to see how to Restore control file without backup. Step 1 – Start the instance [oracle@trichydoyen ~]$ export ORACLE_SID=BIJU1 [oracle@trichydoyen ~]$ sqlplus /…
Read MoreRMAN Backup based Cloning Database using Oracle 12c
Description:- RMAN has the ability to duplicate, or clone, a database from a backup or from an active database. It is possible to create a duplicate database on a remote…
Read MoreHow to Recover From Lost or Missing Database Parameter Files Without any Backup
Description:- If you lost both spfile and pfile of the instance when it is up and running. Suppose you don’t have any type of rman or autobackup also. How can…
Read MoreCREATING A DATABASE USING REMOTE DATABASE FILES
In this Blog we are going to learn about how create the database in local server by using another database files from remote server. For this blog i have used my oracle 12c database. Before started to create we should get the database files from remote server by using SCP command. PRE CREATION OF DATABASE: Required database files are PARAMETER FILE(PFILE),DATAFILE, CONTROL FILE, REDOLOG FILE. Then we should create a path location for that remote files, its should be same as a remote path location for database files. Else database cannot identify the files. Step 1: Startup the database with remote database pfile: [oracle@oracle ~]$ export ORACLE_SID=gdb1 [oracle@oracle ~]$ export ORACLE_HOME=/u01/app/oracle/product/12.2.0.1/db_1 [oracle@oracle ~]$ export PATH=$PATH:$ORACLE_HOME/bin [oracle@oracle ~]$ sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Sat Jan 23 11:18:36 2021 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 524288000 bytes Fixed Size 8794696 bytes Variable Size 381685176 bytes Database Buffers 130023424 bytes Redo Buffers 3784704 bytes ORA-65101: container database set up incorrectly SQL> alter system set ENABLE_PLUGGABLE_DATABASE=FALSE Scope=spfile; alter system set ENABLE_PLUGGABLE_DATABASE=FALSE Scope=spfile * ERROR at line 1: ORA-32001: write to SPFILE requested but no SPFILE is in use Note: Above error is came because of database is running in pfile, there is no spfile for this database so we can’t change anything using command like “scope=spfile”. For that we creating a spfile from pfile using below command: SQL> create spfile from pfile; File created. SQL> shut abort…
Read MoreMANUAL DATABASE CREATION
MANUAL DATABASE CREATION IN ORACLE LINUX In this blog describe the installation of Oracle database 12c release 2 on Oracle Linux 6 as manual method. First, you should have installed …
Read MoreHow to enable Xclock in cloud environment via putty.
How to enable Xclock in cloud environment via putty. Before setup the Display. Need to Apply the private Key Provide the IP address and click open Need to…
Read MoreALTERING ARCHIVE LOG DESTINATION:
ARCHIVE LOG: In Oracle, the Archive log is a copy of a filled redo log file, The process of converting the redo log into archiving log file is called Archiving.…
Read MoreImporting a .dmp file in a Pluggable database
Importing a traditionally exported dump file in a Pluggable database: Step 1: Creating a new pluggable database : Create a new pluggable database(dbca) Step 2: Checking the status of the…
Read MoreCONVERTING NON-CONTAINER DATABASE TO CONTAINER DATABASE
CONVERTING NON-CONTAINER DATABASE TO CONTAINER DATABASE In this tutorial, we are going to learn about how to convert a non-container database to a container database. Before that, we need to install both the database i.e…
Read MoreCreating A Multitenant Database in Oracle 19c using DBCA.
Description:- In this Blog,we are going to Creating A MultiTenant Database In Oracle 19c. The primary database that contains multiple plugged-in databases. Many operations can be performed at the container…
Read More