Home
Search results “Switchover in oracle rac”
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: 7738 OCP Technology
Switchover Operation on Oracle Data Guard 11g
 
08:46
In this video , You will learn how to perform switchover operation on Oracle Data Guard 11g. 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: 1182 DBA Trainer
Overview Switchover  on Oracle Data Guard  (11.2)
 
09:02
Oracle Database 11g , Data Guard
Views: 4811 Mahir M. Quluzade
Overview Oracle data guard failover | data guard switchover  |  Role reversal in dataguard
 
20:53
In this video we discuss about the failover method used in dataguard
Views: 10970 Wysheid Wysheid
5.Overview Switchover on Oracle Data Guard 11g
 
17:43
Hi friends today I'am going to show you overview of switchover in DATA GUARD 11g release Role conversion #DataGuard #Switchoveroverview Oracle database Unbeatable,Unbreakable Platform..
Views: 3567 Oracle World
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: 10047 Ramkumar Swaminathan
Oracle 11g Data Guard(switchover commands): A Complete Look At DG Technology Tutorial 6
 
27:49
In this tutorial you will learn how to change database roles. You will learn about supported switchover commands for oracle data guard.
Views: 1427 DBA Pro
Oracle 11g Data Guard(switchover commands): A Complete Look At DG Technology Tutorial 7
 
51:56
In this tutorial you will learn how to change database roles. You will learn about supported switchover commands for oracle data guard.
Views: 5998 DBA Pro
Oracle Dataguard switchover using dgmgrl
 
03:11
Manual Switchover to a single physical standby takes around eight different commands. How about if we told you that a switchover or failover could be reduced to a single command ? This demo show how easy to perform a switchover using dataguard broker. This is perform on a single database with 2 instance demonstrating how a switchover can be executed. Pre-req 1) init param : dg_broker_start=true, db_unique_name 2) listener.ora : static listener with dgmgrl 3) tnsnames.ora : sid name with those static service_names
Views: 2708 Vincent Ng
Oracle 11g Data Guard Configuration Role Transition Switchover part-11
 
