Home
Search results “Oracle standby database rman”
Creating a Physical Standby database using RMAN - DG Video 4
 
08:10
In this video you will learn about creating a Physical Standby Database using RMAN in an Oracle Data Guard environment. This video explains about the pre-requisites that are to be done before you run the RMAN command to create a standby 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: 10906 Ramkumar Swaminathan
Creating Duplicate and Standby database using RMAN
 
16:19
Creating Duplicate and Standby database using RMAN cloning database oracle on linux make standby db
Views: 6695 mohamed suez
Oracle DBA Justin - How to create a basic Dataguard physical standby database # 1 of 3
 
21:47
How to create a basic Dataguard physical standby database # 1 of 3
Views: 58384 jbleistein11
Oracle- How to Duplicate and Standby database with RMAN
 
16:19
This is a step by step guide.
Views: 1890 Satyajit Mukherjee
Steps to create a standby database in Oracle 11g | physical standby database data guard concepts
 
51:01
In this video we discuss in detail about the steps for configuring a standby in Oracle 11g .This tutorial consits of 5 video and this video is the first among them.
Views: 45713 Wysheid Wysheid
Oracle Data Guard part1: Creating Physical Standby Database in Oracle 12c
 
25:30
Oracle Data Guard is the ultimate Disaster Recovery Solution provided by Oracle Database. This video should be helpful for the DBAs responsible for Managing Enterprise Database. Script used in the Video can be downloaded from the following link: https://drive.google.com/file/d/0B9KYQAdHoJPuckExcU5LdmRwdUU/view?usp=sharing
Views: 4056 Oracle Testlab
How to Start Physical Standby database & Check if Database is in Sync
 
06:32
How to Start Physical Standby database & Check if Database is in Sync Dataguard Status ==================================================== Start Standby Database =============================== startup nomount alter database mount standby database; alter database recover managed standby database disconnect from session; DB STATUS ======================= select status,instance_name,database_role,protection_mode from v$database,v$instance; TO check if dataguard in synchronizing with standby. ============================================================================= select thread#,max(sequence#) from v$archived_log where applied='YES' group by thread#; Status of MRP Process --------------------------- select process,status,client_process,thread#,sequence#,block#,blocks,delay_mins from v$managed_standby; To get the diffrence between Recived and applied logs. ------------------------------------------------------- select MAX_RECEIVED,MAX_APPLIED,(MAX_RECEIVED - MAX_APPLIED) as "Difference" from (SELECT ARCHIVED_THREAD#, MAX(ARCHIVED_SEQ#) as MAX_RECEIVED, APPLIED_THREAD#, MAX(APPLIED_SEQ#) as MAX_APPLIED FROM V$ARCHIVE_DEST_STATUS) ARCH ; ================================================= Hi Folks, Greetings!! I am professional part time oracle dba trainer and having good experience in oracle database administration. This is the right place to enroll yourself for Oracle DBA real time course. Please use following email ID for more details. Don’t hesitate to WhatsApp me any time. I will give you the best training and will create path to get DBA job easily. Enjoy the free YouTube video and connect with me for deep Oracle DBA knowledge. Mobile No : + 91 9960262955 (WhatsApp Number) EmailID: [email protected] Please visit my official website for oracle database training and hadoop blog. https://www.orcldata.com/ Please donate on below link if you think I am helping you with your career. https://www.paypal.me/ankushthavali OR Google Pay : 9960262955 OR Account No : 31347845762 IFSC: SBIN0012311 how to check data guard status oracle how to check lag in data guard how to sync primary and standby database in oracle how to check archive log gap standby database how to check if archive logs are applied to standby database query to check archive log gap how to check if database has standby how to check standby database name from primary
Views: 1724 ANKUSH THAVALI
switchover role primary to standby and vice versa in Oracle 11g R2 | Part-6
 
08:59
In this tutorial i'm going to show you how to switch-over role primary to standby and vice versa in Oracle 11g R2 #dataguard #switchover #primary #standby #oracle11gR2 website:- www.ocptechnology.com
Views: 8379 OCP Technology
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: 1460 DBA Trainer
Oracle 12c Data Guard Create Physical Standby Database
 
