Home
Search results “Expdp flashback time oracle”
Oracle Data Export and Import using DataPump expdp and impdp
 
09:38
Oracle Data Export and Import using DataPump expdp and impdp
Views: 189592 Abbasi Asif
How To Flashback a Table to particular SCN in Oracle
 
08:38
How To Flashback a Table to particular SCN in Oracle
Views: 6136 Abbasi Asif
Oracle Tutroial - Point in time recovery restore sql flashback part -2
 
08:18
In this video i'm going to show you how to use traditional point in time recovery in oracle step by step.
Views: 1095 OCP Technology
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: 2092 Oracle World
How to change Archive Destination in Oracle
 
05:40
How to change Archive Destination in Oracle ======================================== Syantax ============= alter system set log_archive_dest_1='LOCATION=/home/Archive/' scope=both; =============================================== 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: 1321 ANKUSH THAVALI
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: 12671 Abbasi Asif
Oracle XE Point-in-Time Recovery, Part 1
 
14:43
Demonstration of how to use point-in-time recovery mechanisms in Oracle XE.
Views: 1537 Stephen Frein
RMAN: How to perform a time-based incomplete recovery on Oracle 11gR2
 
13:13
RMAN: How to perform a time-based incomplete recovery on Oracle 11gR2 A complete description could be found here: http://dbaworkshop.blogspot.it/2013/04/how-to-perform-a-time-based-incomplete-recovery.html
Views: 4571 mvige
Data Pump in Oracle | Oracle SQL Tutorial Videos | Mr.Vijay Kumar
 
14:39
Data Pump in Oracle | Oracle SQL Tutorial Videos | Mr.Vijay Kumar ** For Online Training Registration: https://goo.gl/r6kJbB ► Call: +91-8179191999 💡 Visit Our Website for Classroom Training: https://nareshit.in/oracle-training/ 💡 For Online Training: https://nareshit.com/oracle-online-training/ #Oracle #Training #CourseVideos -------------------------- 💡 About NareshIT: "Naresh IT is having 14+ years of experience in software training industry and the best Software Training Institute for online training, classroom training, weekend training, corporate training of Hadoop, Salesforce, AWS, DevOps, Spark, Data Science, Python, Tableau, RPA , Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in USA, Hyderabad, Chennai and Vijayawada, Bangalore India which provides online training across all the locations -------------------------- 💡 Our Online Training Features: 🎈 Training with Real-Time Experts 🎈 Industry Specific Scenario’s 🎈 Flexible Timings 🎈 Soft Copy of Material 🎈 Share Videos of each and every session. -------------------------- 💡 Please write back to us at 📧 [email protected]/ 📧 [email protected] or Call us at the USA: ☎+1404-232-9879 or India: ☎ +918179191999 -------------------------- 💡 Check The Below Links ► For Course Reg: https://goo.gl/r6kJbB ► Subscribe to Our Channel: https://goo.gl/q9ozyG ► Circle us on G+: https://plus.google.com/+NareshIT ► Like us on Facebook: https://www.facebook.com/NareshIT ► Follow us on Twitter: https://twitter.com/nareshitek ► Follow us on Linkedin: https://goo.gl/CRBZ5F ► Follow us on Instagram: https://goo.gl/3UXYK3
Views: 14097 Naresh i Technologies
Oracle Flashback Operations Fundamentals 4
 
53:58
In this tutorial you will how to perform flashback operations on oracle databases
Views: 276 DBA Pro
oracle flashback technologies 640x480
 
