Home
Search results “Standby log files oracle”
Redo Logs in an Oracle Database - DBArch Video 11
 
08:54
This video explains the concepts of Redo Log Groups and Files in an Oracle Database. You will understand how Oracle Instance uses Redo Buffers and Logwriter to keep the redo in Redo Logs. Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 13194 Ramkumar Swaminathan
Oracle DBA Justin - How to rename/move an online redo log file
 
09:20
How to rename/move an online redo log file
Views: 4960 jbleistein11
Alert log file in Oracle
 
07:34
Check Alert File Location in Oracle ================================================= DB is upp & Running ================== show parameter dump; select value from v$parameter where name='background_dump_dest'; DB is Down ===================================== find / -name alert_newdb.log 2 )/dev/null
Views: 2530 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: 4420 OrSkl Academy
How to reszie the redolog file
 
14:15
In this video i'm going to demonstrate you how to resize the redolog file step by step, this is only one method to resize the redolog file.
Views: 2135 OCP Technology
Oracle DBA Justin - How to mirror/multiplex online redo log files
 
08:32
How to mirror/multiplex online redo log files
Views: 5815 jbleistein11
SCPT 8: Redo Log Files
 
13:12
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 49835 Oresoft LWC
Oracle 11g Multiplexing Your Online Redo Log Files
 
04:04
In this tutorial i'm going to show you how to do Multiplexing Your Online Redo Log Files in Oracle 11g using command mode.
Views: 1436 OCP Technology
04.03-12 Oracle 10gR2 DataGuard 4.3 Step 12 Add Standby Redo Logs for the Physical Standby Database
 
01:28
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 4. Configure Primary and two Physical Standby Databases 4.1 Configure the Primary Database - (Video) Step 1: Enable Archivelog Mode and Flashback Database - (Video) Step 2: Create a Password file - (Video) Step 3 Enable Force Logging - (Video) Step 4: Create Standby Redo Logs - (Video) Step 5: Configure Oracle Net Components on Primary Database - (Video) Step 6: Configure the Primary Database Initialization Parameters - (Video) Step 7: Create a Backup of the Primary Database - (Video) Step 8: Update /etc/hosts file on all nodes and Verify Network - (Video) 4.2 Configure the First Physical Standby Database(xiamen) - (Video) Step1: Enable Archivelog Mode and Flashback Database - (Video) Step2: Create a Password file - (Video) Step3 Enable Force Logging - (Video) Step4: Create Standby Redo Logs - (Video) Step5: Create Directories on the Standby Host - (Video) Step6: Transfer the files to the standby host - (Video) Step7: Create a spfile for the Standby Instance - (Video) Step8: Configure Oracle Net Components on Primary Database - (Video) Step9: Start the standby database nomount - (Video) Step10: Create the Physical Standby Database - (Video) Step11: Start mount the Physical Standby Database - (Video) Step12: Start Redo Apply on the Standby Database - (Video) Step13: Enable Flashback Database - (Video) Step14: Add Standby Redo Logs for the Physical Standby Database if necessary - (Video) 4.3 Configure the Second Physical Standby Database - (Video) Step1: Enable Archivelog Mode and Flashback Database - (Video) Step2: Create a Password file - (Video) Step3 Enable Force Logging - (Video) Step4: Create Standby Redo Logs - (Video) Step5: Create Directories on the Standby Host - (Video) Step6: Transfer the files to the standby host - (Video) Step7: Create a spfile for the Standby Instance - (Video) Step8: Configure Oracle Net Components on Primary Database - (Video) Step9: Start the standby database nomount - (Video) Step10: Create the Physical Standby Database - (Video) Step11: Start mount the Physical Standby Database - (Video) Step12: Add Standby Redo Logs for the Physical Standby Database if necessary - (Video) Step13: Start Redo Apply on the Standby Database - (Video) Step14: Enable Flashback Database and Add Standby Redo Logs if necessary - (Video) 4.4 Verifying the Physical Standby Database - (Video) 4.5 Startup and Verify Physical Standby Database - ()
Views: 518 Yongcheng Lai
Moving a Database (datafile and Controlfile and Redo Log File)  from File System to ASM Storage
 
27:02
Hi guys today i explaining a real environment scenario that require to move a Full Database from File system to #MovingDatabase #FileSystemtoASMStorage ASM Disk Group Storage. Oracle database Unbeatable,Unbreakable Platform..
Views: 4215 Oracle World
Redo Log Files and RAC
 
03:40
In an Oracle RAC environment, each individual instance requires its own independent set of redo logs, and its own undo tablespace. For more information please visit https://www.koenig-solutions.com/oracle-database-12c-rac-administration-training.aspx
Views: 97 Koenig Solutions
Oracle DBA, Redo logs 1e1
 
05:18
Views: 3811 hammadshams
Oracle Tuning - Diagnosticando e corrigindo lentidão - LOG FILE SYNC
 
05:31
Oracle Tuning - Diagnosticando e corrigindo lentidão - LOG FILE SYNC
Views: 1295 Nerv
Oracle Tutorial - How to recover a corrupted NON SYSTEM datafile (database in ARCHIVELOG mode)
 
06:19
The following scenario describes what happens when a non system datafile is lost. Before proceeding be sure to have a complete backup of your database and be sure your database is in ARCHIVELOG mode. by Lalit saini
Views: 2106 Oracle World
Recovery of Redo log file using Log Sequence number by RMAN
 
13:50
Hi friends today I am showing you to Recovery of Redo log file using Log Sequence number by RMAN (Recovery Manager).This is a simple method and easy way to recovery redo members. Oracle database Unbeatable,Unbreakable Platform..
Views: 5783 Oracle World
04.03-08 Oracle_10gR2_DataGuard_4.3 Step 8 Configure Oracle Net Components on the Standby
 
