Home
Search results “Oracle activate standby”
Creating Duplicate and Standby database using RMAN
 
16:19
Creating Duplicate and Standby database using RMAN cloning database oracle on linux make standby db
Views: 6441 mohamed suez
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: 3132 SkillBuilders
Data Guard - Normal Rolling Upgrade for  Physical Standby Data Guard
 
58:23
Data Guard - Normal Rolling Upgrade for Physical Standby Data Guard Watch more Videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjabi, Tutorials Point India Private Limited.
Oracle Data Guard - Performing Manual Failover Steps
 
42:09
This video is part of my Oracle 12c Data Guard with ASM online training. In case you are looking for full training, please contact: [email protected]
Views: 1152 DBA Genesis
Hybrid data guard configuration for on prem Primary and Cloud standby configuration
 
45:08
Steps to demonstrate how to create a Data Guard configuration with an on premises Primary Database and its Standby on Oracle Cloud.
Views: 369 Tamal Chatterjee
How To Configure Oracle Database in Flashback Mode
 
11:39
How To Configure Oracle Database in Flashback Mode; Configure Flashback related parameters; Enable / Disable Flashback mode
Views: 12057 Abbasi Asif
Manually Switching Active and Standby Namenodes
 
05:08
This video will explain how to switch the namenode status in HA enabled Name nodes By default zookeeper fail over controller will take care of this switching in case zookeeper goes down you can use manual steps hdfs haadmin -transitionToActive serviceId[--forceactive] hdfs haadmin -transitionToStandby serviceId hdfs haadmin -failover [--forcefence] [--forceactive] serviceId serviceId hdfs haadmin -getServiceState serviceId hdfs haadmin -getAllServiceState hdfs haadmin -checkHealth serviceId
Views: 478 Hadoop Engineering
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: 171 Yongcheng Lai
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.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: 408 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.01_Oracle_10gR2_RACDG_14.1 Configure the RAC Primary Database(2012_01_13).flv
 
23: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: 263 Yongcheng Lai
04.02-04_Oracle_10gR2_RACDG_4.2 Step4 Create Directories on the Standby Host(2012_01_13).flv
 
04:05
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: 80 Yongcheng Lai
Oracle Data Guard Tutorial - Advanced Techniques (Part 4 of 4)
 
07:19
Part 4 of SkillBuilders Tutorial "Beyond Data Guard". In this segment Oracle Certified Master DBA John Watson discusses and demonstrates The Read Mostly Database and using Data Guard to enhance performance by using the Standby Database for Query and directing DML to the Primary. For more see www.SkillBuilders.com/DataGuard. John: Now, the last topic. I've just got time to dealing with this. The last topic I want to look at is - I'd like to call it the read mostly database. This is a very nice technique. We're getting even more value out of your physical standby because remember what I've talked about before? When you open your database read-only you can write a very limited amount of data, basically only temporary data. Opening it read-write to the snapshot standby, yes, it's read-write but then you're not applying the redo so it's no longer valid as a real time data warehouse. The read mostly database is a compromise between the two. So it adds even more value ideally to Active Data Guard. It would function without Active Data Guard license but Active Data Guard is where you're going to get most benefits of this. This is where we've come to that low balancing question we had earlier. If you have say two applications, perhaps one application is your standard OLTP application. The other application is your query application. Maybe you've got business objects or discoverer. Business objects applications, discover applications, they're read intensive. They run massive queries. But they also do an occasional bit of DML. Not much, but they do enough to mean you cannot run them against read-only database in many circumstances. So what we need to do is redirect the small amount of DML to the primary while running all heavy weight queries against the standby. In a way, that means your application doesn't even know it's happening. How can I do that? I can do it like this. On my primary, as we see on the slide, send them some database links. So, on my primary which is Madrid, I'll begin by creating a user. I do need to start manage recovery here. So I cancelled recovery, I opened a database, let apply going. I'm about to connect to a user I haven't even created.
Views: 2695 SkillBuilders
RECOVER LOST  DataFile in oracle database
 
