Home
Search results “Delete archivelog all oracle”
Oracle Database11g tutorials 9 || What is archive log mode and how to enable archive log mode
 
07:23
weblink: www.rebellionrider.com What is archive log mode What is noarchive log mode How to enable archivelog mode in oracle 11g How to enable archivelog mode in oracle 10g This SQL tutorial and Oracle database 11g tutorial for beginners will show what are ARCHIVELOG mode and noarchive log mode and how to enable archivelog mode in oracle database 11g or 10g Tool used in this tutorial is command prompt. This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos This is Manish from The Code makers
Views: 101613 Manish Sharma
onlinetraining|| RMAN Crosscheck|Obsoleted backup|Expired backup Part - 1 by Shiva
 
32:42
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 DELETE BACKUP IN ORACLE?
 
03:18
HOW TO DELETE BACKUP? FOR EXTRA CLASSES IN DELHI MAIL ME ON [email protected]
Views: 151 ORACLEMATES
RECOVER LOST  DataFile in oracle database
 
15:33
Please donate on below link if you think I am helping you with your career. https://www.paypal.me/ankushthavali OR Google Pay : 9960262955 OR Account No : 31347845762 IFSC: SBIN0012311 DATAFILE file Lost ================================ Archive log mode-Enabled create tablespace test_ts datafile '/u01/app/oracle/oradata/testdb/ts_test02.dbf' size 10M; create table testtable (id number(5))tablespace test_ts; insert into testtable (id) select * from testtable; SQL>select count(*) from testtable; COUNT(*) ---------- - before deleting datafile 524288 SQL>select count(*) from testtable; COUNT(*) ---------- - After recovery 524288 select tablespace_name, segment_name from dba_segments where segment_name = 'TESTTABLE'; alter system flush buffer_cache; alter database create datafile '/u01/app/oracle/oradata/testdb/ts_test02.dbf' as '/u01/app/oracle/oradata/testdb/ts_test02.dbf' alter database datafile '/u01/app/oracle/oradata/testdb/ts_test02.dbf' offline drop; alter database create datafile '/u01/app/oracle/oradata/testdb/ts_test02.dbf' as '/u01/app/oracle/oradata/testdb/ts_test02.dbf' recover datafile '/u01/app/oracle/oradata/testdb/ts_test02.dbf'; alter database datafile '/u01/app/oracle/oradata/testdb/ts_test02.dbf' online; select count(*) from TESTTABLE; =================================================== Please like,subscribe my channel. Kindly contact for online training on below contacts. Emai: [email protected] Mob No: +91 9960262955 ====================================================== Hi Folks, Greetings!! I am professional part time oracle dba trainer and having good experience in oracle database administration. This is the right place to enroll yourself for Oracle DBA real time course. Please use following email ID for more details. Don’t hesitate to WhatsApp me any time. I will give you the best training and will create path to get DBA job easily. Enjoy the free YouTube video and connect with me for deep Oracle DBA knowledge. Mobile No : + 91 9960262955 (WhatsApp Number) EmailID: [email protected] how to recover lost datafile in oracle how to recover a datafile in oracle without backup how to recover a deleted datafile in oracle 11g how to recover datafile in oracle rman restore datafile oracle missing datafile after clone how to recover system datafile in oracle without backup oracle datafile deleted accidentally
Views: 2447 ANKUSH THAVALI
Backup Full - Oracle
 
27:16
Esse vídeo tem com objetivo mostrar como fazer um backup full do banco de dados oracle usando o Oracle Recovery Manager-RMAN. run{ allocate channel c1 device type disk; allocate channel c2 device type disk; allocate channel c3 device type disk; sql 'alter system switch logfile'; sql 'alter system switch logfile'; sql 'alter system switch logfile'; sql 'alter system checkpoint'; backup as compressed backupset full database tag 'Full_Banco' format '/home/oracle/backup/Full_banco-%T-%I-%d-%s.bkp'; backup current controlfile tag 'CTF_FULL' format '/home/oracle/backup/CTF_FULL-%T-%I-%d-%s.bkp'; backup as compressed backupset spfile tag 'SPF_FULL' format '/home/oracle/backup/SPF_FULL-%T-%I-%d-%s.bkp'; backup as compressed backupset archivelog all delete all input tag 'ARCH_FULL' format '/home/oracle/backup/ARCH_FULL-%T-%I-%d-%s.bkp'; }
Views: 1622 Target Database
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: 3395 ORACLE-BASE.com
Oracle DB - Alert Log, Trace Files & ADR
 
02:21
Oracle DB - Alert Log, Trace Files & ADR Watch More Videos at: https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjabi, Tutorials Point India Private Limited
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: 4468 OCP Technology
Redo Logfile Cancel Based Recovery using Archive bkp
 
07:38
Hi friends watch this video and learn about recovery of redo log file without any backup just simple DB must be in Archive log mode #RedoLogfile #CancelBasedRecovery #Archivebackup if all redo member or any member is deleted permanently Oracle database Unbeatable,Unbreakable Platform..
Views: 2273 Oracle World
Oracle Database Hang Manager
 