17:38
Sometimes it is a rouge query, sometimes a simple data clean up effort by the users, whatever may the cause be, inadvertent data-loss is a very common phenomenon. Backup and recovery capabilities are provided by the database management systems which ensure the safety and protection of valuable enterprise data in case of data loss however, not all data-loss situations call for a complete and tedious recovery exercise from the backup. Oracle introduced flashback features in Oracle 9i and 10g to address simple data recovery needs. Flashback query allows a user to view the data quickly and easily the way it was at a particular time in the past, even when it is modified and committed, be it a single row or the whole table. This article is an introduction to the flashback feature of Oracle and discusses how to use this feature in Oracle 9i and 10g. Its main focus is the usage of flashback queries, not the mechanism that governs it. Please i request please view and subscribe my channel https://www.youtube.com/channel/UCmNRfTChoXgYtdVcVH7c3Dg?view_as=subscriber Please go below link and purchase best item ----- https://amzn.to/2RUGibY Canon EOS 1300D 18MP Digital SLR Camera ----https://amzn.to/2SSLE4N Maxx 4K Ultra HD 16 MP WiFi Waterproof Action Camera ---https://amzn.to/2RvsUvG Mic --- https://amzn.to/2QUEYkS, https://amzn.to/2QS3sLu Mobile --- https://amzn.to/2RuKdN7 https://amzn.to/2RPV9nX https://amzn.to/2T2ndlG laptop ---------- https://amzn.to/2ROLfmG Tripod--------------- https://amzn.to/2RukqoD Memory card-------- https://amzn.to/2RT3FCS https://amzn.to/2SSsNa8 men shoes ---- https://amzn.to/2RPY93D For more items------ https://amzn.to/2RyImHp https://amzn.to/2QUVcdX https://amzn.to/2ROLfmG https://amzn.to/2TRKt5C
Views: 753 P T
How to Flashback in oracle 11g
 
12:18
Berikut ini merupakan tutorial flashback pada oracle
Views: 240 Pratiwi galuh putri
How to perform Incremental Backup using Block change tracking  /* step by step /*
 
08:38
How to perform incremental backup using Block change tracking in Rman Block Change Tracking : ----------------------------------------------- You can perform fast incremental backup by enabling block change tracking. when perform incremental backup, It writes to a file the physical address of each block that is changed. Rman can look the block change tracking file & backup only those blocks refer there. It does not have to scan every block to see if it has changed since the last backup. How to Enable block change tracking? ----------------------------------------------------------------------- Alter database enable block change tracking using file (file path) reuse; 1. We can check Block change tracking is enable or not using v$block_change_tracking View. 2. When block change tracking is enable CTWR process is started.
Views: 508 Parag Mahalle
7 Flashback in Oracle DBA
 
30:39
Flashback in Oracle DBA. How to rollback deleted records after commit.
Views: 3824 NewTechnology
5.ORACLE WORLD - How to perform Flashback Query at the specified point in time
 
07:44
Hi welcome in my oracle world in this video im explaining about flashback query at the specified point in time in Oracle database Unbeatable,Unbreakable Platform.. #performFlashback #Oracledatabase #FlashbackQuery By lalit saini
Views: 2149 Oracle World
Oracle XE Point-in-Time Recovery, Part 2
 
11:55
Demonstration of how to use point-in-time recovery mechanisms in Oracle XE.
Views: 788 Stephen Frein
flashback in Oracle   2
 
09:31
Views: 69 rajani easo
How to split dumpfiles into multiple files and multiple directories. /* step By Step */
 
10:44
When you Export full database and your database size is big ( like 20gb – 30gb ). So, How to break dumpfile in two or more pieces. And Your Export backup are store in these Hard disk (directory) and these HDD has less space (5gb) and your backup size is (10gb). That time we can export these backup in 2 HDD (directories). First backup piece is store in default directory and next backup piece is store in another HDD (directory).
Views: 867 Parag Mahalle
Oracle Tablespace PITR Recovery | TS-PITR Part - 1
 
09:29
https://dbagenesis.com/p/oracle-advanced-rman-backup-recovery Recovery Manager (RMAN) automatic TSPITR enables you to quickly recover one or more tablespaces in a database to an earlier time without affecting the rest of the tablespaces and objects in the database. RMAN TSPITR is most useful for the following situations: 1. You want to recover a logical database to a point different from the rest of the physical database, when multiple logical databases exist in separate tablespaces of one physical database. For example, you maintain logical databases in the orders and personnel tablespaces. An incorrect batch job or DML statement corrupts the data in only one of the tablespaces. 2. You want to recover data lost after DDL operations that change the structure of tables. You cannot use Flashback Table to rewind a table to before the point of a structural change such as a truncate table operation. 3. You want to recover a table after it has been dropped with the PURGE option. 4. You want to recover from the logical corruption of a table. You can also use Flashback Database to rewind data, but you must rewind the entire database rather than just a subset. Also, unlike TSPITR, the Flashback Database feature necessitates the overhead of maintaining flashback logs. The point in time to which you can flash back the database is more limited than the TSPITR window, which extends back to your earliest recoverable backup.
Views: 948 DBA Genesis
Flashback Query
 