15:33
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 DATAFILE file Lost ================================ Archive log mode-Enabled create tablespace test_ts datafile '/u01/app/oracle/oradata/testdb/ts_test02.dbf' size 10M; create table testtable (id number(5))tablespace test_ts; insert into testtable (id) select * from testtable; SQL>select count(*) from testtable; COUNT(*) ---------- - before deleting datafile 524288 SQL>select count(*) from testtable; COUNT(*) ---------- - After recovery 524288 select tablespace_name, segment_name from dba_segments where segment_name = 'TESTTABLE'; alter system flush buffer_cache; alter database create datafile '/u01/app/oracle/oradata/testdb/ts_test02.dbf' as '/u01/app/oracle/oradata/testdb/ts_test02.dbf' alter database datafile '/u01/app/oracle/oradata/testdb/ts_test02.dbf' offline drop; alter database create datafile '/u01/app/oracle/oradata/testdb/ts_test02.dbf' as '/u01/app/oracle/oradata/testdb/ts_test02.dbf' recover datafile '/u01/app/oracle/oradata/testdb/ts_test02.dbf'; alter database datafile '/u01/app/oracle/oradata/testdb/ts_test02.dbf' online; select count(*) from TESTTABLE; =================================================== Please like,subscribe my channel. Kindly contact for online training on below contacts. Emai: [email protected] Mob No: +91 9960262955 ====================================================== 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] how to recover lost datafile in oracle how to recover a datafile in oracle without backup how to recover a deleted datafile in oracle 11g how to recover datafile in oracle rman restore datafile oracle missing datafile after clone how to recover system datafile in oracle without backup oracle datafile deleted accidentally
Views: 1203 ANKUSH THAVALI
04.02-12_Oracle_10gR2_RACDG_4.2 Step12 Start Redo Apply on the RAC Physical Standby(20120113).flv
 
04:11
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. ONLY $199 Please feel free to contact me: E-mail/Skype: [email protected]com 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: 176 Yongcheng Lai
04.02-06_Oracle_10gR2_RACDG_4.2 Step6 Create a spfile for the RAC Standby Instance(20120113).flv
 
