Home
Search results “Add datafile oracle asm”
Add Datafile to Tablespace
 
14:55
Add extra datafile to exixting tablespace, how to drop the extra datafile, how to reuse a datafile, how to make a tablespace offline n online.
Views: 12361 DbaRocksOracle
Oracle DBA Justin - How to add a disk to a diskgroup in Oracle ASM
 
04:48
How to add a disk to a diskgroup in Oracle ASM
Views: 15741 jbleistein11
How to Move a Datafile From File System To ASM Disk Group
 
08:02
Hello friends today is very interesting topic about moving datafile from File system to ASM Disk Storage. #MovingDatafile #ASMDiskGroup Oracle database Unbeatable,Unbreakable Platform..
Views: 4518 Oracle World
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: 261 Parag Mahalle
Creating  Managing  Droping Oracle Database Tablespaces
 
12:10
Creating Managing Droping Oracle Database Tablespaces select tablespace_name,block_size,status,contents,logging from dba_tablespaces; create tablespace mytbs datafile 'd:\oradata\dbrdbms\mytbs01.dbf' size 10m; alter tablespace mytbs add datafile 'd:\oradata\dbrdbms\mytbs02.dbf' size 10m; alter tablespace mytbs drop datafile 'd:\oradata\dbrdbms\mytbs02.dbf'; desc v$datafile; desc ts#,name from v$datafile; select ts#,name from v$tablespace; select v$datafile.ts#,v$datafile.name,v$tablespace.name from v$datafile,v$tablespace where v$datafile.ts#=v$tablespace.ts# and v$tablespace.name='MYTBS'; alter database datafile 'd:\oradata\dbrdbms\mytbs01.dbf' resize 20m; ALTER DATABASE DEFAULT TABLESPACE mytbs; select ts#,name from v$tablespace; select ts#,name from v$datafile; select ts#,name from v$tablespace; drop tablespace mytbs; drop tablespace mytbs ialtncluding contents and datafiles; drop tablespace mytbs including contents and datafiles cascade; alter tablespace mytbs read only; alter tablespace mytbs read write; alter tablespace mytbs force logging; alter tablespace mytbs nologging; alter tablespace mytbs flashback on; alter tablespace mytbs flashback off; purge tablespace mytbs user myuser;
Views: 22476 Abbasi Asif
Add Datafile to Tablespace in Oracle
 
03:25
Welcome Back to KSH Infotainment. Add Datafile to Tablespace in Oracle Activity done on Oracle 11g ASM DB. Used Queries: ============= set lines 200 pages 200 select df.tablespace_name "Tablespace", totalusedspace "Used MB", (df.totalspace - tu.totalusedspace) "Free MB", df.totalspace "Total MB", round(100 * ( (df.totalspace - tu.totalusedspace)/ df.totalspace)) "Pct. Free" from (select tablespace_name, round(sum(bytes) / 1048576) TotalSpace from dba_data_files group by tablespace_name) df, (select round(sum(bytes)/(1024*1024)) totalusedspace, tablespace_name from dba_segments group by tablespace_name) tu where df.tablespace_name = tu.tablespace_name order by 1; set linesize 200 set pagesize 2000 COLUMN tablespace_name format a10 COLUMN file_name format a45 COLUMN free% format a7 SELECT df.tablespace_name,SUBSTR (df.file_name, 1, 60) file_name, df.bytes / 1024 / 1024 allocated_mb, round(((df.bytes / 1024 / 1024) – NVL (SUM (dfs.bytes) / 1024 / 1024, 0)),1) used_mb, round(NVL (SUM (dfs.bytes) / 1024 / 1024, 0),2) free_space_mb FROM dba_data_files df, dba_free_space dfs WHERE df.FILE_ID = dfs.file_id(+) GROUP BY df.tablespace_name, dfs.file_id, df.file_id , df.bytes, df.file_NAME ORDER BY df.tablespace_name;
Views: 49 KSH Infotainment
Moving a Database (datafile and Controlfile and Redo Log File)  from File System to ASM Storage
 