02: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 4. Configure Primary and two Physical Standby Databases 4.1 Configure the Primary Database - (Video) Step 1: Enable Archivelog Mode and Flashback Database - (Video) Step 2: Create a Password file - (Video) Step 3 Enable Force Logging - (Video) Step 4: Create Standby Redo Logs - (Video) Step 5: Configure Oracle Net Components on Primary Database - (Video) Step 6: Configure the Primary Database Initialization Parameters - (Video) Step 7: Create a Backup of the Primary Database - (Video) Step 8: Update /etc/hosts file on all nodes and Verify Network - (Video) 4.2 Configure the First Physical Standby Database(xiamen) - (Video) Step1: Enable Archivelog Mode and Flashback Database - (Video) Step2: Create a Password file - (Video) Step3 Enable Force Logging - (Video) Step4: Create Standby Redo Logs - (Video) Step5: Create Directories on the Standby Host - (Video) Step6: Transfer the files to the standby host - (Video) Step7: Create a spfile for the Standby Instance - (Video) Step8: Configure Oracle Net Components on Primary Database - (Video) Step9: Start the standby database nomount - (Video) Step10: Create the Physical Standby Database - (Video) Step11: Start mount the Physical Standby Database - (Video) Step12: Start Redo Apply on the Standby Database - (Video) Step13: Enable Flashback Database - (Video) Step14: Add Standby Redo Logs for the Physical Standby Database if necessary - (Video) 4.3 Configure the Second Physical Standby Database - (Video) Step1: Enable Archivelog Mode and Flashback Database - (Video) Step2: Create a Password file - (Video) Step3 Enable Force Logging - (Video) Step4: Create Standby Redo Logs - (Video) Step5: Create Directories on the Standby Host - (Video) Step6: Transfer the files to the standby host - (Video) Step7: Create a spfile for the Standby Instance - (Video) Step8: Configure Oracle Net Components on Primary Database - (Video) Step9: Start the standby database nomount - (Video) Step10: Create the Physical Standby Database - (Video) Step11: Start mount the Physical Standby Database - (Video) Step12: Add Standby Redo Logs for the Physical Standby Database if necessary - (Video) Step13: Start Redo Apply on the Standby Database - (Video) Step14: Enable Flashback Database and Add Standby Redo Logs if necessary - (Video) 4.4 Verifying the Physical Standby Database - (Video) 4.5 Startup and Verify Physical Standby Database - ()
Views: 105 Yongcheng Lai
04.03_Oracle_10gR2_RACDG_4.3 Configure the non-RAC Physical Standby Database(20120114).flv
 
22:02
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. ONLY $199 Please feel free to contact me: E-mail/Skype: [email protected] 4. Configure the RAC Primary/Standby and non-RAC Standby 4.1 Configure the RAC Primary Database - (Video) Step1: Enable Archive Mode with the FLASHBACK option enabled - (Video) Step2: Create Shared Oracle Password Files - (Video) Step3: Enable Force Logging - (Video) Step4: Create Standby Redo Logs - (Video) Step5: Configure Oracle Net Components on the RAC Primary Database - (Video) Step6: Configure Initialization Parameters on the RAC Primary Database - (Video) Step7: Create a Backup of the Primary Database - (Video) Step8: Update /etc/hosts file on all nodes and Verify Network - (Video) 4.2 Configure the RAC Standby Database - (Video) Step1: Enable Archive Mode with the Flashback option enabled - (Video) Step2: Enable Force Logging - (Video) Step3: Create Shared Oracle Password Files - (Video) Step4: Create Directories on the Standby Host - (Video) Step5: Transfer the files to the Standby Host - (Video) Step6: Create a spfile for the RAC Standby Instance - (Video) Step7: Configure Oracle Net Components on the RAC Standby Database - (Video) Step8: Startup Standby Database nomount - (Video) Step9: Create the RAC Physical Standby Database - (Video) Step10: Start mount the RAC Physical Standby Database - (Video) Step11: Add RAC Standby Database and Instances to the OCR - (Video) Step12: Start Redo Apply on the RAC Physical Standby Database - (Video) Step13: Verify the RAC Primary and RAC Standby - (Video) Step14: Add Standby Redo Logs for the RAC Physical Standby Database - (Video) Step15: Enabling Flashback Database on the RAC Physical Standby - (Video) 4.3 Configure the non-RAC Physical Standby Database - (Video) Step1: Enable Archivelog Mode - (Video) Step2: Enable Force Logging - (Video) Step3: Create the Standby Password File - (Video) Step4: Create Directories on the Standby Host - (Video) Step5: Transfer the files to the standby host - (Video) Step6: Create a spfile for the Standby Instance - (Video) Step7: Configure Oracle Net Components on the non-RAC Standby - (Video) Step8: Startup Standby Database nomount - (Video) Step9: Create the non-RAC Physical Standby Database - (Video) Step10: Start the standby database. - (Video) Step11: Start Redo Apply on the Standby Database - (Video) Step12: Verify the RAC Primary and non-RAC Standby - (Video) Step13: Add Standby Redo Logs for the Standby Database - (Video) Step14: Enabling Flashback Database on the non-RAC Physical Standby - (Video)
Views: 407 Yongcheng Lai
04.02-05_Oracle_10gR2_RACDG_4.2 Step5 Transfer the files to the Standby Host(2012_01_13).flv
 
02:04
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. ONLY $199 Please feel free to contact me: E-mail/Skype: [email protected] 4. Configure the RAC Primary/Standby and non-RAC Standby 4.1 Configure the RAC Primary Database - (Video) Step1: Enable Archive Mode with the FLASHBACK option enabled - (Video) Step2: Create Shared Oracle Password Files - (Video) Step3: Enable Force Logging - (Video) Step4: Create Standby Redo Logs - (Video) Step5: Configure Oracle Net Components on the RAC Primary Database - (Video) Step6: Configure Initialization Parameters on the RAC Primary Database - (Video) Step7: Create a Backup of the Primary Database - (Video) Step8: Update /etc/hosts file on all nodes and Verify Network - (Video) 4.2 Configure the RAC Standby Database - (Video) Step1: Enable Archive Mode with the Flashback option enabled - (Video) Step2: Enable Force Logging - (Video) Step3: Create Shared Oracle Password Files - (Video) Step4: Create Directories on the Standby Host - (Video) Step5: Transfer the files to the Standby Host - (Video) Step6: Create a spfile for the RAC Standby Instance - (Video) Step7: Configure Oracle Net Components on the RAC Standby Database - (Video) Step8: Startup Standby Database nomount - (Video) Step9: Create the RAC Physical Standby Database - (Video) Step10: Start mount the RAC Physical Standby Database - (Video) Step11: Add RAC Standby Database and Instances to the OCR - (Video) Step12: Start Redo Apply on the RAC Physical Standby Database - (Video) Step13: Verify the RAC Primary and RAC Standby - (Video) Step14: Add Standby Redo Logs for the RAC Physical Standby Database - (Video) Step15: Enabling Flashback Database on the RAC Physical Standby - (Video) 4.3 Configure the non-RAC Physical Standby Database - (Video) Step1: Enable Archivelog Mode - (Video) Step2: Enable Force Logging - (Video) Step3: Create the Standby Password File - (Video) Step4: Create Directories on the Standby Host - (Video) Step5: Transfer the files to the standby host - (Video) Step6: Create a spfile for the Standby Instance - (Video) Step7: Configure Oracle Net Components on the non-RAC Standby - (Video) Step8: Startup Standby Database nomount - (Video) Step9: Create the non-RAC Physical Standby Database - (Video) Step10: Start the standby database. - (Video) Step11: Start Redo Apply on the Standby Database - (Video) Step12: Verify the RAC Primary and non-RAC Standby - (Video) Step13: Add Standby Redo Logs for the Standby Database - (Video) Step14: Enabling Flashback Database on the non-RAC Physical Standby - (Video)
Views: 100 Yongcheng Lai
04.03-04 Oracle_10gR2_DataGuard_4.3 Step 4 Create Standby Redo Logs.avi
 
