Home
Search results “View scn in oracle”
System Change Number in Oracle Database - SCN - DBArch Video 26
 
02:45
In this video you will understand what is System Change Number in an Oracle Database, and get to know about some of the uses of it. . 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: 6548 Ramkumar Swaminathan
How To Flashback a Table to particular SCN in Oracle
 
08:38
How To Flashback a Table to particular SCN in Oracle
Views: 6132 Abbasi Asif
SCPT 21: Oracle Back Ground Processes ( CKPT, DBWR, LGWR, ARCH)
 
19:47
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 61686 Oresoft LWC
Oracle DBA Justin -  How to recover an Oracle database to a specific SCN, not using RMAN.
 
23:54
How to recover an Oracle database to a specific SCN, not using RMAN.
Views: 18107 jbleistein11
RMAN: How to perform a SCN based incomplete recovery
 
14:48
When you don't know the date and time to which you want to recover the database, SCN-based incomplete recovery could be taken into consideration especially if you are able to retrieve a particular SCN. In this scenario I will perform a SCN-based incomplete recovery after I have used the Oracle LogMiner utility to retrieve a useful SCN where to stop my recovery process. A complete description could be found here: http://dbaworkshop.blogspot.it/2013/05/How-to-perform-a-SCN-based-incomplete-recovery.html
Views: 10025 mvige
Oracle DBA Justin - How to create a basic VPD policy
 
14:13
How to create a basic VPD policy
Views: 6286 jbleistein11
Oracle DBA Justin - How to setup multiple archived log locations for an Oracle database
 
10:30
How to setup multiple archived log locations for an Oracle database
Views: 4935 jbleistein11
How to use Oracle LogMiner?
 
14:27
Oracle Database 11g, LogMiner
Views: 8884 Mahir M. Quluzade
Oracle DBA Justin - How to execute sql and Sqlplus commands from an external script
 
09:33
How to execute sql and Sqlplus commands from an external script
Views: 89437 jbleistein11
when checkpoint will occur in oracle database
 
14:13
How to check current_scn number of database? ============================================= select CURRENT_SCN from v$database; select dbms_flashback.get_system_change_number from dual; select timestamp_to_scn(sysdate) from dual; how to check datafile header scn number? ========================================= select name,CHECKPOINT_CHANGE# from v$datafile_header; when checkpoint will occur? ============================ alter system switch logfile; alter database begin backup; alter database end backup; alter system checkpoint;(manual checkpoint) shutdown immediate;(when the database is down) what will happen when checkpoint occurs? ========================================= scn of datafile header will update;
Views: 3962 Praveen Biyyapu
3.ORACLE WORLD - Flashback Table Point in time Recovery in oracle
 
09:52
Hello friends in this demo we learn about how to perform a flashback point in time recovery on table in Oracle database,one important thing is that flashback not supported on SYS user objects... #performingflashback #FlashbackTablePointintimeRecovery By Lalit Saini
Views: 3519 Oracle World
Oracle DBA Justin - How to create a basic Dataguard physical standby database # 3 of 3
 
13:08
How to create a basic Dataguard physical standby database
Views: 17060 jbleistein11
7.ORACLE WORLD- FLASHBACK TRANSACTION QUERY
 
14:43
Hi guys today we will learn how to perform flashback transaction query to find out the DDL that performed by users. #FLASHBACKTRANSACTIONQUERY Oracle database Unbeatable,Unbreakable Platform..
Views: 1647 Oracle World
Flashback database, Architecture, Configuring flashback Database, Monitoring Flashback database
 
16:17
Performing flashback - Flashback database, Architecture, Configuring flashback Database, Monitoring Flashback database For Students of B.Tech, B.E, MCA, BCA, B.Sc., M.Sc., Courses - As Per IP University Syllabus and Other Engineering Courses
1.ORACLE WORLD - How to Performing Flashback in Oracle Database
 
05:04
Hello friends in this video i'm just showing to you that how to enable flashback in Oracle database... #PerformingFlashback #OracleDatabase By Lalit saini
Views: 2052 Oracle World
Fundamental Oracle Flaw Revealed: SCN Poison
 
