Home
Search results “Oracle media recovery log”
Oracle Database Backup and Recovery Session 1
 
02:38:11
https://dbagenesis.com/p/oracle-advanced-rman-backup-recovery DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available on demand. MASTER AND LEARN - Backup and Recovery Overview - Cold Database Backup - Hot Database Backup - Manual Database Recovery
Views: 141255 DBA Genesis
Oracle Tutorial For Beginners - Redo Log File Incomplete Recovery
 
09:56
Hello guys in this tutorial i briefly explaining how to recover a redo log file from archive backup...its called a Cancel Based Recovery... By Lalit saini
Views: 3081 Oracle World
Transaction Failure, Recovery and Log
 
12:36
Join Discussion: http://www.techtud.com/video-lecture/transaction-failure-revovery-and-log IMPORTANT LINKS: 1) Official Website: http://www.techtud.com/ 2) Virtual GATE: http://virtualgate.in/login/index.php Both of the above mentioned platforms are COMPLETELY FREE, so feel free to Explore, Learn, Practice & Share! Our Social Media Links: Facebook Page: https://www.facebook.com/techtuduniversity Facebook Group: https://www.facebook.com/groups/virtualgate Google+ Page: https://plus.google.com/+techtud/posts Last but not the least, SUBSCRIBE our YouTube channel to stay updated about the regularly uploaded new videos.
Views: 59796 Techtud
Datafile Recovery
 
05:11
#Oracle #RMAN Datafile Recovery
Views: 1236 Hemant K Chitale
Oracle Tutorial For Beginners Control File Recovery from Trace File in Oracle 11g
 
10:55
In this scenario i explaining how to recover a control file in oracle 11g. control file is the most important part in oracle database. by Lalit saini
Views: 5537 Oracle World
Oracle Tutorial - How to recover a corrupted NON SYSTEM datafile (database in ARCHIVELOG mode)
 
06:19
The following scenario describes what happens when a non system datafile is lost. Before proceeding be sure to have a complete backup of your database and be sure your database is in ARCHIVELOG mode. by Lalit saini
Views: 2076 Oracle World
Using Recovery Manager (RMAN) for Block Media Recovery of Corrupted Oracle Data Block
 
28:38
Oracle Database : Using Recovery Manager (RMAN) for Block Media Recovery of Corrupted Oracle Data Block
Views: 2765 Satish Lodam
Oracle World - How to perform RMAN Recovery Block Corruption
 
13:11
Let us look at a test case where we corrupt from blocks in a particular datafile and then use the RMAN blockrecover command to recover the corrupted data blocks.
Views: 3327 Oracle World
Oracle DBA Justin - How the RMAN recovery window retention setting works # 1 of 2
 
26:53
How the RMAN recovery window retention setting works # 1 of 2
Views: 5945 jbleistein11
Oracle Data Export and Import using DataPump expdp and impdp
 
09:38
Oracle Data Export and Import using DataPump expdp and impdp
Views: 170981 Abbasi Asif
CDB Backup & Recovery | Oracle DBA 12c Tutorial | Online Oracle DBA Training | Intellipaat
 