01:43
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 4. Configure Primary and two Physical Standby Databases 4.1 Configure the Primary Database - (Video) Step 1: Enable Archivelog Mode and Flashback Database - (Video) Step 2: Create a Password file - (Video) Step 3 Enable Force Logging - (Video) Step 4: Create Standby Redo Logs - (Video) Step 5: Configure Oracle Net Components on Primary Database - (Video) Step 6: Configure the Primary Database Initialization Parameters - (Video) Step 7: Create a Backup of the Primary Database - (Video) Step 8: Update /etc/hosts file on all nodes and Verify Network - (Video) 4.2 Configure the First Physical Standby Database(xiamen) - (Video) Step1: Enable Archivelog Mode and Flashback Database - (Video) Step2: Create a Password file - (Video) Step3 Enable Force Logging - (Video) Step4: Create Standby Redo Logs - (Video) Step5: Create Directories on the Standby Host - (Video) Step6: Transfer the files to the standby host - (Video) Step7: Create a spfile for the Standby Instance - (Video) Step8: Configure Oracle Net Components on Primary Database - (Video) Step9: Start the standby database nomount - (Video) Step10: Create the Physical Standby Database - (Video) Step11: Start mount the Physical Standby Database - (Video) Step12: Start Redo Apply on the Standby Database - (Video) Step13: Enable Flashback Database - (Video) Step14: Add Standby Redo Logs for the Physical Standby Database if necessary - (Video) 4.3 Configure the Second Physical Standby Database - (Video) Step1: Enable Archivelog Mode and Flashback Database - (Video) Step2: Create a Password file - (Video) Step3 Enable Force Logging - (Video) Step4: Create Standby Redo Logs - (Video) Step5: Create Directories on the Standby Host - (Video) Step6: Transfer the files to the standby host - (Video) Step7: Create a spfile for the Standby Instance - (Video) Step8: Configure Oracle Net Components on Primary Database - (Video) Step9: Start the standby database nomount - (Video) Step10: Create the Physical Standby Database - (Video) Step11: Start mount the Physical Standby Database - (Video) Step12: Add Standby Redo Logs for the Physical Standby Database if necessary - (Video) Step13: Start Redo Apply on the Standby Database - (Video) Step14: Enable Flashback Database and Add Standby Redo Logs if necessary - (Video) 4.4 Verifying the Physical Standby Database - (Video) 4.5 Startup and Verify Physical Standby Database - ()
Views: 182 Yongcheng Lai
Oracle DBA, controlfiles, datafiles, online redolog files 1e6
 
03:26
Three very important files in oracle database
Views: 3215 hammadshams
Oracle Tutorial in Hindi - How to Multiplex/Mirror a Redo Log File of an Oracle Database
 
16:02
How to Multiplex/Mirror a Redo Log File of an Oracle Database... by Lalit Saini....
Views: 5288 Oracle World
04.02-14_Oracle_10gR2_RACDG_4.2 Step14 Add Standby Redo Logs for the Standby(20120113).flv
 
03:36
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. ONLY $199 Please feel free to contact me: E-mail/Skype: [email protected] 4. Configure the RAC Primary/Standby and non-RAC Standby 4.1 Configure the RAC Primary Database - (Video) Step1: Enable Archive Mode with the FLASHBACK option enabled - (Video) Step2: Create Shared Oracle Password Files - (Video) Step3: Enable Force Logging - (Video) Step4: Create Standby Redo Logs - (Video) Step5: Configure Oracle Net Components on the RAC Primary Database - (Video) Step6: Configure Initialization Parameters on the RAC Primary Database - (Video) Step7: Create a Backup of the Primary Database - (Video) Step8: Update /etc/hosts file on all nodes and Verify Network - (Video) 4.2 Configure the RAC Standby Database - (Video) Step1: Enable Archive Mode with the Flashback option enabled - (Video) Step2: Enable Force Logging - (Video) Step3: Create Shared Oracle Password Files - (Video) Step4: Create Directories on the Standby Host - (Video) Step5: Transfer the files to the Standby Host - (Video) Step6: Create a spfile for the RAC Standby Instance - (Video) Step7: Configure Oracle Net Components on the RAC Standby Database - (Video) Step8: Startup Standby Database nomount - (Video) Step9: Create the RAC Physical Standby Database - (Video) Step10: Start mount the RAC Physical Standby Database - (Video) Step11: Add RAC Standby Database and Instances to the OCR - (Video) Step12: Start Redo Apply on the RAC Physical Standby Database - (Video) Step13: Verify the RAC Primary and RAC Standby - (Video) Step14: Add Standby Redo Logs for the RAC Physical Standby Database - (Video) Step15: Enabling Flashback Database on the RAC Physical Standby - (Video) 4.3 Configure the non-RAC Physical Standby Database - (Video) Step1: Enable Archivelog Mode - (Video) Step2: Enable Force Logging - (Video) Step3: Create the Standby Password File - (Video) Step4: Create Directories on the Standby Host - (Video) Step5: Transfer the files to the standby host - (Video) Step6: Create a spfile for the Standby Instance - (Video) Step7: Configure Oracle Net Components on the non-RAC Standby - (Video) Step8: Startup Standby Database nomount - (Video) Step9: Create the non-RAC Physical Standby Database - (Video) Step10: Start the standby database. - (Video) Step11: Start Redo Apply on the Standby Database - (Video) Step12: Verify the RAC Primary and non-RAC Standby - (Video) Step13: Add Standby Redo Logs for the Standby Database - (Video) Step14: Enabling Flashback Database on the non-RAC Physical Standby - (Video)
Views: 163 Yongcheng Lai
oracle dba training online What is Archive Log.
 