54:14
#Purpose This tutorial describes the steps to create an Oracle 12c Physical Standby database. The tutorial was implemented using Oracle VirtualBox version 5 and an appliance with Oracle Database 12c Release 1 installed on Linux 6 with Automatic Storage Management (ASM) instance #Tutorial Document The tutorial has been documented and its document can be downloaded from the following link: http://www.ahmedbaraka.com/videos #TIMESTAMPS 0:03 Introducing the tutorial 2:08 Oracle Data Guard Usages 5:29 Start of the tutorial 10:20 Prepare the tutorial environment 31:45 Prepare the Primary Database 45:19 Prepare the Standby Database system 50:55 Create the Physical Standby Database #LINKS Have a look at my course https://www.udemy.com/oracle-12c-data-guard-administration #about Ahmed Baraka I began my career as an Oracle Developer but soon transitioned to Oracle Database Administration. I have 18 years of extensive experience in the computer industry, with focus on Oracle database administration technologies like Oracle RAC, ASM, Data Guard, GoldenGate, WebLogic, Database Appliance, and Enterprise Manager. # Download You can download the VM machines (appliances) that has been created in the tutorial from the following link: http://www.ahmedbaraka.com/download.html #Contact Info [email protected] https://www.facebook.com/profile.php?id=100010975452842 https://twitter.com/hmedBaraka1
Views: 22378 Ahmed Baraka
Oracle Data Guard 12c - Part 1 - Create Physical Standby Database
 
09:09
In Part 1 of this video series, I will show creation of Physical Standby Database in Oracle Database 12c (Multitenant environment).
Views: 366 Evoxera
Oracle Data Guard - Types of Standby Database
 
04:24
Oracle Data Guard - Types of Standby Database Watch more Videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjabi, Tutorials Point India Private Limited.
Step by Step guide to build data guard in Oracle 11g |Physical standby database Data guard |
 
01:18:25
Step by Step guide to build data guard in Oracle 11g
Views: 114120 Wysheid Wysheid
Create Oracle Standby Database using Oracle Enterprise Manager 12c
 
08:25
Step by Step Video tutorial on how to Create Oracle Standby Database using Oracle Enterprise Manager 12c More Articles, Scripts and How-To Papers on http://www.aodba.com
Views: 2397 AO DBA
11g Standby : RMAN Active Duplicate method (Without backup)
 
58:53
The procedure for creating a standby database with RMAN is almost the same as for creating a duplicate database. To create a standby database with the DUPLICATE command you must connect as target to the primary database and specify the FOR STANDBY option. You cannot connect to a standby database and create an additional standby database. RMAN creates the standby database by restoring and mounting a control file. RMAN can use an existing backup of the primary database control file, so you do not need to create a control file backup especially for the standby database. A standby database, unlike a duplicate database created by DUPLICATE without the FOR STANDBY OPTION, does not get a new DBID. Thus, you should not register the standby database with your recovery catalog. Please Find the below link to download checklist to create Active duplicate standby: ************************************************************************************* https://drive.google.com/open?id=0B1Vyp5-9fissS21aUWxISDYyQWc Follow the below link to find other oracle stuffs. http://oraerrors.blogspot.in/ Pradeep kumar +91-9972201100
Views: 742 Pradeep Kumar
Creating an Oracle 12c R2 Physical Standby RAC Database from a Primary RAC
 
01:00:27
#Purpose This tutorial demonstrates creating an Oracle 12c R2 Physical standby RAC database from a Primary RAC database. #Tutorial Document The tutorial has been documented and its document can be downloaded from the following link: http://www.ahmedbaraka.com/videos #TIMESTAMPS 0:03 Introducing the tutorial 7:30 Data Guard Considerations in RAC 10:40 Start of the tutorial 14:20 Preparing the Primary Database 27:05 Prepare the Standby System 33:00 Creating the Standby Database 58:00 Testing the Data Guard Functionality #LINKS Have a look at my course https://www.udemy.com/oracle-database-12c-rac-administration #about Ahmed Baraka I began my career as an Oracle Developer but soon transitioned to Oracle Database Administration. I have 18 years of extensive experience in the computer industry, with focus on Oracle database administration technologies like Oracle RAC, ASM, Data Guard, GoldenGate, WebLogic, Database Appliance, and Enterprise Manager. # Download You can download the VM machines (appliances) that has been created in the tutorial from the following link: http://www.ahmedbaraka.com/download.html #Contact Info [email protected] https://www.facebook.com/profile.php?id=100010975452842 https://twitter.com/hmedBaraka1
Views: 4118 Ahmed Baraka
Dataguard - Redo/Archive log shipping at process and network level
 
14:14
Oracle dataguard redo and archive log shipping process at network level
Views: 5455 OrSkl Academy
11g Steps by step Physical Standby Dataguard configuration
 
01:11:59
11g Steps by step Physical Standby Dataguard configuration
Views: 313 Zain Mohamed
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: 25616 jbleistein11
Duplicate Active database using RMAN
 
13:50
This is a video on how to clone an oracle database using the FROM ACTIVE DATABASE command from RMAN. You can also read the article on: https://www.protractus.com/?p=2268, the article is much more organized than my unstructured brain :)
Views: 18443 André Karlsson
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: 301042 jbleistein11
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: 17016 jbleistein11
Oracle Data Guard - Standby Databases Overview - DG Video 2
 
