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 … Continue reading ORA-00353: log corruption near block change time – 11.2.0.3

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 … Continue reading DBCA failing with “Diskgroup XXX is not compatible for database usage”

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: … Continue reading ORA-26723: user “XXXXX” requires the role “DV_GOLDENGATE_REDO_ACCESS”

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> … Continue reading Change in Database link – 11gR2

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 … Continue reading DB startup/shutdown error after downgrade from 11gR2 to 10gR2

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 … Continue reading EXPDP – Smarter in 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 … Continue reading Exporting tables from different Schemas using EXPDP – Revisited – version 11gR2

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 … Continue reading Use DBMS_AUDIT_MGMT for purging audit files at OS level

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, … Continue reading set newname command made easier in 11gR2