ORA-02019: CONNECTION DESCRIPTION FOR REMOTE DATABASE NOT FOUND.
DESCRIPTION: In this blog,we are going to know about how to overcome ORA-02019 error in database. CAUSE: An attempt was made to connect or log in to a remote database…
Read MorePerforming point in time recovery using RMAN
Description:- RMAN database point-in-time recovery (DBPITR) restores the database from RMAN backups. RMAN will be consider all ( required ) backups (full, incremental, transectional) to restore or roll forward to…
Read MoreRESTORE DROPPED TABLES FROM RECYCLE BIN
DESCRIPTION: In this blog,we are going to see how to restore dropped table from recyclebin. Oracle database has the recycle bin which is a data dictionary table and contains information…
Read MoreTransportable Tablespace using RMAN
DESCRIPTION: In this article, we are going to know how to perform Transportable tablespace using Rman. [oracle@trichy BIJU1]$ rman target / Recovery Manager: Release 12.2.0.1.0 - Production on Mon Jan…
Read MoreHow to Converting Non CDB to CDB in Oracle 12c
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 MoreRMAN Active based Cloning Database using Oracle 12c
Description:- 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 MoreRestore 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 More