Friday 30 November 2012

ORA-16047: DGID mismatch between destination setting and standby



ORA-16047: DGID mismatch between destination setting and standby



SQL> show parameter config

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
dg_broker_config_file1               string      /u01/app/oracle/orcl11g/
                                                 11.2.0/dbs/dr1inc04p.dat
dg_broker_config_file2               string      /u01/app/oracle/orcl11g/
                                                 11.2.0/dbs/dr2inc04p.dat
log_archive_config                   string





See the last parameter was not set on standby database that is why i was receiving the error.

ORA-16047: DGID mismatch between destination setting and standby

Reason: the log archive config parameter was not set on standby db.

solution: set the parameter 


Thursday 29 November 2012

ORA-07217: sltln: environment variable cannot be evaluated.




In Linux or Unix OS Use  export ORACLE_SID='SID_NAME'
                                           export ORACLE_HOME='HOME_PATH'


Permanent Fix in Linux OS 

                                  Edit  /home/oracle/.bash_profile
                     add the following entries

                    ORACLE_HOME=/u01/app/rdbms_9.2.0.5
                      ORACLE_SID=orcl1

                    export ORACLE_HOME
                    export ORACLE_SID


 if in windows
                                   set ORACLE_SID='SID_NAME'
                                   set ORACLE_HOME='HOME_PATH'

ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr]

SQL>Startup mount ;

SQL>Show parameter control_files


Query 1

------------

sql>select a.member,a.group#,b.status from v$logfile a ,v$log b where a.group#=b.group# and b.status='CURRENT'


Note down the name of the redo log


SQL>Shutdown abort ;


Take a OS Level back of the controlfile (This is to ensure we have a backup of current state of controlfile)


SQL>Startup mount ;


SQL>recover database using backup controlfile until cancel ;


Enter location of redo log shown as current in Query 1 when prompted for recovery


Hit Enter


SQL>Alter database open resetlogs ;