Posts

Showing posts from November, 2013

ORA-00600: [2730], [331] after Switchover in New Standby Database

If you found errors  in the log file as:- Errors in file /data1/test/diag/diag/rdbms/art02/art02/trace/art02_ora_29254.trc  (incident=8785): ORA-00600: internal error code, arguments: [2730], [331], [1], [4], [110], [110], [512], [512], [], [], [], [] Incident details in: /data1/test/diag/diag/rdbms/art02/art02/incident/incdir_8785/art02_ora_29254_i8785.trc RCA :- This happens due to Unmatched compatibility setup on the primary and the standby.The value of compatible parameter in primary and standby is different. Solution :- 1. Change the value of the compatible parameter on standby SQL> ALTER SYSTEM SET COMPATIBLE= <same as value of primary> SCOPE=SPFILE; If you are using pfile then edit pfile and change the value of the parameter *. COMPATIBLE= <same as value of primary> 2. Shutdown and Restart the standby database in mount stage 3. Restart Managed recovery process.

ORA-16191: Primary log shipping client not logged on standby

The error appears in the ALRET log file AS :-  Check that the primary and standby are using a password file and remote_login_passwordfile is set to SHARED or EXCLUSIVE, and that the SYS password is same in the password files. returning error ORA-16191 ORA-16191 -Primary log shipping client not logged on standby  Solution :-  1.Defer the remote archival destination (log_archive_dest_state_n) parameter in primary. In case of RAC defer LOG_ARCHIVE_DEST_STATE_n in all nodes. 2.check parameter REMOTE_PASSWORDFILE is set to either EXCLUSIVE or SHARED on the both database . 3.Delete the old password file and create the new one for both the DBs.In case of RAC shutdown all instance of standby before recreating the password file by below command :- orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=sys entries=5 force=y ignorecase=Y  4. set the parameter SEC_CASE_SENSITIVE_LOGON=FALSE on both DBs. 5.Enable the remote archival destination (log_archive_dest_state_n) parameter in

ORA-01153: an incompatible media recovery is active standby database oracle

ORA-01153: an incompatible media recovery is active SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;  2 ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE * ERROR at line 1: ORA-01665: control file is not a standby control file SQL> SELECT database_role FROM v$database; DATABASE_ROLE ---------------- PRIMARY SQL> ALTER DATABASE CONVERT TO PHYSICAL STANDBY; ALTER DATABASE CONVERT TO PHYSICAL STANDBY * ERROR at line 1: ORA-01126: database must be mounted in this instance and not open in any instance SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount ORACLE instance started. Total System Global Area  535662592 bytes Fixed Size                  1345376 bytes Variable Size             331352224 bytes Database Buffers          197132288 bytes Redo Buffers                5832704 bytes Database mounted. SQL> ALT