27:02
Hi guys today i explaining a real environment scenario that require to move a Full Database from File system to #MovingDatabase #FileSystemtoASMStorage ASM Disk Group Storage. Oracle database Unbeatable,Unbreakable Platform..
Views: 4794 Oracle World
Configure and Manage Oracle ASM with ALATO
 
05:11
Learn how to configure ALATO to recognize a new Oracle Database Automatic Storage Management instance (ASM and Grid Infrastructure). Oracle Certified Master DBA John Watson demonstrates configuring ASM in Alato, then adding an ASM Disk Group, followed by create tablespace. Learn more about Alato for Oracle Database Administration (free trial) at http://www.skillbuilders.com/alato.
Views: 141 SkillBuilders
3. Oracle database Installation With ASM: Add Hard Disk, Create partition & transfer software
 
19:39
Automatic Storage Management (ASM) is a feature that has be introduced in Oracle 10g to simplify the storage of Oracle datafiles, controlfiles, logfiles and backups. ASM will be used as the file system and volume manager for Oracle Database files (data, online redo logs, control files, archived redo logs), and the Fast Recovery Area. NOTE: ASMLib in the Unbreakable Enterprise Kernel. ASMLib – Linux specific ASM library and its associated driver. The Oracle ASMLib kernel driver is now included in the Unbreakable Enterprise Kernel. No driver package needs to be installed when using this kernel. The oracleasm-support and oracleasmlib packages still need to be installed. The oracleasm-support can be installed from Oracle Linux ISO image. For other Linux flavors could be found here – (Download section for particular Linux distribution) The oracleasmlib can be downloaded from ULN (Unbreakable Linux Network), subscription is required. Non-subscribers are free to use the similar package built for RHEL on their Enterprise Linux machines, which we will use in this tutorial. Action plan: 1. Installing Oracle Enterprise Linux and creating virtual hard disks in VMware for ASM disks 2. Creating recommended OS groups and user for Grid Infrastructure 3. Creating login scripts for grid and oracle users 4. Installing Oracle ASM packages 5. Creating ASM disk volumes 6. Downloading and installing Oracle Grid Infrastructure software 7. Creating ASM disk groups 8. Installing Oracle database software and create database instance
Views: 812 Md Arshad
How to configure ASM step by step
 
22:41
Hello friends In this tutorial i'm going to demonstrate to you how to configure ASM step by step. For more detail please visit on my official website www.ocptechnology.com and subscribe it. #asm #installation #oracletutorial #shripal
Views: 15695 OCP Technology
All-in-one Oracle ASM Commands ! Download ASM commands pdf file
 
04:32
Download link: https://app.dbagenesis.com/oracle-asm-commands-download
Views: 757 DBA Genesis
Oracle ASM Failure Groups
 
06:52
Oracle ASM Failure Groups
Views: 886 The Silent DBA
Datafile Resize in Oracle
 
05:50
Welcome Back to KSH Infotainment. Datafile Resize in Oracle. Activity done on Oracle 11g ASM DB. Used Queries: ============= set lines 200 pages 200 select df.tablespace_name "Tablespace", totalusedspace "Used MB", (df.totalspace - tu.totalusedspace) "Free MB", df.totalspace "Total MB", round(100 * ( (df.totalspace - tu.totalusedspace)/ df.totalspace)) "Pct. Free" from (select tablespace_name, round(sum(bytes) / 1048576) TotalSpace from dba_data_files group by tablespace_name) df, (select round(sum(bytes)/(1024*1024)) totalusedspace, tablespace_name from dba_segments group by tablespace_name) tu where df.tablespace_name = tu.tablespace_name order by 1; set linesize 200 set pagesize 2000 COLUMN tablespace_name format a10 COLUMN file_name format a45 COLUMN free% format a7 SELECT df.tablespace_name,SUBSTR (df.file_name, 1, 60) file_name, df.bytes / 1024 / 1024 allocated_mb, round(((df.bytes / 1024 / 1024) – NVL (SUM (dfs.bytes) / 1024 / 1024, 0)),1) used_mb, round(NVL (SUM (dfs.bytes) / 1024 / 1024, 0),2) free_space_mb FROM dba_data_files df, dba_free_space dfs WHERE df.FILE_ID = dfs.file_id(+) GROUP BY df.tablespace_name, dfs.file_id, df.file_id , df.bytes, df.file_NAME ORDER BY df.tablespace_name;
Views: 111 KSH Infotainment
Create Tablespace In Migrate To ASM Database
 
