Home
Search results “View scn in oracle”
How To Flashback a Table to particular SCN in Oracle
 
08:38
How To Flashback a Table to particular SCN in Oracle
Views: 5668 Abbasi Asif
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: 3229 Praveen Biyyapu
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: 17650 jbleistein11
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: 9936 Ramkumar Swaminathan
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: 58062 Oresoft LWC
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: 9548 mvige
Relationships of Physical and Logical Storage structures in an Oracle Database - DBArch Video 22
 
06:14
In this video you will understand the Relationships between the Physical files and Logical Components - Tablespace, Segments, Extents and Oracle Blocks 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: 9545 Ramkumar Swaminathan
Redo Logs in an Oracle Database - DBArch Video 11
 
08:54
This video explains the concepts of Redo Log Groups and Files in an Oracle Database. You will understand how Oracle Instance uses Redo Buffers and Logwriter to keep the redo in Redo Logs. 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: 11729 Ramkumar Swaminathan
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: 81101 jbleistein11
Oracle Data Export and Import using DataPump expdp and impdp
 
09:38
Oracle Data Export and Import using DataPump expdp and impdp
Views: 171353 Abbasi Asif
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.. By lalit saini
Views: 2029 Oracle World
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.Oracle database Unbeatable,Unbreakable Platform..
Views: 1334 Oracle World
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: 4936 jbleistein11
Oracle DBA Justin - How to set the Oracle environment on a Unix or Linux system
 
28:22
How to set the Oracle environment on a Unix or Linux system
Views: 45831 jbleistein11
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
Views: 1492 Tech Query Pond
Oracle DBA Justin - Oracle database internals - Dynamic performance views
 
22:15
Oracle dataase internals - Dynamic performance views
Views: 6779 jbleistein11
Converting Oracle Database from Windows to Linux using RMAN
 
13:38
Learn how to migrate oracle database from Microsoft Windows to Linux using RMAN
Views: 20269 Naeem Sheeraz
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: 11503 Abbasi Asif
Oracle DBA Justin - How to reset the log sequence number in an Oracle database
 
10:39
How to reset the log sequence number in an Oracle database
Views: 5015 jbleistein11
RMAN Recovery Scenarios Session - 4
 
