Home
Search results “Shutdown standby oracle”
Oracle Database Shutdown - DBArch Video 14
 
06:36
In this video you learn what happens when an Oracle Database is Shutdown. You will learn about the different types of Shutdown and the intricate details of what happens in each of the types. 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: 9233 Ramkumar Swaminathan
Data Guard - Physical Standby Dataguard Monitoring
 
10:54
Data Guard - Physical Standby Data Guard Monitoring Watch more Videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjabi, Tutorials Point India Private Limited.
Difference between shutdown normal shutdown immediate and shutdown abort
 
14:19
Difference between shutdown normal shutdown immediate and shutdown abort
Views: 3186 Wysheid Wysheid
How to Start and Stop a RAC node in Oracle 12c R2
 
10:00
How to Start and Stop a RAC node in Oracle 12c R2 on OEL
Views: 2548 OracleDBA
Oracle Instance Startup - DBArch Video 13
 
03:38
In this video you will learn the various steps involved in starting an Oracle Database Instance. You get introduced to the different states of an Instance - IDLE, NOMOUNT, MOUNT and OPEN and what happens in each of these states. Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 11953 Ramkumar Swaminathan
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: 522 Yongcheng Lai
SRVCTL and CRSCTL in Oracle RAC
 
50:19
In this Video you will learn:- • What is SRVCTL and CRSCTL tool? • Global Dynamic Performance View • SQL with Global Dynamic Performance view - Practical • SRVCTL Command - Practical • CRSCTL Command - Practical • SRVCTL RAC Administration Basic Activity - Practical • CRSCTL RAC Administration Basic Activity - Practical
Views: 247 DBA Trainer
Oracle DBA Tutorial || Oracle DBA Start up and Shutdown modes by shiva
 
15:14
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS ,ADF,INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo......
Oracle Restart
 
25:15
Oracle Restart
Views: 905 The Silent DBA
Startup/Shutdown/Oratab/Export Oracle Database
 
09:27
Topic Covered Introduction of oratab file How to start and shutdown database How to set Oracle environment
Views: 764 ANKUSH THAVALI
Oracle DBA Justin - How to shutdown an Oracle database # 1 of 2
 
19:38
How to shutdown an Oracle database # 1 of 2
Views: 3802 jbleistein11
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
Oracle DBA Justin - How to shutdown an Oracle database # 2 of 2
 
17:52
How to shutdown an Oracle database # 2 of 2
Views: 1884 jbleistein11
Startup and Shutdown of RAC database | oracle rac administration | srvctl commands
 
08:20
This Video discuss startup and shutdown steps for a RAC database
Views: 29783 Wysheid Wysheid
HOW TO ENABLE DISABLE ARCHIVE LOG MODE IN ORACLE 11G DATABASE
 
03:20
HOW TO ENABLE DISABLE ARCHIVE LOG MODE IN ORACLE 11G ==================================================== archive log list; show parameter log_archive_dest_1; show parameter recovery; Enable archive log mode: ======================== shutdown immediate; startup mount; alter database archivelog; alter database open; Disable archive log mode: ========================= shutdown immediate; startup mount; alter database noarchivelog; alter database open;
Views: 1087 Praveen Biyyapu
How to shutdown standalone asm step by step
 
03:09
standalone asm instance shutdown step by step
Views: 366 Sukumar k
Startup and Types of Shutdown database Oracle
 
07:56
Tutorial how to starting up oracle database and use different types of shutdown.
Views: 10 Guskoro Arief
Starting the standby recovery with no delay using real time apply | Standby real time apply
 
25:45
This video discuss in detail about the steps for enabling realtime apply in Oracle datagaurd
Views: 3267 Wysheid Wysheid
ORA-01033: ORACLE initialization or shutdown in progress
 