04:55
It's recommended to watch it in full HD. Please read the following to get more info about SCN flaw: http://www.gokhanatil.com/2012/01/fundamental-oracle-flaw-revealed-lets.html
Views: 1086 Gokhan Atil
8.oracle world-FLASHBACK Guaranteed Restore Point
 
09:06
HI friends today i give you a brief scenario how to create flashback guaranteed restore point for TABLE-LEVEL RECOVERY. #GuaranteedRestorePoint #FLASHBACK Oracle database Unbeatable,Unbreakable Platform..
Views: 3674 Oracle World
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: 15864 jbleistein11
5.ORACLE WORLD - How to perform Flashback Query at the specified point in time
 
07:44
Hi welcome in my oracle world in this video im explaining about flashback query at the specified point in time in Oracle database Unbeatable,Unbreakable Platform.. #performFlashback #Oracledatabase #FlashbackQuery By lalit saini
Views: 2146 Oracle World
How To Configure Oracle Database in Flashback Mode
 
11:39
How To Configure Oracle Database in Flashback Mode; Configure Flashback related parameters; Enable / Disable Flashback mode
Views: 12667 Abbasi Asif
Shared Server Configuration in Oracle Database - DBArch Video 18
 
08:06
You will learn about the concept of Shared Servers and Dispatchers in an Oracle Database. This is a method of optimizing resources on the Database Server side when a user is connecting from a Thick Client ( application installed on a desktop). 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: 9886 Ramkumar Swaminathan
How To Configure Oracle Database  in ArchiveLog Mode
 
09:47
How To Configure Oracle Database in ArchiveLog Mode / NoArchiveLog Mode
Views: 4426 Abbasi Asif
Oracle DBA Justin - How to create a basic Dataguard physical standby database # 2 of 3
 
21:29
Oracle DBA Justin - How to create a basic Dataguard physical standby database # 2 of 3
Views: 25690 jbleistein11
Oracle Instance Startup - DBArch Video 13
 
03:38
In this video you will learn the various steps involved in starting an Oracle Database Instance. You get introduced to the different states of an Instance - IDLE, NOMOUNT, MOUNT and OPEN and what happens in each of these states. 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: 12425 Ramkumar Swaminathan
Instance Recovery in an Oracle Database - DBArch Video 10
 
06:00
This video explains how Instance recovery happens in an Oracle Database. 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: 19864 Ramkumar Swaminathan
Oracle tutorial : Recover deleted rows in Oracle PL SQL using flashback
 
10:59
Oracle tutorial : Recover deleted rows in Oracle using flashback oracle tutorial for beginners oracle recover deleted rows In this video, we have used as of timestamp concept of oracle. Example : select * from table as of timestamp(systimestamp-interval '1'minute ) Subscribe on youtube: https://www.youtube.com/channel/UCpiyAesWNYOXSz5GPq8lbkA For more tutorial please visit #techquerypond https://techquerypond.com https://techquerypond.wordpress.com https://twitter.com/techquerypond sql in recovery recover deleted rows
Views: 1976 Tech Query Pond
Oracle DBA Justin - Using the controlfile autobackup feature of RMAN
 
26:09
Using the controlfile autobackup feature of RMAN
Views: 13809 jbleistein11
Recovery of Dropped Table using until time by RMAN
 
11:05
Hello friends in this demo i am explain about Recovery of dropped table using until time by RMAN (recovery manager). #RecoveryofDroppedTable #RMANRECOVERY #UNTILTIMERECOVERY Oracle database Unbeatable,Unbreakable Platform..
Views: 5843 Oracle World
Oracle Database and Instance Components - DBArch Video 3
 
10:09
In this video you will learn about the Relationship between and Oracle Instance and an Oracle Database. You will know about the various components of an Instance ( SGA and Background Processes) and the various files of the Database and how they interact. 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: 44645 Ramkumar Swaminathan
Oracle DBA Justin - How to setup a database user to be identified externally with os authentication
 
14:10
How to setup a database user to be identified externally with os authentication
Views: 5539 jbleistein11
Recovery Manager RMAN Architecture
 