49:19
In our September 2018 session, Mark Scardina welcomes Walter Battistella who was responsible for developing the Oracle Hang Management feature that provides autonomous detection and resolution of hangs and deadlocks in Oracle databases. Questions ranged across the full gambit of design, functionality and best its availability in Oracle Database Cloud Services. 02:30 What is Oracle’s goal in developing Hang Manager? 03:45 What actually is a session hang? 05:35 What causes a process or session to be hung? 07:21 Are deadlocks the same as hung sessions or do they differ? 09:40 Do I need to enable hang manager and if so how? 10:17 Which versions and deployment types have Hang Manager enabled? 12:30 How does Hang Manager resolve hangs? 15:20 What is the overhead of Hang Manager monitoring these sessions? 18:00 Is Hang Manager in the transaction path? 18:22 How do I know Hang Manager has detected and resolved a hang or deadlock? 21:22 How can I get notifications when a hang or deadlock is resolved? 23:15 Are these notifications available in Enterprise Manager? 24:00 Does Hang Manager resolve all hangs and deadlocks? 28:51 I thought Oracle Database already resolved deadlocks prior to 18.1. What is different that Hang Manager does? 31:30 If I have a critical application , can I speed up the resolution time? 34:54 I understand that QoS Management lets be set the criticality of workloads. Does Hang Manager use that information? 37:47 Does Hang Manager monitor PQ sessions as well? If so how does its resolution impact the main session? 39:15 Does Hang Manager detect and resolve hangs in ASM? 44:56 Is Hang Manager running on the Oracle Autonomous DB? 45:22 Does it run in the Oracle Database Cloud Service? AskTOM Office Hours offers free, monthly training and tips on how to make the most of Oracle Database, from Oracle product managers, developers and evangelists. https://asktom.oracle.com/ Oracle Developers portal: https://developer.oracle.com/ Sign up for an Oracle Cloud trial: https://cloud.oracle.com/en_US/tryit Music by bensound.com
Views: 180 Oracle Developers
Purging old data from the database used by vCenter Server
 
04:08
https://kb.vmware.com/kb/1025914 This video demonstrates how to Purge old data from the SQL Server database used by vCenter Server When the vCenter Server database if full: - You cannot log in to vCenter Server - VMware VirtualCenter Server service may start and stop immediately. To resolve this issue, we need to manually purge or truncate the vCenter Server database. The script to truncate the database is available at the Resolution of the KB Article 1025914 in the "Truncate the event and tasks table" section. For additional information, see VMware Knowledge Base article 1025914 at the following URL https://kb.vmware.com/kb/1025914
Views: 24132 VMwareKB
SQL tutorial 46: What are System Privileges & How To Grant them using Data Control Language
 
06:26
In this SQL Tutorial you will learn How To Grant System Privilege using Grant Data Control Language (DCL) along with ADMIN OPTION flag. First SQL Tutorial in the series of user privileges in oracle database ------------------------------------------------------------------------ ►►►Timeline◄◄◄ 1:50- Query 1- How To grant Basic System Privilege (i.e.Create Table system privilege) to a user 2:40- Query 2 - How to Grant Multiple System Privilege To a user in Single Grant (Data Control Language) Statement 3:52- Query 3 - How To grant System Privilege To Multiple Users in Single Grant (Data Control Language) Statement 4:50- Query 4- How To Grant System Privilege WITH ADMIN OPTION flag 5:26- WITH ADMIN OPTION demonstration ------------------------------------------------------------------------ Celebrating 1000 subscribers. Thanks a lot guys for all your love and support. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog (Link for SQL Script is at the end of this article) : http://bit.ly/system_privilege_admin_option Link for How To create user ●SQL Tutorial 37 - Using Create User Statement http://youtu.be/4QbK2Y-1LZw ●SQL Tutorial 38- Using SQL Developer http://youtu.be/GS4udgR44Ls ●SQL Tutorial 39- Using Oracle Enterprise Manager http://youtu.be/zGjh-Bb3HrI List of few System Privileges Available in Oracle Database http://wp.me/p3r6sw-7M Previous Tutorial: Introduction To User Privileges http://youtu.be/iQFb86lM1gs ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the first one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at [email protected] Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 26531 Manish Sharma
2.ORACLE WORLD - Recovery of Drop Table with purge condition using Current SCN Number in Flashback
 
06:35
Hello friends in this video we learn about that how to recover a permanent dropped table using current SCN number in Oracle database using Flashback Technology ... #RecoveryofDropTable #performingflashback By Lalit saini
Views: 2706 Oracle World
Catalog rman Parte 2
 