07:10
In this video you will learn about the different types of Standby Databases in an Oracle Data Guard environment. You will get to know the typical use cases in which you would use each type of Standby 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: 13267 Ramkumar Swaminathan
oracle data guard configuration step by step in oracle 12c r2  new features for dba
 
41:06
This video will guide you to create an active data guard in ORACLE. _____________________________________________________ What is active dataguard? Oracle Data Guard is an effective and comprehensive method of achieving data availability, data protection, and disaster recovery solution for Oracle enterprise databases. It provides the management, monitoring, and automation software infrastructure to create and maintain one or more synchronized standby databases to protect data from failures, disasters, errors, and corruptions. _____________________________________________________ What does it mean? A standby database is initially created from a backup copy of the primary database. Once created, Data Guard automatically maintains the standby database as a transactional consistent copy of the primary database. Data Guard helps you protect your Data. Takes your data and automatically puts it elsewhere Makes it available for Failover in case of failure. _____________________________________________ When To Implement Data Guard? Failover A failover is done when the primary database (all instances of an Oracle RAC primary database) fails or has become unreachable and one of the standby databases is transitioned to take over the primary role. Failover should be performed when the primary database cannot be recovered in a timely manner. Failover may or may not result in data loss depending on the protection mode in effect at the time of the failover. Switchover A switchover is a role reversal between the primary database and one of its standby databases. A switchover guarantees no data loss and is typically done for planned maintenance of the primary system. During a switchover, the primary database transitions to a standby role, and the standby database transitions to the primary role. _______________________________________________ Components of Active Data Guard? Primary Database: A primary database is a production database. The primary database is used to create a standby database. Every standby database is associated with one and only one primary database. Standby Database: A physical or logical standby database is a database replica created from a backup of a primary database . A Data Guard configuration consists of one production (or primary) database and up to nine standby databases. The databases in a Data Guard configuration are connected by Oracle. _______________________________________________ Data Guard Benefits? Disaster/Failure Recovery and High Availability Complete Data Protection Efficient Utilization of System Resources Flexibility in Data Protection to Balance Availability Against Performance Requirements Protection from Communication Failures Fast-Start Failover Capabilities Centralized and Simple Management Integrated with Oracle Database RMAN(Recovery Manager) Fast Connection Failover
Views: 3875 ORACLE DBA UNIVERSITY
Overview Data Guard Configuration - A primary and 2 Standby Databases
 
39:24
I showed with this video, how to create oracle standby database on same host primary database and remote host. I created two physical standby database and created oracle data guard configuration with primary and this two standby databases. I think this video very helpful creator standby database and for newly of Oracle Data Guard creator. Mahir M. Quluzade. www.mahir-quluzade.com
Views: 34294 Mahir M. Quluzade
Data Guard - Creating a Logical Standby Database
 
24:29
Data Guard - Creating a Logical Standby Database Watch more Videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjabi, Tutorials Point India Private Limited.
Oracle Data Guard - Performing Manual Failover Steps
 
42:09
This video is part of my Oracle 12c Data Guard with ASM online training. In case you are looking for full training, please contact: [email protected]
Views: 1689 DBA Genesis
oracle data guard | snapshot standby database oracle dataguard |  oracle standby database
 
11:31
This video discuss in detail about the configuartion of snapshot standby database feature in Oracle 11g
Views: 7889 Wysheid Wysheid
How to convert Physical  Standby database to Snapshot Standby Database-DataGuard
 
07:05
Check DB Status =========================================== select status,instance_name,database_role,open_mode from v$database,v$Instance; Check Flashback status =================================== select flashback_on from v$database; Status of MRP Process ----------------------------- set lines 1234 pages 1234; select process,status,client_process,thread#,sequence#,block#,blocks,delay_mins from v$managed_standby; Cancel the MRP ================================ alter database recover managed standby database cancel; Convert to Snapshot Standby ========================================== alter database convert to snapshot standby; Open the database =========================== alter database open; ============================================== Hi Folks, Greetings!! I am professional part time oracle dba trainer and having good experience in oracle database administration. This is the right place to enroll yourself for Oracle DBA real time course. Please use following email ID for more details. Don’t hesitate to WhatsApp me any time. I will give you the best training and will create path to get DBA job easily. Enjoy the free YouTube video and connect with me for deep Oracle DBA knowledge. Mobile No : + 91 9960262955 (WhatsApp Number) EmailID: [email protected]
Views: 458 ANKUSH THAVALI
DBSure - Oracle Standby 11g Standby Standard Edition  on Linux 6
 
50:34
Manual de como crear un Standby en Oracle 11g Standard Edition sobre Linux con DBSure
Views: 1005 Enzo Viza
RMAN Full DB Restore Recover
 