35:50
This tutorial on Oracle DBA is a hands on Oracle Database 12c, CDB Backup & Recovery, NOARCHIVE LOG Mode, Media Failure, Flashback CDB, Data Dictionary Views in Oracle Database. If you’ve enjoyed this video, Like us and Subscribe to our channel for more similar informative videos and free tutorials. Got any questions about Oracle DBA? Ask us in the comment section below. Are you looking for something more? Enroll in our Oracle DBA training course and become a certified Oracle DBA Developer (https://goo.gl/HGzbeU). It is a 18 hrs instructor led training provided by Intellipaat which is completely aligned with industry standards and certification bodies ------------------------------ Intellipaat Edge 1. 24x7 Life time Access & Support 2. Flexible Class Schedule 3. Job Assistance 4. Mentors with +14 yrs industry experience 5. Industry Oriented Courseware 6. Life time free Course Upgrade ------------------------------ Why take this course? The Oracle DBA is associated with the relational database management system. The role of the Database Administrator is crucial to managing the huge volumes of data in large enterprises. Hence Oracle DBA professionals are in huge demand. This Training Course will provide you with the necessary skills to take up jobs as Database Administrators in top companies for big salaries. ------------------------------ What you will learn in this course? This course will be covering following topics: 1.Learn about the core database concepts 2.Role of database administrator 3.Understanding of SQL and PL/SQL 4.Physical and logical structure of database 5.Introduction to table space 6.Configuring and managing the Oracle Network 7.Database configuration and programming 8.Installation, harnessing cloud, storage management 9.Database best practices and scripts 10.Prepare for the Oracle DBA Certification ------------------------------ For more information: Please write us to [email protected] or call us at: +91-7847955955 Website: https://goo.gl/HGzbeU Facebook: https://www.facebook.com/intellipaatonline LinkedIn: https://www.linkedin.com/in/intellipaat/ Twitter: https://www.twitter.com/intellipaat
Views: 379 Intellipaat
Oracle DBA Justin - How to unregister a target database from an RMAN recovery catalog
 
13:32
How to unregister a target database from an RMAN recovery catalog
Views: 3928 jbleistein11
Oracle DBA Justin - How the RMAN recovery window retention setting works # 2 of 2
 
10:07
How the RMAN recovery window retention setting works # 2 of 2
Views: 5752 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: 9541 mvige
Oracle Recovery
 
00:20
Recorded on April 04, 2008 using a Flip Video camcorder.
Views: 1112 Modelrocket4
Oracle Database Tutorial 56:Data Pump impdp table and Duplicate (Remap_table ) table
 
06:03
In this oracle database tutorial you will learn How to import table using impdp data pump import utility. And how to rename table using REMAP_TABLE in impdp Data Pump import. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/oracle-data-pump-impdp-import-and-duplicate-table-remap-table Previous Tutorial Tut 55 expdp table- http://youtu.be/5mdmCqGuok8 Tut 54 expdp Schema - http://youtu.be/t8TSLDGN5gg Tut 53 expdp Tablespace - http://youtu.be/-hXBZd-FCjs Tut 54 expdp Full Database - http://youtu.be/K8_PjUksT54 ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at [email protected] Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 22844 Manish Sharma
Configuring Oracle Database to use Archive Log Mode
 
05:02
small video that explains how to setup oracle database to use the archivelog mode.
Views: 5028 jricardooliveira
RMAN: How to recover a corrupted NONSYSTEM datafile (database in ARCHIVELOG mode)
 
05:20
The following scenario describes what happens when a nonsystem datafile is lost. Before proceeding be sure to have a complete backup of your test database and be sure your database is in ARCHIVELOG mode. A complete description could be found here: http://dbaworkshop.blogspot.it/2012/08/how-to-recover-corrupteddamagedlostcanc.html
Views: 1995 mvige
System Data File Recovery in Oracle Database 12c
 
07:06
In this video , you will learn how to recover SYSTEM01.dbf file in case you lost it in Oracle Database 12c. For More Videos and Blogs:- Visit Our Website - http://www.dbatrainer.com Also , Subscribe and Follow us on our social media pages:- LinkedIn - https://www.linkedin.com/company/dbatrainer FaceBook - https://www.facebook.com/dbatrainer Google Plus - https://plus.google.com/+DBATrainer Twitter - https://www.twitter.com/DBA_Trainer "Exceptional Education. Exceptional Value."
Views: 161 DBA Trainer
How to recover corrupt oracle database?
 
01:02
Watch this : http://www.oracledatabaserecovery.com/ or http://www.stellarinfo.com/database-recovery/oracle-recovery/oracle-recovery.php I had found this video while researching on Oracle Database. The thing which encourage me to select this video in my selection that what happen when some thing went wrong with our database specially in case of Oracle if we lost some tables, vies, stored procedures etc. I had search for my favorite company does they provide any solution for Oracle Databse and believe me they provide. Stellar Phoenix Oracle database recovery software which is capable to recover or repair .dbf files from corrupted Oracle Database. This is my own experience about this company I am not related to this in any manner.
Views: 2319 Martin Crow
database is in hot backup mode,db crashes now how to recover and open the database
 
04:06
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: 679 Praveen Biyyapu
ORACLE WORLD - Recovery of Dropped Tablespace using  TSPITR without RMAN
 
17:05
Hello friends in this video I'm going to explain you how to recover the dropped tablespace using point in time recovery in oracle 11gR2 without rman backups Oracle database Unbeatable,Unbreakable Platform..
Views: 9143 Oracle World
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
Oracle Guaranteed restore points
 
39:29
Restore points and related data protection features enable us to rewind data back in time to correct any problems caused by logical data corruption or user errors within a designated time window. These features provide a more efficient alternative to point-in-time recovery and does not require a backup of the database to be restored first. The effects are similar to database point-in-time recovery (DBPITR). Restore points is not only effective in traditional database recovery situations but can also be useful during database upgrades, application deployments and testing scenarios when test databases must be quickly created and re-created. Restore points provide capabilities related to Flashback Database and other media recovery operations. In particular, a guaranteed restore point created at a system change number (SCN) ensures that you can use Flashback Database to rewind the database to this SCN. You can use restore points and Flashback Database independently or together
Views: 1138 Naveen Calappurackal
Trace It, Log It, Format It - Part 1
 
01:28:11
Oracle Performance Tuning - Logging and Tracing in Oracle In this video I have explained how to enable Oracle Trace for a session, service, module, action or client identifier using Oracle Event 10046, SQL_TRACE, DBMS_MONITOR, DBMS_SUPPORT, DBMS_SYSTEM, location of log and trace files and how to write custom messages to alert.log file
Views: 4267 Satish Lodam
Recovery Scenario5 BLOCK CORRUPTION
 
01:08:37
This video talks how to recover database from block corruption.
Oracle Database : Undo Management Short Overview
 
25:04
Oracle Database Undo Management Short Overview
Views: 4485 Satish Lodam
Oracle Tutorial for beginners - Recovery of dropped tablespace with RMAN.
 
18:55
Hello friends in this session i'll showing a Demo of Recovery of dropped tablespace with RMAN. By Lalit saini
Views: 3645 Oracle World
Oracle Data Guard 11g - Why force logging on primary database?
 
18:24
I showed what is effect of no force logging on primary database withthis video. I think this video answered -Why force logging on primary database- question. Mahir M. Quluzade www.mahir-quluzade.com
Views: 4898 Mahir M. Quluzade
20 Recovery Resetlogs
 
15:32
How to recover resetlogs in oracle 11g DBA
Views: 609 NewTechnology
Oracle Logminer HowTo Guide
 
14:44
A HOWTO guide to help you start using Oracle's LogMiner. It is a useful tool for auditing redo logs and archive logs. Everything was done on a Oracle Linux 6.2 OS, database version is 12c which was used for testing purposes only.
Views: 4612 Blaz Lampreht
INCOMPLETE TIME BASED RECOVERY IN ORACLE
 
07:32
INCOMPLETE TIME BASED RECOVERY...
Views: 181 junaid khan
database recovery management | DBMS
 
11:41
3 states of recovery - pre condition - condition - post condition
Views: 12021 Education 4u
Recover Database upto Recent Backup in No Archive mode when  missed all redo groups and any datafile
 
09:40
By Vivek Saxena Shabad Coachings Recover Database upto Recent Backup in No Archive mode when missed all redo groups and any datafile show parameter db_name; startup archive log list alter system switch logfile create table vishu(rn number(10)) tablespace vivek; insert into vishu values(1) commit shut immediate startup ERROR ORA-01257: cannot identify/lock data file ORA-01110: data file shut immediate startup ERROR ORA-00313 open failed for member of log group ORA-00312: online log recover database until cancel //media recovery complete alter database open resetlogs;
How to restore tablespace in case of NO backup
 
14:09
In this video i'm going to show you how to restore tablespace in case of no backup using RMAN.
Views: 1299 OCP Technology
Controlfile & redolog file management
 
39:45
Multiplexing the control file, adding Redolog to the database, Adding Redolog member to the existing group, Drop Redolog member tfrom the database, Drop Redolog group from databse, Resizing Redo log groups, an last but not the list.... Views.
Views: 3399 techbrain
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
Views: 23 Dynamic Study
Oracle tutorial for beginners - Switch to Image copy for fast recovery with RMAN
 
17:45
Hello guys I explaining with this video how to backup database as copy, how to use switch to copy image for fast recovery and how to recover corrupted datafile without close database. Oracle database Unbeatable,Unbreakable Platform..
Views: 1986 Oracle World
Netbackup Catalog Backup , DR File and Catalog Recovery
 
06:03
Netbackup Catalog Backup, DR files and Catalog Recovery in Testing Environment. Please review support portal steps and prerequisite before proceeding in Production Environment
Views: 11445 Ishu Khani
How to corrupt a block and how to recover it
 
11:34
In this session i'm going to discus with you How to corrupt a block and how to recover it step by step
Views: 2738 OCP Technology
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: 1742 Praveen Biyyapu
Monitoring of Oracle Data Guard - Physical Standby Database
 
10:53
Monitor Physical Standby database health check - all redo information applying on standby database or not , all background process for data guard environment started or not. For More Videos and Blogs:- Visit Our Website - http://www.dbatrainer.com Also , Subscribe and Follow us on our social media pages:- LinkedIn - https://www.linkedin.com/company/dbatrainer FaceBook - https://www.facebook.com/dbatrainer Google Plus - https://plus.google.com/+DBATrainer Twitter - https://www.twitter.com/DBA_Trainer "Exceptional Education. Exceptional Value."
Views: 946 DBA Trainer
SQL tutorial 48: How to create Roles in Oracle Database
 
07:16
4th SQL Tutorial in the series of user privileges in oracle database user Roles in Oracle Database. In this tutorial you will learn ● What user roles ● How to create simple roles (Role with Not Identified clause) ● How to create secure roles (Role with Identified clause) ● How to create external role. ● How To create global role. ● How to Grant System Privilege to a user Role ● How to Grant Object Privilege to a user Role In oracle database. ● How to grant a Role to another Role ● How To grant a role to database users (with Admin option) ● How To enable role using SET ROLE statement This video will teach you the concept of user role in oracle database which is an extension to the user privileges. In this video I did 10 SQL queries on user Roles which makes this tutorial fun. Celebrating 1000 subscribers. Thanks a lot guys for all your love and support. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/create_role_in_oracle System Privilege: http://youtu.be/EQzdtKPiErU Object Privilege: http://youtu.be/DuDL7NTPdqQ ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the first one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at [email protected] Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 22100 Manish Sharma
Understanding Listener and Dynamic Service Registration
 
49:59
Understanding Oracle Listener and Dynamic Service Registration
Views: 6078 Satish Lodam
can we take hot backup when the database is in noarchive log mode
 
03:42
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: 296 Praveen Biyyapu
Exploring the Oracle Database Architecture - Part-1 (Video-2)
 
01:26:12
In this video I have explained the following topics of Oracle Database Architecture 1. Private Global Area/Program Global Area (PGA) and Database Instance Connection 2. Oracle SQL Statement Processing - PGA, Private SQL Areas and Shared SQL Areas 3. Oracle SQL Statement Processing - Parsing 4. Oracle SQL Statement Processing - Flow 5. Oracle SQL Statement Processing - Example
Views: 9263 Satish Lodam
Oracle Database Tutorial 52 : Data Pump expdp - How to Export full database using expdp
 
07:26
Oracle Database tutorial/SQL Tutorial 52 On Data Pump expdp utility here in this tutorial you'll learn how to export full/complete Database using expdp data pump utility of oracle Database ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/database-full-export-using-expdp Tut 48 Roles: http://youtu.be/tyYxSrCXzCM ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at [email protected] Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 70783 Manish Sharma
Oracle Database11g tutorials - What is Archive log mode and how to enable Archive log mode.
 
16:24
What is Archivelog mode what is Noarchivelog mode and how to enable archivelog mode into oracle database... by Lalit saini
Views: 4221 Oracle World