Ulfat`s DataBase Blog

Hi friends, on 1st December of 2012 I will attend to Azerbaijan Oracle User Group meeting and will talk about Oracle Streams in Azerbaijani. In the seminar I will demonstrate how Streams works, and there will be some FAQ part, such as : What is streams, why do you use streams, streams advantages, streams architecture and so on. Link: http://www.azeroug.org/?p=124

When I tried to use Oracle 11g`s create active standby feature weeks ago I faced below error, but after research it on Metalink I found solution. [oracle@db-server dbs]$ rman target / auxiliary sys/oracle@testdb_stby; Recovery Manager: Release 11.2.0.1.0 - Production on Sun Oct 28 17:11:39 2012 Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved. connected to target database: TESTDB (DBID=2580410479) connected to auxiliary database: TESTDB (not mounted) RMAN> DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE NOFILENAMECHECK DORECOVER SPFILE SET DB_UNIQUE_NAME="TESTDB_STBY" SET LOG_ARCHIVE_DEST_2="service=TESTDB_LIVE LGWR SYNC REGISTER VALID_FOR=(online_logfile,primary_role)" SET CONTROL_FILES='/oracle/product/11.2.0/oradata/testdb/control01.ctl'; Starting Duplicate Db at 28-OCT-12 using target database control file instead of recovery catalog allocated channel: ORA_AUX_DISK_1...

Today we will demonstrate migration NON ASM to ASM storage. We have already ASM instance and 2 asm diskgroups DATA and FLSHBK Our database name is mydb and it works Archivelog mode. Be sure  block change tracking  is disabled SQL> select status from v$block_change_tracking; STATUS ---------- DISABLED SQL> If no, disable it SQL> ALTER DATABASE DISABLE BLOCK CHANGE TRACKING; Database altered. SQL> Firstly check filenames on the database using this SQL: SQL> select member from v$logfile union select file_name from dba_data_files union select name from v$controlfile union select value from v$parameter where name='spfile' order by 1;  2    3    4    5    6    7 MEMBER -------------------------------------------------------------------------------- /home/oracle/oracle/product/10.2.0/db_1/dbs/spfilemydb.ora /home/oracle/oracle/product/10.2.0/oradata/mydb/control01.ctl /hom...