01:58
This video gives an overview of the Flashback Query functionality in Oracle, which can be used to display data how it was at a previous point in time. For more information see: https://oracle-base.com/articles/10g/flashback-10g Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by Dina Blaschczok : Twitter : https://twitter.com/DinaBlaschczok 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: 2151 ORACLE-BASE.com
7.Convert Dumpfile into SQLfile EXPDP & IMPDP
 
19:47
Hi friends today its very important topic in oracle how to convert .DMP file into .SQL format and modified it and used that file. #DumpfileintoSQLfile #EXPDP&IMPDP Oracle database Unbeatable,Unbreakable Platform..
Views: 2378 Oracle World
expdp impdp  (tablespace level)
 
12:33
THIS VIDEO WILL GIVE YOU A BASIC IDEA OF HOW TO PERFORM A EXPDP/IMPDP (export/import using datapump) IN ORACLE 10G DATABASE PLEASE DO GIVE YOUR VALUABLE FEEDBACKS.
Views: 10967 AKHTAR HUSSAIN SHAIKH
RMAN Consistent and Inconsistent Backups
 
08:05
RMAN Consistent and Inconsistent Backups
Views: 697 Hemant K Chitale
11.How to Export/Import from Higher version 11g  to 10g Lower version
 
16:20
Hi friends today i will explain briefly How to Export/Import from Higher version to Lower version in oracle database. #Export/Import #version Oracle database Unbeatable,Unbreakable Platform..
Views: 2463 Oracle World
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: 3291 ORACLE-BASE.com
Oracle Upgrade, oracle 10g and oralce 11g to oracle 12c
 
