Home
Search results “Flashback oracle enable”
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: 12535 Abbasi Asif
1.ORACLE WORLD - How to Performing Flashback in Oracle Database
 
05:04
Hello friends in this video i'm just showing to you that how to enable flashback in Oracle database... #PerformingFlashback #OracleDatabase By Lalit saini
Views: 2024 Oracle World
04.03-14 Oracle 10gR2 DataGuard 4 3 Step 14 Enable Flashback Database
 
04: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 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: 798 Yongcheng Lai
8.oracle world-FLASHBACK Guaranteed Restore Point
 
09:06
HI friends today i give you a brief scenario how to create flashback guaranteed restore point for TABLE-LEVEL RECOVERY. #GuaranteedRestorePoint #FLASHBACK Oracle database Unbeatable,Unbreakable Platform..
Views: 3597 Oracle World
Oracle Database 11g,12c DBA tutorials. how to enable archive log mode and disable.
 
07:00
This section describes how to set the archiving mode of the database and how to control the archiving process.And how to Archive log mode on and off.
Views: 947 Sayif Uddin
How To Configure Oracle Database  in ArchiveLog Mode
 
09:47
How To Configure Oracle Database in ArchiveLog Mode / NoArchiveLog Mode
Views: 4392 Abbasi Asif
Turn FLASHBACK DATABASE on & off while the Database stays OPEN
 
03:38
The clip demonstrates how to change FLASHBACK DATABASE without having to restart the instance. A text version is here: https://uhesse.com/2010/06/25/turning-flashback-database-on-off-with-instance-in-status-open/ The demo is done with 12c but the shown can be done with 11gR2 as well.
What is Fast Recovery Area and how to configure it- Backup&Reco Video 6
 
03:28
In this video you will learn about FRA - Fast Recovery Area, what is used for and how to configure it. 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: 4288 Ramkumar Swaminathan
Flashback Database Oracle 11g
 
10:53
This video show how to flashback database in oracle 11g
Views: 1180 Pratiwi galuh putri
Flashback database, Architecture, Configuring flashback Database, Monitoring Flashback database
 
16:17
Performing flashback - Flashback database, Architecture, Configuring flashback Database, Monitoring Flashback database For Students of B.Tech, B.E, MCA, BCA, B.Sc., M.Sc., Courses - As Per IP University Syllabus and Other Engineering Courses
6.ORACLE WORLD - How to perform Flashback Version Query in Oracle database
 
10:57
Hello friends in this scenario i have explain about flashback version query in oracle database flashback version query is provide analysis of sql statement b/w different of time. #performFlashback #Oracledatabase #FlashbackVersionQuery By lalit saini
Views: 2070 Oracle World
Enable Disable Oracle 11g archivelog
 
07:50
Enable Disable Oracle Archive log mode. Like us on Facebook: https://www.facebook.com/IMK.DBA
Views: 451 ibrahim kmail
02.25.02_Oracle_10gR2_RACDG_2.25.2 Enabling Archive Logs and Flashback in a RAC
 
