Home
Videos uploaded by user “Parag Mahalle”
How to Export and Import Full Oracle Database using Datapump Utility.
 
05:37
we can export ( expdp ) and import ( impdp ) Full Oracle Database using datapump utility. we can use expdp for export and impdp for import. In this video i am showing you how to export Full Oracle Database and how to import Schema, Tablespace, Tables, Viwes using Datapump utility. It is very easy to understand.
Views: 3590 Parag Mahalle
How to configure Rman Controlfile Autobackup
 
03:35
Today I am showing you How to Configure Controlfile AutoBackup using Rman. 1. We can configure Controlfile Autobackup using Configure Control file AutoBackup On; Parameter 2. When we configure this parameter, that time it automatically take a backup of control file and spfile. 3. It can store AutoBackup of control file & spfile in fast recovery area /AutoBackup Directory. It is a default directory. 4. We run Backup command that time it take automatically backup of control file and spfile. 5. Suppose we want to take a AutoBackup of Controlfile on different location so we configure parameter 6. Configure Control file Auto Backup format for device type disk to '%F'; (In the place of %F we set location of AutoBackup). 7. If we set a new format ' /u01/app/backup/%F '. that time it takes a Auto Backup in new location.
Views: 499 Parag Mahalle
How to Create, Alter, Resize, Drop Tablespace (Tablespace Management #1)
 
07:37
Hello Today I am showing you how to create tablespace. Alter tablespace datafile using fileid & filename and resize datafile. How to check Tablespace Size. How to check datafile Size in MB. How to drop Tablespace including contents and all Datafiles of these tablespace.
Views: 1136 Parag Mahalle
How to take Rman Hot Database Backup using Rman
 
03:41
How to take Rman Hot Database Backup using Rman
Views: 508 Parag Mahalle
How to perform Remap Schema Export &  Import utility in Oracle Database. /* Step By Step /*
 
07:39
In this video i am showing you How we can perform Remap schema in export and import utility in Oracle Database. Remap Schema: we can to create a duplicate user, using Remaping schema. Suppose I have one schema scott. In this user no. of Tables, Indexes, Views. I want new Schema Test Duplicate Like Scott Schema. So, I am using Remap Schema command in export and import utility This is very easy to implement.
Views: 957 Parag Mahalle
How to Export and Import Using Parameter file ( Parfile ). /* Step By Step */
 
04:33
My Today’s Scenario How to use parfile in Export and Import. Parfile export and Import used .par extension. Suppose Export command is very lengthy that case we create a parfile. In this file we write a Export command and file extension is .par File name= exp_scott.par -----------------------------------------------------------------------------------directory=mydump logfile=scott_exp.log dumpfile=scott_exp.dmp schemas=‘SCOTT’exclude=table:"IN(‘EMP',’DEPT’)“
Views: 1281 Parag Mahalle
How to Perform Incomplete Recovery Until Sequence #  &  Thread #  Using Rman. /* Step By Step */
 
10:40
We can Perform incomplete recovery Until Sequence # And Thread # Using Rman. It is Very easy to understand. Incomplete recovery means The Database upto the specific point in time in the past, before the recovery operation was required. We can create Incomplete recovery in many ways but in this video i am showing you incomplete recovery until Sequence # and Thread # using Rman backup.
Views: 766 Parag Mahalle
How to perform Oracle Attach job using Export & Import Datapump utility. /* Step By Step /*
 
10:23
How to perform Attach Job using export (Expdp)and import (Impdp) Datapump utility in Oracle Database In this video i am showing you When we perform Export (Expdp)Database and that time for some reason we want to stop export database that time we create a job. We stop this export database job and when we have free we can attach this job. It is very easy to implemrnt.
Views: 1106 Parag Mahalle
How to perform Rman backup with Parallism command. /Step by step/*
 
06:17
Today i am showing you How to perform Rman backup with Parallism command. You follow this steps. it is very easy to understand.
Views: 235 Parag Mahalle
How to Encrypt Oracle Rman Backup without wallet step by step
 
03:55
Today I am showing you How to Encrypt oracle Rman Backup without wallet. 1. We want to Encrypt Rman backup for the Organization security. 2. You know that all Rman backup is not Encrypted backup. 3. So, Today I am showing you how to encrypt that backup files 4.When you take the backup using Rman whether it is Full backup or whether it is tablespace and Datafile backup. There are two ways to Encrypt Rman Backup. 1.Transport Encryption. 2. password Encryption. Today I am showing you Password Encryption.
Views: 281 Parag Mahalle
Restore Spfile From Autobackup Using Rman
 
06:43
Hello Friends Today, In this video I am showing you 1. How to Restore Spfile from Rman Autobackup. 1. Database is in Archivelog Mode. 2. Configure Rman Controlfile Autobackup on. 3. we have Rman database backup. 4. Suppose Spfile is lost so, we can restore spfile using Rman. 5. First Database is shutdown in normally or abort. 6. go to Rman Prompt and startup Database in Nomount mode forcefully. startup nomount force 7. restore spfile from '/Spfile Autobackup destination path/' 8. After restore database is open. follow this step it is very easy to understand. I Love my all Subscriber. Please Like & Share my Video . and Subscribe my Channel.
Views: 193 Parag Mahalle
How to Perform Incomplete Recovery Until Scn No. using Rman */Step By Step /*
 
08:40
We can perform Incomplete Recovery until Scn no. Using Rman. It is very easy using Rman. we can doing various types of Incomplete Recovery using Rman. But I am Showing you on this video only SCN No. base Incomplete Recovery. Please follow this steps and learn how can we do incomplete recovery using scn no.
Views: 704 Parag Mahalle
How to split dumpfiles into multiple files and multiple directories. /* step By Step */
 
10:44
When you Export full database and your database size is big ( like 20gb – 30gb ). So, How to break dumpfile in two or more pieces. And Your Export backup are store in these Hard disk (directory) and these HDD has less space (5gb) and your backup size is (10gb). That time we can export these backup in 2 HDD (directories). First backup piece is store in default directory and next backup piece is store in another HDD (directory).
Views: 796 Parag Mahalle
How to Exclude Schemas and Tables using Export and Import. /* Step By Step */
 
08:33
Today I am showing you 1. How to perform Export and Import with Exclude Schemas and Tables in Oracle Datapump utility. When we take a Export Full database Backup but I don’t take a backup of Scott and System Schemas. That time we can use Exclude command. We can Export Scott Schema but exclude EMP , DEPT Tables. If the expdp exclude parameter is used directly from the command line (and  not in a parameter file (parfile)), the special characters (quote marks) in the exclude clause may need to be escaped with  backslash (\) character . Because of this, it is recommended that you always use a parameter file (parfile). In Windows we used round bracket ( ) in IN clouse. But In Linux, we used { } bracket. Exclude Schema: expdp system/admin directory=mydump FULL=Y dumpfile=full.dmp exclude=schema:\"=\'SCOTT\'\“ expdp system/admin directory=mydump FULL=Y dumpfile=full.dmp exclude=schema:\”In{\'SCOTT\‘,\’SYSTEM\’}\“ Exclude Tables: expdp system/admin directory=mydump schemas='SCOTT' dumpfile=scott.dmp exclude=table:\"=\'EMP\'\“ OR expdp system/admin directory=mydump dumpfile=scott.dmp schemas=‘SCOTT’ exclude=:\"IN {\’EMP\',\’ DEPT\‘}\“ It is very easy to understand.
Views: 1371 Parag Mahalle
How to Export and Import Contents data metadata and all step by step
 
07:48
How to perform Export Database without structure Data_only, with structure Metadata_only and All in Oracle Datapump utility. Hint: All means Data and Metadata. ( All is Default ) When we take a Export Full database Backup without structure It take export backup of Data_only. When we take a Export Full database Backup with structure It take export backup of Metadata_only. When we take a Export Full database Backup with structure It take export backup of full database (All ) Command. Its Default
Views: 1040 Parag Mahalle
How to run Background jobs in Oracle Export and Import Datapump /* step by step */
 
05:59
In this video i am showing you How to run Background jobs in Oracle Export and Import. Suppose I want to Export Database, Schemas job in background. So, use nohup in the front of expdp command Nohup command is used for jobs are running in the background.
Views: 1131 Parag Mahalle
How to perform Incremental Backup using Block change tracking  /* step by step /*
 
08:38
How to perform incremental backup using Block change tracking in Rman Block Change Tracking : ----------------------------------------------- You can perform fast incremental backup by enabling block change tracking. when perform incremental backup, It writes to a file the physical address of each block that is changed. Rman can look the block change tracking file & backup only those blocks refer there. It does not have to scan every block to see if it has changed since the last backup. How to Enable block change tracking? ----------------------------------------------------------------------- Alter database enable block change tracking using file (file path) reuse; 1. We can check Block change tracking is enable or not using v$block_change_tracking View. 2. When block change tracking is enable CTWR process is started.
Views: 369 Parag Mahalle
How to Change Oracle Database ID ( DBID ) using Nid Utility. /* Step By Step /*
 
07:15
Nid Utility is used for Changing DB Name and DBID. Nid means DB New Id Utility. 1. Using this utility we can change Database Name. 2. Using this utility we can change Database Id. 3 Using this utility we can change Database Name and Database Id. ------ Both. IN this Video I am Showing you how can we Change Oracle Database ID (DBID) using Nid Utility Nid Utility is a database tool for change Database name and Database Id. This tool is very easy to implement and understand. Follow Steps: Nid target=userid/password
Views: 640 Parag Mahalle
How to Export (Expdp) and Import (Impdp) Oracle schema using Datapump Utility.
 
07:28
we can export ( expdp ) and import ( impdp ) Oracle Schemausing datapump utility. we can use expdp for export and impdp for import. In this video i am showing you how to export Oracle Schema and how to import using Datapump utility. It is very easy to understand.
Views: 991 Parag Mahalle
How to Create Database Using DBCA in Oracle  /* Step By Step /*
 
07:58
We can create Oracle Database in 3 Types. 1. Manually Database Creation. 2. Using Database tool DBCA. 3. IN Silent Mode. These All steps are very easy to create database. In DBCA we can Run only ./DBCA command then database installation window is open then follow these steps are refer in this video for creation of oracle database using dbca. It is very easy to understand. plz follow this steps to create Database in silent mode. Installation Script : Go to $ORACLE_HOME/bin Directory Run ./DBCA Command for Installing Oracle Database.
Views: 985 Parag Mahalle
How to Create Oracle Database in Silent Mode /* Step By Step /*
 
10:25
We can create Oracle Database in Silent Mode. It is very easy to create. we can write some lines on $ prompt and then enter it is automatically create oracle database with proper location. It is very easy to understand. plz follow this steps to create Database in silent mode. Installation Script : dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbname orcl -sid orcl -syspassword sys -systempassword sys -responseFile NO_VALUE -characterSet AL32UTF8 -memoryPercentage 50 -emConfiguration NONE
Views: 1313 Parag Mahalle
Recover Block Corruption with Rman.
 
10:38
Hello friends In this video I am showing you how to Recover Block Corruption with Rman. Friends Suppose in any resion any block of datafile is corrupted, so we can repair it using Rman. Please watch this video
Views: 386 Parag Mahalle
How to Perform Oracle Loader Export (Expdp) & Import (Imopdp) Datapump utility. /* Step By Step /*
 
09:10
I am showing you How to perform Oracle Loader using Export (Expdp) and import (Impdp) Datapump utility in Oracle Database. Oracle Database external table population with Datapump utility. we can load data from non oracle file to oracle database using Oracle loader utility. when you enter new record in text file it will be reflected in Oracle table. this facility is not in sql loader. It is very easy to understand
Views: 818 Parag Mahalle
Rename Tablespace ( Tablespace Management #3 )/* Step By Step /*
 
06:23
Hello Friends In this video I am showing you 1. How to check Tablespace, Datafile size and Datafile Location. 2. How to Rename Tablespace. 3. How to Offline Tablespace. 4. How to Online Tablespace. 5. How to Rename Datafile. 6. How to Check Tablespace. (How many tablespace Do you Have). 7. How to check Tablespace Status. It is Offline or online. 8. How to Rename Old Datafile name to New Datafile Name in controlfile.
Views: 128 Parag Mahalle
How to Create Database Link in Oracle. /* Step By Step /*
 
17:21
Today I am showing you. How to create Database link (DB Link) in Oracle. What is Database Link ( DB Link ) ? A database link is a schema object in one database that enables you to access objects on another database. I have 2 databases 1. paragdb 2. orcl In Paragdb database 1. Create listener 2. Service Name 3. In Orcl Database 1. Create Listener 2. Service Name 3. Create new User 4.Grant connect,resource,create database link to username; 5. open user 6. create database link 1. create database link link1 connect to scott identified by tiger using 'connect_primary''; 7.select * from [email protected]; 8. select * from [email protected]; 9. views 1. select * from user_db_links; 2. select * from all_db_links; 10. conn sys as sysdba 11. grant public database link to username; 12. select * from dba_db_links; 13. conn username/pass 14. create public database link plink connect to scott identified by tiger using 'connect_primary'; 15. drop database link. drop database link link1; To follow this steps you will also create oracle database link. It is very easy to understand.
Views: 7562 Parag Mahalle
How to perform Incremental Backup using Rman /* Step by Step /*
 
08:29
In this video i am showing you how to perform Incremental backup using Rman. What is incremental Backup? The goal of incremental backup is a backup only those block that have change since a previous backup. You can use Rman to create incremental backup of Datafiles, tablespace and whole database. When making incremental backup Rman read only those blocks refer to locate the change blocks, since the last backup. That's why the backup smaller because only changed blocks are backup. • Level 0 - All database within your chosen file.(Full or Incremental level 0) • Level 1 - Only information that has changed since a previous backup. • Cumulative (Changes upto last level 0) • Differential (changes upto last incremental)
Views: 317 Parag Mahalle
How to Create Duplicate Database from Active Database on Linux / Stet By Step /
 
27:19
We can create Duplicate Database from Active Database command on Linux machine. This is a New Feature of 11g. we can create easily to create Duplicate database. plz fallow this steps to create uplicate database without any rman backup with Active database Function.
Views: 1413 Parag Mahalle
How to create Oracle Database Manually. /* Step By Step /*
 
27:57
We can create Oracle Database Manually. It is very easy to create. First we can create pfile from init.ora file. This file located on $ORACLE_HOME/dbs directory. Modify init.ora file and create pfile. startup database in nomount mode. Then Write Oracle Database creation script and create database. Controlfile is created automatically. It is very easy to understand. plz follow this steps to create Database manually. Installation Script :
Views: 1602 Parag Mahalle
How to load data from non oracle file to oracle file using Sql Loader. /* Step By Step /*
 
14:48
In this video i am showing you How We can transfer data from non oracle file to oracle Table. use Oracle Sql Loader export import datapump utility. I have data in test file with comma ( , ) separated column. so we can move this data to oracle useing sql loader. example: ename, sal, deptno Joy, 10000, 10 Scott, 2000, 20 Roy, 4000, 30 using this utility must have to create controlfile ( em.ctl load data infile append into table scott.test fields terminated by ',' optionally enclosed by '"' (ename,sal,deptno) Create table test with 3 column (ename,sal,deptno) rum sqlldr command sqlldr control=/u01/app/parag/em.ctl data=/u01/app/parag/em.txt log=/u01/app/parag/em.log Login to scott schema and check table It is very easy to implement.
Views: 836 Parag Mahalle
How to Perform Resumable Space Allocation in Oracle. /* Step By Step /*
 
19:56
We can perform Resumable space allocation on Tables. Resumable space allocation, introduced in Oracle 9i, is for all tablespaces at the session level. Database operations are suspended when an out-of-space condition is encountered. These suspended operations automatically resume when the error condition disappears. This feature is very easy to understand. And easy to Implement on any tables.
Views: 717 Parag Mahalle
How to Perform Incomplete recovery Until Cancel Base Using Rman Backup. /* Step By Step /*
 
19:12
We can Perform incomplete recovery until Cancel using Rman Backup. Incomplete Recovery Means The Database upto the specific point in time in the past, before the recovery operation was required. There where many types of incomplete Recovery. But in this video i am showing you only Incomplete Recovery Until Cancel Using Rman Backup. We can perform easily To follow this steps to perform Incomplete Recovery Until Cancel Base Using Rman Backup. This is easy to Understand
Views: 867 Parag Mahalle
How to Add & Drop Datafile in Tablespace. ( Tablespace Management #2 )
 
06:46
Hello Friend In this video I am showing you 1. How to add datafile. 2. How to drop Datafile. 3. How to alter Tablespace. 4. How to check Datafile Location. 5. How to check free space in tablespace.
Views: 170 Parag Mahalle
How to Export ( Expdp ) and Import ( Impdp ) Oracle Table using Datapump utility.
 
07:06
we can export ( expdp ) and import ( impdp ) Oracle table using datapump utility. we can use expdp for export and impdp for import. In this video i am showing you how to export Oracle table and how to import using Datapump utility. It is very easy to understand.
Views: 977 Parag Mahalle
How to Create Virtual Private Catalog (VPC) */ Step By Step */ New feature of 11g
 
13:29
We can create Virtual private catalog (VPC). It is a New feature of 11g. On the use of this feature we can create more then one catalog and some catalog permission send to other user for handle some issue. It is good for use. It is very easy to understand. Please follow this steps to create Virtual private catalog.
Views: 695 Parag Mahalle
How to Perform Incomplete Recovery Until Time Base Using Rman Backup. /* Step By Step /*
 
09:07
We can Perform incomplete recovery until Time using Rman Backup. Incomplete Recovery Means The Database upto the specific point in time in the past, before the recovery operation was required. There where many types of incomplete Recovery. But in this video i am showing you only Time base Incomplete Recovery Using Rman Backup. We can perform easily To fillow this steps to perform Time Base Incomplete Recovery Using Rman Backup. This is easy to Understand.
Views: 668 Parag Mahalle
How to Install Microsoft Loopback Adapter in Windows 7 ?
 
03:15
Install Loopback Adapter in Windows 7
Views: 597 Parag Mahalle
How to Create Duplicate , Auxiliary, Clone, Database with Backup on Windows. */ Step By Step /*
 
13:42
We can Create Duplicate, Auxiliary, Clone, Standby Database with Rman Backup on 10g and 11g. Duplicate Database is a Database replica created on a backup of primary database. Plz follow this steps how to create clone, duplicate database with backup. It is very easy to understand.
Views: 809 Parag Mahalle
Query Parameter in Oracle Datapump
 
19:05
Hello Friends Today, In this video I used to show you How to Used Data pump Query Parameter. In Query Parameter we can take export backup using particular query. Suppose iwant to take a export backup of EMP table but in this table i want to take backup only department no 20. so it is possible . please watch this video and subscribe In Some Methods i am showing you. Method 1: (Using Parameter File) ------------------------------------------------------------ 1. Create Table Test. (Create table scott.test as select * from scott.emp;) 2. Create Par file. ------------------------------------------------------------ directory=dump dumpfile=d1.dmp tables='SCOTT . TEST' query=TEST:"WHERE deptno=20" ---------------------------------------------------------------- Save this file test.par --------------------------------------------------------------- 3. Go to Command Prompt Export expdp system/admin parfile='/u01/app/parag/test.par’  Import impdp system/admin directory=dump dumpfile=d1.dmp tables=‘SCOTT . TEST‘ ------------------------------------------------------------------------------------- Method 2: ------------------------------------------------------------ 1. Create Table Test. (Create table scott.test as select * from scott.emp;) 2. Go to Command Prompt Export expdp system/admin directory=dump dumpfile=d2.dmp tables=‘SCOTT . TEST ’ query=TEST:\”WHERE deptno=20\”  Import impdp system/admin directory=dump dumpfile=d2.dmp tables=‘SCOTT . TEST ' -----------------------------------------------------------------------------------------------------------
Views: 415 Parag Mahalle
How to Perform Incomplete Recovery Until Restore point Using Rman Backup. /* Step By Step /*
 
10:58
We can Perform incomplete recovery until Restore point using Rman Backup. Incomplete Recovery Means The Database upto the specific point in time in the past, before the recovery operation was required. There where many types of incomplete Recovery. But in this video i am showing you only Incomplete Recovery Until Restore point Using Rman Backup. We can perform easily To follow this steps to perform Incomplete Recovery Until Restore point Using Rman Backup. This is easy to Understand.
Views: 728 Parag Mahalle
How to Change Oracle Database Name using Nid Utility /* Step By Step /*
 
26:20
Nid Utility is used for Changing DB Name and DBID. Nid means DB New Id Utility. 1. Using this utility we can change Database Name. 2. Using this utility we can change Database Id. 3 Using this utility we can change Database Name and Database Id. ------ Both. IN this Video I am Showing you how can we Change Oracle Database Name (DB Name) using Nid Utility Nid Utility is a database tool for change Database name and Database Id. This tool is very easy to implement and understand. Follow Steps: Nid target=username/password dbname='New DB Name' setname=yes
Views: 633 Parag Mahalle
How to Create Auxiliary, Duplicate, Clone Database From Active database on Windows.
 
20:03
We can create Duplicate Database from Active Database command on Windws and Linux Machine. This is a New Feature of 11g. we can create easily to create Duplicate database. plz fallow this steps to create uplicate database without any rman backup with Active database Function.
Views: 796 Parag Mahalle
How to Change Oracle Database Name And Database Id Using Nid Utility. /* Step By Step /*
 
27:57
Nid Utility is used for Changing DB Name and DBID. Nid means DB New Id Utility. 1. Using this utility we can change Database Name. 2. Using this utility we can change Database Id. 3 Using this utility we can change Database Name and Database Id. ----- Both. IN this Video I am Showing you how can we Change Oracle Database Name (DB Name) and Database Id (DBID) using Nid Utility Nid Utility is a database Utility for change Database name and Database Id. This tool is very easy to implement and understand. Follow Steps: Nid target=username/password dbname='New DB Name'
Views: 827 Parag Mahalle
Perform Incomplete Recovery When Control files, Data files, & Redolog files are missing Using Rman.
 
11:13
We can Perform incomplete recovery When Control files, Data files, & Redo log files are missing using Rman Backup. Incomplete Recovery Means The Database upto the specific point in time in the past, before the recovery operation was required. There where many types of incomplete Recovery. But in this video i am showing you only Incomplete Recovery When Control files, Data files, & Redo log files are missing Using Rman Backup. We can perform easily To follow this steps to perform Incomplete Recovery When Control files, Data files, & Redo log files are missing Using Rman Backup. This is easy to Understand
Views: 690 Parag Mahalle
How to Change Oracle Database Name Manually without using Nid Utility
 
24:21
We can change Oracle Database Name Manually without using nid utility. In this video i am showing you we can change database name using modifying controlfile. First we take a backup of controlfile. alter database backup controlfile to trace as '/location'; Modify some parameter in this controlfile backup. In the place of Reuse Set Old Database name New Database Name Noresetlogs Resetlogs It is very easy to understand. Follow this steps.
Views: 604 Parag Mahalle

Ethnic minority representation parliament
Hijackthis report analysis
Lindenwood resume maker
Mainframe testing resume sample
Pictorial presentation and information about a mall introduction