08:28
SAP On Oracle Database Upgrade, From Oracle 10g to 12c Direct upgrade, ================================================= TAKE BACKUP OF EXISITNG DB brbackup -u / -p initGWP-disk-OFF.sap -d disk -t offline -m all -o time INSTALL ORACLE 12 DATA BASE - CHANGE THE HOME DIRECTORY PATH IN ENVIRONEMNT - Not to ADD FULL PERMISSION IN TO ORALCE INSTALLATION USER - TAKE A COPY OF OLD ORACLE & AND NEW ORACLE HOME BEFORE APPLYING PATCHES - TAKE COPY OF NETWORK\ADMIN AND DATABASE FOLDER - DOWNLOADED LATEST OPATCH AND REPLACE OPATCH FOLDER - APPYL NEEDED PATCHES USING OPATCHS - STOP ALL SERVICES ORACLE RELATED FOR APPLYINT PATCHES **PATCHBUNDLE12102P_1702-20012303.zip **PATCHBUNDLE12102P_1704-20012303.zip **P9584028GEN12102P_2-20012303.zip 'EG: B:\Patches\P9584028GEN12102P_2-20012303\9584028 C:\oracle\GWP\12102\OPatch\OPATCH APPLY' 'EG: B:\Patches\PATCHBUNDLE12102P_1702-20012303\25433286 E:\oracle\GWQ\12102\OPatch\OPATCH APPLY' "EG: B:\Patches\PATCHBUNDLE12102P_1704-20012303\25632533 E:\oracle\GWQ\12102\OPatch\OPATCH APPLY" -START SERVICES AFTER APPLYING PATCHES FOR UPGRADE. RUN THE PRE UPGRADE SCRIPT AS FOLLOWS.. PRE UPGRADE SCRIPT WILL PROVIDE YOU WHEN YOU UPDATE PATCHES ================================ OS sqlplus / as sysdba SQL @pre_upgrade_tasks.sql SQL @pre_upgrade_checks_ora.sql SQL @pre_upgrade_checks_sap.sql THEN CREATE RESTORE POINT FOR RECOVERY IF ANY FAILIUR HAPPEND */ ============================================================= /*(ALTER SYSTEM SET db_recovery_file_dest_size='10G G:\oracle\GWP\oraflash' scope=both; ALTER SYSTEM SET db_recovery_file_dest= 'E:\oracle\GWQ\oraflash scope=both';)*/ ------------------------------------------- SQL @grp_create_restore_point.sql SQL @grp_list_restore_point.sql ===TAKE BACKUP OF NETWORK/ADMIN & ORAHOME\DATABASE RUN DUBA from new home (oralce 12c) KEEP DATABSE OPEN FOR UPGRADE. ===================== CREATE RMAN BACKUP DURING THE UPGRADE \Post upgrade steps 1915315 - Database Upgrade Scripts for 12.1.0.2 ====================================================================== After DUB create Listner or check the listner status LSNRCTL/ Go to directory 'post_upgrade' to run the post-upgrade scripts. --SQL @?/rdbms/admin/utlu121s.sql --SQL @?/rdbms/admin/utluiobj.sql --SQL @post_upgrade_tasks.sql Recompile invalid objects --SQL @?/rdbms/admin/utlrp.sql Run post-upgrade checks --SQL @post_upgrade_checks.sql Check whether guaranteed restore point 'GRP_BEFORE_UPGRADE_12102' exists: OS cd NEW_ORACLE_HOME /sap/ora_upgrade/pre_upgrade OS sqlplus / as sysdba --SQL @grp_list_restore_point.sql you need to drop this restore point and set 'COMPATIBLE' to the new value. OS cd NEW_ORACLE_HOME /sap/ora_upgrade/pre_upgrade OS sqlplus / as sysdba --SQL @grp_drop_restore_point.sql OS cd NEW_ORACLE_HOME /sap/ora_upgrade/post_upgrade OS sqlplus / as sysdba --SQL @set_compatible.sql After setting compatible to a new value, 'RESTART THE DATABASE.' Ensure that parameter 'compatible' is set to '12.1.0.2.0' or '12.1.0.2': --SQL SHOW PARAMETER COMPATIBLE SQL show parameter compatible NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ compatible string 12.1.0.2.0 noncdb_compatible boolean FALSE --SQL SELECT VALUE "COMPATIBLE" FROM V$PARAMETER WHERE NAME = 'COMPATIBLE'; Before you start the remaining database post-upgrade tasks you can create a new guaranteed restore point ====================================================== --SQL CREATE RESTORE POINT "'GRP_AFTER_UPGRADE_12102'" GUARANTEE FLASHBACK DATABASE ; --SQL SELECT NAME FROM V$RESTORE_POINT WHERE GUARANTEE_FLASHBACK_DATABASE = 'YES'; drop V$RESTORE_POINT WHERE GUARANTEE_FLASHBACK_DATABASE = 'YES'; Check for invalid objects: =========================== --SQL select owner, object_name, object_type from dba_objects where status = 'INVALID'; If the object 'DBMS_METADATA' (package body) is still invalid (Ref: patch 17871192), run utlrp to recompile the package. ====================================================== --SQL @?\rdbms\admin\utlrp.sql --SQL select owner, object_name, object_type from dba_objects where status = 'INVALID'; COPY data from OLDorahome\database\ to new database\ FOLLOWING FILES INIT SID .SAP INIT SID .UTL update the kernel CHEK THE TNS FILE NAME IN NETWORK\ADMIN brconnect -u / -c -f stats -t system_stats brconnect -u / -c -f stats -t oradict_stats brconnect -u / -c -f stats -t all -f collect -p 4 deinstall the 11g /*if needed */{}{}{}{}{}{}{}{}{}{}{}{}{}{}{} ================= sqlplus / as sysdba @sapuprof_profile Insufficent privillege 134592 - Import of SAPDBA role (sapdba_role.sql) ========================== sqlplus /nolog @sapdba_role SAPSR3 --CHANGE PARAMTER ONCE UPGRADE COMPLETE. Visit My Blog:http://wrongcodes.blogspot.com/
Views: 352 SNOOPPY TV
Creating  Managing  Droping Oracle Database Tablespaces
 
12:10
Creating Managing Droping Oracle Database Tablespaces select tablespace_name,block_size,status,contents,logging from dba_tablespaces; create tablespace mytbs datafile 'd:\oradata\dbrdbms\mytbs01.dbf' size 10m; alter tablespace mytbs add datafile 'd:\oradata\dbrdbms\mytbs02.dbf' size 10m; alter tablespace mytbs drop datafile 'd:\oradata\dbrdbms\mytbs02.dbf'; desc v$datafile; desc ts#,name from v$datafile; select ts#,name from v$tablespace; select v$datafile.ts#,v$datafile.name,v$tablespace.name from v$datafile,v$tablespace where v$datafile.ts#=v$tablespace.ts# and v$tablespace.name='MYTBS'; alter database datafile 'd:\oradata\dbrdbms\mytbs01.dbf' resize 20m; ALTER DATABASE DEFAULT TABLESPACE mytbs; select ts#,name from v$tablespace; select ts#,name from v$datafile; select ts#,name from v$tablespace; drop tablespace mytbs; drop tablespace mytbs ialtncluding contents and datafiles; drop tablespace mytbs including contents and datafiles cascade; alter tablespace mytbs read only; alter tablespace mytbs read write; alter tablespace mytbs force logging; alter tablespace mytbs nologging; alter tablespace mytbs flashback on; alter tablespace mytbs flashback off; purge tablespace mytbs user myuser;
Views: 22686 Abbasi Asif
Moving Data - Oracle 11g
 