13:23
Learn Oracle 11g ( SQL, OCA, OCP, Data Guard and Real Application Clusters with Sherzad Zahid
Views: 111 Sherzad Zahid
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: 1196 DBA Genesis
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: 1386 ANKUSH THAVALI
Storage Foundation for Oracle RAC - Demo of Disaster Recovery Configuration with Oracle Dataguard
 
10:01
This demo showcases the configuration of a Primary site and a Disaster Recovery site with Storage foundation for Oracle RAC using Oracle Dataguard to create and maintain the standby database.
Oracle RAC Components | Basic cluster components
 
12:51
https://dbagenesis.com/p/oracle-11gr2-rac-for-beginners A computer cluster consists of a set of loosely or tightly connected computers that work together so that, in many respects, they can be viewed as a single system. Unlike grid computers, computer clusters have each node set to perform the same task, controlled and scheduled by software. The components of a cluster are usually connected to each other through fast local area networks, with each node (computer used as a server) running its own instance of an operating system. In most circumstances, all of the nodes use the same hardware and the same operating system, although in some setups (i.e. using Open Source Cluster Application Resources (OSCAR)), different operating systems can be used on each computer, and/or different hardware.
Views: 12454 DBA Genesis
Swichover in oracle Datagurd | OrclData
 
05:49
Switchover Switchover is the act of change the standby database into the primary but in a controlled manor, the planned event means that it is safe from data loss because the primary database must complete all redo generation on the production data before allowing the switchover to commence. The switchback does not exists as it is a switchover but in the reserve order, which would restore the database back on its original server. This planned event normally happens during a quiet period, the reason for the switchover might be DR testing, patch, hardware changes, implementing RAC, etc. ======================================= 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 data guard switchover 11g using dgmgrl data guard switchover steps 12c oracle data guard failover step by step oracle 12c data guard switchover steps oracle database switchover steps data guard switchover commands data guard switchover and failover best practices oracle data guard dr drill
Views: 272 ANKUSH THAVALI
Oracle 11g Data Guard Configuration Role Transition Switchover -  part - 12
 
08:37
Learn Oracle 11g ( SQL, OCA, OCP, Data Guard and Real Application Clusters with Sherzad Zahid
Views: 59 Sherzad Zahid
dg switchover
 
12:34
dg switchover
Views: 215 Lalit Verma
2.Data Guard Configuration - DGMGRL Broker configuration
 
19:43
Hello friends today we will learn how to create Broker DGMGRL in data guard to monitor primary and physical standby. #DataGuardConfiguration #DGMGRLBrokerconfiguration Oracle database Unbeatable,Unbreakable Platform..
Views: 7137 Oracle World
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: 3159 ORACLE DBA UNIVERSITY
VCS Oracle SwitchOver
 
09:10
Views: 619 Anderosn Fang
Understanding Client Side Connect time Load Balancing And Failover
 
41:54
Oracle Database : Understanding Oracle Client Side Connect Time Load Balancing and Failover for Oracle Network Connections
Views: 3228 Satish Lodam
ORACLE DBA -  [LINUX] How to create an Active Dataguard in Oracle 10g/11g(Physical/Standby)
 
57:34
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: 2539 Ankit Saini
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: 4999 Mahir M. Quluzade
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: 7776 Wysheid Wysheid
6.Overview Failover on Oracle Data Guard 11g
 
20:03
Hi guys today we learn how to perform automatic Failover in data guard broker configuration using DGMGRL. #DataGuard #Failover Oracle database Unbeatable,Unbreakable Platform..
Views: 3402 Oracle World
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: 20239 Ahmed Baraka
Dataguard Fast Start Failover
 
06:58
Demonstration of Oracle Fast Start Failover
Views: 3064 Darrell McClure
Oracle Data Guard - Broker
 
11:41
Oracle Data Guard - Broker Watch more Videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjabi, Tutorials Point India Private Limited.
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.
Active data guard in Oracle 11g | Read only standby database |  Real time queries
 
05:00
This video discuss in detail about the active dataguard feature of Oracle 11g
Views: 5368 Wysheid Wysheid
Oracle RAC DATAGUARD 11g Training in Bangladesh
 
02:21
Oracle Data Guard 10g / 11g, Oracle RAC , Oracle High Availability , Oracle RAC on Linux
Views: 2375 Dev Net IT
04.02-08 Oracle_10gR2_DataGuard_4.2 Step 8 Configure Oracle Net Components on the Standby
 
02:32
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. Please feel free to contact me: E-mail/Skype: [email protected] Oracle Database 10gR2 High Availability with Data Guard on Linux http://www.youtube.com/playlist?list=PLCEC4947864F3B571 1. Install Oracle Database 10gR2 on Linux for primary Database 2. Install Oracle Database 10gR2 on Linux for Physical Standby 3. Install Oracle Database 10gR2 for Physical/Logical Standby 4. Configure Primary and two Physical Standby Databases 4.1 Configure the Primary Database - (Video) 4.2 Configure the First Physical Standby Database(xiamen) - (Video) 4.3 Configure the Second Physical Standby Database - (Video) 4.4 Verifying the Physical Standby Database - (Video) 4.5 Startup and Verify Physical Standby Database - () 5. Upgrading and Downgrading the Protection Mode 5.1 Data Guard Protection Mode - () 5.2 Upgrading the Protection Mode - (Video) 5.3 Downgrading the Protection Mode - (Video) 6. Role Transition - Physical Standby Database 6.1 Perform a Switchover with shanghainode and xiamennode - (Video) 6.2 Perform a Switchback with xiamennode and shanghainode - (Video) 6.3 Perform a Switchover with shanghainode and longyannode - (Video) 6.4 Perform a Switchback with longyannode and shanghainode - (Video) 6.5 Perform a Failover to the Physical Standby - xiamennode - (Video) 6.6 Flashing Back a Failed Primary into a Physical Standby - (Video) 6.7 Perform a Switchback with xiamennode and shanghainode - (Video) 7. Oracle Data Guard Broker 7.1 Oracle Data Guard Broker Concepts - () 7.2 Configuring Data Guard Broker - (Video) 7.3 Changing the State of a Database - (Video) 7.4 Start / Stop Data Guard with Broker - () 7.5 Managing Data Protection Modes - () 7.6 Upgrading the Protection Mode - (Video) 7.7 Downgrading the Protection Mode - (Video) 7.8 Removing the Broker - (Video) 8. Role Transition - Switchover and Failover Using Broker 8.1 Introduction to Role Transition - () 8.2 Flashback Technologies and Data Guard - () 8.3 Preparatory Checks before a Switchover - (Video) 8.4 Perform a Switchover with shanghai and xiamen Using Broker - (Video) 8.5 Perform a Switchover with xiamen and shanghai Using Broker - (Video) 8.6 Perform a Switchover with shanghai and longyan Using Broker - (Video) 8.7 Perform a Switchover with shanghai and longyan Using Broker - (Video) 8.8 Perform a Manual Failover Using Broker - (Video) 8.9 Reinstating a Failed Primary Database - (Video) 8.10 Perform a Switchover with xiamen and shanghai Using Broker - (Video) 9. Fast-Start Failover - Automatic Failover 9.1 Fast-Start Failover Architecture - () 9.2 Enabling Fast-Start Failover and Starting the Observer - (Video) 9.3 Initiating a Fast-Start Failover - (Video) 9.4 Perform a Switchover with xiamen and shanghai Using Broker - (Video) 9.5 Disabling Fast-Start Failover - (Video) 10. Managing Physical Standby and Logical Standby Database 10.1 Downgrading Maximum Performance if necessary - (Video) 10.2 Removing the Broker - (Video) 10.3 Create a Logical Standby Database - (Video) 10.4 Verifying the Logical Standby and Physical Standby - (Video) 10.5 Start and Stop the Physical Standby & Logical Standby - () 11. Role Transition - Physical and Logical Standby Database 11.1 Perform a Switchover with shanghainode and xiamennode - (Video) 11.2 Perform a Switchback with xiamennode and shanghainode - (Video) 11.3 Perform a Failover to the Physical Standby - xiamennode - (Video) 11.4 Flashing Back a Failed Primary into a Physical Standby - (Video) 11.5 Perform a Switchback with xiamennode and shanghainode - (Video) 12. Managing Physical and Logical Standby Database Using Broker 12.1 Configuring Data Guard Broker - (Video) 12.2 Start and Stop the Physical and Logical Standby Using Broker - () 12.3 Upgrading the Protection Mode - (Video) 12.4 Downgrading the Protection Mode - (Video) 12.5 Perform a Switchover with shanghai and xiamen Using Broker - (Video) 12.6 Perform a Switchover with xiamen and shanghai Using Broker - (Video) 12.7 Enabling Fast-Start Failover and Starting the Observer - (Video) 12.8 Initiating a Fast-Start Failover - (Video) 12.9 Perform a Switchover with xiamen and shanghai Using Broker - (Video) 12.10 Disabling Fast-Start Failover - (Video) 12.11 Removing the Data Guard Broker - (Video)
Views: 112 Yongcheng Lai
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: 3845 Oracle World
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]om
Views: 8399 Ramkumar Swaminathan
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.
Patching In Oracle Data Guard 11g
 
32:50
In this video , you will learn how to apply patch in Oracle Data Guard 11g Environment. 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: 627 DBA Trainer
Effective Client Failover in an Oracle RAC Environment | Sean Kim
 
02:51
Oracle University senior principal instructor Sean Kim brings the classroom to you with his tip on effective client failover in Oracle Real Application Cluster environments.
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: 26593 Oracle World
7.Oracle Data Guard - Reinstate primary database after failover
 
17:04
Hi friends in this video we learn how to Reinstate after Failover in data guard 11g R2 . #DataGuardConfiguration #primarydatabase #failover Oracle database Unbeatable,Unbreakable Platform..
Views: 2056 Oracle World
11gR2 Grid RAC Services Part 2
 
01:38:02
Oracle 11gR2 Grid Infrastructure Daemons
Views: 13552 Satish Lodam
06.05 Oracle_10gR2_DataGuard_6.5 Perform a Failover to the Physical Standby - xiamennode.avi
 
13:47
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. Please feel free to contact me: E-mail/Skype: [email protected] Oracle Database 10gR2 High Availability with Data Guard on Linux http://www.youtube.com/playlist?list=PLCEC4947864F3B571 6. Role Transition - Physical Standby Database 6.1 Perform a Switchover with shanghainode and xiamennode Step 1: Verify the Switchover status on the Primary - shanghainode Step 2: Convert the primary database into a physical standby database Step 3: Shut down and restart the former primary as a new standby Step 4: Query the SWITCHOVER_STATUS on the standby database Step 5: Convert the former standby to a primary database Step 6: Shutdown and restart the new primary database Step 7: Start Redo Apply on the new physical standby - shanghainode Step 8: Start Redo Apply on the physical standby - longyannode Step 9: Verify the new primary and standby database 6.2 Perform a Switchback with xiamennode and shanghainode Step 1: Verify the Switchover status on the Primary - xiamennode Step 2: Convert the primary database into a physical standby database Step 3: Shut down and restart the former primary as a new standby Step 4: Query the SWITCHOVER_STATUS on the standby database Step 5: Convert the former standby to a primary database Step 6: Shutdown and restart the new primary database Step 7: Start Redo Apply on the new physical standby - xiamennode Step 8: Start Redo Apply on the physical standby - longyannode Step9: Verify the new primary and standby database 6.3 Perform a Switchover with shanghainode and longyannode Step 1: Verify the Switchover status on the Primary - shanghainode Step 2: Convert the primary database into a physical standby database Step 3: Shut down and restart the former primary as a new standby Step 4: Query the SWITCHOVER_STATUS on the standby database Step 5: Convert the standby to a primary database Step 6: Shutdown and restart the new primary database Step 7: Start Redo Apply on the new physical standby - shanghainode Step 8: Start Redo Apply on the physical standby - xiamennode Step 9: Verify the new primary and standby database 6.4 Perform a Switchback with longyannode and shanghainode Step 1: Verify the Switchover status on the Primary - shanghainode Step 2: Convert the primary database into a physical standby database Step 3: Shut down and restart the former primary as a new standby Step 4: Query the SWITCHOVER_STATUS on the standby database Step 5: Convert the former standby to a primary database Step 6: Shutdown and restart the new primary database Step 7: Start Redo Apply on the new physical standby - longyannode Step 8: Start Redo Apply on the physical standby - xiamennode Step 9: Verify the new primary and standby database 6.5 Perform a Failover to the Physical Standby - xiamennode Step1: Identify and resolve any archive log gaps Step2: Copy and register any other missing archived redo logs Step3: Perform terminal recovery on the target standby Step4: convert the physical standby into a primary database Step5: Restart the new primary database in read/write mode Step6: Verify the new Primary Database Step7: Perform a full backup of the new primary database Step8: Flashing Back the Physical Standby Database - longyannode Step9: Using Flashback Database After a Failover 6.6 Flashing Back a Failed Primary into a Physical Standby Step1: Determine the SCN at which the old standby database became the primary database Step 2: Flash back the failed primary database Step 3: Convert the Failed Database to a Physical Standby Database Step 4: Shut down and restart the old primary database Step 5: Restart transporting redo to the new physical standby Step 6: Start Redo Apply Step 7: Restart Redo Apply on the new physical standby database if necessary Step 8: Verify the new primary and standby database 6.7 Perform a Switchback with xiamennode and shanghainode Step1: Verify the Switchover status on the Primary - xiamennode Step2: Convert the primary database into a physical standby database Step3: Shut down and restart the former primary as a new standby Step4: Query the SWITCHOVER_STATUS on the standby database Step5: Convert the former standby to a primary database Step6: Shutdown and restart the new primary database Step7: Start Redo Apply on the new physical standby - xiamennode Step8: Start Redo Apply on the physical standby - longyannode Step9: Verify the new primary and standby database
Views: 521 Yongcheng Lai
04.02-09 Oracle_10gR2_DataGuard_4.2 Step 9 Start the standby database nomount.avi
 
00:46
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. Please feel free to contact me: E-mail/Skype: [email protected] Oracle Database 10gR2 High Availability with Data Guard on Linux http://www.youtube.com/playlist?list=PLCEC4947864F3B571 1. Install Oracle Database 10gR2 on Linux for primary Database 2. Install Oracle Database 10gR2 on Linux for Physical Standby 3. Install Oracle Database 10gR2 for Physical/Logical Standby 4. Configure Primary and two Physical Standby Databases 4.1 Configure the Primary Database - (Video) 4.2 Configure the First Physical Standby Database(xiamen) - (Video) 4.3 Configure the Second Physical Standby Database - (Video) 4.4 Verifying the Physical Standby Database - (Video) 4.5 Startup and Verify Physical Standby Database - () 5. Upgrading and Downgrading the Protection Mode 5.1 Data Guard Protection Mode - () 5.2 Upgrading the Protection Mode - (Video) 5.3 Downgrading the Protection Mode - (Video) 6. Role Transition - Physical Standby Database 6.1 Perform a Switchover with shanghainode and xiamennode - (Video) 6.2 Perform a Switchback with xiamennode and shanghainode - (Video) 6.3 Perform a Switchover with shanghainode and longyannode - (Video) 6.4 Perform a Switchback with longyannode and shanghainode - (Video) 6.5 Perform a Failover to the Physical Standby - xiamennode - (Video) 6.6 Flashing Back a Failed Primary into a Physical Standby - (Video) 6.7 Perform a Switchback with xiamennode and shanghainode - (Video) 7. Oracle Data Guard Broker 7.1 Oracle Data Guard Broker Concepts - () 7.2 Configuring Data Guard Broker - (Video) 7.3 Changing the State of a Database - (Video) 7.4 Start / Stop Data Guard with Broker - () 7.5 Managing Data Protection Modes - () 7.6 Upgrading the Protection Mode - (Video) 7.7 Downgrading the Protection Mode - (Video) 7.8 Removing the Broker - (Video) 8. Role Transition - Switchover and Failover Using Broker 8.1 Introduction to Role Transition - () 8.2 Flashback Technologies and Data Guard - () 8.3 Preparatory Checks before a Switchover - (Video) 8.4 Perform a Switchover with shanghai and xiamen Using Broker - (Video) 8.5 Perform a Switchover with xiamen and shanghai Using Broker - (Video) 8.6 Perform a Switchover with shanghai and longyan Using Broker - (Video) 8.7 Perform a Switchover with shanghai and longyan Using Broker - (Video) 8.8 Perform a Manual Failover Using Broker - (Video) 8.9 Reinstating a Failed Primary Database - (Video) 8.10 Perform a Switchover with xiamen and shanghai Using Broker - (Video) 9. Fast-Start Failover - Automatic Failover 9.1 Fast-Start Failover Architecture - () 9.2 Enabling Fast-Start Failover and Starting the Observer - (Video) 9.3 Initiating a Fast-Start Failover - (Video) 9.4 Perform a Switchover with xiamen and shanghai Using Broker - (Video) 9.5 Disabling Fast-Start Failover - (Video) 10. Managing Physical Standby and Logical Standby Database 10.1 Downgrading Maximum Performance if necessary - (Video) 10.2 Removing the Broker - (Video) 10.3 Create a Logical Standby Database - (Video) 10.4 Verifying the Logical Standby and Physical Standby - (Video) 10.5 Start and Stop the Physical Standby & Logical Standby - () 11. Role Transition - Physical and Logical Standby Database 11.1 Perform a Switchover with shanghainode and xiamennode - (Video) 11.2 Perform a Switchback with xiamennode and shanghainode - (Video) 11.3 Perform a Failover to the Physical Standby - xiamennode - (Video) 11.4 Flashing Back a Failed Primary into a Physical Standby - (Video) 11.5 Perform a Switchback with xiamennode and shanghainode - (Video) 12. Managing Physical and Logical Standby Database Using Broker 12.1 Configuring Data Guard Broker - (Video) 12.2 Start and Stop the Physical and Logical Standby Using Broker - () 12.3 Upgrading the Protection Mode - (Video) 12.4 Downgrading the Protection Mode - (Video) 12.5 Perform a Switchover with shanghai and xiamen Using Broker - (Video) 12.6 Perform a Switchover with xiamen and shanghai Using Broker - (Video) 12.7 Enabling Fast-Start Failover and Starting the Observer - (Video) 12.8 Initiating a Fast-Start Failover - (Video) 12.9 Perform a Switchover with xiamen and shanghai Using Broker - (Video) 12.10 Disabling Fast-Start Failover - (Video) 12.11 Removing the Data Guard Broker - (Video)
Views: 148 Yongcheng Lai
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: 365 ANKUSH THAVALI
Dataguard - Redo/Archive log shipping at process and network level
 
14:14
Oracle dataguard redo and archive log shipping process at network level
Views: 4945 OrSkl Academy
Overview Failover on Oracle Data Guard (11.2)
 
14:45
Oracle Database 11g, Data Guard
Views: 2247 Mahir M. Quluzade