05:56
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. Please feel free to contact me: E-mail/Skype: [email protected] 1. Building an Oracle RAC 10gR2 for RAC Primary 1.1 Install Linux OS(CentOS 5.3) - () 1.2 Install Required Linux Packages for Oracle RAC- (Video) 1.3 Network Configuration - (Video) 1.4 Create "oracle" User and Directories - (Video) 1.5 Configure the Linux Servers for Oracle - (Video) 1.6 Configure the "hangcheck-timer" Kernel Module - (Video) 1.7 Configure RAC Nodes for Remote Access using SSH - (Video) 1.8 IP SAN Configuration - Openfiler - () 1.9 Install Openfiler - SAN - () 1.10 Configure iSCSI Volumes using openfiler - (Video) 1.11 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 1.12 Install and configure Oracle Cluster File System(OCFS2)- (Video) 1.13 Install and Configure ASM (ASMLib2.0) - (Video) 1.14 Download Oracle RAC 10g Software - (Video) 1.15 Pre-Installation Tasks for Oracle 10g Release 2- (Video) 1.16 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 1.17 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 1.18 Install and configure Automatic Storage Management (ASM) - (Video) 1.19 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 1.20 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 1.21 Install Oracle Database 10g Companion CD Software - (Video) 1.22 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 1.23 Create TNS Listener Process - (Video) 1.24 Create ASM Instance - (Video) 1.25 Install the EM agent on each cluster node - (Video) 1.25.1 Pre-Installation Requirements - (Video) 1.25.2 Download Oracle Management Agent (10.2.0.5) - (Video) 1.25.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video) 1.25.4 Verify Agent Status - (Video) 1.25.5 Secure the Management Agent if necessary - (Video) 1.26 Create a Cluster Database - (Video) 1.27 Post-Installation Tasks - (Optional) - (Video) 1.27.1 Re-compile Invalid Objects - (Video) 1.27.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 1.27.3 Create Shared Oracle Password Files - (Video) 1.28 Verify TNS Networking Files - (Video) 1.29 Create / Alter Tablespaces - () 1.30 Verify the RAC Cluster & Database Configuration - (Video) 1.31 Configuring the Initialization Parameters - (Video) 1.32 Startup / Shutdown the Oracle RAC 10gR2 - (Video) 1.32.1 Stopping the Oracle RAC 10g Environment - (Video) 1.32.2 Start Monitor the alert.log - () 1.32.3 Start the Oracle RAC 10g - () 2. Building an Oracle RAC 10gR2 for RAC Standby 2.1 Install Linux OS(CentOS 5.3) - () 2.2 Install Required Linux Packages for Oracle RAC - (Video) 2.3 Network Configuration - (Video) 2.4 Create "oracle" User and Directories - (Video) 2.5 Configure the Linux Servers for Oracle - (Video) 2.6 Configure the "hangcheck-timer" Kernel Module - (Video) 2.7 Configure RAC Nodes for Remote Access using SSH - (Video) 2.8 Configure iSCSI Volumes using openfiler - (Video) 2.9 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 2.10 Install and configure Oracle Cluster File System(OCFS2) - (Video) 2.11 Install and Configure ASM (ASMLib2.0) - (Video) 2.12 Download Oracle RAC 10g Software - (Video) 2.13 Pre-Installation Tasks for Oracle 10g Release 2 - (Video) 2.14 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 2.15 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 2.16 Install and configure Automatic Storage Management (ASM) - (Video) 2.17 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 2.18 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 2.19 Install Oracle Database 10g Companion CD Software - (Video) 2.20 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 2.21 Create TNS Listener Process - (Video) 2.22 Create ASM Instance - (Video) 2.23 Install the EM agent on each cluster node - (Video) 2.23.1 Pre-Installation Requirements - (Video) 2.23.2 Download Oracle Management Agent (10.2.0.5) - (Video) 2.23.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video) 2.23.4 Verify Agent Status - () 2.23.5 Secure the Management Agent if necessary - () 2.24 Create a Cluster Database - (Video) 2.25 Post-Installation Tasks - (Optional) - (Video) 2.25.1 Re-compile Invalid Objects - (Video) 2.25.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 2.25.3 Create Shared Oracle Password Files - (Video) 2.26 Verify TNS Networking Files - (Video) 2.27 Create / Alter Tablespaces - () 2.28 Verify the RAC Cluster & Database Configuration - (Video) 2.29 Configuring the Initialization Parameters - (Video) 2.30 Startup / Shutdown the Oracle RAC 10gR2 - ()
Views: 247 Yongcheng Lai
How to recover dropped table using flashback
 
06:13
In this video i'm going to show you how to recovery dropped table using flashback step by step. #recover #dropped #table #flashback
Views: 4217 OCP Technology
How to Flashback in oracle 11g
 
12:18
Berikut ini merupakan tutorial flashback pada oracle
Views: 237 Pratiwi galuh putri
Enable Disable Block Change Tracking in Oracle
 
04:49
Enable Disable Block Change Tracking in Oracle
Views: 1455 Abbasi Asif
flashback version query
 
03:27
Views: 207 MrQutaibah
Oracle Flashback Operations Fundamentals 2
 
