Home
Search results “Alter logfile group oracle”
Oracle - CLEAR CORRUPTED LOGFILE
 
22:25
STARTUP MOUNT; ALTER DATABASE DROP LOGFILE GROUP 1; ALTER DATABASE CLEAR LOGFILE GROUP 1; ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;
Views: 579 Dario Rafael
Redo Logs in an Oracle Database - DBArch Video 11
 
08:54
This video explains the concepts of Redo Log Groups and Files in an Oracle Database. You will understand how Oracle Instance uses Redo Buffers and Logwriter to keep the redo in Redo Logs. Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 21603 Ramkumar Swaminathan
oracle database Redo logfile management
 
26:07
watch this video about Redo logfile management defiantly improve your subject
Views: 4409 COMBINATIONS FOR ALL
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: 7468 Oracle World
Oracle Administration 31 =  Alert Log File Hands On
 
18:29
CREATE TABLE command in sql/oracle,INSERT command in sql/oracle UPDATE,ALTER PASSWORD command in sql, GRANT command, REVOKE command i, CREATE SYNONYM command in sql/oracle, DELETE command in sql/oracle, ALTER TABLE command in sql/oracle, DROP TABLE command in sql/oracle, CREATE INDEX command in sql/oracle, ALTER INDEX command in sql/oracle, DROP INDEX command in sql/oracle, CREATE VIEW command in sql/oracle, DROP VIEW command in sql/oracle USING SQL COMMAND Types of SQL Commands The following sections discuss the basic categories of commands used in SQL to perform various functions. These functions include building database objects, manipulating objects, populating database tables with data, updating existing data in tables, deleting data, performing database queries, controlling database access, and overall database administration. The main categories are DDL (Data Definition Language) DML (Data Manipulation Language) DQL (Data Query Language) DCL (Data Control Language) Data administration commands Transactional control commands Defining Database Structures Data Definition Language, DDL, is the part of SQL that allows a database user to create and restructure database objects, such as the creation or the deletion of a table. Some of the most fundamental DDL commands discussed during following hours include the following: CREATE TABLE ALTER TABLE DROP TABLE CREATE INDEX ALTER INDEX DROP INDEX CREATE VIEW DROP VIEW Manipulating Data Data Manipulation Language, DML, is the part of SQL used to manipulate data within objects of a relational database. There are three basic DML commands: INSERT UPDATE DELETE Selecting Data Though comprised of only one command, Data Query Language (DQL) is the most concentrated focus of SQL for modern relational database users. The base command is as follows: SELECT This command, accompanied by many options and clauses, is used to compose queries against a relational database. Queries, from simple to complex, from vague to specific, can be easily created. The SELECT command is discussed in exhilarating detail during Hours 7 through 16. A query is an inquiry to the database for information. A query is usually issued to the database through an application interface or via a command line prompt. Data Control Language Data control commands in SQL allow you to control access to data within the database. These DCL commands are normally used to create objects related to user access and also control the distribution of privileges among users. Some data control commands are as follows: ALTER PASSWORD GRANT REVOKE CREATE SYNONYM You will find that these commands are often grouped with other commands and may appear in a number of different lessons throughout this book. Data Administration Commands Data administration commands allow the user to perform audits and perform analyses on operations within the database. They can also be used to help analyze system performance. Two general data administration commands are as follows: START AUDIT STOP AUDIT Do not get data administration confused with database administration. Database administration is the overall administration of a database, which envelops the use of all levels of commands. Database administration is much more specific to each SQL implementation than are those core commands of the SQL language. Transactional Control Commands In addition to the previously introduced categories of commands, there are commands that allow the user to manage database transactions. COMMIT Saves database transactions ROLLBACK Undoes database transactions SAVEPOINT Creates points within groups of transactions in which to ROLLBACK SET TRANSACTION Places a name on a transaction Transactional commands are discussed extensively during Hour 6, "Managing Database Transactions."
Oracle DB - Multiplexing Redo Log Files
 
05:19
Oracle DB - Multiplexing Redo Log Files Watch More Videos at: https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjabi, Tutorials Point India Private Limited
Multiplexación de RedoLog files
 