07:23
RMAN Full Database Restore and Recover
Views: 10382 Hemant K Chitale
1.Data Guard Configuration - A Primary and one Standby database
 
53:44
Hi guys today is very interesting topic for you means how to configure oracle Data Guard project on 11gr2.#DataGuard #Standbydatabase Oracle database Unbeatable,Unbreakable Platform..
Views: 28144 Oracle World
3.Oracle Data Guard 11g - Snapshot Standby Database
 
18:36
Hi guys today topic is very most important that comes in oracle 11g release 1 SNAPSHOT STANDBY, you can open standby in read,write mode in snapshot standby. #DataGuard11g #SnapshotStandbyDatabase Oracle database Unbeatable,Unbreakable Platform..
Views: 2660 Oracle World
Oracle DBA Justin - How to clone an Oracle database not using RMAN
 
20:23
How to clone an Oracle database not using RMAN
Views: 61638 jbleistein11
How to Create Oracle Duplicate Database with Recovery Manager RMAN Part 01
 
12:54
How to Create Oracle Duplicate Database with Recovery Manager RMAN Part 01
Views: 16450 Abbasi Asif
Database Point-in-Time Recovery | RMAN INCREMENTAL Backups | DB PITR
 
08:41
Database point-in-time recovery (DBPITR) restores the database from backups prior to the target time for recovery, then uses incremental backups and redo to roll the database forward to the target time. DBPITR is sometimes called incomplete recovery because it does not use all of the available redo or completely recover all changes to your database. The target SCN can be specified using a date and time, in which case the operation is sometimes called time-based recovery. https://dbagenesis.com/p/oracle-advanced-rman-backup-recovery
Views: 1943 DBA Genesis
Oracle Data Guard 11g - Overview Snapshot Standby Database
 
15:53
Oracle Data Guard 11g - Overview Snapshot Standby Database How to convert physical standby database to snapshot standby database? How to use snapshot standby database? What is benefits of standby databases? I answered this questions with video Regards Mahir M. Quluzade http://www.mahir-quluzade.com
Views: 4082 Mahir M. Quluzade
Oracle Database Cloning via RMAN Restore Recover Method
 
23:58
https://dbagenesis.com/p/oracle-advanced-rman-backup-recovery RMAN has the ability to duplicate, or clone, a database from a backup or from an active database. It is possible to create a duplicate database on a remote server with the same file structure, a remote server will a different file structure or the local server with a different file structure. Cloning the database on the remote host requires two servers. Both servers should have Oracle Software installed on them.
Views: 6873 DBA Genesis
Types of RMAN backups and RMAN components
 
20:31
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. RMAN provides you flexibility to take full database backups and incremental backups. With the incremental backups, you only take backup of changed blocks. This results in saving the disk space. While taking first incremental backup, it will be count as level 0 incremental backup, which is same in content to RMAN full backup and takes backup of all blocks in the database. Level 1 incremental backup takes backup of only those blocks who modified after earlier incremental backup.
Views: 25664 DBA Genesis
Data Guard - Physical Standby Dataguard Configuration   Part 2
 
01:21:17
Data Guard - Physical Standby Dataguard Configuration Part 2
How to configure Oracle 12c DataGuard  on Linux platform - Part-1
 
11:30
Hello Friends today i'm going to demonstrate you how to configure Oracle 12c Data Guard step by step using duplicate command with complete descriptions. Please subscribe my channel for more updates. My other Youtube: https://www.youtube.com/4usupport #dataguard #oracle12c #onlinux #oracletutorial #data #guard For Data Guard configuration step visit on following link:- http://ocptechnology.com/configure-oracle-12c-active-dataguard-database-using-rman-duplicate/ For Oracle 12c installation steps on Linux platform visit on following link:- http://ocptechnology.com/install-oracle-database-12c-release-1-12-1-redhat-linux-6/ Oracle 12c installation video visit on following link:- https://youtu.be/Nnhlu-Hlsuc
Views: 4576 OCP Technology
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: 18070 jbleistein11
CLONE Database using RMAN
 
01:24:11
Clone by using RMAN in Oracle 11g By following this Video any one can do cloning
Views: 7118 Yasin Basha
Oracle Database Backup and Recovery Introduction - Backup&Reco Video 1
 
06:25
In this video you will get introduced to the Backup and Recovery options available with 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: 15263 Ramkumar Swaminathan
8.Oracle Data Guard 11g - Overview Logical Standby Database
 
23:03
Hi guys today topic is very important in Data Guard logical standby apply all changes using SQL APPLY and opened in read write mode for real application testing. #DataGuardConfiguration #LogicalStandbyDatabase Oracle database Unbeatable,Unbreakable Platform..
Views: 4006 Oracle World