15:13
Conectar no Catálogo do rman [[email protected] ~]$ rman target / catalog rcat/[email protected] Listar os scripts LIST ALL SCRIPT NAMES; Criando um script local: CREATE script COMANDO_SQL{sql 'alter system switch logfile'; } Criando um script global: CREATE global script BACKUP_DO_BANCO{ allocate channel c1 device type disk; allocate channel c2 device type disk; allocate channel c3 device type disk; sql 'alter system switch logfile'; sql 'alter system switch logfile'; sql 'alter system switch logfile'; sql 'alter system checkpoint'; backup as compressed backupset full database tag 'Full_Banco' format '/home/oracle/backup/Full_banco-%T-%I-%d-%s.bkp'; backup current controlfile tag 'CTF_FULL' format '/home/oracle/backup/CTF_FULL-%T-%I-%d-%s.bkp'; backup as compressed backupset spfile tag 'SPF_FULL' format '/home/oracle/backup/SPF_FULL-%T-%I-%d-%s.bkp'; backup as compressed backupset archivelog all delete all input tag 'ARCH_FULL' format '/home/oracle/backup/ARCH_FULL-%T-%I-%d-%s.bkp'; } Executando o script criado com a sintaxe run {execute script BACKUP_DO_BANCO;} Visualizar um script no Catalog Rman: print script BACKUP_DO_BANCO; Deletar script do Catálogo delete script BACKUP_DO_BANCO; delete script COMANDO_SQL; Executando os script do Catálogo rman target / catalog rcat/[email protected] script 'BACKUP_DO_BANCO' rman target / catalog rcat/[email protected] script 'BACKUP_DO_BANCO' msglog /home/oracle/backup/rman_bkp_diario-$dthora.log
Views: 290 Target Database
Sentencias Backup Oracle 11g - Open SUSE
 
06:20
Sentencias Utilizadas lsnrctl start sqlplus '/ as sysdeba' startup backup spfile; copiado del archivo de configuración de la instancia. backup current controlfile; copiado del archivo de control. backup archivelog all; copiado de los archivos de archive. list backup; listar copias almacenadas. delete backup; borrar copias de respaldo. delete archivelog all; borrado de archivos. restore database; restaurar la bd. recover database; recuperar la bd a su punto optimo. -------------------------------------------------------------------------- Angelica Dominguez Estefania Gallo Milena Castañeda Sandra Silva Leonardo Mendoza Sebastián Lozano
Oracle Database11g tutorials 11: SQL case manipulation function in Oracle Database
 
04:38
Part 2 SQL functions- character function -case manipulation functions Previous Video Link :: http://youtu.be/5rx8Q4x4-qI Tool used in this tutorial is command prompt. This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ------------------------------------------------------------------------------------- As discuss in last video we have 3 case manipulation functions. In case you miss the SQL functions intro video you can find the link in the description below. First let's see what these functions are. Upper (): This function takes a parameter converts it into uppercase and returns the new string. Initcap (): this function also takes parameter and converts the initial letter of or parameter into uppercase and returns the new string. Lower (): This function takes a parameter converts it into lowercase and returns the new string. Ok let's do some practical For this practical we will be using 2 tables First is dual table Which is a dummy table provided by oracle? And I have created another table again by the name of example. This will be our second table. Let's start with SQL function upper ( ); SELECT upper('hello world') FROM dual; As you can see I have used "hello world" completely in lowercase as parameter to SQL upper function. Execute it. Here, our result has given us a completely new hello world string which is in uppercase. Similarly you can also use SQL upper function to perform other DML Let's try This time we will work on our second table EXAMPLE; insert into example values (upper('manish')); first parentheses for values and second for SQL function upper. Let's check the result. As you can see here inserted value is in upper case. Lets compare it with simple insert query Insert into example values ('manish'); Execute it, i think now it's clear that when we perform simple insert DML the inserted value will be the same you provide. Similarly let's try SQL function initcap(); SELECT initcap('hello world') FROM dual; As you see here in result the initial letters of string hello world are in uppercase. Let's do the insert query insert into example values (initcap('hello world')); initial letters of string also are in uppercase. Let's try SQL function lower(); This time we have to write our hello world in all caps. SELECT lower('HELLO WORLD') FROM dual; Execute String totally in lower case. Similarly you can user SQL function lower in other DML like insert and all.
Views: 91206 Manish Sharma
Oracle RMAN Full Backup
 
03:17
#### full backup #### run { backup current controlfile format 'F:\rman\Full_%s_%t_%p.ctl'; backup incremental level 0 format 'F:\rman\Full_%s_%t_%p.dbf' database; sql ' alter system switch logfile'; backup archivelog all format 'F:\rman\Full_%s_%t_%p.arch'; delete noprompt force archivelog until time 'sysdate - 7'; } .............................. Dear Viewers... ThnxXxx U fOr VieWinG, RatinG, FavOritE N PasSinG Ur ValuAble COmmEnts........ :-) Take Care yOu aLL, ALLwayS...................!!! .....................
Views: 156 Oracle
SQL tutorials 17: SQL Primary Key constraint,  Drop primary Key
 
09:22
Blog link: http://www.rebellionrider.com/sql-primary-key.htm SQL tutorial on Primary key / SQL Primary key, In this tutorial you will learn about simple primary key, composute primary key, how to drop primary key. defining primary key using create table and alter table along with many other things. Tool used in this tutorial is SQL Developer. This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com So Primary Key There are two types of Primary keys First is Simple primary Key: Primary key which Involves only one column and Second is Composite Primary Key: Primary Key which involves more than one column. We will start with Simple primary key. You can create Primary key either with Create Table statement of by using Alter table Statement. Let's define simple primary key using create table statements. With create table statement we can either define primary key at column level or at table level. We will start with defining Primary key at column level using create table statement. You just have to put keyword Primary key after data type and size of column while defining a column of a table. Here oracle server will create a primary key on product id with default constraint name which will be slightly difficult to understand. You can give your own name to your constraint which is also a good practice.
Views: 106299 Manish Sharma
Oracle DBA Justin - How to backup and restore an Oracle database with RMAN (basic)
 