30:50
In this tutorial you will how to perform flashback operations on oracle databases.
Views: 270 DBA Pro
4.ORACLE WORLD - How to Recover drop table from Recyclebin using Flashback in oracle database
 
07:57
Hello guys in this demo I'm just showing to you that we can easily recover the dropped table from recyclebin in oracle using flashback technology very fast without shutdown the database... #performingflashback #recoveryofdroptablefromrecyclebin #oracledatabase By lalit saini
Views: 5179 Oracle World
Configure oracle database in flashback mode. And how to works guaranteed restore point!
 
20:03
In this video I am going to show you how to configure oracle database in flashback mode. And how to works guaranteed restore point. Using this amazing feature we can recover data and tables without restoring any backup
Views: 479 Sentura
Point in time recovery via flashback
 
05:35
Point in time Recovery in Oracle 11g
Views: 778 Athar Fahad
flashback query in oracle
 
02:52
in this tutorial i teach flashback query in oracle
Automatic Historical Tracking of Data in Oracle Using Flashback Data Archive
 
21:44
Track data as it changes over time without any code or schema changes in Oracle Database using Flashback Data Archive.
Flashback technology and Flashback Queries
 
07:55
Video del curso Base de Datos II- Universidad de Costa Rica - II Semestre Año 2014 Tema: Flashback Technologies and Flashback Queries Referencias: Página Oracle 1- Oracle® Database Development Guide 12c Release 1, Ch 16 Using Flashback Technology en: http://docs.oracle.com/database/121/ADFNS/adfns_flashback.htm#ADFNS1008 2. Oracle® Database SQL Language Reference 12c Release 1, SELECT Statement, Using Flashback Queries: Example, en: http://docs.oracle.com/database/121/SQLRF/ statements_10002.htm#SQLRF55379!
Views: 164 Erick Palma Solano
Oracle Flashback Operations Fundamentals 5
 
39:33
In this tutorial you will how to perform flashback operations on oracle databases.
Views: 249 DBA Pro
Oracle Flashback Database
 
04:20
Oracle Flashback Database
Views: 538 The Silent DBA
Oracle Tutorial || Oracle|Adv Sql | FlashBack by basha
 
43:08
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS ,ADF,INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo......
04.03-01 Oracle_10gR2_DataGuard_4.3 Step 1 Enable Archivelog Mode and Flashback Database.avi
 
01:49
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: 258 Yongcheng Lai
Oracle Flashback Data Archive
 
21:34
Oracle Flashback Data Archive
Views: 533 The Silent DBA
Auditing in Oracle 11g
 
10:43
Auditing in Oracle database will help you to what a user doing??
Views: 5418 Athar Fahad
Oracle Database: How to enable ARCHIVELOG mode
 
02:13
Oracle Database: How to enable ARCHIVELOG mode Have a visit at my website: http://dbaworkshop.blogspot.com
Views: 1462 mvige
Table Point In Time Recovery (PITR) in Oracle Database 12c
 
02:47
This video gives a quick demonstration of the table point in time (PITR) in Oracle Database 12c. Note. In this case it would be easier to do a flashback query to get the data as it was, but I'm using this simple example to demonstrate this functionality. For more information see: https://oracle-base.com/articles/12c/rman-table-point-in-time-recovery-12cr1 https://oracle-base.com/articles/12c/multitenant-rman-backup-recovery-cdb-and-pdb-12cr1#pdb-pitr-recovery Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by Uwe Hesse : Blog: https://uhesse.com/ Twitter : https://twitter.com/UweHesse Cameo appearances are for fun, not an endorsement of the content of this video. All trademarks, product names and logos are the property of their respective owners.
Views: 3208 ORACLE-BASE.com
Table Shrinking in Oracle Database
 