04:38
Vamos a agregar miembros a los grupos de Redo Logfiles de nuestra base de datos de Oracle desde el SQL Plus. Comandos: select group#, members, bytes from v$log; alter database add logfile member '/u03/app/oracle/oradata/orcl/REDO01' to group 1;
Views: 383 Codingraph
Oracle Administration 30 =The Alert Log File Theory
 
08:38
CREATE TABLE command in sql/oracle,INSERT command in sql/oracle UPDATE,ALTER PASSWORD command in sql, GRANT command, REVOKE command i, CREATE SYNONYM command in sql/oracle, DELETE command in sql/oracle, ALTER TABLE command in sql/oracle, DROP TABLE command in sql/oracle, CREATE INDEX command in sql/oracle, ALTER INDEX command in sql/oracle, DROP INDEX command in sql/oracle, CREATE VIEW command in sql/oracle, DROP VIEW command in sql/oracle USING SQL COMMAND Types of SQL Commands The following sections discuss the basic categories of commands used in SQL to perform various functions. These functions include building database objects, manipulating objects, populating database tables with data, updating existing data in tables, deleting data, performing database queries, controlling database access, and overall database administration. The main categories are DDL (Data Definition Language) DML (Data Manipulation Language) DQL (Data Query Language) DCL (Data Control Language) Data administration commands Transactional control commands Defining Database Structures Data Definition Language, DDL, is the part of SQL that allows a database user to create and restructure database objects, such as the creation or the deletion of a table. Some of the most fundamental DDL commands discussed during following hours include the following: CREATE TABLE ALTER TABLE DROP TABLE CREATE INDEX ALTER INDEX DROP INDEX CREATE VIEW DROP VIEW Manipulating Data Data Manipulation Language, DML, is the part of SQL used to manipulate data within objects of a relational database. There are three basic DML commands: INSERT UPDATE DELETE Selecting Data Though comprised of only one command, Data Query Language (DQL) is the most concentrated focus of SQL for modern relational database users. The base command is as follows: SELECT This command, accompanied by many options and clauses, is used to compose queries against a relational database. Queries, from simple to complex, from vague to specific, can be easily created. The SELECT command is discussed in exhilarating detail during Hours 7 through 16. A query is an inquiry to the database for information. A query is usually issued to the database through an application interface or via a command line prompt. Data Control Language Data control commands in SQL allow you to control access to data within the database. These DCL commands are normally used to create objects related to user access and also control the distribution of privileges among users. Some data control commands are as follows: ALTER PASSWORD GRANT REVOKE CREATE SYNONYM You will find that these commands are often grouped with other commands and may appear in a number of different lessons throughout this book. Data Administration Commands Data administration commands allow the user to perform audits and perform analyses on operations within the database. They can also be used to help analyze system performance. Two general data administration commands are as follows: START AUDIT STOP AUDIT Do not get data administration confused with database administration. Database administration is the overall administration of a database, which envelops the use of all levels of commands. Database administration is much more specific to each SQL implementation than are those core commands of the SQL language. Transactional Control Commands In addition to the previously introduced categories of commands, there are commands that allow the user to manage database transactions. COMMIT Saves database transactions ROLLBACK Undoes database transactions SAVEPOINT Creates points within groups of transactions in which to ROLLBACK SET TRANSACTION Places a name on a transaction Transactional commands are discussed extensively during Hour 6, "Managing Database Transactions."
Block corruption recovery with RMAN
 
10:11
How to recover block corruption with the help of Recovery manager (RMAN) in Oracle 11g
Views: 2298 Athar Fahad
How to reszie the redolog file
 
14:15
In this video i'm going to demonstrate you how to resize the redolog file step by step, this is only one method to resize the redolog file.
Views: 2594 OCP Technology
reset log on oracle server
 
06:41
reset log on oracle server
Views: 318 Jamaal Khan
ORACLE: Quản lý REDOLOG: Tăng (giảm) kích thước LOG GROUP
 
05:51
RE-SIZE LOG GROUP - Thay đổi kích thước của group. - Tăng-giảm số group trên database. - Xóa Group đang ở trạng thái CURRENT hoặc ACTIVE. - Xem thông tin REDO Group.
Views: 363 1Click2beDBA
How To Add/Drop ASM Disk In Disk Groups And Monitor Re-Balance Operations Part 2 of 2
 