02:09:11
Recently i took RMAN sessions to some group of people and as a part of it i explained various scenarios of rman restore and recovery operation. I tried to record the video for the purpose of the people who follow my blog. In this present session we will see various recovery scenarios mentioned below. 1) Complete database restore and recovery 2) Loss of System Datafile 3) Non-System datafile ( closed and Open ) 4) Restoring a tablespace ( closed and Open ) 5) Restoring a datafile if no backups 6) Restoring a datafile to different location 7) Restoring controlfile 8) restoring spfile 9) Restoring online redologs 10) Restoring temporary datafiles 11) Incomplete Recovery ( time based , Change based and SCN based ) 12) Recovering archived logs The following video demo gives you detailed explanation of each scenario and how to restore and recover under different scenarios. Setup: ===== Let me explain you the environment used for this practice. I am using a database with ORACLE_SID=orcl as my database for testing all the different scenarios mentioned above. I am using a recovery catalog for my rman configuration and its details are ORACLE_SID=rmandb and schema used for rman catalog data is rman and the tns alias to connect to catalog database is rmandb. I have both my databases orcl and rmandb in archive log mode and i also have backup for my database orcl. For all my restore and recover operations i am using the following syntax to connect to target database and catalog database. rman target / catalog rman/*******@rmandb
Oracle DBA Justin - Using the controlfile autobackup feature of RMAN
 
26:09
Using the controlfile autobackup feature of RMAN
Views: 13278 jbleistein11
Oracle 11G Using Flash bask Technology
 
05:19
Working Example of Flash back Technology in Oracle 11G. Remember to enable row movement on all tables for which you feel you may have to use flashback technology. Also before note down the System Change Number (SCN) or Point in Time. To Learn or Teach Oracle visit www.theskillpedia.com, A Marketplace for Learners and Trainers.
Views: 1360 TheSkillPedia
Oracle DBA Justin - How to multiplex/mirror a controlfile of an Oracle database
 
14:54
How to multiplex/mirror a controlfile of an Oracle database
Views: 6950 jbleistein11
User and Schema - DbArch Video 33
 
04:31
In this video you will understand whats the difference between an Oracle User and Schema. You will also get to know about some of the most frequently created objects in a Schema. 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: 3516 Ramkumar Swaminathan
Oracle DBA Justin - How to perform a differential incremental Oracle database backup
 
13:11
How to perform a differential incremental Oracle database backup
Views: 12402 jbleistein11
Oracle - Export
 
22:21
Oracle - Export
Views: 11911 Chris Ostrowski
Oracle DBA Justin - How to clone an Oracle database not using RMAN
 
20:23
How to clone an Oracle database not using RMAN
Views: 60190 jbleistein11
Oracle DBA Justin - How to change the name of an Oracle database # 1 of 2
 
16:11
How to change the name of an Oracle database
Views: 9917 jbleistein11
Oracle DBA, SPfile and Pfile, Initialization parameters, 1e14
 
10:47
Oracle initialization parameter file
Views: 9744 hammadshams
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: 282788 jbleistein11
RMAN Full DB Restore Recover
 
07:23
RMAN Full Database Restore and Recover
Views: 7424 Hemant K Chitale
Backup & Recovery oracle database scenarios part 1
 
54:57
Backup & Recovery oracle database scenarios part 1
Views: 4212 COMBINATIONS FOR ALL
Flashback Database Oracle 11g
 
10:53
This video show how to flashback database in oracle 11g
Views: 1050 Pratiwi galuh putri
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: 1870 Kishan Mashru
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).Oracle database Unbeatable,Unbreakable Platform..
Views: 4867 Oracle World
Oracle 11G - Backup and Recovery using RMAN
 
16:59
Demonstration of three steps: 1. Take a Full backup using RMAN. 2. Simulate Disk Failure by deleting Data Files. 3. Performing Recovery of data Files from Backup. To Learn or Teach Linux visit www.theskillpedia.com, A Marketplace for Learners and Trainers.
Views: 14075 TheSkillPedia
Oracle DBA Justin - How to use the spool command in Sqlplus
 
12:50
How to use the spool command in Sqlplus
Views: 31911 jbleistein11
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: 24541 jbleistein11
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: 4971 Ramkumar Swaminathan
Oracle DBA Justin - How to drop/delete a user account from an Oracle database
 
07:41
How to drop/delete a user account from an Oracle database
Views: 5245 jbleistein11
CommVault Simpana 9: Oracle IDA Simple Restore Demo
 
03:29
This video demonstrates CommVault Simpana 9's ability to restore an Oracle DataBase after file corruption. It's shows CommVault Oracle IDA recovering a simple oracle database after a key file has been removed and the DB has stopped. SNS Limited are independent UK based Storage, Virtualisation & Backup specialists. Look us up online on : www.snsltd.co.uk or drop us a mail if you have any questions on : [email protected] Thanks for watching.
Views: 3241 SNSLimitedUK
Read Consistency -  Introduction - DBArch Video 24
 
03:29
In this video you will understand how Oracle Database implements Concurrency and Consistency when Multiple users access the data. . 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: 3123 Ramkumar Swaminathan
Oracle DBA Justin - ASM startup sequence
 
08:41
ASM startup sequence
Views: 8553 jbleistein11
How To Configure Oracle Database  in ArchiveLog Mode
 
09:47
How To Configure Oracle Database in ArchiveLog Mode / NoArchiveLog Mode
Views: 3942 Abbasi Asif
Oracle DBA Justin - How to wrap PL/SQL code in an Oracle database
 
15:28
How to wrap PL/SQL code in an Oracle database
Views: 15679 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
Flashback Version Query
 
03:15
This video gives an overview of the Flashback Version Query functionality in Oracle, which can be used to display how data in a row has changed over time. For more information see: https://oracle-base.com/articles/10g/flashback-10g Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by Tanel poder : Website: https://gluent.com/ Blog: http://blog.tanelpoder.com/ Twitter : https://twitter.com/TanelPoder Cameo appearances are for fun, not an endorsement of the content of this video. All trademarks, product names and logos are the property of their respective owners.
Views: 934 ORACLE-BASE.com
Oracle - Putting Your Database into ARCHIVELOG mode
 
18:05
Oracle - Putting Your Database into ARCHIVELOG mode
Views: 3020 Chris Ostrowski
How to purge data in Oracle General Ledger module?
 
11:30
This is an ultimate solution to purge data from Oracle general ledger module. It has all the details from setup to whole process. This process can work across 11i, R12.1.3, R12.2.6. Review whole video to get an exact idea of purging process for General ledgers.
Views: 138 Indian Oracle
Oracle Recruiters Answer Your Questions
 
08:13
Are you concerned about the best approach to applying for a role within Oracle? In this video, Recruiters Saul and Fiona answer questions from some of our followers on social media. If you have any questions, feel free to ask us on http://facebook.com/oraclecommunity http://twitter.com/oracle_emeajobs, or leave comments under this video.
Views: 18741 Klaudia Drulis