02:10
Hi... Friends In This Video We Learn How To Create Tablespace in Migrate To ASM Database in Oracle 11g On Windows Database Name : Orcl Watch My Previous Video Migrate To ASM in Oracle 11g https://www.youtube.com/watch?v=NCXEt0KGwoU&t=5s
Views: 137 PGT POINT
ASMCMD-Command
 
07:42
ASMCMD-Command
Views: 7478 Ritesh Raj Singh
How To Add/Drop ASM Disk In Disk Groups And Monitor Re-Balance Operations Part 2 of 2
 
04:23
Hi... Friends In This Video We Learn How To Add/Drop ASM Disk In Disk Groups And Monitor Re-Balance Operations In Oracle On Windows .
Views: 1207 PGT POINT
Part 5 Accessing your datafile on ASM disk group
 
06:06
Accessing your oracle database file on ASM disk group
Views: 221 Olusegun Oluyemi
Oracle ASM (Quick Hands-on Basics) Part 2
 
12:05
This video includes very basics of ASM, like ASMCMD & ASMCA.
Views: 399 Anonymous far
Oracle ASM (Theoretical Discussion) Part 1
 
01:14:20
This video will give you a complete understanding towards ASM (Automatic Storage Management) widely used in Oracle Databases and Oracle Real Application Clusters.
Views: 541 Anonymous far
1.  Oracle database Installation With ASM: Installation of Linux & network configuration
 
22:18
Automatic Storage Management (ASM) is a feature that has be introduced in Oracle 10g to simplify the storage of Oracle datafiles, controlfiles, logfiles and backups. ASM will be used as the file system and volume manager for Oracle Database files (data, online redo logs, control files, archived redo logs), and the Fast Recovery Area. NOTE: ASMLib in the Unbreakable Enterprise Kernel. ASMLib – Linux specific ASM library and its associated driver. The Oracle ASMLib kernel driver is now included in the Unbreakable Enterprise Kernel. No driver package needs to be installed when using this kernel. The oracleasm-support and oracleasmlib packages still need to be installed. The oracleasm-support can be installed from Oracle Linux ISO image. For other Linux flavors could be found here – (Download section for particular Linux distribution) The oracleasmlib can be downloaded from ULN (Unbreakable Linux Network), subscription is required. Non-subscribers are free to use the similar package built for RHEL on their Enterprise Linux machines, which we will use in this tutorial. Action plan: 1. Installing Oracle Enterprise Linux and creating virtual hard disks in VMware for ASM disks 2. Creating recommended OS groups and user for Grid Infrastructure 3. Creating login scripts for grid and oracle users 4. Installing Oracle ASM packages 5. Creating ASM disk volumes 6. Downloading and installing Oracle Grid Infrastructure software 7. Creating ASM disk groups 8. Installing Oracle database software and create database instance
Views: 1007 Md Arshad
RenameDG or Add Disk to existing Disk Group
 
08:33
RenameDG or Add Disk to existing Disk Group
Views: 3126 Ritesh Raj Singh
OracleTablespace Administration | Bigfile tablespace in Oracle - Creation and Management
 
08:42
This video is the part of Oracle Database Self learn Kit From Wysheid. In this video we discuss about the creation and management of bigfile tablespaces in an Oracle database
Views: 2451 Wysheid Wysheid
PRM 3.1 For Oracle ASM Extract Datafile From Damaged ASM Disk group
 
05:40
PRM 3.1 For Oracle ASM Extract Datafile From Damaged ASM Disk group
Part 4 Creating Oracle ASM Disk
 