04:42
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: 215 Yongcheng Lai
04.02-11_Oracle_10gR2_RACDG_4.2 Step11 Add RAC Standby Database and Instances to OCR(20120113.flv
 
08: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: 274 Yongcheng Lai
04.02-09_Oracle_10gR2_RACDG_4.2 Step9 Create the RAC Physical Standby Database(2012_01_13).flv
 
10: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: 379 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
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: 90 Yongcheng Lai
oracle connected to an idle instance Resolved ✅
 
01:14
How To Fix Oracle connected to idle instance issue ? Worked this. Please Subscribe ❤ Our YouTube Channels ❤ : ☛ CBOT : http://goo.gl/IyFFSV 🔗 ☛ LazyAssTrainer : http://goo.gl/38LlyY 🔗 ☛ Free Promotions For YouTubers : http://goo.gl/bl4OLq 🔗 ☛ Indian Vlogger : http://goo.gl/pHJWIO 🔗 Please Follow ❤ Us On Twitter ❤ : ☛ LazyAssTrainer : http://goo.gl/osKEO7 🔗 ☛ Sameer Pradhan : http://goo.gl/FKWUPt 🔗 ☛ CBOT : http://goo.gl/e4JYn7 🔗 Please Join ❤ Us At FaceBook ❤ : ☛ Sameer Photography : http://goo.gl/6wthA2 🔗 ☛ TCS Photographers Photostock Group : http://goo.gl/8G8n5i 🔗
Views: 15088 WikiVlog
HADR Tutorial Part 17 - Export ignores Statement Isolation Level in RE Standby
 
12:24
Export Utility Ignores Statement Isolation Level in Read Enabled Standby Database. Kindly Share Your Inputs. Happy Learning & Sharing http://db2luwacademy.blogspot.in
Views: 115 DB2-LUW-ACADEMY
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: 124 Yongcheng Lai
Create oracle 11gR2 RAC database using response file
 
46:09
In this video the oracle 11gR2 RAC database has been created using response file or in silent mode. Database is created in no archivelog mode hence converted the database in archivelog mode after creating one more RECO diskgroup for the archives. This video also shows how to set up new shared virtual disk to be used as RAW disk for new disk group. Formatted the new disk and created new volume for the RECO disk group. Please visit my blog : https://orablogtalk.wordpress.com/ Please provide suggestion or comment if you find this tutorial helpful...Thanks...
Views: 51 BoxOracle
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
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.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-13_Oracle_10gR2_RACDG_4.2 Step13 Verify the RAC Primary and RAC Standby_2(2012_01_13).flv
 
02:26
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: 79 Yongcheng Lai
TranData In Oracle GoldenGate
 
02:06
Oracle GoldenGate uses supplemental log groups to configure supplemental logging at table level. Supplemental logging is enabled using the ADD TRANDATA command in GGSCI.For more information please visit https://www.koenig-solutions.com/oracle-goldengate-12-c-fundamentals-training.aspx
Views: 108 Koenig Solutions
How to Connect Toad For Oracle To Oracle Database
 
03:41
This video shows how to connect Toad for oracle to an oracle database via direct connection.
Views: 23766 SQL TUTORIALS
Oracle Training - Training Video | How to Fix DHCP Errors with Oracle Database Installation
 
04:03
Oracle Training from Firebox IT Training (https://www.fireboxtraining.com) In this Oracle Training tutorial you will learn how to solve the dreaded DHCP error. When installing an Oracle database on Windows, you may get the dreaded DHCP error, which has to do with your IP address, which needs to be static instead of dynamic. This tutorial shows you how to correct that error by installing the Microsoft loopback adapter and modifying your ets/hosts file.
Views: 3069 Firebox Training
How to create pfile to spfile and Vice-Versa
 
08:59
How to create pfile to spfile and Vice-Versa ======================================== Important command ======================== create pfile from spfile create spfile from pfile show parameter spfile ============================================== 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: 183 ANKUSH THAVALI
Networking : Fault Tolerant Default Gateway -  Hot Standby Router Protocol [HSRP]
 
16:43
Fault Tolerant Default Gateway - Hot Standby Router Protocol [HSRP] ____________________________________________________________________ In computer networking, the Hot Standby Router Protocol (HSRP) is a Cisco proprietary redundancy protocol for establishing a fault-tolerant default gateway. Version 1 of the protocol was described in RFC 2281. The protocol establishes a framework between network routers in order to achieve default gateway failover if the primary gateway becomes inaccessible, in close association with a rapid-converging routing protocol like EIGRP or OSPF. HSRP routers send multicast Hello messages to other routers to notify them of their priorities (which router is preferred) and current status (Active or Standby). The primary router with the highest configured priority will act as a virtual router with a pre-defined gateway IP address and will respond to the ARP / ND request from machines connected to the LAN with a virtual MAC address. If the primary router should fail, the router with the next-highest priority would take over the gateway IP address and answer ARP requests with the same MAC address, thus achieving transparent default gateway failover.
Views: 103 Maddy’s World
HOW TO INSTALL ORACLE 11G ON RHEL 6
 
31:12
ORACLE 11G INSTALLATION IN RHEL 6
Views: 168 ORACLEMATES
How to configure listener in oracle database 11g
 
11:54
In this tutorial you will learn how to configure oracle listener. if you have any problem with this tutorial or listener configuration please comment below If you have any quary about database you can comment below or contact to me by mail [email protected] Or via facebook My facebook home pagelink is……… https://www.facebook.com/pages/Oracle-DBA-Help-line/110901159026745?ref=hl
Views: 11376 OnLinE ReSoUrCe
IPSEC High Availability In A VPN Network With Hot Standby Router Protocol Enabled
 
03:40
I was going to write a description, but there are maybe 500 people in the world who need any information from this video, and they are unlikely to watch this video with out knowing they need this and they are likely only interested the part about Device Cache Fail over. IPSEC High Availability In A VPN Network With Hot Standby Router Protocol Enabled
Views: 1321 Biz of Tech
EMC World 2014: XtremIO Snapshots and Oracle
 
05:04
This is a quick demonstration shown at EMC World 2014 that walks through the new XtremIO snapshots - simple, high performance, and distributed across the scale-out cluster. Perfect for making Oracle Test and Dev not only super AFA fast, at XtremIO consistently low latency, and with inline dedupe you can count on - but also awesomely simple snapshots (that don't impact performance, have huge scaling).
Views: 3407 Chad Sakac
Light Ships & Activation of Light Workers
 
01:43:43
Ari Kopel addresses how the spiritual community has been compromised and infiltrated via the same forces that are trying to eradicate life on the planet. The different behaviors expressed by some in these spiritual communities are symptoms of the "programming" that has taken place via off-world entities that have hijacked the spiritual Light Forces, preventing the full realization of their God-potential so that the agenda of the "dark forces" can continue to go unchecked and undetected. The breaking free of this mind/spiritual control and programming occurs when we humbly come in with the desire and willingness to know this truth, and when we are willing to let go of "belief systems" that have been designed to keep us numbed down, ineffective, disengaged and disempowered to effect change. Courage and humility is "key". Light Ships and why these are on Standby is also discussed in more depth. The purpose of this broadcast is for the Activation of the Spiritual Warrior and Light Worker Community, to help us step into our Divine Roles and allow us to Unite in purpose. Ultimately, it is meant to help us be engaged in uplifting humanity and returning this world, and all expressions of life on it, to its original Divine Blueprint. Click link below to hear broadcast: http://www.blogtalkradio.com/shatteringthematrix/2013/08/16/light-s... Please join our website for more Matrix-Shattering information: 2012Emergence.com Like us on Facebook at: Facebook.com/ShatteringTheMatrix Please Share, so others are Aware...
Views: 5628 Ari Kopel
abmr_adg_11g_featurs
 
01:55
AUTO BLOCK MEDIA RECOVERY in Oracle 11g Active Data Guard _auto_bmr enabled enable/disable Auto BMR _auto_bmr_req_timeout 60 Auto BMR Requester Timeout _auto_bmr_sess_threshold 30 Auto BMR Request Session Threshold _auto_bmr_pub_timeout 10 Auto BMR Publish Timeout _auto_bmr_fc_time 60 Auto BMR Flood Control Time _auto_bmr_bg_time 3600 Auto BMR Process Run Time _auto_bmr_sys_threshold 100 Auto BMR Request System Threshold
F5 LTM Force Failover Test
 
02:31
Views: 1743 Gary Chen
Tips n Tricks Part 137 - Unused Storage Group can Impede Database Activation
 
05:28
Unused Storage Group can Impede Database Activation. Empty Folder Deos Not Mean Unused. Happy Learning & Sharing http://db2luwacademy.blogspot.in
Views: 104 DB2-LUW-ACADEMY
Oracle RMAN backup
 
10:17
Creating a backup script to backup Oracle database without shutting the instance. Requires that archive logging is enabled. #!/bin/bash # This is a simple backup script, and will work fine for a small installation such as Oracle XE # Change the Recovery Window to be longer than the frequency of backup # Change the /home/paulw/backups to be a specific backup location, at least on a separate disk # and preferably accessible if the source machine isn't accessible # # Replace the @@ with a left angle bracket . /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh rman @@ EOF CONNECT target / CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/paulw/backups/auto_control_file_%F'; CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS; run { ALLOCATE CHANNEL RMAN_BACK_CH01 TYPE DISK; BACKUP AS COMPRESSED BACKUPSET DATABASE FORMAT '/home/paulw/backups/databasefiles_%d_%u_%s_%T'; sql 'ALTER SYSTEM ARCHIVE LOG CURRENT'; BACKUP AS COMPRESSED BACKUPSET ARCHIVELOG ALL FORMAT '/home/paulw/backups/archivelogs_%d_%u_%s_%T'; BACKUP AS COMPRESSED BACKUPSET CURRENT CONTROLFILE FORMAT '/home/paulw/backups/controlfile_%d_%u_%s_%T'; CROSSCHECK BACKUP; DELETE NOPROMPT OBSOLETE; DELETE NOPROMPT EXPIRED BACKUP; RELEASE CHANNEL RMAN_BACK_CH01; } CONFIGURE CONTROLFILE AUTOBACKUP OFF; EXIT; EOF
Views: 8 Paul Williams
How to set up Log shipping in DB2
 
17:55
What is log shipping? It is a method where transaction logs are automatically backed up from primary to standby. How to set up Log shipping in DB2? Step1: Create a folder with name "mylogs" Step2: Here we are using userexit method to do log shipping so we need a program called db2uext2.cdisk it will be located in "C:\IBM\SQLLIB\samples\c" Step3: copy it into a working directory and rename it as db2uext2.c Step4: After this create two instances(DB2 & DB2INST1) and create tstls database in each instance separately. In this video DB2 is primary instance and DB2INST1 is secondary database instance. Step5: Now in DB2 instance enable the USEREXIT parameter as below "db2 update db cfg for tstls using USEREXIT ON" Step6: Lets check what are the parameters got effected after this. "db2 get db cfg for tstls | findstr -i user" output: User exit for logging status = YES User exit for logging enabled (USEREXIT) = ON First log archive method (LOGARCHMETH1) = USEREXIT Step7: Here logarchmeth1 parameter also enabled so we must take the backup of that database otherwise we can not connect to the database so now we have to take backup of tstls database "db2 backup db tstls to C:\Users\GANESH\Desktop\primary compress" Step8: Now we have to change some parameters in db2uext2.c file #define ARCHIVE_PATH "C:\\Users\\Administrator\\Desktop\\mylogs\\" #define RETRIEVE_PATH "C:\\Users\\Administrator\\Desktop\\mylogs\\" #define AUDIT_ACTIVE 1 /* enable audit trail logging */ #define ERROR_ACTIVE 0 /* enable error trail logging */ #define AUDIT_ERROR_PATH "C:\\Users\\Administrator\\Desktop\\mylogs\\" /* path must end with a slash */ #define AUDIT_ERROR_ATTR "a" /* append to text file */ #define BUFFER_SIZE 32 /* # of 4K pages for output buffer */ Step9: Now we need to compile this c program so we need c compiler in our system I have ms visual studio so I'll use developer command prompt to compile my c program. "cl db2uext2.c" now you will get an .exe file step10: Now we have to place the executable file in the below folder. "C:\IBM\SQLLIB\BIN" Step11: Now we have to stop and start the DB manager for instance DB2 Now the log shipping process is done. If you create a table in tstls which is present in DB2 instance those logs will be archived from "C:\DB2\NODE0000\SQL00003\SQLOGDIR" to "C:\Users\GANESH\Administrator\mylogs" In this video I used a procedure to insert multiple rows at a time into a table to generate more logs you can create it sample table and insert data to generate one log file Thanks for watching the video. Please follow us on Google+: https://plus.google.com/b/110932362852272683221/+Db2devadmin/posts Please subscribe for more:
Views: 3356 DB Tutorials
[Archived][1.0 SPS 09] SAP HANA Administration: System Replication, Concepts - SAP HANA Academy
 
07:45
For the latest videos, see the playlist: https://www.youtube.com/playlist?list=PLkzo92owKnVxBAv4lAEcXqP7FWpXwoUfe In this video tutorial series we will show you how to setup and manage SAP HANA System Replication. In this video, Denys van Kempen briefly discusses some of the concepts. If you like our video tutorials, please subscribe to our channel: http://youtube.com/saphanaacademy MORE INFORMATION You can read more about system replication in my blog: https://blogs.sap.com/2015/05/19/sap-hana-system-replication/ BLOGS Stay up to date with our latest blogs on SAP.com: https://people.sap.com/denys.kempen https://people.sap.com/philip.muggles... Do you speak a different language to English? Did you know you can submit Subtitles on all of our videos on YouTube? For instructions how to do this click here: https://goo.gl/M1Ca4J SOCIAL MEDIA Feel free to connect with us at the links below: LinkedIn: https://linkedin.com/saphanaacademy Twitter: https://twitter.com/saphanaacademy Facebook: https://www.facebook.com/saphanaacademy/ Google+: https://plus.google.com/+saphanaacademy Github: https://github.com/saphanaacademy
Views: 13187 SAP HANA Academy
EMC Protection Platform For Oracle Exadata # 1
 
02:48
Short demo of an EMC VNX 5300 as a protection platform for Oracle Exadata. Oracle Data Guard Standby Database resides on the VNX
Views: 200 OracleUnCorked
How to connect to Oracle Database using Toad for Oracle.
 
08:42
How to connect to Oracle Database using Toad for Oracle. Online Video to learn the simple way to connect to database through Toad for Oracle. Learn Oracle connectivity from configuring tnsnames.ora , net8 client configuration to connecting to toad. A complete oracle tutorial.
Views: 119467 Subhroneel Ganguly
2 Minute Tech Tip: BIG IP Upgrade
 
02:19
Learn how to upgrade to a new version of the BIG-IP.
Views: 9986 F5 DevCentral