04:33
This video is about Archive Logs and How to use Archive Logs and enable Archive logs
Views: 481 Nayabsoft
Oracle - CLEAR CORRUPTED LOGFILE
 
22:25
STARTUP MOUNT; ALTER DATABASE DROP LOGFILE GROUP 1; ALTER DATABASE CLEAR LOGFILE GROUP 1; ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;
Views: 512 Dario Rafael
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: 7115 Ramkumar Swaminathan
DATAGUARD Part-6 ✓ | switchover role primary to standby and #vice versa in Oracle 11g R2
 
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: 6942 OCP Technology
oracle database Redo logfile management
 
26:07
watch this video about Redo logfile management defiantly improve your subject
Views: 3842 COMBINATIONS FOR ALL
04.02-03_Oracle_10gR2_RACDG_4.2 Step3 Create Shared Oracle Password Files(2012_01_13).flv
 
00:29
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. ONLY $199 Please feel free to contact me: E-mail/Skype: [email protected] 4. Configure the RAC Primary/Standby and non-RAC Standby 4.1 Configure the RAC Primary Database - (Video) Step1: Enable Archive Mode with the FLASHBACK option enabled - (Video) Step2: Create Shared Oracle Password Files - (Video) Step3: Enable Force Logging - (Video) Step4: Create Standby Redo Logs - (Video) Step5: Configure Oracle Net Components on the RAC Primary Database - (Video) Step6: Configure Initialization Parameters on the RAC Primary Database - (Video) Step7: Create a Backup of the Primary Database - (Video) Step8: Update /etc/hosts file on all nodes and Verify Network - (Video) 4.2 Configure the RAC Standby Database - (Video) Step1: Enable Archive Mode with the Flashback option enabled - (Video) Step2: Enable Force Logging - (Video) Step3: Create Shared Oracle Password Files - (Video) Step4: Create Directories on the Standby Host - (Video) Step5: Transfer the files to the Standby Host - (Video) Step6: Create a spfile for the RAC Standby Instance - (Video) Step7: Configure Oracle Net Components on the RAC Standby Database - (Video) Step8: Startup Standby Database nomount - (Video) Step9: Create the RAC Physical Standby Database - (Video) Step10: Start mount the RAC Physical Standby Database - (Video) Step11: Add RAC Standby Database and Instances to the OCR - (Video) Step12: Start Redo Apply on the RAC Physical Standby Database - (Video) Step13: Verify the RAC Primary and RAC Standby - (Video) Step14: Add Standby Redo Logs for the RAC Physical Standby Database - (Video) Step15: Enabling Flashback Database on the RAC Physical Standby - (Video) 4.3 Configure the non-RAC Physical Standby Database - (Video) Step1: Enable Archivelog Mode - (Video) Step2: Enable Force Logging - (Video) Step3: Create the Standby Password File - (Video) Step4: Create Directories on the Standby Host - (Video) Step5: Transfer the files to the standby host - (Video) Step6: Create a spfile for the Standby Instance - (Video) Step7: Configure Oracle Net Components on the non-RAC Standby - (Video) Step8: Startup Standby Database nomount - (Video) Step9: Create the non-RAC Physical Standby Database - (Video) Step10: Start the standby database. - (Video) Step11: Start Redo Apply on the Standby Database - (Video) Step12: Verify the RAC Primary and non-RAC Standby - (Video) Step13: Add Standby Redo Logs for the Standby Database - (Video) Step14: Enabling Flashback Database on the non-RAC Physical Standby - (Video)
Views: 103 Yongcheng Lai
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]
Views: 1021 ANKUSH THAVALI
Process to check alert log in oracle
 
02:25
Here is a simple procedure by which you can checkout aleart log . regards, Pushpak Pattewar
Views: 9855 Pushpak Pattewar
Oracle Data Guard - Physical Standby Data Guard Configuration Part 1
 
01:00:38
Oracle Data Guard - Physical Standby Data Guard Configuration Part 1 Watch more Videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjabi, Tutorials Point India Private Limited.
04.02-04 Oracle_10gR2_DataGuard_4.2 Step 4 Create Standby Redo Logs.avi
 
02: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 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: 159 Yongcheng Lai
04.02-13_Oracle_10gR2_RACDG_4.2 Step13 Verify the RAC Primary and RAC Standby(2012_01_13).flv
 
03:49
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. ONLY $199 Please feel free to contact me: E-mail/Skype: [email protected] 4. Configure the RAC Primary/Standby and non-RAC Standby 4.1 Configure the RAC Primary Database - (Video) Step1: Enable Archive Mode with the FLASHBACK option enabled - (Video) Step2: Create Shared Oracle Password Files - (Video) Step3: Enable Force Logging - (Video) Step4: Create Standby Redo Logs - (Video) Step5: Configure Oracle Net Components on the RAC Primary Database - (Video) Step6: Configure Initialization Parameters on the RAC Primary Database - (Video) Step7: Create a Backup of the Primary Database - (Video) Step8: Update /etc/hosts file on all nodes and Verify Network - (Video) 4.2 Configure the RAC Standby Database - (Video) Step1: Enable Archive Mode with the Flashback option enabled - (Video) Step2: Enable Force Logging - (Video) Step3: Create Shared Oracle Password Files - (Video) Step4: Create Directories on the Standby Host - (Video) Step5: Transfer the files to the Standby Host - (Video) Step6: Create a spfile for the RAC Standby Instance - (Video) Step7: Configure Oracle Net Components on the RAC Standby Database - (Video) Step8: Startup Standby Database nomount - (Video) Step9: Create the RAC Physical Standby Database - (Video) Step10: Start mount the RAC Physical Standby Database - (Video) Step11: Add RAC Standby Database and Instances to the OCR - (Video) Step12: Start Redo Apply on the RAC Physical Standby Database - (Video) Step13: Verify the RAC Primary and RAC Standby - (Video) Step14: Add Standby Redo Logs for the RAC Physical Standby Database - (Video) Step15: Enabling Flashback Database on the RAC Physical Standby - (Video) 4.3 Configure the non-RAC Physical Standby Database - (Video) Step1: Enable Archivelog Mode - (Video) Step2: Enable Force Logging - (Video) Step3: Create the Standby Password File - (Video) Step4: Create Directories on the Standby Host - (Video) Step5: Transfer the files to the standby host - (Video) Step6: Create a spfile for the Standby Instance - (Video) Step7: Configure Oracle Net Components on the non-RAC Standby - (Video) Step8: Startup Standby Database nomount - (Video) Step9: Create the non-RAC Physical Standby Database - (Video) Step10: Start the standby database. - (Video) Step11: Start Redo Apply on the Standby Database - (Video) Step12: Verify the RAC Primary and non-RAC Standby - (Video) Step13: Add Standby Redo Logs for the Standby Database - (Video) Step14: Enabling Flashback Database on the non-RAC Physical Standby - (Video)
Views: 89 Yongcheng Lai
04.03-10 Oracle_10gR2_DataGuard_4.3 Step 10 Create the Physical Standby Database.avi
 