04:35
ORA-01033: ORACLE initialization or shutdown in progress - How to fix this issue? You can fix ORA-01033: ORACLE initialization or shutdown in progress issue using following commands. Error Message: ORA-01033: ORACLE initialization or shutdown in progress Resolution: As a DBA, you must know the Shutdown, Shutdown Immediate or Startup commands that are issued by database administrator with SYSDBA privileges. 1) select status, database_status from v$instance; 2) select open_mode from v$database; 3) alter database mount; 4) select status, database_status from v$instance; 5) select open_mode from v$database; 6) / as sysdba 7) alter database open; 8) select status, database_status from v$instance; 9) select open_mode from v$database; Check out this entire video and you will see the database is opened in read write mode and your database issue is resolved. Now you can login with your user name and password to access your database. You can also follow below step by step guide to resolve ORA-01033: ORACLE initialization or shutdown in progress issue. http://techiesdigest.com/ora-01033-oracle-initialization-or-shutdown-in-progress/ Share your LOVE by Liking & Sharing this Video and SUBSCRIBE to our YouTube channel for more interesting and useful Tech videos. LIKE - SHARE - SUBSCRIBE Subscribe - https://goo.gl/Z4No32 Website: http://techiesdigest.com/ Twitter: http://www.twitter.com/techiesdigest Facebook: http://www.facebook.com/techiesdigest Google+ - https://plus.google.com/100074553945448527181 YouTube: http://www.youtube.com/techiesdigest Thank you so much! We appreciate your continued extended support, enthusiasm, dedication and passion to LOVE our channel.
Views: 20693 Techies Digest
Solving ORA-01033 oracle initialization or shutdown in progress 12c
 
01:26
Solving ORA-01033 oracle initialization or shutdown in progress 12c select name, open_mode from v$pdbs; Solution 1 Alter pluggable database pdborcl open Solution 2 create or replace TRIGGER pdb_startup AFTER STARTUP ON DATABASE BEGIN EXECUTE IMMEDIATE 'alter pluggable database pdborcl open'; END;
Views: 11540 khaled alkhudari
06.06 Oracle_10gR2_DataGuard_6.6 Flashing Back a Failed Primary into a Physical Standby.avi
 
10:17
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: 236 Yongcheng Lai
Demostrating Oracle TAF (transparent application failover)
 
02:26
The TAF allow user to re-connect a surviving instance if the existing connection fail. This video demostrate how a long running query remain connected when one of the instance is shutdown. 1) The long running query was initially connected to instance 2. 2) Perform shutdown abort to simulate a instance failure 3) The long running query automatically failover to instance 1. It enables the application to automatically reconnect to a database, if the database instance to which the connection is made fails Platform : Oracle Linux 6.3 Database : 11.2.0.3
Views: 1666 Vincent Ng
How to convert Snapshot  Standby Database to Physical Standby Database-Oracle Dataguard
 
09:07
Database should be in mount Stage select name, guarantee_flashback_database from v$restore_point; ALTER DATABASE CONVERT TO PHYSICAL STANDBY; shutdown database startup database in mount stage Start the MRP process #dataguard #snapshotdb #oracledba
Views: 371 ANKUSH THAVALI
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
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
How to connect to an Oracle Database? - Database Tutorial 37
 
12:37
Video 37 - How to connect to a Oracle Database? - Database Tutorial 37 This video explains how to connection to an oracle database. The database, which is Oracle 11g has been installed in a Windows 7 computer.
Views: 126601 Sam Dhanasekaran
Oracle DBA Justin - You can't shutdown or startup a database in backup mode
 
07:40
You cannot shutdown or startup a database while in backup mode.
Views: 2199 jbleistein11
Dataguard   Real time apply
 
14:10
Understand what is Real time apply in Oracle Dataguard
Views: 8372 OrSkl Academy
L1 Activity for APPS DBA r12.1 how to STARTUP and SHUT DOWN
 
05:19
This video is specially designed for beginners. follow my upcoming videos to know about activity's in TOP MNC.
Views: 51 EBS STUDIO ORACLE
How To Start Or Stop Oracle Database Service In Red Hat Linux Enterprise 6.0.
 
06:15
How To Start Or Stop Oracle Service In Red Hat Linux Enterprise 6.0.
Views: 14141 Subhroneel Ganguly
Rolling Upgrade with Transient Logical Standby
 
15:00
Rolling Upgrade with upgrade to a new Database Release with Minimum Downtime. How to upgrade to a new Database Release with Minimum Downtime using physru
Views: 1071 Vincent Ng
Data Guard - Creating & Managing a Snapshot Standby Database
 
20:00
Data Guard - Creating & Managing a Snapshot 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 Broker
 