14:15
1.Shrink the Table: Shrinking is started from 10g. In this method I’m using user u1 and table name sm1. Now I’m deleting some rows in sm1 COUNT ---------- 1048576 Table sm1 has 1048576 rows. [email protected]: delete from sm1 where deptno=10; 262144 rows deleted. I deleted above number of rows. Rows COUNT ---------- 786432 And I’m giving commit [email protected]: commit; Commit complete. So now we have 786432 rows in sm1 table. Now see the following command [email protected]: select OWNER,TABLESPACE_NAME,SEGMENT_NAME,SEGMENT_TYPE,BYTES/1024/1024||' mb'"space",BLOCKS,EXTENTS from dba_segments where tablespace_name like 'U%TS'; OWNER TABLESPACE_NAME SEGMENT_NAME SEGMENT_TYPE space BLOCKS EXTENTS ----- --------------- ------------- ------------- ------ ---------- ---------- U1 U1TS SM1 TABLE 29 mb 3712 44 After I deleted some rows in sm1 table still above result showing same values, so now our duty is shrink this table. This is done by following 2 ways, i By using COMPACT key word: In this method shrinking is done in two phases. In the first phase all fragmented space are just defragmented, but still the High Water Mark is persist with last used block only. That mean used free blocks are not de allocated and HWM is not updated here. Issue the following command before use shrink command. [email protected] alter table sm1 enable row movement; Table altered. There is particular use with above command, when we shrink the table all rows are moves to contiguous blocks, so here row movement should be done. By default the row movement is disabled for any table, so above command enabled the row movement. Then execute shrink command now. [email protected]: alter table sm1 shrink space compact; Table altered. Now see the space of table by using below command. [email protected]: select OWNER,TABLESPACE_NAME,SEGMENT_NAME,SEGMENT_TYPE,BYTES/1024/1024||' mb'"space",BLOCKS,EXTENTS from dba_segments where tablespace_name like 'U%TS'; OWNER TABLESPACE_NAME SEGMENT_NAME SEGMENT_TYPE space BLOCKS EXTENTS ----- --------------- ------------- ------------- ------ ---------- ---------- U1 U1TS SM1 TABLE 29 mb 3712 44 So here seems nothing happened with above shrink command, but internally the fragmented space is defragmented. But the high water mark is not updated, used free blocks are also not de allocated. For de allocating the used blocks we have to execute below command. This is the second phase. [email protected]: alter table sm1 shrink space; Table altered. Now see the space by using below command. [email protected]: select OWNER,TABLESPACE_NAME,SEGMENT_NAME,SEGMENT_TYPE,BYTES/1024/1024||' mb'"space",BLOCKS,EXTENTS from dba_segments where tablespace_name like 'U%TS'; OWNER TABLESPACE_NAME SEGMENT_NAME SEGMENT_TYPE space BLOCKS EXTENTS ----- --------------- ------------- ------------- ---------- ---------- ---------- U1 U1TS SM1 TABLE 20.8125 mb 2664 36 So now the space of sm1 table is reduced. Note: Actually the alter table sm1 shrink space command will complete these two phases of the shrinking of table at a time. But here we done shrink process in two phases because when we use alter table sm1 shrink space command the table locked temporarily some time period, during this period users unable to access the table. So if we use alter table sm1 shrink space compact command the table is not locked but space is defragmented. When we not in business hours issue the second phase shrink command then users are won’t get any problem. ii Because of above method the table dependent objects are goes to invalid state, to overcome this problem we have to use below command. [email protected]: alter table sm1 shrink space cascade; Table altered. The above command also shrinks the space of all dependent objects. We also do this in two phases like above two phases. See the below command. [email protected]: alter table sm1 shrink space compact cascade; Table altered. And then [email protected]: alter table sm1 shrink space cascade; Table altered. Transporting tablespace to different platform by Using RMAN : https://www.youtube.com/watch?v=CN401PUKK4A Oracle EBS apps Upgrade from 12 2 to 12 2 5 (start CD 51) : https://www.youtube.com/watch?v=zeO4goqR70Y Transport tablespace by using RMAN.: https://www.youtube.com/watch?v=YG6kWX7Par8
Views: 7410 BhagyaRaj Katta
Archivelog enable in RAC database
 
07:52
enable archivelog in RAC database
04.26.02_Oracle_10gR2_RAC_4.26.2 Enabling Archive Logs and Flashback in a RAC.avi
 