02: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 4. Configure Primary and two Physical Standby Databases 4.1 Configure the Primary Database - (Video) Step 1: Enable Archivelog Mode and Flashback Database - (Video) Step 2: Create a Password file - (Video) Step 3 Enable Force Logging - (Video) Step 4: Create Standby Redo Logs - (Video) Step 5: Configure Oracle Net Components on Primary Database - (Video) Step 6: Configure the Primary Database Initialization Parameters - (Video) Step 7: Create a Backup of the Primary Database - (Video) Step 8: Update /etc/hosts file on all nodes and Verify Network - (Video) 4.2 Configure the First Physical Standby Database(xiamen) - (Video) Step1: Enable Archivelog Mode and Flashback Database - (Video) Step2: Create a Password file - (Video) Step3 Enable Force Logging - (Video) Step4: Create Standby Redo Logs - (Video) Step5: Create Directories on the Standby Host - (Video) Step6: Transfer the files to the standby host - (Video) Step7: Create a spfile for the Standby Instance - (Video) Step8: Configure Oracle Net Components on Primary Database - (Video) Step9: Start the standby database nomount - (Video) Step10: Create the Physical Standby Database - (Video) Step11: Start mount the Physical Standby Database - (Video) Step12: Start Redo Apply on the Standby Database - (Video) Step13: Enable Flashback Database - (Video) Step14: Add Standby Redo Logs for the Physical Standby Database if necessary - (Video) 4.3 Configure the Second Physical Standby Database - (Video) Step1: Enable Archivelog Mode and Flashback Database - (Video) Step2: Create a Password file - (Video) Step3 Enable Force Logging - (Video) Step4: Create Standby Redo Logs - (Video) Step5: Create Directories on the Standby Host - (Video) Step6: Transfer the files to the standby host - (Video) Step7: Create a spfile for the Standby Instance - (Video) Step8: Configure Oracle Net Components on Primary Database - (Video) Step9: Start the standby database nomount - (Video) Step10: Create the Physical Standby Database - (Video) Step11: Start mount the Physical Standby Database - (Video) Step12: Add Standby Redo Logs for the Physical Standby Database if necessary - (Video) Step13: Start Redo Apply on the Standby Database - (Video) Step14: Enable Flashback Database and Add Standby Redo Logs if necessary - (Video) 4.4 Verifying the Physical Standby Database - (Video) 4.5 Startup and Verify Physical Standby Database - ()
Views: 245 Yongcheng Lai
04.03-06 Oracle_10gR2_DataGuard_4.3 Step 6 Transfer the files to the standby host.avi
 
02:45
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 4. Configure Primary and two Physical Standby Databases 4.1 Configure the Primary Database - (Video) Step 1: Enable Archivelog Mode and Flashback Database - (Video) Step 2: Create a Password file - (Video) Step 3 Enable Force Logging - (Video) Step 4: Create Standby Redo Logs - (Video) Step 5: Configure Oracle Net Components on Primary Database - (Video) Step 6: Configure the Primary Database Initialization Parameters - (Video) Step 7: Create a Backup of the Primary Database - (Video) Step 8: Update /etc/hosts file on all nodes and Verify Network - (Video) 4.2 Configure the First Physical Standby Database(xiamen) - (Video) Step1: Enable Archivelog Mode and Flashback Database - (Video) Step2: Create a Password file - (Video) Step3 Enable Force Logging - (Video) Step4: Create Standby Redo Logs - (Video) Step5: Create Directories on the Standby Host - (Video) Step6: Transfer the files to the standby host - (Video) Step7: Create a spfile for the Standby Instance - (Video) Step8: Configure Oracle Net Components on Primary Database - (Video) Step9: Start the standby database nomount - (Video) Step10: Create the Physical Standby Database - (Video) Step11: Start mount the Physical Standby Database - (Video) Step12: Start Redo Apply on the Standby Database - (Video) Step13: Enable Flashback Database - (Video) Step14: Add Standby Redo Logs for the Physical Standby Database if necessary - (Video) 4.3 Configure the Second Physical Standby Database - (Video) Step1: Enable Archivelog Mode and Flashback Database - (Video) Step2: Create a Password file - (Video) Step3 Enable Force Logging - (Video) Step4: Create Standby Redo Logs - (Video) Step5: Create Directories on the Standby Host - (Video) Step6: Transfer the files to the standby host - (Video) Step7: Create a spfile for the Standby Instance - (Video) Step8: Configure Oracle Net Components on Primary Database - (Video) Step9: Start the standby database nomount - (Video) Step10: Create the Physical Standby Database - (Video) Step11: Start mount the Physical Standby Database - (Video) Step12: Add Standby Redo Logs for the Physical Standby Database if necessary - (Video) Step13: Start Redo Apply on the Standby Database - (Video) Step14: Enable Flashback Database and Add Standby Redo Logs if necessary - (Video) 4.4 Verifying the Physical Standby Database - (Video) 4.5 Startup and Verify Physical Standby Database - ()
Views: 88 Yongcheng Lai
oracle tutorial for beginners - Redo Log File Recovery in Hindi.
 
03:09
incomplete recovery of redo log files.
Views: 1486 OCP Technology
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.
04.02-02_Oracle_10gR2_RACDG_4.2 Step2 Enable Force Logging(2012_01_13).flv
 