18:53
How to backup and restore an Oracle database with RMAN (basic)
Views: 305360 jbleistein11
Oracle XE Hot Backup & Recovery
 
14:34
Demonstrating hot backup and recovery with Oracle XE.
Views: 8120 Stephen Frein
Oracle RMAN INCREMENT 1 BACKUP
 
01:52
#### increment l backup #### code run { backup current controlfile format 'F:\rman_inc\Inc_%s_%t_%p.ctl'; backup incremental level 1 format 'F:\rman_inc\Inc_%s_%t_%p.dbf' database; sql ' alter system switch logfile'; backup archivelog all format 'F:\rman_inc\Inc_%s_%t_%p.arch'; delete noprompt force archivelog until time 'sysdate - 7'; } ....................................... Dear Viewers... ThnxXxx U fOr VieWinG, RatinG, FavOritE N PasSinG Ur ValuAble COmmEnts........ :-) Take Care yOu aLL, ALLwayS...................!!!
Views: 43 Oracle
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: 5312 Oracle World
#Oracle 11G - #BackupRecovery using RMAN
 
16:59
#oracle11G #oracle #oracleDBA Demonstration of three steps: 1. Take a Full backup using RMAN. 2. Simulate Disk Failure by deleting Data Files. 3. Performing Recovery of data Files from Backup. To Learn or Teach Linux visit www.theskillpedia.com, A Marketplace for Learners and Trainers.
Views: 15316 TheSkillPedia
Oracle Database tutorials 5:  how to Fetch Data using SELECT - SQL statement by Manish Sharma
 
05:13
SELECT – SQL Statement which will help you in fetching data from your database. Learn the concepts of SELECT statement with easy examples in this SQL tutorial by Manish Sharma Contacts www.Facebook.com/TheRebellionRider www.twitter.com/rebellionrider www.instagram.com/RebellionRider in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos This is Manish from RebellionRider
Views: 205554 Manish Sharma
How to move a Datafile in Oracle Database 12c - part 2
 
01:26
How do you move a datafile in an Oracle Database? Well, it just got a lot easier in 12c! Watch this free video tutorial where OCM John Watson of SkillBuilders will demonstrate both techniques, 11g and 12c. http://skillbuilders.com/free-oracle-tutorials There are many reasons to move a datafile in an Oracle database. Here are just a few: Renaming datafiles to a standard Moving from one file system to another Converting from file system storage to ASM Changing from SAN to NFS storage In 11g, we need to take the tablespace offline, meaning downtime. Argh! In 12c, all that is required is ALTER DATABASE MOVE DATAFILE; this is an online operation with zero downtime (in 11g we use ALTER DATABASE RENAME DATAFILE). Even "critical" files such as the files associated with the SYSTEM tablespace can be moved online. Consider the ease of moving to ASM this provides! This also functions in an Active Data Guard standby environment. And, there are syntax options that allow you to keep or delete the original file. Very cool stuff.
Views: 570 SkillBuilders
Datafile Recovery
 
05:11
#Oracle #RMAN Datafile Recovery
Views: 1763 Hemant K Chitale
Recovery of Redo log file using Log Sequence number by RMAN
 
13:50
Hi friends today I am showing you to Recovery of Redo log file using Log Sequence number by RMAN (Recovery Manager).This is a simple method and easy way to recovery redo members. #Recovery #Redologfile #LogSequence #RMANrecovery Oracle database Unbeatable,Unbreakable Platform..
Views: 8221 Oracle World
Incomplete Database Recovery when redo logs missing in Oracle
 
03:38
By Vivek Saxena Insa Shabad Coachings Shamli If redo logs missing then 1st perform recovery until cancel then alter database open resetlogs //First check automatic archival enabled Archive log list Shut immediate //Delete redo logs Startup //Error ORA-00313 open failed for members of logs group 1 of thread 1 //ORA-00312 Online log 1 thread 1 Recover database until cancel; Alter database open resetlogs;
Enable/Disable Archive Log Mode in Oracle 11g Database
 
13:57
Learn how to change the log mode of database from NoArchive Log mode to Archive Log Mode and ViceVersa.
Views: 99 linux recipe
Oracle RMAN backup
 
