ORA-00752 on standby and DB_ULTRA_SAFE parameter

Posted by oraclue on January 11, 2010 · 1 Comment 

Alert file from standby database got following messages: ORA-00752: recovery detected a lost write of a data block ORA-10567: Redo is inconsistent with data block (file# 8, block# 351475) ORA-10564: tablespace TD_DATA ORA-01110: data file 8: ‘+TD_DATA/test/datafile/test01.dbf’ ORA-10561: block type ‘TRANSACTION MANAGED DATA BLOCK’, data object# 105684 and second part ORA-10877: error signaled in parallel … Read more

Filed under Troubleshooting

On Database Trigger and current schema issue

Posted by oraclue on January 6, 2010 · 3 Comments 

I run into this issue few months ago: Login as sysdba bash-3.2$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Tue Jan 5 15:13:49 2010 Copyright (c) 1982, 2009, Oracle.  All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production With the Partitioning, OLAP, Data Mining and Real Application … Read more

Filed under Troubleshooting, Uncategorized

Tracing Oracle Data Guard

Posted by oraclue on January 5, 2010 · 2 Comments 

Data Guard Broker (DGMGRL) can connect to database using following options: -echo -silent -xml -debug -logfile So if I need to run dgmgrl command in debug mode I would execute following : dgmgrl -debug / or -bash-3.2$ dgmgrl -debug sys/secret@test DGMGRL for Linux: Version 11.2.0.1.0 – 64bit Production Copyright (c) 2000, 2009, Oracle. All rights … Read more

Filed under Troubleshooting