00:46
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. ONLY $199 Please feel free to contact me: E-mail/Skype: [email protected] 4. Configure the RAC Primary/Standby and non-RAC Standby 4.1 Configure the RAC Primary Database - (Video) Step1: Enable Archive Mode with the FLASHBACK option enabled - (Video) Step2: Create Shared Oracle Password Files - (Video) Step3: Enable Force Logging - (Video) Step4: Create Standby Redo Logs - (Video) Step5: Configure Oracle Net Components on the RAC Primary Database - (Video) Step6: Configure Initialization Parameters on the RAC Primary Database - (Video) Step7: Create a Backup of the Primary Database - (Video) Step8: Update /etc/hosts file on all nodes and Verify Network - (Video) 4.2 Configure the RAC Standby Database - (Video) Step1: Enable Archive Mode with the Flashback option enabled - (Video) Step2: Enable Force Logging - (Video) Step3: Create Shared Oracle Password Files - (Video) Step4: Create Directories on the Standby Host - (Video) Step5: Transfer the files to the Standby Host - (Video) Step6: Create a spfile for the RAC Standby Instance - (Video) Step7: Configure Oracle Net Components on the RAC Standby Database - (Video) Step8: Startup Standby Database nomount - (Video) Step9: Create the RAC Physical Standby Database - (Video) Step10: Start mount the RAC Physical Standby Database - (Video) Step11: Add RAC Standby Database and Instances to the OCR - (Video) Step12: Start Redo Apply on the RAC Physical Standby Database - (Video) Step13: Verify the RAC Primary and RAC Standby - (Video) Step14: Add Standby Redo Logs for the RAC Physical Standby Database - (Video) Step15: Enabling Flashback Database on the RAC Physical Standby - (Video) 4.3 Configure the non-RAC Physical Standby Database - (Video) Step1: Enable Archivelog Mode - (Video) Step2: Enable Force Logging - (Video) Step3: Create the Standby Password File - (Video) Step4: Create Directories on the Standby Host - (Video) Step5: Transfer the files to the standby host - (Video) Step6: Create a spfile for the Standby Instance - (Video) Step7: Configure Oracle Net Components on the non-RAC Standby - (Video) Step8: Startup Standby Database nomount - (Video) Step9: Create the non-RAC Physical Standby Database - (Video) Step10: Start the standby database. - (Video) Step11: Start Redo Apply on the Standby Database - (Video) Step12: Verify the RAC Primary and non-RAC Standby - (Video) Step13: Add Standby Redo Logs for the Standby Database - (Video) Step14: Enabling Flashback Database on the non-RAC Physical Standby - (Video)
Views: 105 Yongcheng Lai
04.02-14 Oracle_10gR2_DataGuard_4.2 Step 14 Add Standby Redo Logs for the Physical Standby Database
 
03:06
Provide free Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training,please feel free to contact me: skype: [email protected]
Views: 71 Yongcheng Lai
04.04 Oracle_10gR2_DataGuard_4.4 Verifying the Physical Standby Database.avi
 
09:09
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 4. Configure Primary and two Physical Standby Databases 4.1 Configure the Primary Database - (Video) Step 1: Enable Archivelog Mode and Flashback Database - (Video) Step 2: Create a Password file - (Video) Step 3 Enable Force Logging - (Video) Step 4: Create Standby Redo Logs - (Video) Step 5: Configure Oracle Net Components on Primary Database - (Video) Step 6: Configure the Primary Database Initialization Parameters - (Video) Step 7: Create a Backup of the Primary Database - (Video) Step 8: Update /etc/hosts file on all nodes and Verify Network - (Video) 4.2 Configure the First Physical Standby Database(xiamen) - (Video) Step1: Enable Archivelog Mode and Flashback Database - (Video) Step2: Create a Password file - (Video) Step3 Enable Force Logging - (Video) Step4: Create Standby Redo Logs - (Video) Step5: Create Directories on the Standby Host - (Video) Step6: Transfer the files to the standby host - (Video) Step7: Create a spfile for the Standby Instance - (Video) Step8: Configure Oracle Net Components on Primary Database - (Video) Step9: Start the standby database nomount - (Video) Step10: Create the Physical Standby Database - (Video) Step11: Start mount the Physical Standby Database - (Video) Step12: Start Redo Apply on the Standby Database - (Video) Step13: Enable Flashback Database - (Video) Step14: Add Standby Redo Logs for the Physical Standby Database if necessary - (Video) 4.3 Configure the Second Physical Standby Database - (Video) Step1: Enable Archivelog Mode and Flashback Database - (Video) Step2: Create a Password file - (Video) Step3 Enable Force Logging - (Video) Step4: Create Standby Redo Logs - (Video) Step5: Create Directories on the Standby Host - (Video) Step6: Transfer the files to the standby host - (Video) Step7: Create a spfile for the Standby Instance - (Video) Step8: Configure Oracle Net Components on Primary Database - (Video) Step9: Start the standby database nomount - (Video) Step10: Create the Physical Standby Database - (Video) Step11: Start mount the Physical Standby Database - (Video) Step12: Add Standby Redo Logs for the Physical Standby Database if necessary - (Video) Step13: Start Redo Apply on the Standby Database - (Video) Step14: Enable Flashback Database and Add Standby Redo Logs if necessary - (Video) 4.4 Verifying the Physical Standby Database - (Video) 4.5 Startup and Verify Physical Standby Database - ()
Views: 137 Yongcheng Lai
Oracle Data Guard Tutorial - Open the Standby Read Only (Part 2 of 4)
 
16:49
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. Opening the standby database read-only. This has in fact been possible since the automation of redo transport and redo apply when it was first introduced in release 8i. Redo is received on the standby database but is not applied. So the redo is written to the RFS, slave to standby logs, archive to standby logs into archive logs but there's no apply done. So recoverability is not compromised. There's still no danger being lots of data. You're still receiving. The thing is open read-only. What does that mean? It means you can run queries against it. You can offload all your heavyweight queries from the primary to the standby. When I say all of them, even queries that require vast massive temporary space, those horrendous queries, those doing hash joins between multi gigabyte tables, they'll be generating many gigabytes of temporary data. You can write temporary data. Provided that you're using proper temporary tablespaces which you're certain you should be, you can run any query no matter how big, no matter how much temporary data it needs. You can also write audit data and this is important because with version 11, there's quite a lot of auditing enabled by default. By default, that auditing goes to the database, writing database tables. And you can't write to a database table in a read-only database. That we can configure for automatic switching and direct the audit records to the operating system or the trail instead. The queries you run, why is this such a good facility? First, you're taking stress off the primary. I'm sure that we're all DBAs here and we all know how difficult it is to tune your database or a concurrent workload that includes both high volume DML and includes heavyweight queries. Basically, you can't tune that way at all. Offloading the queries to the physical standby will reduce a lot of stress from the primary. So your DML should run significantly better and you can even do a certain amount of tuning on the standby to tune for optimal query performance. The most obvious tuning one would do, would be the memory parameters. No one could for example give the primary a massive PGA aggregate target and the much smaller SGA target or use indeed automatic memory management, perhaps cell tuning. One can adjust many parameters to do with tuning the optimizer to drive the optimizer to a certain execution plan, to exploit the environments. All that can be done on an open read-only database. How does one do it? It really couldn't be simpler. If we look at my physical standby here, this thing database role, physical standby - and if we select the open mode from v$ database, we find this in mount mode. How do we actually open at read-only? First off, we have to stop the recovery process because remember redo is received but no applied. You have to cancel the recovery. So "alter database recover managed standby database cancel." That will give us a read consistent version of the database. The command is intelligent enough to know that there might be incomplete transactions. Long-run transactions could've been partially received. We will end up with a read consistent version. To cancel it, all we do is alter database open read-only. It is that simple.
Views: 3103 SkillBuilders
04.02-10_Oracle_10gR2_RACDG_4.2 Step10 Start mount the RAC Physical Standby(20120113).flv
 