10:17
Creating a backup script to backup Oracle database without shutting the instance. Requires that archive logging is enabled. #!/bin/bash # This is a simple backup script, and will work fine for a small installation such as Oracle XE # Change the Recovery Window to be longer than the frequency of backup # Change the /home/paulw/backups to be a specific backup location, at least on a separate disk # and preferably accessible if the source machine isn't accessible # # Replace the @@ with a left angle bracket . /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh rman @@ EOF CONNECT target / CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/paulw/backups/auto_control_file_%F'; CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS; run { ALLOCATE CHANNEL RMAN_BACK_CH01 TYPE DISK; BACKUP AS COMPRESSED BACKUPSET DATABASE FORMAT '/home/paulw/backups/databasefiles_%d_%u_%s_%T'; sql 'ALTER SYSTEM ARCHIVE LOG CURRENT'; BACKUP AS COMPRESSED BACKUPSET ARCHIVELOG ALL FORMAT '/home/paulw/backups/archivelogs_%d_%u_%s_%T'; BACKUP AS COMPRESSED BACKUPSET CURRENT CONTROLFILE FORMAT '/home/paulw/backups/controlfile_%d_%u_%s_%T'; CROSSCHECK BACKUP; DELETE NOPROMPT OBSOLETE; DELETE NOPROMPT EXPIRED BACKUP; RELEASE CHANNEL RMAN_BACK_CH01; } CONFIGURE CONTROLFILE AUTOBACKUP OFF; EXIT; EOF
Views: 37 Paul Williams
How configure oracle 11g In Archivelog Mode & No archvielog Mode On Redhat
 
16:45
The following are the steps required to enable archive log mode on an Oracle 10g or 11g database. Verify the database log mode. [email protected] sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Thu Apr 8 12:02:52 2010 Copyright 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL archive log list Database log mode No Archive Mode Automatic archival Disabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 25 Current log sequence 27 SQL The log mode is No Archive Mode. Note that Archive destination is USE_DB_RECOVERY_FILE_DEST. You can determine the path by looking at the parameter RECOVERY_FILE_DEST. SQL show parameter recovery_file_dest NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_recovery_file_dest string /u01/app/oracle/flash_recovery _area db_recovery_file_dest_size big integer 3852M SQL By default, archive logs will be written to the flash recovery area. If you do not want to write archive logs to the flash recovery area you can set the parameter LOG_ARCHIVE_DEST_n to the location in which you wish to write archive logs. SQL alter system set log_archive_dest_1='LOCATION=/u02/app/oracle/oradata/orcl/arch' scope = both; System altered. SQL archive log list; Database log mode No Archive Mode Automatic archival Disabled Archive destination /u02/app/oracle/oradata/orcl/arch Oldest online log sequence 25 Current log sequence 27 SQL Now we shutdown the database and bring it backup in mount mode. SQL shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL startup mount ORACLE instance started. Total System Global Area 849530880 bytes Fixed Size 1339824 bytes Variable Size 511708752 bytes Database Buffers 331350016 bytes Redo Buffers 5132288 bytes Database mounted. SQL Lastly all that is needed it set archive log mode and open the database. SQL alter database archivelog; Database altered. SQL alter database open; Database altered. SQL archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination /u02/app/oracle/oradata/orcl/arch Oldest online log sequence 25 Next log sequence to archive 27 Current log sequence 27 SQL We can now see that archive log mode is enabled. Notice that Automatic archive is enabled as well. In Oracle 9i an earlier another parameter needed to be set in order to enable automatic archiving. This in no longer the case in 10g and 11g as automatic archiving is enabled when the database is placed in archive log mode. You can switch to the log file to see that an archive is written to archive log location. SQL alter system switch logfile; System altered. SQL host [email protected] ~$ ls /u02/app/oracle/oradata/orcl/arch 1_27_711369564.dbf [email protected] ~$ exit exit SQL The following are the steps required to disable archive log mode on an Oracle 10g or 11g database. Verify the database log mode. [email protected] ~$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Thu Apr 8 12:54:05 2010 Copyright c 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination /u02/app/oracle/oradata/orcl/arch Oldest online log sequence 26 Next log sequence to archive 28 Current log sequence 28 he Database log mode is Archive mode. Next we shut down the database and bring up back up in mount mode. SQL shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL startup mount ORACLE instance started. Total System Global Area 849530880 bytes Fixed Size 1339824 bytes Variable Size 511708752 bytes Database Buffers 331350016 bytes Redo Buffers 5132288 bytes Database mounted. SQL All that is left is to disable archive log mode and open the database. SQL alter database noarchivelog; Database altered. SQL alter database open; Database altered. SQL archive log list; Database log mode No Archive Mode Automatic archival Disabled Archive destination /u02/app/oracle/oradata/orcl/arch Oldest online log sequence 26 Current log sequence 28 SQL
Views: 230 Md Arshad
Recovery of data file without backup
 
06:15
How to Recovery of data file without backup in Oracle
Views: 482 Koenig Solutions
Oracle Architecture
 
