Ulfat`s DataBase Blog

Hi, today I will post interview with young beautiful woman, Oracle 10g and 11g OCM certified - Lucia Hustatyova. She is one of the seldom DBA woman which have had OCM 10g and 11g certified. After graduating from high school in Bardejov Stockel Leonard continued his studies at the University of Pavol Jozef Safarik in Kosice, the first scientific maths, later to study maths and science. Thanks opportunities in Kosice as a student she worked at various companies for part-time positions. The last six years working as a database consultant at famous company in Slovakia . Q: Lucia, when did you pass that certified exam and where did you do it? A: Oracle 10g OCM in Slovakia 2011, 11g also Slovakia but in 2012. Q: How many years have you had experience with Oracle? A: 6 years. Q: What is your job responsibility and where currently are you in charge? A: I am database admin at leader IT company - mainly practical stuff but sometimes my colleagues need consultations duri...

Example of recovery database until time. For checking after recovery I am going to create simple table with one row SQL> create user ulfet identified by ulfet; User created. SQL> grant dba to ulfet; Grant succeeded. SQL> conn ulfet/ulfet Connected. SSQL> create table test1 (id number); Table created. SQL> insert into test1 values(1); 1 row created. SQL> commit; Commit complete. Now taking backup. RMAN> backup database plus archivelog; --note date SQL> select systimestamp from dual; SYSTIMESTAMP --------------------------------------------------------------------------- 13-JAN-16 11.03.34.646076 AM +04:00 --dropping table SQL> drop table ulfet.test1; Table dropped. SQL> select systimestamp from dual; SYSTIMESTAMP --------------------------------------------------------------------------- 13-JAN-16 11.04.40.428868 AM +04:00 SQL> --start recovery process --firstly start...

Today while duplication database I faced strange error: RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 07/09/2013 16:02:16 RMAN-06136: ORACLE error from auxiliary database: ORA-01503: CREATE CONTROLFILE failed ORA-01130: database file version 11.1.0.0.0 incompatible with ORACLE version 11.0.0.0.0 ORA-01110: data file 1: '/u01/app/oracle/oradata/DUPLPROD/system01.dbf' I checked all actions and tried again, but result was same. Error happened creation control file. Let me note that I used to duplication on the same host and Oracle version 11.1.0.7.0 SQL> select * from v$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production PL/SQL R...

So, finally Oracle introduced Oracle database 12c (12.1.0.1). You can easily download it from oracle`s official site : http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html For now only for Linux and Solaris platform`s download is available, soon for windows platform will have.

Today my friend asked me what is the different between kill session and disconnect session. After researching I found useful information and here I`m going to share briefly. Using Disconnect Session clause to disconnect the current session by destroying the dedicated server process. Using Kill Session clause let you mark a session as terminated, release locks. Example: SQL>ALTER SYSTEM DISCONNECT SESSION 'sid,serial#'; SQL>ALTER SYSTEM KILL SESSION 'sid,serial#'; For more details please refer to :  http://oracletempspace.wordpress.com/2011/04/20/example-alter-sytem-disconnect-vs-alter-system-kill-for-currently-connected-sessions/

Today I faced with new ORA error. After solving I want to share this experience with yours. So, today 5`th datafile of my database was corrupted (/u01/app/oracle/oradata/ulfet_db/example01.dbf). After recover via RMAN I saw strange error. RMAN> recover datafile 5 block 443; Starting recover at 24-MAR-13 using channel ORA_DISK_1 channel ORA_DISK_1: restoring block(s) channel ORA_DISK_1: specifying block(s) to restore from backup set restoring blocks of datafile 00005 channel ORA_DISK_1: reading from backup piece /u01/app/oracle/flash_recovery_area/ULFET_DB/backupset/2013_03_24/o1_mf_nnndf_TAG20130324T223233_8nykp220_.bkp channel ORA_DISK_1: piece handle=/u01/app/oracle/flash_recovery_area/ULFET_DB/backupset/2013_03_24/o1_mf_nnndf_TAG20130324T223233_8nykp220_.bkp tag=TAG20130324T223233 channel ORA_DISK_1: restored block(s) from backup piece 1 channel ORA_DISK_1: block restore complete, elapsed time: 00:00:03 starting media recovery media recovery complete, elapsed ti...

Today I will show you how to rename existing database name. Before it take backup of your database and also please note that this step will change only database name not dbid. My database name is prod2 and oracle version is 11g R2. I will change it to prod name. SQL> select name from v$database; NAME --------- PROD2 SQL> select * from v$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production PL/SQL Release 11.2.0.1.0 - Production CORE    11.2.0.1.0      Production TNS for Linux: Version 11.2.0.1.0 - Production NLSRTL Version 11.2.0.1.0 - Production SQL> [oracle@localhost ~]$ uname -n localhost.localdomain [oracle@localhost ~]$ more /etc/redhat-release  Red Hat Enterprise Linux Server release 5.5 (Tikanga) Firstly shutdown database and open it on mount mode. [oracle@localhost ~]$ sql SQL*Plus:...