Jump to content

killerDBA

Members
  • Content count

    7
  • Joined

  • Last visited

Community Reputation

0 Neutral

About killerDBA

  • Rank
    Newbie
  1. killerDBA

    Logical standby apply failed

    Hello Experts, My logical standby apply is failing with below error LOGSTDBY Apply process AS03 started with server id=3 pid=85 OS id=28966974 LOGMINER: Begin mining logfile for session 1 thread 1 sequence 1287562, /archivelog/newsis77/1_1287562_735413983.dbf LOGMINER: End mining logfile for session 1 thread 1 sequence 1287562, /archivelog/newsis77/1_1287562_735413983.dbf Errors in file /oracle/product/diag/rdbms/newsis77/newsis77/trace/newsis77_ms00_34078918.trc (incident=34236): ORA-00600: internal error code, arguments: [2619], [1287563], [], [], [], [], [], [], [], [], [], [] Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. krvxerpt: Errors detected in process 78, role reader. krvxmrs: Leaving by exception: 600 Errors in file /oracle/product/diag/rdbms/newsis77/newsis77/trace/newsis77_ms00_34078918.trc: ORA-00600: internal error code, arguments: [2619], [1287563], [], [], [], [], [], [], [], [], [], [] LOGSTDBY status: ORA-00600: internal error code, arguments: [2619], [1287563], [], [], [], [], [], [], [], [], [], [] LOGMINER: session#=1 (Logical_Standby$), reader MS00 pid=78 OS id=34078918 sid=367 stopped Errors in file /oracle/product/diag/rdbms/newsis77/newsis77/trace/newsis77_ms00_34078918.trc: ORA-00600: internal error code, arguments: [2619], [1287563], [], [], [], [], [], [], [], [], [], [] LogMiner process death detected LOGSTDBY: logminer process death detected, exiting. LOGSTDBY: logminer process died with status 600 Please help, it is 11.2.0.4 on AIX
  2. killerDBA

    Index missing in Logical standby

    Wow!..Don!...It really helps, Thank you so much... Best Regards, KillerDBA.
  3. killerDBA

    Index missing in Logical standby

    Dear Experts, Previously a table was existing on both primary and logical standby with index on one of the column I have recreated this table(I exported the table and imported with 'indexes=no' option on primary) I have manually created the index(with logging option) on the primary table but which is not getting reflected on logical standby. what could be the reason? or is this a logical standby feature ?..can I manually create the same index on logical standby? Please help
  4. killerDBA

    Logical stand by out of Sync

    Dear Don... Thanks for your prompt reply, Let me check the options which you have suggested. Best Regards,
  5. killerDBA

    Logical stand by out of Sync

    Hello Experts, Currently we are facing a logical stand by(11.2.0.4) out of sync issue. Current situation 1. Both primary and logical standby is running on same server(may not be relevant in this case, still..) 2. The last applied SCN on the Logical stand by was on 2nd_March-2017(The team did not notice the stand by sql apply has stopped after a restart) 3. The archive logs from March 2nd to 26th have been lost. Is there any possibility that we can re-sync the primary and logical stand by again or is it a clear logical stand by rebuild scenario? Any scope for 'instantiate_table' option? Please advice, Thanks
  6. killerDBA

    AIX TL Upgradation for Oracle 11gr2 - 2 nodes

    Dear Geelwortel, Thank you so much for the prompt reply.. Cheers!
  7. Hello Experts, Can anybody just help me on this? The operating system Team wants to perform AIX TL upgrade for each node in a 11gr2 RAC system(2 nodes). They wants to know whether the AIX TL upgrade can be done for for each node separately without impacting the service. OR Bring down RAC system completely(both nodes) and perform AIX TL upgrade on each node , then bring up the RAC system. Kindly suggest... Regards,
×