04:10
This video gives a quick demonstration of the Oracle Data Guard Broker. I've used standby databases since Oracle 8i and Data Guard since Oracle 9i, but I've always done the manual configuration. Since 10g the Data Guard Broker has been available to make life easier. For more information see: https://oracle-base.com/articles/12c/data-guard-setup-using-broker-12cr1 PS. I know I kept exiting to reconnect when I could have used CONNECT. I'm new to using the broker. :) Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by Liron Amitzi : Blog: https://amitzil.wordpress.com/ Twitter : https://twitter.com/amitzil 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: 6263 ORACLE-BASE.com
06.04 Oracle_10gR2_DataGuard_6.4 Perform a Switchback with longyannode and shanghainode.avi
 
12:29
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: 95 Yongcheng Lai
06.07 Oracle_10gR2_DataGuard_6.7 Perform a Switchback with xiamennode and shanghainode.avi
 
11:14
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: 102 Yongcheng Lai
Oracle Data Guard Tutorial - Introduction and Review (Part 1 of 4)
 
16:53
Oracle Data Guard Tutorial: Data Guard for Performance and Reduced Licensing Costs. Watch all four FREE lessons at http://www.skillbuilders.com/oracle-dataguard-tutorial. We all know that Data Guard is essential for protecting data. And we know that it is expensive and relies on largely idle systems, sitting there waiting for a problem that may never happen. This tutorial provides a quick review of what Data Guard is, and then goes on to show how you can extract value from Data Guard in every-day usage: how you can use it to enhance performance, and to reduce (yes, reduce!) your need for Oracle licences. Audience: This will be of interest to anyone already running Data Guard (or the old Standard Edition "standby database" facility) who needs to become aware of the newer capabilities, and to anyone trying to motivate the investment needed for a new Data Guard implementation. Recommended Prerequisites: As is common with SkillBuilders webinars, the content is technical, including live demonstrations of the techniques described. Some knowledge of Data Guard is recommended. Presenter: John Watson, Oracle Certified Master, SkillBuilders' Director of Oracle Services
Views: 9117 SkillBuilders
How To Create Standby Database Part 1 Of 4
 
10:01
Hi.. Guys In This Video We Learn How To Create Standby Database In Oracle 11g On Windows.
Views: 143 PGT POINT
Oracle DB - SPFILE & PFILE
 
23:44
Oracle DB - SPFILE & PFILE Watch More Videos at: https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjabi, Tutorials Point India Private Limited
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: 7629 Oracle World
Steps for creating Oracle 11g manually using sql commands
 
35:19
Steps for creating Oracle 11g manually using sql commands
Views: 24604 Wysheid Wysheid
Introduction to Oracle Real Application Clusters - DBArch Video 15
 
05:02
In this video , you will understand how an Oracle RAC ( Real Application Cluster) works. You will know the benefits of setting up a RAC Cluster. 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: 26001 Ramkumar Swaminathan
ASM Shutdown
 
00:36
Katie Morzinski shuts down MagAO's adaptive secondary mirror at the end of the our first run.
Views: 49 Jared Males
Oracle 12c Upgrade 112040 to 121010
 
48:26
Oracle 12c Database Upgrade from 11.2.0.4.0 to 12.1.0.1.0 This video was recorded in January 2014.
Views: 45315 Oracle By Example
Oracle 11g Grid Infrastructure Installation
 
01:34:27
This video describes in detail, the steps involved in Oracle 11g Grid Infrastructure Installation. This video includes, the OS setup, user creation and Grid infrastructure Installation
Views: 121296 Wysheid Wysheid
Oracle - Automating Database Startup on Linux and Windows
 
15:13
Oracle - Automating Database Startup on Linux and Windows
Views: 8594 Chris Ostrowski
Security in the Database Oracle 11g
 
01:07:48
This webinar was recorded live on 29 Feb 2012. Michelle Malcher (Oracle Ace Director and a representative on the Oracle Security Customer Advisor Council for the Independent Oracle User Group) presents practical ways to look at security and implementing standards and procedures around the database environment to account for the security outside of the users, including secured environments for regulations and compliance. Oracle 11g provides transparent data encryption at a tablespace level, and this webinar looks at how to implement this option to make it transparent to applications and users. You will learn some quick steps on securing the database environment, a basic process for applying CPU security patches, managing permissions and roles from test environments to production, and encryption. You can view our complete archive at http://www.red-gate.com/oracle-webinars
Views: 19353 Redgate Videos