Search results “Expdp flashback time oracle”
Oracle Data Export and Import using DataPump expdp and impdp
Oracle Data Export and Import using DataPump expdp and impdp
Views: 183803 Abbasi Asif
Data Pump in Oracle | Oracle SQL Tutorial Videos | Mr.Vijay Kumar
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: 12044 Naresh i Technologies
How To Flashback a Table to particular SCN in Oracle
How To Flashback a Table to particular SCN in Oracle
Views: 5953 Abbasi Asif
How To Configure Oracle Database in Flashback Mode
How To Configure Oracle Database in Flashback Mode; Configure Flashback related parameters; Enable / Disable Flashback mode
Views: 12271 Abbasi Asif
6.ORACLE WORLD - How to perform Flashback Version Query in Oracle database
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: 2033 Oracle World
expdp impdp  (tablespace level)
oracle flashback technologies 640x480
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: 750 P T
5.ORACLE WORLD - How to perform Flashback Query at the specified point in time
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: 2117 Oracle World
Oracle Most easiest way to take backup of Schema of  Database DBMS
Oracle Most easiest way to take backup of Schema of Database DBMS
Views: 30 Musman Jamil
Creating  Managing  Droping Oracle Database Tablespaces
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: 21883 Abbasi Asif
ORACLE:  FLASHBACK DATABASE, hướng dẫn cấu hình và sử dụng.
Với FLASHBACK Database, việc phục hồi database chưa bao giờ dễ như thế. Một tính năng mà mội DBA điều phải biết.
Views: 3546 1Click2beDBA
Oracle DBA - Dataguard Realtime
Understand Redo/Archive shipping at Network and process level in Dataguard. Find us @ facebook : https://www.facebook.com/orsklacademy For training on Oracle DBA please visit - www.orskl.com
Views: 17874 OrSkl Academy
RMAN: How to perform a time-based incomplete recovery on Oracle 11gR2
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: 4532 mvige
flashback version query
Views: 207 MrQutaibah
Oracle 12C Datapump
Hello Everyone and thank you for watching. Email us with any questions or concerns at [email protected] and visit us online at www.uniktechnologies.net. Thank you and have a blessed day.
11.How to Export/Import from Higher version 11g  to 10g Lower version
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: 2325 Oracle World
7 Flashback in Oracle DBA
Flashback in Oracle DBA. How to rollback deleted records after commit.
Views: 3780 NewTechnology
Oracle 12c backup and recovery on pdbs and cdbs
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: 655 Vincent Ng
Oracle Tablespace PITR Recovery | TS-PITR Part - 1
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: 770 DBA Genesis
Flashback Version Query
This video gives an overview of the Flashback Version Query functionality in Oracle, which can be used to display how data in a row has changed over 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 Tanel poder : Website: https://gluent.com/ Blog: http://blog.tanelpoder.com/ Twitter : https://twitter.com/TanelPoder 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: 1037 ORACLE-BASE.com
Table Point In Time Recovery (PITR) in Oracle Database 12c
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: 3012 ORACLE-BASE.com
Oracle DBA- Realtime Activities
Get Oracle DBA online training on real time scenarios and issues. Take a step by step learning modules and become an expert Oracle DBA with our professional trainer.
Views: 173742 OrSkl Academy
7.Convert Dumpfile into SQLfile EXPDP & IMPDP
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: 2200 Oracle World
Oracle Flashback Operations Fundamentals 4
In this tutorial you will how to perform flashback operations on oracle databases
Views: 275 DBA Pro
Oracle 12c_Lesson 9: Managing Undo Data
Oracle Database 12c Administration Workshop
Views: 142 B N H
Oracle Database Administration-  UNDO MANAGEMENT
Oracle Database Administration- UNDO MANAGEMENT
Views: 86 SooCloudy
Oracle DBA Tutorial || Online Training || Flashback techonogies by Shiva
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......
How to Flashback in oracle 11g
Berikut ini merupakan tutorial flashback pada oracle
Views: 228 Pratiwi galuh putri
Oracle XE Cold Backup & Recovery
Demonstrating cold backup and recovery with Oracle XE in NOARCHIVELOG mode
Views: 5609 Stephen Frein
ORACLE WORLD - Recovery of Dropped Tablespace using  TSPITR without RMAN
Hello friends in this video I'm going to explain you how to recover the dropped tablespace using point in time recovery in oracle 11gR2 without rman backups #RecoveryofDroppedTablespace #rmanrecovery #TSPITRwithoutRMAN Oracle database Unbeatable,Unbreakable Platform..
Views: 9561 Oracle World
flashback in Oracle   2
Views: 69 rajani easo
Oracle XE Point-in-Time Recovery, Part 2
Demonstration of how to use point-in-time recovery mechanisms in Oracle XE.
Views: 785 Stephen Frein
Oracle Upgrade, oracle 10g and oralce 11g to oracle 12c
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 ====================================================================== 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 '' or '': --SQL SHOW PARAMETER COMPATIBLE SQL show parameter compatible NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ compatible string 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: 253 SNOOPPY TV
Oracle Database 10g: New Features for Administrators
This course introduces students to the new features in Oracle Database 10g - the database for Grid computing. Students learn how to use Oracle Database 10g new features to increase database availability, to simplify database performance monitoring and tuning through the use of Oracle Database 10g Advisors, and to offer simplified database manageability. The course also covers security and some development platform changes that students need to understand if applications running in databases support the related features. Hands-on practice sessions give students an opportunity to examine many of the new features for themselves. Course Objectives: Implement improved manageability features to simplify database management Utilize database advisors to provide proactive database monitoring Increase data availability through Oracle Database 10g features that offer improved point in time recovery Assist developers using Oracle Database 10g features in their applications ________________________________________ Course Topics: Introduction How DBAs Spend Their Time Oracle Database 10g Manageability Goals Oracle Database 10g Solution: Self-Managing Database Grid Computing Oracle Database 10g: The Database for the Grid Installation Installation Performance Enhancements Installation New Feature Support Automatic pre & post install validations CD pack contents Server Configuration Database Features Usage Tracking Automatic Enterprise Manager Configuration Simplified Initialization Parameters Simplified Database Install Load and Unload Data Cross-platform Transportable Tablespaces External Tables Unload DataPump Export and Import Utilities Automatic Management Automatic Checkpoint Tuning Automatic Database Diagnostic Monitor Automatic Shared Memory Tuning Automatic Optimizer Statistics Collection Automatic Undo Retention Manageability Infrastructure Advisory Framework Automatic Routine Administration Tasks Server-generated Alerts / Threshold-based Alerts Automatic Workload Repository Application Management and Availability SQL Access Advisor SQL Tuning Advisor New performance overview charts in EM Rule-based optimization (RBO) obsolescence SQL Support for Analytical Applications MERGE Command Enhancements Partitioned Outer Join Integrating Interrow Calculations in SQL Summary Management Enhancements System Resource Management Setting Idle Timeouts Switching Back to the Initial Consumer Group at End of Call Database Resource Manager - Adaptive Consumer Group Mapping Monitoring the Resource Manager The Scheduler Core Scheduler Features Privileges for Scheduler Components Calendaring Expressions Advanced Scheduler Concepts Space Management Segment Advisor New Segment Resource Estimation Online Segment Shrink Proactive Tablespace Management Undo Advisor Sorted Hash Clusters Improved VLDB Support Bigfile Tablespace Enhanced Partition Management in Enterprise Manager Global Partitioned Indexes - Hash Partitioning Local Partitioned Indexes Manageability Improvements Temporary tablespace groups RMAN Enhancements Flash Backup and Recovery Backup Compression Drop Database Automatic Channel Failover for Backup & Restore Incrementally Updated Backups Simplified Recovery Through Resetlogs Flashback Any Error Flashback Database Flashback Table Flashback Versions Query Flashback Transaction Query Flashback Drop General Storage Management Rename Tablespace Redo Logfile Sizing Advisor SYSAUX Tablespace Copying Files using the Database Server Automatic Storage Management Data mirroring with ASM ASM Dynamic Rebalancing ASM Striping ASM General Architecture ASM Disk Groups Failure Groups Maintain Software Oracle Database 10g Upgrade Paths Easy Upgrade (key DBUA features / one script upgrade) Upgrade Information Tools (pre/post) Security Enhancements VPD Static and Dynamic Policies Column-level VPD Uniform Audit Trail Miscellaneous New Features Transaction Monitoring End-to-End Tracing Logminer Enhancements Resumable Space Allocation Enhancements Regular Expression functions
Views: 10160 critiquemusicale
How to Create Oracle Duplicate Database with Recovery Manager RMAN Part 01
How to Create Oracle Duplicate Database with Recovery Manager RMAN Part 01
Views: 16277 Abbasi Asif
Demo Session on Oracle By Suman
• INTRODUCTION to ORACLE • Exploring the Oracle Database Architecture • Installing your Oracle Software • Creating an Oracle Database • Managing the Database Instance • Managing Database Storage Structures • Administering User Security • Managing Data Concurrency • Managing Undo Data • Configuring the Oracle Network Environment • Backup and Recovery Concepts • Use of RMAN Recovery Catalog & Configuring Backup Settings • Performing Database Backups with RMAN • Performing Database Recovery • Moving Data ( Expdp, Impdp, Sqlloader & External tables ) • Using Flashback Technology I • Using Flashback Technology II • Implementing Oracle Database Auditing • Database Maintenance ( ADR, AWR, ADDM... ) • Performance Management ( Memory, Instance ... ) • Managing Performance by SQL Tuning • Diagnosing the Database • Managing Space • Managing Space for the Database • Configuring & Managing ASM Instance • Duplicating a Database / Cloning Database • Data Guard Concepts & Administration • Database Patches & Database Upgrades • Introduction to Real Application Clusters ( RAC )
Views: 156 Linga Infotech
What is the difference between database refresh and database cloning
DBA Technologies. What is the difference between database refresh and cloning. http://oracledbatech.com
Flashback Query
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: 2042 ORACLE-BASE.com
Oracle DBA | Tasks Of  An Oracle Database Administrator (DBA) | dba1-02
Oracle DBA | Tasks Of An Oracle Database Administrator (DBA) | dba1-02 To See More DBA part-01 Tutorial Click here https://www.youtube.com/playlist?list=PLXXvCMuixAJUO3yQq7-LLdfQb5HpsQKNg To See More DBA part-02 Tutorial Click here https://www.youtube.com/playlist?list=PLXXvCMuixAJUviefN3-ZzKDVgbIH0RoaS To See More Reports Tutorial Click here https://www.youtube.com/watch?v=y_0f_iILlmY&list=PLXXvCMuixAJUfU4ZISmPtHrmKe5qRvyVY To See More Forms Tutorial Click here https://www.youtube.com/watch?v=Zsu4CWo_vwk&list=PLXXvCMuixAJU3Ap_FE2zSEBicv8IC5kDU Dear viewer, In this tutorial you will know about tasks of Database Administrator (DBA) Task 1: Evaluate the Database Server Hardware: Evaluate how Oracle Database and its applications can best use the available computer resources. This evaluation should reveal the following information:-How many disk drives are available to the Oracle products-How many, if any, dedicated tape drives are available to Oracle products-How much memory is available to the instances of Oracle Database you will run (see your system configuration documentation) Task 2: Install the Oracle Database Software: As the database administrator, you install the Oracle Database server software and any front-end tools and database applications that access the database. In some distributed processing installations, the database is controlled by a central computer (database server) and the database tools and applications are executed on remote computers (clients). In this case, you must also install the Oracle Net components necessary to connect the remote systems to the computer that executes Oracle Database. Task 3: Plan the Database: As the database administrator, you must plan: -The logical storage structure of the database -The overall database design -A backup strategy for the databaseConsider how the logical storage structure of the database will affect: -The performance of the computer running Oracle Database -The performance of the database during data access operations -The efficiency of backup and recovery procedures for the database Task 4: Creating, migrating, and opening the database: After you complete the database design, you can create the database and open it for normal use. You can create a database at installation time, using the Database Configuration Assistant (DBCA), or you can supply your own scripts for creating a database. Task 5: Backup the Database : After you create the database structure, perform the backup strategy you planned for the database. Create any additional redo log files, take the first full database backup (online or offline), and schedule future database backups at regular intervals. Backup Strategy May Include: - Entire database (whole) - Portion of the database (partial) Whole database backup: Includes all data files and at least one control file (Remember that all control files in a database are identical.) Partial database backup: May include zero or more tablespaces and zero or more data files; may or may not include a control file. Backup Types (RMAN) - All data blocks within your chosen files (full) - Incremental - Cumulative - Differential Backup Mode May Be: - Offline (consistent, cold) - Online (inconsistent, hot) Offline backups (also known as “cold” or consistent backup): Are taken while the database is not open. They are consistent because, at the time of the backup, the system change number (SCN) in data file headers matches the SCN in the control files. Online backups (also known as “hot” or inconsistent backup): Are taken while the database is open. They are inconsistent because, with the database open, there is no guarantee that the data files are synchronized with the control files. Task 6: Enroll System Users Task 7: Implement the Database Design Task 8: Recovering from database failure Task 9: Monitoring Database Performance Task 10: Download and Install Patches Task 11: Roll Out to Additional Hosts To Get more Tutorial Subscribe The Channel click here https://www.youtube.com/channel/UCQ3ea4zVCfnKBx1_7h8raGQ?sub_confirmation=1 To Get All Post Like The Facebook Page Click here https://www.facebook.com/oracledbsolutions Follow us: Facebook: https://www.facebook.com/oracledbsolutions Youtube link: https://www.youtube.com/channel/UCQ3ea4zVCfnKBx1_7h8raGQ?view_as=subscriber Facebook Group: https://www.facebook.com/groups/465557066961548 Contact us: email: [email protected] Skype: oracle26solutions Mob: 01734557080, 01627422780
Views: 189 OracleDB Solutions
How to change Archive Destination in Oracle
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]
Oracle DB 12c - Backup in CDB & PDB
Oracle DB 12c - Backup in CDB & PDB Watch more videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjabi, Tutorials Point India Private Limited
How to Use RMAN Backup Command to perform Full and Incremental Backups of database
How to Use RMAN Backup Command to perform Full and Incremental Backups of database
Views: 23972 Abbasi Asif
Rename Tablespace ( Tablespace Management #3 )/* Step By Step /*
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: 145 Parag Mahalle
Oracle Tablespace Management
Oracle Tablespace Management , Creating tablespaces
Views: 29 lalitha tpt
How To Configure and Use RMAN with Recovery Catalog and Target Database Part 01
How To Configure and Use RMAN with Recovery Catalog and Target Database
Views: 11881 Abbasi Asif