04:46
Step by Step 1. Install Oracle ASM RPM 2. Creating Oracle ASM Disk Need a copy of the Word file? Just inbox me your email id. SUBSCRIBE ======================================== Uncopyrighted Background Music! #50 (Chill Instrumental) https://www.youtube.com/watch?v=tDTH_SAYBwU Uncopyrighted Background Music! #44 (Chill Trap) https://www.youtube.com/watch?v=Z-l5MjwNT4E
Views: 2439 Jonathan Piston
Create Clone/Duplicate Database from File System to ASM Storage from RMAN Backup in Oracle 12c
 
17:42
In this video I have shown how to create clone/duplicate database from file system to ASM storage from RMAN backup in Oracle 12c. Operating system is Oracle Linux 6.5 64-bit.
Views: 3154 Oracle Testlab
How to Move a Datafile in Oracle Database - Part 1
 
01:32
Dozens of free Oracle tutorials at http://skillbuilders.com/free-oracle-tutorials. See Part 2 (the demonstration) of this tutorial at http://skillbuilders.com/How-to-Move-Datafiles-Oracle-12c. How do you move a datafile in an Oracle Database? Well, it just got a lot easier in 12c! Watch this free video tutorial - OCM John Watson of SkillBuilders will demonstrate both techniques, 11g and 12c. There are many reasons to move a datafile in an Oracle database. Here are just a few: Renaming datafiles to a standard Moving from one file system to another Converting from file system storage to ASM Changing from SAN to NFS storage In 11g, we need to take the tablespace offline, meaning downtime. Argh! In 12c, all that is required is ALTER DATABASE MOVE DATAFILE; this is an online operation with zero downtime. Even "critical" files such as the files associated with the SYSTEM tablespace can be moved online. Consider the ease of migrating to ASM this provides! This also functions in an Active Data Guard standby environment. And, there are syntax options that allow you to keep or delete the original file. Very cool stuff.
Views: 2652 SkillBuilders
Oracle Administer ASM
 
34:08
Oracle RAC, ASM and Data Guard Training classes in 12c. oracle advanced DBA Training course with Grid Infrastructure and High Availability. We offered our courses as: Trainng Course: Oracle DBA Focus Training Services offers "ADMINISTRATIVE & SOFTWARE DEVELOPMENT COURSES" based on today's hottest technologies, including DATAWAREHOUSING | UNIX | HIGH AVAILABILITY COURSES |STORAGE TECHNOLOGIES | MIDDLEWARE TECHNOLOGIES | CLUSTERING |DBA | VIRTUALIZATION | CLOUD COMPUTING | SHELL/PERL SCRIPTING | PROGRAMMING LANGUAGES etc DATAWAREHOUSING - ETL& BI TOOLS INFORMATICA | COGNOS | DATASTAGE | OBIEE | MSBI | ABINITIO |BO | MICROSTATAGY | TERADATA | QLIKVIEW | DATABASE ADMINISTRATION ORACLE DBA | ORACLE APPS | RAC | PERFORMANCE TUNING | DBA ARCHITECT | SQL | PLSQL | CORE DBA VIRTUALIZATION VMWARE VCP 5.5 | HYPERV | CITRIX | VCAP DCA | CITRIX XEN SERVER XEN-APP XEN-DESKTOP | KVM | AIX-VIO | REDHAT ENTERPRISE VIRTUALIZATION CLOUD COMPUTING SALESFORCE | VCLOUD | AMAZON | OPENSTACK | OPEN NEBULA | EUCALYPTUS | IBM CLOUD | CLOUD SECURITY | IaaS | PaaS | SaaS| UNIX LINUX - RHEL 6.4 | REDHAT & VERITAS CLUSTER | REDHAT SATELLITE website: www.focustraining.in email: [email protected] Focus Training Services Madhavi Apartment, 2102/5, Ground Floor, Near Kalaprasad Mangal Karyalaya, Vijaynagar Colony, Sadashiv Peth, Pune 411030 Tel 020-30243333,30243334.
How to ADD DISKGROUP IN ASM Using Enterprise Manager
 