04:23
Hi... Friends In This Video We Learn How To Add/Drop ASM Disk In Disk Groups And Monitor Re-Balance Operations In Oracle On Windows .
Views: 1144 PGT POINT
Oracle Redo log group status-  Simple Example
 
06:45
This video explains about the ORACLE REDO GROUP STATUS This has 4 status  Current  Active  In Active  Unused These 4 statuses will be cycled whether Database is in Archive mode or No Archive mode.
Views: 180 Ezylearning
Moving a Database (datafile and Controlfile and Redo Log File)  from File System to ASM Storage
 
27:02
Hi guys today i explaining a real environment scenario that require to move a Full Database from File system to #MovingDatabase #FileSystemtoASMStorage ASM Disk Group Storage. Oracle database Unbeatable,Unbreakable Platform..
Views: 4721 Oracle World
DBA losson5-Control file and redolog file
 
22:42
create new control file add new group and redo log file alter and drop member redo lof
Views: 3203 ayman hamdan
Oracle Database 11g,12c DBA tutorials. how to enable archive log mode and disable.
 
07:00
This section describes how to set the archiving mode of the database and how to control the archiving process.And how to Archive log mode on and off.
Views: 917 Sayif Uddin
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;
Oracle DBA Justin - How to rename/move an online redo log file
 
09:20
How to rename/move an online redo log file
Views: 5052 jbleistein11
Oracle Tutorial -  How to multiplex/mirror a controlfile of an Oracle database
 
03:23
In this video i'm going to discus with you how to do multiplexing of controlfile in oracle 11g step by step.
Views: 1433 OCP Technology
Controlfile & redolog file management
 
39:45
Multiplexing the control file, adding Redolog to the database, Adding Redolog member to the existing group, Drop Redolog member tfrom the database, Drop Redolog group from databse, Resizing Redo log groups, an last but not the list.... Views.
Views: 3695 techbrain
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: 2193 Oracle World
Oracle DBA Justin - How to mirror/multiplex online redo log files
 
08:32
How to mirror/multiplex online redo log files
Views: 5892 jbleistein11
managing controlfiles | oracle
 
21:24
managing Controlfiles , multiplexing control files
How to Start Physical Standby database & Check if Database is in Sync
 
06:32
How to Start Physical Standby database & Check if Database is in Sync Dataguard Status ==================================================== Start Standby Database =============================== startup nomount alter database mount standby database; alter database recover managed standby database disconnect from session; DB STATUS ======================= select status,instance_name,database_role,protection_mode from v$database,v$instance; TO check if dataguard in synchronizing with standby. ============================================================================= select thread#,max(sequence#) from v$archived_log where applied='YES' group by thread#; Status of MRP Process --------------------------- select process,status,client_process,thread#,sequence#,block#,blocks,delay_mins from v$managed_standby; To get the diffrence between Recived and applied logs. ------------------------------------------------------- select MAX_RECEIVED,MAX_APPLIED,(MAX_RECEIVED - MAX_APPLIED) as "Difference" from (SELECT ARCHIVED_THREAD#, MAX(ARCHIVED_SEQ#) as MAX_RECEIVED, APPLIED_THREAD#, MAX(APPLIED_SEQ#) as MAX_APPLIED FROM V$ARCHIVE_DEST_STATUS) ARCH ; ================================================= 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] Please visit my official website for oracle database training and hadoop blog. https://www.orcldata.com/ 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 how to check data guard status oracle how to check lag in data guard how to sync primary and standby database in oracle how to check archive log gap standby database how to check if archive logs are applied to standby database query to check archive log gap how to check if database has standby how to check standby database name from primary
Views: 1608 ANKUSH THAVALI
How to log in to an Oracle Database - Answer Video - Database Tutorials 42
 
