EXPORT AND IMPORT DATAPUMP IN DATABASE_LINK PARAMETER
In this blog we are going to learn about the export and import in datapump using database link. DESCRIPTION: A database link , is a schema object in one database that…
Read MoreORACLE DATABSE CLONING USING COLD BACKUP
ORACLE DATABSE CLONING USING COLD BACKUP DESCRIPTION: The Cold database backup is, while taking backup or doing cloning, we need to shutdown the source database. This method is usually used for test server when database is in no archive log mode. First we want to take a backup of control file, note down the data file location, and finally shut down the database in source database side. Second. Transfer the data file, temp file to target database, create a pfile(init.ora) for target database. Then start the target database in no mount stage, then in there recreate a control file, then open the database in reset logs. Send the datafile,log files and control files to target destination: [oracle@oracle trainee]$ scp -r *.log oracle@192.168.1.122:/u01/shan The authenticity of host ‘192.168.1.122 (192.168.1.122)’ can’t be established. RSA key fingerprint is 9b:35:ae:ab:bf:6b:33:b4:43:86:f5:98:8b:bb:11:1c. Are you sure you want to continue connecting (yes/no)? oracle Please type ‘yes’ or ‘no’: yes oracle@192.168.1.122’s password: redo01.log 100% 200MB 3.1MB/s 01:05 redo02.log 100% 200MB 4.0MB/s 00:50 redo03.log 100% 200MB 3.5MB/s 00:58 [oracle@oracle trainee]$ scp -r users01.dbf oracle@192.168.1.122:/u01/shan oracle@192.168.1.122’s password: users01.dbf 100% 5128KB 5.0MB/s 00:01 [oracle@oracle trainee]$ scp -r undotbs01.dbf oracle@192.168.1.122:/u01/shan oracle@192.168.1.122’s password: undotbs01.dbf 100% 70MB 3.7MB/s 00:19 [oracle@oracle trainee]$ scp -r temp01.dbf oracle@192.168.1.122:/u01/shan oracle@192.168.1.122’s password: temp01.dbf 100% 32MB 2.9MB/s 00:11…
Read MoreAPEX INSTALLATION(5.1) in ORACLE12c
APEX INSTALLATION(5.1) in ORACLE12c In this blog we are going install the apex 5.1. Here, i have a database with 12c. So here i explained about this install steps at database directly. If we have a database then, follow below steps.…
Read MoreRECOVER THE LOST DATAFILE USNIG FLASHBACK SCN CONCEPT
RECOVER THE LOST DATAFILE USNIG FLASHBACK SCN CONCEPT In this blog we are going to learn about how to recover the lost data file by using flashback database in SCN method You can restore any lost or dropped datafile with flashback and rman after a tablespace is dropped. First of all, create a tablespace, user a table and insert data as your wish. CONNECT TO THE DATABASE AND…
Read MoreEXPORT AND IMPORT DATAPUMP IN REMAP_DATA & REMAP_SCHEMA
EXPORT AND IMPORT DATA PUMP IN REMAP_DATA & REMAP_SCHEMA In this blog we are going to learn about EXPORT AND IMPORT in data pump using remap data and remap schema…
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 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 More