04:11
This video describes the best architecture of the oracle after trying more than times to Oracle structure I decided to produce an animated video let's start first with the database structure on the left side you have the client here on the right side you have to serve a two-year the server side is divided in three main structures to memory the logical structure and the physical structure so let's use SQL Plus application to provide you every step up a transaction will be using Scott sample schema it is important to note that the whole string is an alias and not a database name district will be compared to this alias inside of a file called pianist named doc or this file is similar to a DNS and with up pain all the necessary detail to reach a database server locally a user process will be allocated and will validate the connection through a listener the listener will be in charge to allocate a server process the user processes da link to the server process let's now execute our first transaction for this example we will execute an update first to state that will be validated we call this step the parsing this server process sense back to confirmation of the parsing that statement with be written into their share pool and the redo log buffer an execution plan will also be created it to the fair share Paul that database book they choose fought the transaction will be read and copy into the database buffer cache only that feel implicated in that transaction will be held it to a - segment till the transaction is completed we call those copies the before image a copy of this block will be duplicated with the updated feel this copy is called me after image a confirmation will be sent to to use a process the commit statement will complete the transaction and will be written into to redo log buffer to commit statement triggers the log writer process and we'll send all statement for the current transaction into the redo log file the before image into undo segment could be then deleted went that threshold up to undo retention parameters reach alaskan from Asian will be sent to the user process went to current law kiss Paul it generates a switch lock triggering at the same time the archiver process and to log sequence number the archiver will generate and archive the file with the content of the current loc a switch up with them trigger a checkpoint process that will incriminate the checkpoint number by applying this last number into each data file header the checkpoint process with finally trigger the database writer process enright the last image from that database buffer cache into thirty people
Views: 22501 Ezylearning
Oracle Database Recovery
 
01:24
Learn How to recover corrupt or deleted Oracle Database Files(.dbf) from all the events of data loss and data corruption scenarios.
Views: 206 Kelley Jones
Perform Incomplete Recovery When Control files, Data files, & Redolog files are missing Using Rman.
 
11:13
We can Perform incomplete recovery When Control files, Data files, & Redo log files are missing using Rman Backup. Incomplete Recovery Means The Database upto the specific point in time in the past, before the recovery operation was required. There where many types of incomplete Recovery. But in this video i am showing you only Incomplete Recovery When Control files, Data files, & Redo log files are missing Using Rman Backup. We can perform easily To follow this steps to perform Incomplete Recovery When Control files, Data files, & Redo log files are missing Using Rman Backup. This is easy to Understand
Views: 717 Parag Mahalle
Where is my tracefile
 
04:32
SQL trace is an awesome performance tuning resource. But before you can do that analysis, you need to know WHERE your trace file is. ========================================­============== Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 3109 Connor McDonald
Oracle Database 12c SQL Certified Associate 1Z0-071 : Group functions Introduction
 
05:58
http://ytwizard.com/r/PLkVTt http://ytwizard.com/r/PLkVTt Oracle Database 12c SQL Certified Associate 1Z0-071 Become Oracle SQL Certified ( OCA ) / Covers ORACLE university track 100%. All the presentations & scripts are attached
Oracle Instance Recovery Tutorial - Module 2 - Tutorial Agenda
 
02:40
Q. Is It Possible to Corrupt an Oracle Database? A. No, You Cannot - Not If It Is Properly Administered. Why? Because the mechanism of redo and undo is the best yet developed on this planet. In this free tutorial, Oracle Certified Master John Watson will explain redo, undo, commit, instance recovery and demonstrate why your database can never lose one row of committed data. Learn what actually happens, in memory and on disc, when DML is issued. John will demonstrate that instance recovery is automatic, and unstoppable. This is critical and essential knowledge for all Oracle Administrators and DBA students. Presenter: John Watson, Oracle Certified Master See all free Oracle Database tutorials at www.SkillBuilders.com/OracleTutorials
Views: 629 SkillBuilders
Simulación recuperación ante desastre con RMAN
 
37:59
Administración de Bases de Datos - Unipanamericana - 2017 1. Ver la configuración actual de RMAN Ejecutamos: rman target / Para ver la configuración actual del RMAN Ejecutamos: SHOW ALL; 2. Cambiar algunos parámetros de configuración del RMAN - Para configurar la ubicación de los archivos de backup... Ejecutamos: CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT 'D:\backup\full_%u'; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'D:\backup\full_%f'; - Para configurar el período de retención... Ejecutamos: CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS; Ahora verificamos que los dos cambios están hechos... Ejecutamos: SHOW ALL; En caso que se quiera limpiar un parámetro, por ejemplo, la política de retención... Ejecutamos: CONFIGURE RETENTION POLICY CLEAR; 3. Respaldar la Base de Datos Oracle - Respaldo completo de la base de datos sin el archivo de registro... Ejecutamos: BACKUP DATABASE; - Respaldo completo de la base de datos con el archivo de registro... Ejecutamos: BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT; Si fall el commando anterior… run { shutdown immediate startup mount backup database plus archivelog delete input; SQL 'ALTER DATABASE OPEN'; } -- Respaldo de un tablespace... BACKUP AS BACKUPSET TABLESPACE USERS; 4. Comprimir un respaldo Ejecutamos: BACKUP AS COMPRESSED BACKUPSET TAG 'DAILY_ORCL_BK_ONLY' TABLESPACE USERS; 5. Ver todos los respaldos de RMAN Ejecutamos: LIST BACKUP SUMMARY; - Para ver el estado de los respaldos cuando RMAN está en ejecución... Ejecutamos SELECT OPERATION, STATUS, MBYTES_PROCESSED, START_TIME, END_TIME from V$RMAN_STATUS; 6. Simular el desastre Estando en la consola de RMAN, ejecutamos: SHUTDOWN ABORT; - Abrimos una consola de texto de Windows... Nos pasamos a D:\app\oracle\product\11.2.0\dbhome_1\dbs Ejecutamos: del perf11.ora del init.ora - En SQLPlus, vamos a averiguar la ubicación de los archivos de datos, de control y logs... Ejecutamos: select name from v$datafile; select member from v$logfile; select name from v$controlfile; show parameter dump_dest Es importante averiguar el Oracle DBID, si no lo tenemos, se presentará un error al recuperar los archivos spfile y controlfile... Ejecutamos: select DBID from v$database; DBID ---------- 1470628578 Tomamos nota de las rutas... - De nuevo, en la consola de texto de Windows, nos pasamos a la carpeta donde se encuentran los archivos de datos de oracle... Ejecutamos del *.* /f 7. Restaurar la base de datos Accedemos de nuevo a la consola de RMAN Ejecutamos: rman target / set dbid=1470628578; startup force nomount; restore spfile to 'D:\app\oracle\product\11.2.0\dbhome_1\dbs\perf11.ora' from 'D:\backup\FULL_0KS4QNS7'; shutdown immediate; quit -- Verificamos que el archivo restaurado, y vovemos a la consola de RMAN rman target / startup nomount; set dbid=1470628578; restore controlfile from 'D:\backup\FULL_0KS4QNS7'; alter database mount; Ahora vamos a restaurar y recuperar la base de datos... Accedemos de nuevo a la consola de RMAN Ejecutamos: rman target / restore database; recover database; alter database open resetlogs;
DB Recovery from RMAN Full backup
 
