Monthly Archives: April 2013

ORA-00600: How to recover and open the database if the archive log required for recovery is missing.

How to recover and open the database if the archive log required for recovery is missing. ORA-00600: internal error code, arguments: [4194], [17], [9], [], [], [], [], [] Tue OCT 16 12:45:55 2008 Errors in file /u01/XSCLFYDB/admin/XSCLFY/bdump/xsclfy_smon_24975.trc: ORA-00600: internal … Continue reading

Posted in Oracle | Tagged , , | 2 Comments

Oracle Database Standby Database Failover for Oracle 10g

Step 1. If the standby database is in managed recovery mode, it will need to be cancelled and the instance shutdown using the IMMEDIATE option: SQL> recover managed standby database cancel; Media recovery complete. SQL> shutdown immediate ====================================================== Step 2. … Continue reading

Posted in Oracle | Tagged | Leave a comment

ORA-04031,ORA-06508,RMAN-00554,RMAN-06429

ORA-04031_ORA-06508_RMAN-00554_RMAN-06429 ORACLE error from target database: ORA-04031: unable to allocate 41152 bytes of shared memory (“shared pool”,”DBMS_RCVMAN”,”PL/SQL MPCODE”,”BAMIMA: Bam Buffer”) ORA-06508: PL/SQL: could not find program unit being called: “SYS.DBMS_RCVMAN” error executing package DBMS_RCVMAN in TARGET database RMAN-00571: =========================================================== RMAN-00569: … Continue reading

Posted in Oracle | Tagged , , , | Leave a comment

RMAN-06059: expected archived log not found, lost of archived log compromises recoverability

Starting backup at 04-JUN-12 current log archived released channel: t1 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of backup command at 06/04/2012 10:36:16 RMAN-06059: expected archived log not found, lost of archived log compromises … Continue reading

Posted in Oracle | Tagged | 1 Comment

Oracle Database Physical standby Starting and Shutting down

Starting Up a Physical Standby Database ======================================== 1.Start and mount the physical standby database: ————————————————- SQL> STARTUP MOUNT; 2.Start Redo Apply or real-time apply: ————————————– To start Redo Apply, issue the following statement: ————————————————— SQL> ALTER DATABASE RECOVER MANAGED STANDBY … Continue reading

Posted in Oracle | Tagged | Leave a comment

ORA-09817 IBM AIX RISC System/6000 Error: 89

ORA-09817 IBM AIX RISC System/6000 Error: 89 Oracle 11.2.0.2 AIX 5.3 Related Errors:- Mon Nov 05 18:33:51 2012 ARC3 started with pid=30, OS id=954622 ARC1: Becoming the ‘no FAL’ ARCH ARC1: Becoming the ‘no SRL’ ARCH ARC2: Becoming the heartbeat … Continue reading

Posted in Oracle | Tagged | Leave a comment

ORA-1652

The quick fix for temp tablespace issue (ORA-1652) which is to add temporary datafile and then find root cause of temp tablespace issue. Extent – An extent is a logical unit of database storage space allocation made up of a … Continue reading

Posted in Oracle | Tagged | Leave a comment