03:04
Hello... Friends In this video How to Add DISKGROUP in ASM using Enterprise Manager. First of check your database is migrate to ASM If not migrate so watch my this video https://www.youtube.com/watch?v=NCXEt0KGwoU&t=11s
Views: 145 PGT POINT
ASM Instance and Disk Groups - ASM Video 06
 
04:22
In this video you will understand what is an Oracle ASM Instance and what are Disk Groups. . Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 4793 Ramkumar Swaminathan
Zero downtime ASM diskgroup migration to another SAN storage
 
18:58
https://dbagenesis.com/p/oracle-11gr2-rac-for-beginners In your environment, you might require to migrate ASM disks from one storage to another storage. The activity is very simple and straight forward. You can follow bellow procedure in order to migrate ASM disks without any downtime. High level disks migration steps: Get the new disks mounted on RAC nodes - from new SAN storage Create ASM disks from the newly mounted disks Add the new disk to existing diskgroup - where you want to replace old ASM disks Wait for re-balance to complete Drop the old disk from the diskgroup Wait for re-balance to complete Done!
Views: 2473 DBA Genesis
Replace Failed ASM Disk in ASM DISKGROUP  11g R2
 
17:52
Short clip on how to replace failed ASM DISK in ASM DISKGROUP
Views: 1727 VTMSolution
5. Oracle database Installation With ASM: Install database software & Create database.
 
09:59
Automatic Storage Management (ASM) is a feature that has be introduced in Oracle 10g to simplify the storage of Oracle datafiles, controlfiles, logfiles and backups. ASM will be used as the file system and volume manager for Oracle Database files (data, online redo logs, control files, archived redo logs), and the Fast Recovery Area. NOTE: ASMLib in the Unbreakable Enterprise Kernel. ASMLib – Linux specific ASM library and its associated driver. The Oracle ASMLib kernel driver is now included in the Unbreakable Enterprise Kernel. No driver package needs to be installed when using this kernel. The oracleasm-support and oracleasmlib packages still need to be installed. The oracleasm-support can be installed from Oracle Linux ISO image. For other Linux flavors could be found here – (Download section for particular Linux distribution) The oracleasmlib can be downloaded from ULN (Unbreakable Linux Network), subscription is required. Non-subscribers are free to use the similar package built for RHEL on their Enterprise Linux machines, which we will use in this tutorial. Action plan: 1. Installing Oracle Enterprise Linux and creating virtual hard disks in VMware for ASM disks 2. Creating recommended OS groups and user for Grid Infrastructure 3. Creating login scripts for grid and oracle users 4. Installing Oracle ASM packages 5. Creating ASM disk volumes 6. Downloading and installing Oracle Grid Infrastructure software 7. Creating ASM disk groups 8. Installing Oracle database software and create database instance
Views: 426 Md Arshad
2.  Oracle database Installation With ASM:  Prepare Environment For database & ASM installation.
 
06:48
Automatic Storage Management (ASM) is a feature that has be introduced in Oracle 10g to simplify the storage of Oracle datafiles, controlfiles, logfiles and backups. ASM will be used as the file system and volume manager for Oracle Database files (data, online redo logs, control files, archived redo logs), and the Fast Recovery Area. NOTE: ASMLib in the Unbreakable Enterprise Kernel. ASMLib – Linux specific ASM library and its associated driver. The Oracle ASMLib kernel driver is now included in the Unbreakable Enterprise Kernel. No driver package needs to be installed when using this kernel. The oracleasm-support and oracleasmlib packages still need to be installed. The oracleasm-support can be installed from Oracle Linux ISO image. For other Linux flavors could be found here – (Download section for particular Linux distribution) The oracleasmlib can be downloaded from ULN (Unbreakable Linux Network), subscription is required. Non-subscribers are free to use the similar package built for RHEL on their Enterprise Linux machines, which we will use in this tutorial. Action plan: 1. Installing Oracle Enterprise Linux and creating virtual hard disks in VMware for ASM disks 2. Creating recommended OS groups and user for Grid Infrastructure 3. Creating login scripts for grid and oracle users 4. Installing Oracle ASM packages 5. Creating ASM disk volumes 6. Downloading and installing Oracle Grid Infrastructure software 7. Creating ASM disk groups 8. Installing Oracle database software and create database instance
Views: 309 Md Arshad
RAC Tutorial | Oracle 11g RAC Installation on  Linux|Creating ASM Diskgroups using ASMCA
 
