Ulfat`s DataBase Blog

Today after restore and recovery prod database on test environment I faced with strange error: ORA-16072: a minimum of one standby database destination is required. My database environment : OS: OEL 6.5 DB: 11.2.0.4 After recovery database stays on MOUNT mode and could not open it. RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 11/27/2015 12:55:01 RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 9573 and starting SCN of 556583605 RMAN> alter database open resetlogs; RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure ...

Today I will show you how to handle ORA-16053 error --Check maximum sequence number of archive log SQL> select max(sequence#) from v$archived_log; MAX(SEQUENCE#) -------------- 36 --Now check parameter SQL> col destination for a70 SQL> select dest_id, status, destination, error from v$archive_dest; DEST_ID STATUS DESTINATION ERROR ---------- --------- ---------------------------------------------------------------------- ----------------------------------------------------------------- 1 BAD PARAM ORA-16053: DB_UNIQUE_NAME is not in the Data Guard Configuration 2 VALID PROD 3 INACTIVE 4 INACTIVE 5 INACTIVE 6 INACTIVE 7 INACTIVE 8 INACTIVE 9 INACTIVE 10 INACTIVE 11 VALID /u01/app/oracle/product/11.0.1/db_1/dbs/arch 11 rows selected. Here is error which means db_unique_name not setted o...

Sometimes we face "[INS-32025] The chosen installation conflicts with software already installed in the given Oracle home" error when we reinstall Oracle home. To fix this error, go to oraInventory folder. cd /u01/oraInventory/ContentsXML --this is my folder edit inventory.xml any editor remove below line: <HOME NAME="OraDb11g_home1" LOC="/u01/oracle/product/11.2.0/dbhome_1" TYPE="O" IDX="1"/> execute runInstaller again

I requested to gather most used tables list in production database. After investigation I found some advice and of course metalink note. Here is OTN link:   https://forums.oracle.com/forums/thread.jspa?threadID=511661 Use below query. SQL> SELECT ROWNUM AS RANK, Seg_Lio.* FROM ( SELECT St.Owner, St.Obj#, St.Object_Type, St.Object_Name, St.VALUE, 'LIO' AS Unit FROM V$segment_Statistics St WHERE St.Statistic_Name = 'logical reads' ORDER BY St.VALUE DESC) Seg_Lio WHERE owner not in ('SYS', 'SYSTEM') and object_type='TABLE' and ROWNUM <= 20 UNION ALL SELECT ROWNUM AS RANK, Seq_Pio_r.* FROM ( SELECT St.Owner, St.Obj#, St.Object_Type, St.Object_Name, St.VALUE, 'PIO Reads' AS Unit FROM V$segment_Statistics St WHERE St.Statistic_Name = 'physical read...