ORA-00353: log corruption near block change time – 11.2.0.3

Recently I came across "ORA-00353: log corruption near block change time" error. Errors in file /oracle/app/diag/rdbms/test/test/trace/test_ms00_54284.trc (incident=1490189): ORA-00353: log corruption near block change time ORA-00353: log corruption near block 4631374 change 263470473806052 time 04/16/2015 06:53:16 ORA-00312: online log 43 thread 3: '+REDO02/test/onlinelog/group_43.258.875922665' ORA-00312: online log 43 thread 3: '+REDO01/test/onlinelog/group_43.258.875922633' Incident details in: /oracle/app/diag/rdbms/test/test/incident/incdir_1490189/test_ms00_54284_i1490189.trc Thu Apr …

Advertisement

DBCA failing with “Diskgroup XXX is not compatible for database usage”

Today a friend of mine pinged me an error while he was trying to create database using DBCA from 11.2.0.3 RDBMS home on an exadata box.Screenshot of the error is below The error was easy to understand as compatible parameter set in the database initialization parameter was lower than the compatible.rdbms set for the diskgroup …

Internals of Active Dataguard – A must read

I found the below blog interesting and feel its a must read to enchance knowledge on Active DataGuard http://sai-oracle.blogspot.in/2012/11/internals-of-active-dataguard.html Happy reading 🙂

ORA-26723: user “XXXXX” requires the role “DV_GOLDENGATE_REDO_ACCESS”

While starting the extract on UAT DB env which had been recently moved to exadata we got the below error.As we had redo and archive logfiles on ASM, we used "TRANLOGOPTIONS DBLOGREADER" in extract parameter file. 2012-10-24 22:35:48 ERROR OGG-00446 Oracle GoldenGate Capture for Oracle, emos_cc.prm: Opening ASM file +RECO_UMO1/archivelog/2012_10_24/thread_1_seq_224.955.797517005 in DBLOGREADER mode: (26723) ORA-26723: …

Change in Database link – 11gR2

A little change in dblink from 11gR2 - SQL> conn anand/anand123 Connected. SQL> SQL> @db_link OWNER DB_LINK USERNAME HOST ------------------------------ ------------------------------ ------------------------------ ------------------------------ ANAND SCOTT_DBLINK SCOTT MATSTDBY SQL> select sysdate from dual@SCOTT_DBLINK; SYSDATE --------- 11-MAY-12 I login as sys and change scott schema's password - SQL> conn / as sysdba Connected. SQL> SQL> SQL> SQL> …

DB startup/shutdown error after downgrade from 11gR2 to 10gR2

I was asked to work on a 2-node RAC db which was downgraded to 10.2.0.5 from 11.2.0.3. While working, i had stopped the database using "shutdown immediate" command from sqlplus instead of srvctl. While start the db using srvctl - wdlab1: (matrix1) /u01/app/oracle/product/rdbms/10205> srvctl start database -d matrix_lab -o open PRKR-1001 : cluster database matrix_lab …

EXPDP – Smarter in 11gR2

I feel Oracle has made EXPDP utility more smarter by its releases.The below command fails on 10gR2 as "owner" is an unknown parameter for expdp. Correct syntax would be using SCHEMAS parameter in expdp. [oracle@localhost Desktop]$ expdp directory=DATA_PUMP_DIR dumpfile=full_feb16_scott.dmp logfile=full_feb16.log owner=scott LRM-00101: unknown parameter name 'owner' What happens when we try the same on 11gR2 …

Exporting tables from different Schemas using EXPDP – Revisited – version 11gR2

More than an year ago i had written https://aprakash.wordpress.com/2010/10/19/exporting-tables-from-different-schemas-using-expdp/ where in mentioned how to export tables from different schemas using the EXPDP in 10gR2. Using exp - "D:\>exp file= exp_test.dmp log=exp_test.log tables='scott.emp','hr.jobs' feedback=10" Using expdp D:\>expdp directory=DATA_PUMP_DIR dumpfile=expdp_test_1.dmp logfile=expdp_test_1.log schemas='scott','hr' include=TABLE:\"IN (\'EMP\', \'JOBS\')\" With the above expdp command the problem arises when tables with same …

Use DBMS_AUDIT_MGMT for purging audit files at OS level

Few of the times we have scenario where db logon fails with ORA-09925: Unable to create audit trail file.Mostly a weekly crontab would have been set to delete the trace files, audit files etc from the server. From 11gR2 oracle introduced and started supporting dbms_audit_mgmt for managing the various audit trail types like database audit …

set newname command made easier in 11gR2

From 11gR2 oracle introduced new options for "SET NEWNAME" command. 1.SET NEWNAME FOR DATAFILE and SET NEWNAME FOR TEMPFILE 2.SET NEWNAME FOR TABLESPACE 3.SET NEWNAME FOR DATABASE The following variables are introduced for SET NEWNAME from 11gR2 :- %b The file name remains same as the original. For example, if a datafile is named D:\oracle\oradata\matrix\test.dbf, …