04:26
How to log in to an Oracle Database - Answer Video - Database Tutorials 42 This video explains about how to log in to an Oracle database. This also explains about how to create an user and grant a role to that user. In this case, the role granted is 'dba'. The following things happen in this Oracle Database Tutorial. * We invoke SQLPLUS using the CMD utility which came with Windows 7 (Just click START in your Windows 7 and type CMD in the field which is immediately above the START button. A CMD window will open) * We also invoke SQLPLUS using the program group in which Oracle has been installed. * We also invoke Database Control * We then create a user. * And we assign a password to that user. * Using those (username and password) we are able to connect to the Oracle Database.
Views: 11834 Sam Dhanasekaran
Oracle DB - Multiplexing Control Files
 
07:59
Oracle DB - Multiplexing Control Files Watch More Videos at: https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjabi, Tutorials Point India Private Limited
how to manual database creation on oracle 11g
 
18:53
how to manual database creation parameter file -- ------------------------------------------------------------------ db_name=TEST Instance_name=TEST Control_files='/u01/home/TEST/control01.ctl' Db_block_size=8192 Undo_management='auto' Undo_tablespace=undotbs1 Undo_retention=900 Compatible=11.2.0 Memory_max_target=400m Memory_target=300m Log_buffer=100 Workarea_size_policy=auto Diagnostic_dest='/u01/home/TEST/diag' ----------------------------------------------------------------------- control file -- --------------------------------------------------------------- CREATE DATABASE TEST user sys identified by oracle user system identified by oracle logfile group 1 ('/u01/home/TEST/redo01.log') size 50m, group 2 ('/u01/home/TEST/redo02.log') size 50m, group 3 ('/u01/home/TEST/redo03.log') size 50m maxlogfiles 5 maxlogmembers 5 maxloghistory 50 maxdatafiles 100 maxinstances 1 datafile '/u01/home/TEST/system01.dbf' size 100m autoextend on sysaux datafile'/u01/home/TEST/sysaux01.dbf' size 100m autoextend on default tablespace users datafile '/u01/home/TEST/users01.dbf' size 100m autoextend on default temporary tablespace temp tempfile '/u01/home/TEST/temp01.dbf' size 50m undo tablespace undotbs1 datafile '/u01/home/TEST/undotbs01.dbf' size 200m; ------------------------------------------------------------------------------ script -- -------------------------------------------------------------------------- @$ORACLE_HOME/rdbms/admin/catalog.sql @$ORACLE_HOME/rdbms/admin/catproc.sql connect system/oracle @$ORACLE_HOME/sqlplus/admin/pupbld.sql -----------------------------------------------------------------------------
Views: 1807 Cocktail Video
TABLESPACE MANAGEMENT CREATE TABLESPACE ALTER DATAFILE
 