29:09
https://dbagenesis.com/p/oracle-advanced-rman-backup-recovery DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available on demand. The video speaks about database recovery using RMAN when we have loss of all the data files. First we take DB FULL backup using RMAN and then simulate error by manually deleting all the data files. Later we recover the data base with RMAN backup taken earlier.
Views: 13036 DBA Genesis
Learn Oracle | How to Drop and Truncate a Table using SQL
 
02:36
Pebbles present, Learn Oracle 10g with Step By Step Video Tutorials. Learn Oracle 10g Tutorial series contains the following videos : Learn Oracle - History of Oracle Learn Oracle - What is Oracle - Why do we need Oracle Learn Oracle - What is a Database Learn Oracle - What is Grid Computing Learn Oracle - What is Normalization Learn Oracle - What is ORDBMS Learn Oracle - What is RDBMS Learn Oracle - Alias Names, Concatenation, Distinct Keyword Learn Oracle - Controlling and Managing User Access (Data Control Language) Learn Oracle - Introduction to SQL Learn Oracle - Oracle 10g New Data Types Learn Oracle - How to Alter a Table using SQL Learn Oracle - How to Create a Package in PL SQL Learn Oracle - How to Create a Report in SQL Plus Learn Oracle - How to Create a Table using SQL - Not Null, Unique Key, Primary Key Learn Oracle - How to Create a Table using SQL Learn Oracle - How to Create a Trigger in PL SQL Learn Oracle - How to Delete Data from a Table using SQL Learn Oracle - How to Drop and Truncate a Table using SQL Learn Oracle - How to Insert Data in a Table using SQL Learn Oracle - How to open ISQL Plus for the first time Learn Oracle - How to Open SQL Plus for the First Time Learn Oracle - How to Update a Table using SQL Learn Oracle - How to use Aggregate Functions in SQL Learn Oracle - How to use Functions in PL SQL Learn Oracle - How to use Group By, Having Clause in SQL Learn Oracle - How to Use Joins, Cross Join, Cartesian Product in SQL Learn Oracle - How to use Outer Joins (Left, Right, Full) in SQL Learn Oracle - How to use the Character Functions, Date Functions in SQL Learn Oracle - How to use the Merge Statement in SQL Learn Oracle - How to use the ORDER BY Clause with the Select Statement Learn Oracle - How to use the SELECT Statement Learn Oracle - How to use the Transactional Control Statements in SQL Learn Oracle - How to use PL SQL Learn Oracle - Data Types in PL SQL Learn Oracle - Exception Handling in PL SQL Learn Oracle - PL SQL Conditional Logics Learn Oracle - PL SQL Cursor Types - Explicit Cursor, Implicit Cursor Learn Oracle - PL SQL Loops Learn Oracle - Procedure Creation in PL SQL Learn Oracle - Select Statement with WHERE Cause Learn Oracle - SQL Operators and their Precedence Learn Oracle - Using Case Function, Decode Function in SQL Learn Oracle - Using Logical Operators in the WHERE Clause of the Select Statement Learn Oracle - Using Rollup Function, Cube Function Learn Oracle - Using Set Operators in SQL Learn Oracle - What are the Different SQL Data Types Learn Oracle - What are the different types of Databases Visit Pebbles Official Website - http://www.pebbles.in Subscribe to our Channel – https://www.youtube.com/channel/UCNNjWVsQqaMYccY044vtHJw?sub_confirmation=1 Engage with us on Facebook at https://www.facebook.com/PebblesChennai Please Like, Share, Comment & Subscribe
Views: 277 Pebbles Tutorials
RMAN Encryption Backup - Transparent Mode
 