05:14
This Video discuss in detail, the steps for creating the ASM Disk groups using ASCMA tool
Views: 10326 Wysheid Wysheid
Moving datafile to different Mount Point while the database is Running Live
 
08:25
Hi Guys welcome to my channel ORACLE WORLD today m going to share a new topic Moving datafile to different Mount point while the database is Running Live. #Movingdatafile #MountPoint Oracle database Unbeatable,Unbreakable Platform..
Views: 1100 Oracle World
How to Recover or Recreate Controlfile without Backup ?
 
12:08
Hi guys in my today videos i will explain how to recover to controlfile without any backup. #RecreateControlfile #withoutBackup Oracle database Unbeatable,Unbreakable Platform..
Views: 11235 Oracle World
Creating Tablespace With AutoExtend Option
 
02:35
Shohieb Ahmad Nasruddin -
How To Add/Drop ASM Disk In Disk Groups And Monitor Re-Balance Operations Part 1 of 2
 
05:02
Hi... Friends In This Video We Learn How To Add/Drop ASM Disk In Disk Groups And Monitor Re-Balance Operations.
Views: 376 PGT POINT
Restore ASM Controllfile
 
06:18
#Oracle #ControlFile #RMAN #ASM Restoring Controlfile in ASM
Views: 684 Hemant K Chitale
Convert Database ASM File System to Cooked File System in Oracle Part 01
 
06:03
Convert Database ASM File System to Cooked File System in Oracle Part 01
Views: 1627 Abbasi Asif
Convert Database Cooked File System to ASM File System in Oracle Part 01
 
12:39
Convert Database Cooked File System to ASM File System in Oracle Part 01 1) Convert control file to asm instance 2) Convert datafiles to asm instance 3) Convert tempfiles to asm instance 4) Convert log files to asm instance
Views: 1815 Abbasi Asif
How to create an Oracle ASM Instance Manually
 
31:23
Hi friends today i explaining about ASM in 10g R2 ASM basically manage the disk storage and improve the performance Oracle database Unbeatable,Unbreakable Platform.. #OracleASMInstance
Views: 2323 Oracle World
Oracle Tutorial - How to rename Datafile in Oracle step by step
 
08:24
Hello friends in this video i'm going to show you how to rename datafile in oracle step by step
Views: 707 OCP Technology
20. Tablespace and Datafile in Oracle
 
04:34
In this video you will learn about Tablespaces and Datafiles in detail. We are going to cover something theoretically here because you will be using it frequently in next videos so it is good to watch this before proceeding. For Support =========== Email: [email protected] Contact Form: http://www.learninhindi.com/home/contact Our Social Media ================ Facebook: https://www.facebook.com/LearnInHindi Twitter: https://twitter.com/LearnInHindi For Training & Videos ===================== For more videos and articles visit: http://www.learninhindi.com Free Java Programming In Hindi Course ===================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAwwhMyoLISrxkXTADGp7PH Free Oracle PL/SQL Programming In Hindi Course ============================================== https://www.youtube.com/playlist?list=PLB5DA82419C2D99B6 Free C Programming In Hindi Course ================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAxKpBLMWogxSdy6BZcsAJq Trips & Tricks Channel ====================== https://www.youtube.com/channel/UCGmLfkuCo-3lHHJXRJ9HUMw Programming in Hindi Channel ============================ https://www.youtube.com/channel/UCudElIDgwNrybeAvXIy1HZQ
Views: 31866 ITORIAN
Oracle Tablespace Management
 
41:44
How to Create and Manage tablespace watch this video
Views: 5326 COMBINATIONS FOR ALL