05:51
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. Building an Oracle RAC 10gR2 (10.2.0.3) on Linux 4.1 Install Linux OS(CentOS 5.3) - () 4.2 Install Required Linux Packages for Oracle RAC - (Video) 4.3 Network Configuration - (Video) 4.4 Create "oracle" User and Directories - (Video) 4.5 Configure the Linux Servers for Oracle - (Video) 4.6 Configure the "hangcheck-timer" Kernel Module - (Video) 4.7 Configure RAC Nodes for Remote Access using SSH - (Video) 4.8 IP SAN Configuration - Openfiler - () 4.9 Install Openfiler - SAN - () 4.10 Configure iSCSI Volumes using openfiler - (Video) 4.11 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 4.12 Install and configure Oracle Cluster File System(OCFS2) - (Video) 4.13 Install and Configure ASM (ASMLib2.0) - (Video) 4.14 Download Oracle RAC 10g Software - (Video) 4.15 Pre-Installation Tasks for Oracle 10g Release 2 - (Video) 4.16 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 4.17 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 4.18 Install and configure Automatic Storage Management (ASM) - (Video) 4.19 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 4.20 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 4.21 Install Oracle Database 10g Companion CD Software - (Video) 4.22 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 4.23 Create TNS Listener Process - (Video) 4.24 Create ASM Instance - (Video) 4.25 Create a Cluster Database - (Video) 4.26 Post-Installation Tasks - (Optional) - (Video) 4.26.1 Re-compile Invalid Objects - (Video) 4.26.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 4.26.3 Create Shared Oracle Password Files - (Video) 4.27 Verify TNS Networking Files - (Video) 4.28 Create / Alter Tablespaces - () 4.29 Verify the RAC Cluster & Database Configuration - (Video) 4.30 Configuring the Initialization Parameters - (Video) 4.31 Startup / Shutdown the Oracle RAC 10gR2 - ()
Views: 151 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: 155 Yongcheng Lai
Oracle Database Upgrades - Fallback Strategie - Guaranteed Restore Point
 
06:15
This video shows various techniques to protect yourself against issues happening during a database upgrade. Guaranteed Restore Points are very powerful, not only for upgrades but of course for all kinds of testing. And interestingly enough, you don't have to enable Flashback Database - and you can not only flashback but flash forward as well.
01.27.02_Oracle_10gR2_RACDG_1.27.2 Enabling Archive Logs and Flashback in a RAC
 