01:27
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. ONLY $199 Please feel free to contact me: E-mail/Skype: [email protected] 4. Configure the RAC Primary/Standby and non-RAC Standby 4.1 Configure the RAC Primary Database - (Video) Step1: Enable Archive Mode with the FLASHBACK option enabled - (Video) Step2: Create Shared Oracle Password Files - (Video) Step3: Enable Force Logging - (Video) Step4: Create Standby Redo Logs - (Video) Step5: Configure Oracle Net Components on the RAC Primary Database - (Video) Step6: Configure Initialization Parameters on the RAC Primary Database - (Video) Step7: Create a Backup of the Primary Database - (Video) Step8: Update /etc/hosts file on all nodes and Verify Network - (Video) 4.2 Configure the RAC Standby Database - (Video) Step1: Enable Archive Mode with the Flashback option enabled - (Video) Step2: Enable Force Logging - (Video) Step3: Create Shared Oracle Password Files - (Video) Step4: Create Directories on the Standby Host - (Video) Step5: Transfer the files to the Standby Host - (Video) Step6: Create a spfile for the RAC Standby Instance - (Video) Step7: Configure Oracle Net Components on the RAC Standby Database - (Video) Step8: Startup Standby Database nomount - (Video) Step9: Create the RAC Physical Standby Database - (Video) Step10: Start mount the RAC Physical Standby Database - (Video) Step11: Add RAC Standby Database and Instances to the OCR - (Video) Step12: Start Redo Apply on the RAC Physical Standby Database - (Video) Step13: Verify the RAC Primary and RAC Standby - (Video) Step14: Add Standby Redo Logs for the RAC Physical Standby Database - (Video) Step15: Enabling Flashback Database on the RAC Physical Standby - (Video) 4.3 Configure the non-RAC Physical Standby Database - (Video) Step1: Enable Archivelog Mode - (Video) Step2: Enable Force Logging - (Video) Step3: Create the Standby Password File - (Video) Step4: Create Directories on the Standby Host - (Video) Step5: Transfer the files to the standby host - (Video) Step6: Create a spfile for the Standby Instance - (Video) Step7: Configure Oracle Net Components on the non-RAC Standby - (Video) Step8: Startup Standby Database nomount - (Video) Step9: Create the non-RAC Physical Standby Database - (Video) Step10: Start the standby database. - (Video) Step11: Start Redo Apply on the Standby Database - (Video) Step12: Verify the RAC Primary and non-RAC Standby - (Video) Step13: Add Standby Redo Logs for the Standby Database - (Video) Step14: Enabling Flashback Database on the non-RAC Physical Standby - (Video)
Views: 102 Yongcheng Lai
04.02-15_Oracle_10gR2_RACDG_4.2 Step15 Enabling Flashback Database on the Standby(20120113).flv
 
04:29
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. ONLY $199 Please feel free to contact me: E-mail/Skype: [email protected] 4. Configure the RAC Primary/Standby and non-RAC Standby 4.1 Configure the RAC Primary Database - (Video) Step1: Enable Archive Mode with the FLASHBACK option enabled - (Video) Step2: Create Shared Oracle Password Files - (Video) Step3: Enable Force Logging - (Video) Step4: Create Standby Redo Logs - (Video) Step5: Configure Oracle Net Components on the RAC Primary Database - (Video) Step6: Configure Initialization Parameters on the RAC Primary Database - (Video) Step7: Create a Backup of the Primary Database - (Video) Step8: Update /etc/hosts file on all nodes and Verify Network - (Video) 4.2 Configure the RAC Standby Database - (Video) Step1: Enable Archive Mode with the Flashback option enabled - (Video) Step2: Enable Force Logging - (Video) Step3: Create Shared Oracle Password Files - (Video) Step4: Create Directories on the Standby Host - (Video) Step5: Transfer the files to the Standby Host - (Video) Step6: Create a spfile for the RAC Standby Instance - (Video) Step7: Configure Oracle Net Components on the RAC Standby Database - (Video) Step8: Startup Standby Database nomount - (Video) Step9: Create the RAC Physical Standby Database - (Video) Step10: Start mount the RAC Physical Standby Database - (Video) Step11: Add RAC Standby Database and Instances to the OCR - (Video) Step12: Start Redo Apply on the RAC Physical Standby Database - (Video) Step13: Verify the RAC Primary and RAC Standby - (Video) Step14: Add Standby Redo Logs for the RAC Physical Standby Database - (Video) Step15: Enabling Flashback Database on the RAC Physical Standby - (Video) 4.3 Configure the non-RAC Physical Standby Database - (Video) Step1: Enable Archivelog Mode - (Video) Step2: Enable Force Logging - (Video) Step3: Create the Standby Password File - (Video) Step4: Create Directories on the Standby Host - (Video) Step5: Transfer the files to the standby host - (Video) Step6: Create a spfile for the Standby Instance - (Video) Step7: Configure Oracle Net Components on the non-RAC Standby - (Video) Step8: Startup Standby Database nomount - (Video) Step9: Create the non-RAC Physical Standby Database - (Video) Step10: Start the standby database. - (Video) Step11: Start Redo Apply on the Standby Database - (Video) Step12: Verify the RAC Primary and non-RAC Standby - (Video) Step13: Add Standby Redo Logs for the Standby Database - (Video) Step14: Enabling Flashback Database on the non-RAC Physical Standby - (Video)
Views: 150 Yongcheng Lai
04.02-01_Oracle_10gR2_RACDG_4.2 Step1 Enable Archive Mode(2012_01_13).flv
 
