0 Comments

How To Recover Table from Drop/Truncate/Delete done on Primary using Flashback on a Standby 5 (3)

Recover a Table from Drop/Truncate/Delete done on Primary using Flashback on a Standby In this article, we will learn steps needed to perform recovery of User wrong operation like delete/drop/truncate action on the production table without using Restore and Recover command on PRIMARY DATABASE.Recovering the table from the standby database will also eliminate any required […]

 465 total views,  4 views today

3 Comments

Resolve ORA-10562,10564,01110,10561,00600 at Standby database 4.7 (21)

Few days back, we got SYSAUX tablespace error at DBGURU STANDBY database and the error was – Errors in file /u02/app/oracle/diag/rdbms/dbguru/dbguru/trace/dbguru_mrp0_26696.trc:ORA-10562: Error occurred while applying redo to data block (file# 2, block# 3052738)ORA-10564: tablespace SYSAUXORA-01110: data file 2: ‘/u02/app/oracle/oradata/DBGURU_STAND/datafile/sysaux.dbf’ORA-10561: block type ‘TRANSACTION MANAGED INDEX BLOCK’, data object# 46394ORA-00600: internal error code, arguments: [kdxlin:bad itl index], […]

 1,543 total views,  4 views today

Spread the love