05:17
Moving Data - Using DataPump Import Export Utilities. Music : Hakaru Nara - Goose House
Views: 144 Adi P
Transportation of Tablespace from Linux to Windows platform
 
37:21
Hi friends today I'll show you how to plug(transport a tablespace from Linux to windows platform) Amazing tutorial by lalit saini , #TransportationofTablespace #LinuxtoWindowsplatform Oracle database Unbeatable,Unbreakable Platform..
Views: 1265 Oracle World
Oracle Most easiest way to take backup of Schema of  Database DBMS
 
08:22
Oracle Most easiest way to take backup of Schema of Database DBMS
Views: 32 Musman Jamil
Oracle 12c backup and recovery on pdbs and cdbs
 
06:15
This video demonstrate backup and recovery on Oracle 12c. 1) Backup whole database including cdb and pdbs 2) Bakcup of root databases 3) Backup of pluggable databases 4) Recovery database
Views: 700 Vincent Ng
Database 12c Backing up the Control File
 
03:00
Oracle DB 12c Backing up the Control File
Views: 96 Ora Tube
Oracle 11gR2 RAC DEMO
 
16:43
Demonstration on Oracle 11gR2 RAC training.
Views: 2230 OrSkl Academy
move table from one tablespace to other
 
08:24
move table from one tablespace to other
Views: 1201 Jamaal Khan
Recover Block Corruption with Rman.
 
10:38
Hello friends In this video I am showing you how to Recover Block Corruption with Rman. Friends Suppose in any resion any block of datafile is corrupted, so we can repair it using Rman. Please watch this video
Views: 513 Parag Mahalle
[en] SQL Developer: Recover table from DROP accident.
 
03:01
Flashback table to before DROP/ recover table via Oracle SQL Developer. Tiếng Việt: https://youtu.be/19ffd9zXSWQ
Views: 64 1Click2beDBA
Rename Tablespace ( Tablespace Management #3 )/* Step By Step /*
 
06:23
Hello Friends In this video I am showing you 1. How to check Tablespace, Datafile size and Datafile Location. 2. How to Rename Tablespace. 3. How to Offline Tablespace. 4. How to Online Tablespace. 5. How to Rename Datafile. 6. How to Check Tablespace. (How many tablespace Do you Have). 7. How to check Tablespace Status. It is Offline or online. 8. How to Rename Old Datafile name to New Datafile Name in controlfile.
Views: 158 Parag Mahalle
Creation & Configuration of PDB in Oracle Database 12c
 
22:16
Learn how to create and configure PDB using SQL Plus in Oracle Database 12c. For More Videos and Blogs:- Visit Our Website - www.dbatrainer.com Also , Subscribe and Follow us on our social media pages:- LinkedIn - https://www.linkedin.com/company/dbatrainer FaceBook - https://www.facebook.com/dbatrainer Google Plus - https://plus.google.com/+DBATrainer Twitter - https://www.twitter.com/DBA_Trainer "Exceptional Education. Exceptional Value."
Views: 167 DBA Trainer
How to Use RMAN Backup Command to perform Full and Incremental Backups of database
 
12:07
How to Use RMAN Backup Command to perform Full and Incremental Backups of database
Views: 24677 Abbasi Asif
Oracle 12c_Lesson 9: Managing Undo Data
 
01:11:58
Oracle Database 12c Administration Workshop
Views: 153 B N H
Oracle DB 12c - Root SYSTEM or UNDO Data File Recovery
 
07:47
Oracle DB 12c - Root SYSTEM or UNDO Data File Recovery Watch more videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjabi, Tutorials Point India Private Limited
TEMP In oracle
 
10:22
Views: 551 Sainora Annanagar
How to Create Oracle Duplicate Database with Recovery Manager RMAN Part 01
 
12:54
How to Create Oracle Duplicate Database with Recovery Manager RMAN Part 01
Views: 16483 Abbasi Asif