14:14
Oracle Recovery Manager Architecture Concepts Utility Use Configuration
Views: 32089 Abbasi Asif
Using RMAN: backup - disaster - recovery demonstration
 
19:33
Demonstrates a simple usage of Recovery Manager in Oracle. Plan: 1. Backup a database. 2. Simulate a disaster. 3. Restore and recover the database. For more details please go to http://dba-presents.com/index.php/oracle/11-simple-disaster-recovery-scenario-with-rman-video
Views: 4388 DBA presents
7 Flashback in Oracle DBA
 
30:39
Flashback in Oracle DBA. How to rollback deleted records after commit.
Views: 3824 NewTechnology
Oracle- How to Duplicate and Standby database with RMAN
 
16:19
This is a step by step guide.
Views: 1900 Satyajit Mukherjee
Module 1- Introduction to Oracle Database
 
13:39
Hello viewers, We are starting our section on professional courses and for which we are starting our course material which is based on the Oracle Database, Please refer to the description below for knowing which topics will be covered in Oracle DBA Installation Module 1 – Introduction to Database • Introduction to Database • How ORACLE DB does it • Unix kernal Module 2 – Physical Database Structure • Physical Database Structure • Control files • Key information of files • Redo log files Module 3 – Oracle Storage structures • Oracle Storage structures • Table statement • How to check “create table” • Schemas and schema objects • Data blocks • Extents • Segments Module 4 – Memory & Process Architecture • Memory & Process Architecture • Instance/Memory structures • Shared pool • Buffer Cache • Redo Log Buffer • Process Architecture • Background process Module 5 – Background Process, Alert & Trace files • Background Process, Alert & Trace files • Alert • Trace files Module 6 – Database Startup & Serving User Requests • Database Startup & Serving User Requests • Offline backup • Standby Database Module 12 – Oracle Recovery Manager (RMAN) • Oracle Recovery Manager (RMAN) • Data pump export & import • SQL loader • External table Module 13 – Data dictionary & Dynamic Performance Tables • Data dictionary & Dynamic Performance Tables • Dynamic performance Tables • Typical day ORACLE DBA Module 14 – Introduction to Database Tuning • Introduction to Database Tuning • Monitor space usage • Monitor SQL scripts • Data base tuning • SQL tuning • Table Statistics • Index statistics • Index Selectivity • Chained Rows • Locks Module 15 – Introduction to Database Tuning Continued • Introduction to Database Tuning Continued • Tuning Shared pool • Data dictionary performance • Data dictionary tuning • PL/SQL code • Code reuse • Data base Buffer • Buffer cache hit Ratio • Code reuse • Database Startup • User process, Server process Module 7 – Database Security • Database Security • Process of “Create User” • Alter & Drop User • Resource Limits & profiles • Auditing Module 8 – Schema Objects • Schema Objects • Types of schema objects • How table data is stored • Temporary Tables • External Tables Module 9 – Schema Object Continued • Schema Object Continued • Materialized View • Sequence Generator • Indexes • B-Tree index structure • Cluster/Hash Cluster • Data concurrency & consistency • Locking • Deadlocks Module 10 – Oracle Network Environment • Oracle Network Environment • How to connect your database • Network environment of ORACLE • Database link Module 11 – Oracle Backup & Recovery Concepts • Oracle Backup & Recovery Concepts • Standby database • Testing • Media recovery options so in today's video, we will be discussing Module -1 The Introduction to Oracle Database. ----------------------------------------------------------------------------------------------------------- For downloading notes in PDF format please visit my Blog https://thedynamicstudy.blogspot.com/ ---------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------- Please go through the video and don't forget to share your views and subscribe the channel to keep the content open and reachable to students. ---------------------------------------------------------------------------------------------------- keep on watching, keep on learning! #dynamicstudy -~-~~-~~~-~~-~- Please watch: "OCTAPACE - Detailed Explanation in Hindi" https://www.youtube.com/watch?v=f_4WET6y49c -~-~~-~~~-~~-~-
Views: 145 Dynamic Study
Oracle DBA Justin - How to mirror/multiplex online redo log files
 
08:32
How to mirror/multiplex online redo log files
Views: 5914 jbleistein11
Oracle DB 12c - Recovery Manager (RMAN) New Features
 