03:34
How to check existing tablespace information in database ========================================================= select tablespace_name from dba_tablespaces; How to create a tablespace =============================== create tablespace king datafile 'E:\DATABASE\DATABASE\ORADATA\ORCL\KING01.DBF' size 10m; How to Resize the datafile ========================== alter database datafile 'E:\DATABASE\DATABASE\ORADATA\ORCL\KING01.DBF' resize 20m; Adding a datafile to a tablespace ================================= alter tablespace king add datafile 'E:\DATABASE\DATABASE\ORADATA\ORCL\KING02.DBF' size 10m; How to get the defintion of tablespace ====================================== set head off echo off select 'select dbms_metadata.get_ddl(''TABLESPACE'',''' || tablespace_name || ''') from dual;' from dba_tablespaces;
Views: 955 Praveen Biyyapu
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: 145 Oracle
Oracle Tutorial - How to rename Datafile in Oracle step by step
 
08:24
Hello friends in this video i'm going to show you how to rename datafile in oracle step by step
Views: 682 OCP Technology
how to create redolog files and clean the redo log files
 
03:19
for more vedios www.oraman.in
Views: 1034 oramandba
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: 1744 ANKUSH THAVALI
Oracle DBA, How to drop an online redolog member 1e5
 
03:32
How to drop and online redolog member which has invalid status
Views: 989 hammadshams
How to use Oracle's blockrecover command in order to recover from block corruption.
 
04:01
This video demonstrates Oracle's blockrecover command and provides and example on how it works.
Views: 1922 SaxDBA
How to Move a Datafile in Oracle Database - Part 1
 
01:32
Dozens of free Oracle tutorials at http://skillbuilders.com/free-oracle-tutorials. See Part 2 (the demonstration) of this tutorial at http://skillbuilders.com/How-to-Move-Datafiles-Oracle-12c. How do you move a datafile in an Oracle Database? Well, it just got a lot easier in 12c! Watch this free video tutorial - OCM John Watson of SkillBuilders will demonstrate both techniques, 11g and 12c. 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. Even "critical" files such as the files associated with the SYSTEM tablespace can be moved online. Consider the ease of migrating 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: 2630 SkillBuilders
db files change
 
03:09
Change the DB_FILES parameter in ORACLE without changing the control file.
Views: 119 Imraan Grace
How to Shrink table in Oracle..
 
11:52
this video will help how to reclaim space from the table.
Views: 1928 oracdb
Redo Log Files and RAC
 
03:40
In an Oracle RAC environment, each individual instance requires its own independent set of redo logs, and its own undo tablespace. For more information please visit https://www.koenig-solutions.com/oracle-database-12c-rac-administration-training.aspx
Views: 173 Koenig Solutions
Oracle Database Tutorial 65: How to create temporary tablespace in oracle database
 
05:55
Learn How to create big file and small file temporary tablespace in oracle database by Manish Sharma RebellionRider Follow Me on Twitter @RebellionRider and Instagram "RebellionRider" ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : Previous Tutorial ► Permanent Tablespace https://youtu.be/vkwKZIssvfc ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- 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 1st 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 for E-mail address please check About section 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: 15633 Manish Sharma
RMAN Recovery Scenarios Session - 4
 
02:09:11
Recently i took RMAN sessions to some group of people and as a part of it i explained various scenarios of rman restore and recovery operation. I tried to record the video for the purpose of the people who follow my blog. In this present session we will see various recovery scenarios mentioned below. 1) Complete database restore and recovery 2) Loss of System Datafile 3) Non-System datafile ( closed and Open ) 4) Restoring a tablespace ( closed and Open ) 5) Restoring a datafile if no backups 6) Restoring a datafile to different location 7) Restoring controlfile 8) restoring spfile 9) Restoring online redologs 10) Restoring temporary datafiles 11) Incomplete Recovery ( time based , Change based and SCN based ) 12) Recovering archived logs The following video demo gives you detailed explanation of each scenario and how to restore and recover under different scenarios. Setup: ===== Let me explain you the environment used for this practice. I am using a database with ORACLE_SID=orcl as my database for testing all the different scenarios mentioned above. I am using a recovery catalog for my rman configuration and its details are ORACLE_SID=rmandb and schema used for rman catalog data is rman and the tns alias to connect to catalog database is rmandb. I have both my databases orcl and rmandb in archive log mode and i also have backup for my database orcl. For all my restore and recover operations i am using the following syntax to connect to target database and catalog database. rman target / catalog rman/*******@rmandb
Oracle Tutorial - How to recover a corrupted NON SYSTEM datafile (database in ARCHIVELOG mode)
 
06:19
The following scenario describes what happens when a non system datafile is lost. Before proceeding be sure to have a complete backup of your database and be sure your database is in ARCHIVELOG mode. #Oracletutorialforbeginners #rmanrecoverytutorial #recoveracorruptedNONSYSTEMdatafile By ORACLE WORLD
Views: 2229 Oracle World
Tutoriel Oracle DBA1 (34) : Les fichiers Redo Log.
 
06:40
Bonjour, Abonnez-vous à Sybaway : http://goo.gl/dBJO13 Plus de tutoriels : http://goo.gl/Ut31RF Facebook : http://goo.gl/DC7AIA Twitter : http://goo.gl/PUrQga Sybaway
Views: 1978 Abdessamad HALLAL
How to Add & Drop Datafile in Tablespace. ( Tablespace Management #2 )
 
06:46
Hello Friend In this video I am showing you 1. How to add datafile. 2. How to drop Datafile. 3. How to alter Tablespace. 4. How to check Datafile Location. 5. How to check free space in tablespace.
Views: 240 Parag Mahalle

Here!
Dragon ball z mission to namek online dating
Lose your virginity dating site
Griekse tv zenders online dating
Top online dating blogs