04:57
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. Please feel free to contact me: E-mail/Skype: [email protected] 1. Building an Oracle RAC 10gR2 for RAC Primary 1.1 Install Linux OS(CentOS 5.3) - () 1.2 Install Required Linux Packages for Oracle RAC- (Video) 1.3 Network Configuration - (Video) 1.4 Create "oracle" User and Directories - (Video) 1.5 Configure the Linux Servers for Oracle - (Video) 1.6 Configure the "hangcheck-timer" Kernel Module - (Video) 1.7 Configure RAC Nodes for Remote Access using SSH - (Video) 1.8 IP SAN Configuration - Openfiler - () 1.9 Install Openfiler - SAN - () 1.10 Configure iSCSI Volumes using openfiler - (Video) 1.11 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 1.12 Install and configure Oracle Cluster File System(OCFS2)- (Video) 1.13 Install and Configure ASM (ASMLib2.0) - (Video) 1.14 Download Oracle RAC 10g Software - (Video) 1.15 Pre-Installation Tasks for Oracle 10g Release 2- (Video) 1.16 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 1.17 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 1.18 Install and configure Automatic Storage Management (ASM) - (Video) 1.19 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 1.20 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 1.21 Install Oracle Database 10g Companion CD Software - (Video) 1.22 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 1.23 Create TNS Listener Process - (Video) 1.24 Create ASM Instance - (Video) 1.25 Install the EM agent on each cluster node - (Video) 1.25.1 Pre-Installation Requirements - (Video) 1.25.2 Download Oracle Management Agent (10.2.0.5) - (Video) 1.25.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video) 1.25.4 Verify Agent Status - (Video) 1.25.5 Secure the Management Agent if necessary - (Video) 1.26 Create a Cluster Database - (Video) 1.27 Post-Installation Tasks - (Optional) - (Video) 1.27.1 Re-compile Invalid Objects - (Video) 1.27.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 1.27.3 Create Shared Oracle Password Files - (Video) 1.28 Verify TNS Networking Files - (Video) 1.29 Create / Alter Tablespaces - () 1.30 Verify the RAC Cluster & Database Configuration - (Video) 1.31 Configuring the Initialization Parameters - (Video) 1.32 Startup / Shutdown the Oracle RAC 10gR2 - (Video) 1.32.1 Stopping the Oracle RAC 10g Environment - (Video) 1.32.2 Start Monitor the alert.log - () 1.32.3 Start the Oracle RAC 10g - () 2. Building an Oracle RAC 10gR2 for RAC Standby 2.1 Install Linux OS(CentOS 5.3) - () 2.2 Install Required Linux Packages for Oracle RAC - (Video) 2.3 Network Configuration - (Video) 2.4 Create "oracle" User and Directories - (Video) 2.5 Configure the Linux Servers for Oracle - (Video) 2.6 Configure the "hangcheck-timer" Kernel Module - (Video) 2.7 Configure RAC Nodes for Remote Access using SSH - (Video) 2.8 Configure iSCSI Volumes using openfiler - (Video) 2.9 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 2.10 Install and configure Oracle Cluster File System(OCFS2) - (Video) 2.11 Install and Configure ASM (ASMLib2.0) - (Video) 2.12 Download Oracle RAC 10g Software - (Video) 2.13 Pre-Installation Tasks for Oracle 10g Release 2 - (Video) 2.14 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 2.15 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 2.16 Install and configure Automatic Storage Management (ASM) - (Video) 2.17 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 2.18 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 2.19 Install Oracle Database 10g Companion CD Software - (Video) 2.20 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 2.21 Create TNS Listener Process - (Video) 2.22 Create ASM Instance - (Video) 2.23 Install the EM agent on each cluster node - (Video) 2.23.1 Pre-Installation Requirements - (Video) 2.23.2 Download Oracle Management Agent (10.2.0.5) - (Video) 2.23.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video) 2.23.4 Verify Agent Status - () 2.23.5 Secure the Management Agent if necessary - () 2.24 Create a Cluster Database - (Video) 2.25 Post-Installation Tasks - (Optional) - (Video) 2.25.1 Re-compile Invalid Objects - (Video) 2.25.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 2.25.3 Create Shared Oracle Password Files - (Video) 2.26 Verify TNS Networking Files - (Video) 2.27 Create / Alter Tablespaces - () 2.28 Verify the RAC Cluster & Database Configuration - (Video) 2.29 Configuring the Initialization Parameters - (Video) 2.30 Startup / Shutdown the Oracle RAC 10gR2 - ()
Views: 142 Yongcheng Lai
Oracle DBA Tutorial- How to Flashback Data archive Process  Lecture-12 part-3 YouTube
 
13:41
#Oracle #DBA #ComputerScience #SQL create the flashback data archive specify the default flashback data archive enable the flashback data archive.
Views: 10 IT Support Desk
The Evolution of Flashback in Oracle Database | Lucas Jellema
 
02:40
Oracle ACE Director Lucas Jellema, domain and solution architect, Chief Technical officer of AMIS Services, and the author of the "Oracle SOA Suite 12c Handbook" (2015, Oracle Press), delivers 118 seconds of insight into the Flashback mechanism in Oracle Database.
Views: 639 ArchBeat Archive
01.23.02_Oracle_10gR2_RAC_1.23.2 Enabling Archive Logs and Flashback in a RAC_20120204.flv
 