14:13
Oracle DB 12c - Recovery Manager (RMAN) New Features Watch more videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjabi, Tutorials Point India Private Limited
how to take  hot backup of database manually
 
07:37
can we take hot backup when the database is in noarchive log mode? =================================================================== no archive log list; alter database begin backup; can we shutdown a database when it is in backup mode? ===================================================== alter database begin backup; shutdown immediate; ==no shutdown normal;==no shutdown transcational;==no shutdown abort;==yes database is in hot backup mode,db crashes now how to recover and open the database? =================================================================================== alter databse begin backup; shutdown abort; ORA-10873: file 1 needs to be either taken out of backup mode or media recovered ORA-01110: data file 1: 'E:\DATABASE\DATABASE\ORADATA\ORCL\SYSTEM01.DBF' solution: startup mount; alter database end backup; alter database open; how to check whether the database is in backup mode or not? =========================================================== select * from v$backup; how to take hot backup of database manually? ============================================ alter database begin backup; copy datafiles manually from original location to backup location alter database end backup; alter system switch logfile; alter system switch logfile; alter system switch logfile; copy archives from archive location to backup location. alter database backup controlfile to trace; (or) alter database backup controlfile to location; copy controlfile to backup location. How to check current_scn number of database? ============================================= select CURRENT_SCN from v$database; select dbms_flashback.get_system_change_number from dual; select timestamp_to_scn(sysdate) from dual; how to check datafile header scn number? ========================================= select name,CHECKPOINT_CHANGE# from v$datafile_header; when checkpoint will occur? ============================ alter system switch logfile; alter database begin backup; alter database end backup; alter system checkpoint;(manual checkpoint) shutdown immediate;(when the database is down) what will happen when checkpoint occurs? ========================================= scn of datafile header will update;
Views: 2257 Praveen Biyyapu
Oracle DBA Justin -  How to re-create a dropped/deleted data dictionary view
 
08:34
How to re-create a dropped/deleted data dictionary view
Views: 1995 jbleistein11
Oracle DBA Justin - How to kill a user session connected to an Oracle database
 
07:32
How to kill a user session connected to an Oracle database
Views: 8207 jbleistein11
Oracle DBA Justin - How to install Statspack in an Oracle database
 
11:59
How to install Statspack in an Oracle database
Views: 6121 jbleistein11
Understanding Oracle Database Undo and Redo (1 of 2)
 
03:24
Oracle's Undo and Redo architecture supports crash recovery and the database "ACID" test, i.e. transaction atomicity, consistency, isolation and durability. Understanding this architecture and how it works is essential knowledge for all DBA's. This tutorial requires a background in Oracle SQL and helpful is an understanding of Oracle system and dynamic views, e.g. v$bh. Presented by SkillBuilders' Oracle Certified Master DBA John Watson.
Views: 1163 SkillBuilders
Backup & Recovery oracle database scenarios part 1
 
54:57
Backup & Recovery oracle database scenarios part 1
Views: 4535 COMBINATIONS FOR ALL
Datafile Recovery
 
05:11
#Oracle #RMAN Datafile Recovery
Views: 1701 Hemant K Chitale
Oracle DBA, controlfiles, datafiles, online redolog files 1e6
 
03:26
Three very important files in oracle database
Views: 3287 hammadshams
Oracle DBA Justin - How to backup an 11g Oracle database hot  # 3 of 4
 
14:24
How to backup an 11g Oracle database hot
Views: 17283 jbleistein11
Oracle DBA Justin - How to put an Oracle database in restricted session mode
 
09:30
How to put an Oracle database in restricted session mode
Views: 2600 jbleistein11
How to recover a dropped table in oracle?
 
16:52
This is a free tutorial video on how to use the FLASHBACK TABLE query to restore a dropped table in oracle, and we have given some useful information on PURGE, RECYCLEBIN and shown some demo on how to restore a dropped table in oracle.
Views: 2543 Kishan Mashru
Oracle DBA Justin - How to backup and restore an Oracle database with RMAN (basic)
 
18:53
How to backup and restore an Oracle database with RMAN (basic)
Views: 302487 jbleistein11