Description:- The multitenant option introduced in Oracle Database 12c allows a single container database (CDB) to host multiple separate pluggable databases (PDB). DBMS_PDB package permits to generate an XML metadata…
Read MoreDescription:- Duplicating from an active database doesn’t require any RMAN backup to be taken from the source database.Active database duplication copies the live target database over the network to the…
Read MoreDESCRIPTION: 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 MoreDescription:- 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 MoreDescription:- 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 MoreIn 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 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. Before setup the Display. Need to Apply the private Key Provide the IP address and click open Need to…
Read MoreARCHIVE 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 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 More