05:17
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. ONLY $199 Please feel free to contact me: E-mail/Skype: [email protected] 1. Building an Oracle RAC 10g R2 (10.2.0.1) on Linux 1.1 Install Linux OS(CentOS 5.3) - () 1.2 Install Required Linux Packages for Oracle RAC - (Video) 1.3 Network Configuration - (Video) 1.4 Create "oracle" User and Directories - (Video) 1.5 Configure the Linux Servers for Oracle - (Video) 1.6 Configure the "hangcheck-timer" Kernel Module - (Video) 1.7 Configure RAC Nodes for Remote Access using SSH - (Video) 1.8 IP SAN Configuration - Openfiler - () 1.9 Install Openfiler - () 1.10 Configure iSCSI Volumes using openfiler - (Video) 1.11 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 1.12 Install and configure Oracle Cluster File System(OCFS2) - (Video) 1.13 Install and Configure ASM (ASMLib2.0) - (Video) 1.14 Download Oracle RAC 10g Software - (Video) 1.15 Pre-Installation Tasks for Oracle10g Release 2 - (Video) 1.16 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 1.17 Install and configure Automatic Storage Management (ASM) - (Video) 1.18 Install Oracle Database 10gR2 Software - (Video) 1.19 Install Oracle Database 10g Companion CD Software - (Video) 1.20 Create TNS Listener Process - (Video) 1.21 Create ASM Instance - (Video) 1.22 Create a Cluster Database - (Video) 1.23 Post-Installation Tasks - (Optional) - (Video) 1.23.1 Re-compile Invalid Objects - (Video) 1.23.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 1.23.3 Create Shared Oracle Password Files - (Video) 1.24 Verify TNS Networking Files - (Video) 1.25 Create / Alter Tablespaces - () 1.26 Verify the RAC Cluster & Database Configuration - (Video) 1.27 Verify Cluster Network Configuration - (Video) 2. RAC Database Administration and Workload Management 2.1 Starting / Stopping the Cluster - (Video) 2.2 Transparent Application Failover - (TAF) - () 2.3 Configuring the Server Parameter File(SPFILE) in RAC - (Video) 3. Upgrading Oracle CRS, ASM, RDBMS and Database 10.2.0.3 3.1 Download and Extract the Installation Software - (Video) 3.2 Pre-installation Tasks for Patch set and Release Upgrades - (Video) 3.3 Oracle Clusterware Rolling Upgrade - (Video) 3.4 Apply the patch 10.2.0.3.0 to the ASM Home - (Video) 3.5 Applying Patch set to Oracle RAC - (Video) 3.6 Upgrading Oracle Database 10.2.0.x to 10.2.0.3.0 Using DBUA - (Video)
Views: 170 Yongcheng Lai
How to enable Archive Log Mode in Oracle 11g
 
03:32
www.valeh.info
Views: 623 Valeh Agayev
04.02-01 Oracle_10gR2_DataGuard_4.2 Step 1 Enable Archivelog Mode and Flashback Database.avi
 
03:31
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: 218 Yongcheng Lai
Oracle Guaranteed restore points
 
39:29
Restore points and related data protection features enable us to rewind data back in time to correct any problems caused by logical data corruption or user errors within a designated time window. These features provide a more efficient alternative to point-in-time recovery and does not require a backup of the database to be restored first. The effects are similar to database point-in-time recovery (DBPITR). Restore points is not only effective in traditional database recovery situations but can also be useful during database upgrades, application deployments and testing scenarios when test databases must be quickly created and re-created. Restore points provide capabilities related to Flashback Database and other media recovery operations. In particular, a guaranteed restore point created at a system change number (SCN) ensures that you can use Flashback Database to rewind the database to this SCN. You can use restore points and Flashback Database independently or together
Views: 1258 Naveen Calappurackal
Oracle 12c Flashback Data Archiving: Building an Evolutionary Trail of Your Data
 
52:15
Learn how to take advantage of the new Oracle 12c data archiving features to manage historical data and provide a timeline of the data lifecycle. During this presentation, our Oracle expert will demonstrate how to use the in-database archiving capabilities to build a history of data changes. Presented by Arman Rawls, Senior Oracle Database Architect at Neovera.
Views: 1613 Neovera
Oracle DBA Tutorial || Online Training || Flashback techonogies by Shiva
 
35:48
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS ,ADF,INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo......
Oracle - "Flashback"
 
03:08
Download for FREE at http://vibedeck.com/oracle http://creterecordings.blogspot.com/ & http://www.mediafire.com/?0dxxxkf8xpazc
Views: 328 Oracle503