00:37
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. ONLY $199 Please feel free to contact me: E-mail/Skype: [email protected] 4. Configure the RAC Primary/Standby and non-RAC Standby 4.1 Configure the RAC Primary Database - (Video) Step1: Enable Archive Mode with the FLASHBACK option enabled - (Video) Step2: Create Shared Oracle Password Files - (Video) Step3: Enable Force Logging - (Video) Step4: Create Standby Redo Logs - (Video) Step5: Configure Oracle Net Components on the RAC Primary Database - (Video) Step6: Configure Initialization Parameters on the RAC Primary Database - (Video) Step7: Create a Backup of the Primary Database - (Video) Step8: Update /etc/hosts file on all nodes and Verify Network - (Video) 4.2 Configure the RAC Standby Database - (Video) Step1: Enable Archive Mode with the Flashback option enabled - (Video) Step2: Enable Force Logging - (Video) Step3: Create Shared Oracle Password Files - (Video) Step4: Create Directories on the Standby Host - (Video) Step5: Transfer the files to the Standby Host - (Video) Step6: Create a spfile for the RAC Standby Instance - (Video) Step7: Configure Oracle Net Components on the RAC Standby Database - (Video) Step8: Startup Standby Database nomount - (Video) Step9: Create the RAC Physical Standby Database - (Video) Step10: Start mount the RAC Physical Standby Database - (Video) Step11: Add RAC Standby Database and Instances to the OCR - (Video) Step12: Start Redo Apply on the RAC Physical Standby Database - (Video) Step13: Verify the RAC Primary and RAC Standby - (Video) Step14: Add Standby Redo Logs for the RAC Physical Standby Database - (Video) Step15: Enabling Flashback Database on the RAC Physical Standby - (Video) 4.3 Configure the non-RAC Physical Standby Database - (Video) Step1: Enable Archivelog Mode - (Video) Step2: Enable Force Logging - (Video) Step3: Create the Standby Password File - (Video) Step4: Create Directories on the Standby Host - (Video) Step5: Transfer the files to the standby host - (Video) Step6: Create a spfile for the Standby Instance - (Video) Step7: Configure Oracle Net Components on the non-RAC Standby - (Video) Step8: Startup Standby Database nomount - (Video) Step9: Create the non-RAC Physical Standby Database - (Video) Step10: Start the standby database. - (Video) Step11: Start Redo Apply on the Standby Database - (Video) Step12: Verify the RAC Primary and non-RAC Standby - (Video) Step13: Add Standby Redo Logs for the Standby Database - (Video) Step14: Enabling Flashback Database on the non-RAC Physical Standby - (Video)
Views: 121 Yongcheng Lai
Using DG-Broker how to switchover Primary and standby roles | Live Proof 💯% working
 
06:02
Hello Friends, Today i'm going to show you how to switchover primary & standby role using DG-Broker step by step. #switchover #dgbroker #standby Please subscribe ocptechnology on YouTube for more updated.
Views: 1821 OCP Technology
How to convert physical standby into snapshot standby part-5
 
06:55
In this video i'm going to demonstrate you how to convert physical standby into snapshot standby step by step
Views: 2334 OCP Technology
04.02-07_Oracle_10gR2_RACDG_4.2 Step7 Configure Oracle Net Components(20120113).flv
 
05:37
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. ONLY $199 Please feel free to contact me: E-mail/Skype: [email protected] 4. Configure the RAC Primary/Standby and non-RAC Standby 4.1 Configure the RAC Primary Database - (Video) Step1: Enable Archive Mode with the FLASHBACK option enabled - (Video) Step2: Create Shared Oracle Password Files - (Video) Step3: Enable Force Logging - (Video) Step4: Create Standby Redo Logs - (Video) Step5: Configure Oracle Net Components on the RAC Primary Database - (Video) Step6: Configure Initialization Parameters on the RAC Primary Database - (Video) Step7: Create a Backup of the Primary Database - (Video) Step8: Update /etc/hosts file on all nodes and Verify Network - (Video) 4.2 Configure the RAC Standby Database - (Video) Step1: Enable Archive Mode with the Flashback option enabled - (Video) Step2: Enable Force Logging - (Video) Step3: Create Shared Oracle Password Files - (Video) Step4: Create Directories on the Standby Host - (Video) Step5: Transfer the files to the Standby Host - (Video) Step6: Create a spfile for the RAC Standby Instance - (Video) Step7: Configure Oracle Net Components on the RAC Standby Database - (Video) Step8: Startup Standby Database nomount - (Video) Step9: Create the RAC Physical Standby Database - (Video) Step10: Start mount the RAC Physical Standby Database - (Video) Step11: Add RAC Standby Database and Instances to the OCR - (Video) Step12: Start Redo Apply on the RAC Physical Standby Database - (Video) Step13: Verify the RAC Primary and RAC Standby - (Video) Step14: Add Standby Redo Logs for the RAC Physical Standby Database - (Video) Step15: Enabling Flashback Database on the RAC Physical Standby - (Video) 4.3 Configure the non-RAC Physical Standby Database - (Video) Step1: Enable Archivelog Mode - (Video) Step2: Enable Force Logging - (Video) Step3: Create the Standby Password File - (Video) Step4: Create Directories on the Standby Host - (Video) Step5: Transfer the files to the standby host - (Video) Step6: Create a spfile for the Standby Instance - (Video) Step7: Configure Oracle Net Components on the non-RAC Standby - (Video) Step8: Startup Standby Database nomount - (Video) Step9: Create the non-RAC Physical Standby Database - (Video) Step10: Start the standby database. - (Video) Step11: Start Redo Apply on the Standby Database - (Video) Step12: Verify the RAC Primary and non-RAC Standby - (Video) Step13: Add Standby Redo Logs for the Standby Database - (Video) Step14: Enabling Flashback Database on the non-RAC Physical Standby - (Video)
Views: 123 Yongcheng Lai
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: 230 Yongcheng Lai
Oracle DB - No Archive log & Archive log Mode
 
07:44
Oracle DB - No Archive log & Archive log Mode Watch More Videos at: https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjabi, Tutorials Point India Private Limited

Tk102 application letters
Yazzy application letters
Broadcast meteorology cover letter
Quality writing service
The best writing service review