Mahir M. Quluzade | Oracle Blog

I take full  backup with RMAN, after backup I will create tablespace and a user with default tablespace new tablespace and a table on this user schema. After those I loss new tablespace's datafile. RMAN restore datafile  without backup of this datafile. I think, this video will be  intersting for O racle DBA's. You can watch   How to restore tablespace in case of NO backup?  on youtube. Regards Mahir M. Quluzade.   

I showed with this video how to backup database as copy, how to use switch to copy image for fast recovery and how to recover corrupted datafile without close database. This method using often with VLDB for fast recovery large tablespace without restore big datafile. See on YouTube :  Switch to Image for Fast Recovery with RMAN

Often need copy of database for developers or testers. We can  copy database with RMAN or manually.  I showed with this video. How to copy database manually? See on YouTube :  How to copy database manually?

When we clone the Oracle Database then cloned database DBID is remains same of source database DBID.  If you want change DBID then this video is will be useful for you.

What happens on start database after changed deprecated parameter on Oracle Database 11g R2 (11.2.0.1). I want show with this video this situation. YouTube :   Changed deprecated parameter on Oracle Database 11g R2

I showed with this video, recovery of a  droped tablespace with  Oracle Recovery Manager (RMAN). I droped my tablepace (APPDATA) and restored, recovered this droped a tablespace from RMAN backups. I  think  this video  shall be  interesting for beginner of Oracle Backup and Recovery.  Please try this on test database, if you try on production, may be you loss your critical data.      Don't try on production database See on YouTube :  Recovery of a droped tablespace with RMAN.

With this video  I showed migration of database from file  system to ASM with  Oracle Enterprise Manager. I added two subtitle caption Azerbaijani - Azerbaijan and English - English on this video. With  selecting "CC" on this video you can use this captions. I think this video  is very helpful  for who is is want migrate database to ASM. Watch on youtube :   Oracle ASM - Migration to ASM with Oracle Enterprise Manager

With this video I showed, how to create externally authenticated users? When we are connect to Oracle Database, we can use "sqlplus / as sysdba" with SQL*Plus tool and connecting database with "SYS" user. I showed, how to we can connect to database with "sqlplus /" - without write username/password, with operating system (windows) users. This way is same for other operation systems. YouTube : http://www.youtube.com/watch?v=Vpgdg8hYsb8

How to convert physical standby database to snapshoot standby database? How to  use snapshot standby database? What is benefits of standby databases? I answered this questions with video. Blog : www.mahir-quluzade.com YouTube Channel: http://www.youtube.com/user/mahoora How to  create standby database? Please watch my video about creation standby databases : http://www.mahir-quluzade.com/2012/01/overview-data-guard-configuration.html

I  showed with  this video, how to enable Oracle Data Guard 11g new feature Active Data Guard with SQL*Plus and Data Guard Manager (DGMGRL)? And I showed a little test Active Data Guard. Blog : www.mahir-quluzade.com

I showed with this video, how to create oracle standby database on same host primary database and remote host. I created two physical standby database and created oracle data guard configuration with primary and this two standby databases. I think this video very helpful creator standby database and for newly of Oracle Data Guard creator. Watch on youtube :   http://www.youtube.com/watch?feature=player_embedded&v=5keahpkzLtM

I showed with this video, overview Oracle Database SQL - MERGE Statement .I Created two table and transformed data from first table to second table with  MERGE Command.I think this video shall be interesting, who working with Oracle Database SQL and Data Warehousing.  See more : Oracle® Database SQL Language Reference 11g - MERGE

You can download : Oracle Database 11 g  Release 2 (11.2.0.1.0) for Microsoft Windows (x64)  Oracle Database 11 g  Release 2 Grid Infrastructure (11.2.0.1.0) for Microsoft Windows (x64)  

I showed with this video,  how  to installing Oracle VirtualBox, and how to create virtual machine on VirtualBox. I installed Microsoft Windows 2008 R2 operating  system  on virtual machine.  VirtualBox  is very useful for testing all Oracle products. Usually I  using Oracle VirtualBox for testing Oracle Data Guard, Oracle RAC and other technologies.  Best  regards Mahir M. Quluzade. 

As know always we transport schema data to same database with other schema name or  other database. We using EXPDP/IMPDP  Data Pump utilities for transport schema. There have DUMPFILE option for generate data pump file in EXPDP and  when we import data from dump file, then using this option in IMPDP.   But we can transport schema without dump file. With this video  I showed how to can transport schema without DUMP file.  Regards  Mahir M. Quluzade