08:42
RMAN Encryption Backup Transparent mode: – Requires Oracle Wallet – Is best suited for day-to-day backup and restore operations at the same location – Is the default encryption mode Transparent mode: Transparent encryption can create and restore encrypted backups with no further intervention, as long as the required Oracle key management infrastructure is available. Transparent encryption is best suited for day-to-day backup operations, where backups are restored at the same database that they were backed up from. Transparent encryption is the default mode for RMAN encryption.
Views: 578 Saurabh Joshi
Tuto DBA1 : Gérer Les utilisateurs Et privilège Sur Oracle 10g [Vidéo 7]
 
10:48
Objectif : Comment Créer un utilisateur sur Oracle 10g Comment accorder un privilège Pour tout contact : [email protected]
Views: 3566 EW FORMATION
Recreating Datafile when no backup but all archives available in Oracle (Media Recovery)
 
19:01
By Vivek Saxena Shabad Coachings Recreating Datafile when having no backup but having all archives since its creation
Oracle DBA Justin - How to Backup an 11g Oracle Database COLD - KMedia Channel
 
14:56
Oracle DBA Justin - How to Backup an 11g Oracle Database COLD, Entertaining and Educating - Free Education Foundation Initiative
Views: 570 krishnavaloorytube
SQL tutorial 36: how to create database using database configuration assistant DBCA
 
12:11
Step by step process of creating oracle database using DBCA database configuration assistant, how to unlock user account of sample schema WATCH FULL VIDEO TO KNOW HOW TO UNLOCK HR SCHEMA Tutorial Consist: How to create general purpose transaction database using DBCA database configuration assistant in Oracle 11g, Links How to create database detail blog: http://bit.ly/how-to-create-database-using-dbca What is archiving and archivelog mode: http://bit.ly/what-is-archiving-in-oracle-database Video Tutorial 1 How to install oracle 11g database http://youtu.be/0NLsJQCvKXY Video tutorial http://youtu.be/-13SbeDavwk Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 Amazon Wishlist: http://bit.ly/wishlist-amazon Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com
Views: 68146 Manish Sharma
SQL Into - How to Copy Table Data with Select Into Statement - SQL Training Online
 
05:08
http://www.sqltrainingonline.com SQL Into - How to Copy Table Data with Select Into Statement - SQL Training Online In this video, I show you how to copy data using the SQL INTO statement. Including a trick to copy only a table schema in SQL Server. How do you copy a whole table in SQL Server? You often see the SQL INTO statement when you are using INSERT, but there is a special INTO statement in SQL Server that is used with the SELECT statement that allows you to make a copy of a table for development, testing, or whatever purpose you can think of. So, to start, let's take a look at the SQL Training Online Simple DB employee table. You can see that we have 14 records Now, all we have to do to make a copy of the table is to simply add the SQL INTO clause: SELECT * INTO EMPLOYEE_TEST FROM EMPLOYEE If we run that, you see that we made a copy of the table with all of the data. Now, I want to go ahead and empty the employee_test table and show you how to use the INSERT INTO. If you already have a copy of the table, (I will show you a shortcut in a minute on how to create a copy without data.) then you can use the following insert into statement: INSERT INTO EMPLOYEE_TEST SELECT * FROM EMPLOYEE After running that statement, you see that I have inserted data from the Employee table into the employee_test table. This is sometimes referred to as INSERT INTO SELECT. But, there is one trick that I have used throughout the years that is pretty cool. Sometimes, you want the table schema, but you don't want the data. Now, I know that you can use Management Studio to script out the table for you, but there is an easier way that is more flexible as far as I am concerned. That is to use the SELECT INTO FROM, but put the following in the WHERE clause: SELECT * INTO EMPLOYEE_TEST FROM EMPLOYEE WHERE 1=2 The 1=2 makes is so not data will come over, but you get the new table with the right column types. Is that pretty cool? I have found many uses for this over the years. Let me know what you think bellow. Let me know what you think by commenting or sharing on twitter, facebook, google+, etc. If you enjoy the video, please give it a like, comment, or subscribe to my channel. You can visit me at any of the following: SQL Training Online: http://www.sqltrainingonline.com Twitter: http://www.twitter.com/sql_by_joey Google+: https://plus.google.com/#100925239624117719658/posts LinkedIn: http://www.linkedin.com/in/joeyblue Facebook: http://www.facebook.com/sqltrainingonline
Views: 26280 Joey Blue
2MTT: Using SYS_CONTEXT to Secure Your Database Environment | Rob Lockard
 
02:50
Database expert Rob Lockard put in a lot of practice to deliver his 2 Minute Tech Tip on using SYS_CONTEXT to help secure your database environment -- and the effort paid off. Rob crosses the finish line with time to spare. Rob will be presenting at ODTUG Kscope 2015: http://kscope15.com/component/seminar/seminarslist#A%20Holistic%20Approach%20to%20Database%20Security Rob is also speaking at the Oracle User Group Estonia's Harmony 15 conference in June: https://www.ouge.eu/wp/2015/01/harmony-2015-call-for-papers/
Views: 346 ArchBeat Archive