Online DBA

<<Back to Oracle DataGuard Main Page How to Resolve : ORA-16698: LOG_ARCHIVE_DEST_n parameter set for object to be added DGMGRL>  ADD DATABASE "ORCL3PS" AS CONNECT IDENTIFIER IS "ORCL3PS"; Error: ORA-16698: LOG_ARCHIVE_DEST_n parameter set for object to be added Cause: One of log_archive_dest_n parameter is set for service  ORCL3PS in either primary or standby or both databases Solution: Identify the log_archive_dest_n parameter which is set to value  ORCL3PS  and rest it. SQL> show parameter dest_4 log_archive_dest_4                   string      SERVICE=ORCL3PS.EU.MERCKGROUP.C                                         ...

<<Back to DB Administration Main Page In this post NID utility is used to change both database name together with DBID About NID and its Syntax: NID utility is used to change Database Name , Database Identifier (DBID) both or just any one of them. You can invoke the command as below as user oracle after setting the environment of the database you want to work on. Change DB Name as well as DBID $nid TARGET=SYS DBNAME=TEST1D Change DB Name  Only $nid TARGET=SYS DBNAME=TEST1D SETNAME=YES Check out the post How to Rename Oracle Database Using NID Utility if want to change the database name only. Change DBID Only $nid TARGET=SYS  $nid help=y DBNEWID: Release 11.2.0.4.0 - Production on Mon Mar 2 11:29:26 2020 Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved. Keyword            Description                       ...

<<Back to Oracle DataGuard Main Page To use sqlplus instead broker follow the steps on this blog HOW TO CONVERT PHYSICAL STANDBY DATABASE TO SNAPSHOT STANDBY DATABASE USING SQLPLUS HOW TO CONVERT PHYSICAL STANDBY DATABASE TO SNAPSHOT STANDBY DATABASE USING DGMGRL- Dataguard Broker Utility Current Configuration Primary DB: ORCL1PP Standby DB: ORCL1PS Connect to primary database  over listener dgmgrl sys/xxxxx@ORCL1PP.ORACLE.COM Disable Fast Start Failover if enabled DGMGRL> DISABLE FAST_START FAILOVER; Change to maximum performance: DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MAXPERFORMANCE; Convert to snapshot standby DGMGRL> CONVERT DATABASE ORCL1PS TO SNAPSHOT STANDBY; CONVERING BACK THE SNAPSHOT STANDBY TO PHYSICAL STANDBY USING DGMGRL- Dataguard Broker Utility Connect to primary database  over listener dgmgrl sys/xxxxx@ORCL1PP.ORACLE.COM Convert to standby DGMGRL> CONVERT DATABASE ORCL1PS TO PHYSICAL STANDBY; Change back...

<<Back to Oracle DataGuard Main Page HOW TO CONVERT PHYSICAL STANDBY DATABASE TO SNAPSHOT STANDBY DATABASE MANUALLY USING SQLPLUS To open the physical standby database as snapshot standby, Flashback must be on. If not already set, set db_recovery_file_dest and db_recovery_file_dest_size parameter to enable the flashback. SQL> alter system set db_recovery_file_dest='/ora_data/orcl/flash'; System altered. SQL>alter system set db_recovery_file_dest_size=30G; System altered. SQL> recover managed standby database cancel; Media recovery complete. SQL> shutdown immediate; SQL> startup mount; SQL> alter database flashback on; Database altered. SQL> select flashback_on from v$database; FLASHBACK_ON ------------------ YES SQL> ALTER DATABASE CONVERT TO SNAPSHOT STANDBY; Database altered. SQL> Select NAME, OPEN_MODE, GUARD_STATUS, DATABASE_ROLE from v$database; NAME      OPEN_MODE     ...

<<Back to Oracle DataGuard Main Page HOW TO ACTIVATE PHYSICAL STANDBY DATABASE WHEN PRIMARY IS NO MORE AVAILABLE If you have lot the primary database and you want to activate the physical standby database as primary you can follow the steps below. SQL> RECOVER MANAGED STANDBY DATABASE CANCEL; Media recovery complete. SQL> SHUT IMMEDIATE SQL> STARTUP MOUNT SQL> SELECT OPEN_MODE,PROTECTION_MODE,DATABASE_ROLE FROM V$DATABASE; OPEN_MODE            PROTECTION_MODE      DATABASE_ROLE -------------------- -------------------- ---------------- MOUNTED              MAXIMUM PERFORMANCE  PHYSICAL STANDBY SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH; Database altered. SQL> ALTER DATABASE ACTIVATE PHYSICAL STANDBY DATABASE; Database altered. SQL> SELECT OPEN_MODE,PROTECTION_MODE,DATABASE_ROLE...

<<Back to DB Administration Main Page ORA-00068: invalid value 0 for parameter _query_execution_time_limit, must be between 1920170603 and 7041645 looking into the alertlog found below errors Wed Feb 19 14:47:27 2020 WARNING: Oracle executable binary mismatch detected.  Binary of new process does not match binary which started instance issue alter system set "_disable_image_check" = true to disable these messages Wed Feb 19 14:47:27 2020 WARNING: Oracle executable binary mismatch detected.  Binary of new process does not match binary which started instance issue alter system set "_disable_image_check" = true to disable these messages Wed Feb 19 14:47:49 2020 Tried to check the rman config also ended with errors RMAN> connected to recovery catalog database recovery catalog schema release 19.04.00.00. is newer than RMAN release RMAN> echo set on RMAN> show all; RMAN-00571: ========================================================...

<<Back to DB Administration Main Page The program can't start because perl510.dll is missing from your computer. While Patching Oracle 12.1.0.2 on windows Solution:  Step1> Note down the value of  PERL5LIB   echo %PERL5LIB% Step2> unset PERL5LIB and retry  SET PERL5LIB= set PATH=%ORACLE_HOME%\perl\bin;%PATH% Step3>  Set the path of  PERL5LIB variable , as it was before.