Ulfat`s DataBase Blog

Today I want to show you how to enable archivelog mode on Oracle 11g R2 RAC environment. 1. Checking log_mode: [oracle@rac1 acfs]$ export ORACLE_SID=RAC1 [oracle@rac1 acfs]$ sqlplus "/as sysdba" SQL> archive log list Database log mode No Archive Mode Automatic archival Disabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 9 Current log sequence 10 SQL> [oracle@rac2 acfs]$ export ORACLE_SID=RAC2 [oracle@rac2 acfs]$ sqlplus "/as sysdba" SQL*Plus: Release 11.2.0.1.0 Production on Mon Oct 13 18:13:53 2014 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options SQL> select name, open_mode, log_mode from v$database; NAME OPEN_MODE LOG_MODE --------- -...

Today after restarting primary and standby database servers I faced with ORA-16810 error DGMGRL> show configuration; Configuration - DGMANAGER   Protection Mode: MaxAvailability   Databases:     XXXPROD - Primary database       Error: ORA-16810: multiple errors or warnings detected for the database     XXXSTND - Physical standby database       Error: ORA-01017: invalid username/password; logon denied Fast-Start Failover: DISABLED Configuration Status: ERROR I did not understand what and why it happened... After research I found that it was related password file of standby side. DGMGRL> show database 'XXXPROD'   Database - XXXPROD   Role:            PRIMARY   Intended State:  TRANSPORT-ON   Instance(s):     FCDBPROD       Error: ORA-16737: the redo transport service for standby database "XXXSTND" has an error ...

Today when I tested dataguard configuration I saw ORA-16826 error. DGMGRL> show configuration; Configuration - DGMANAGER   Protection Mode: MaxPerformance   Databases:     PROD   - Primary database     PRODST - Physical standby database       Warning: ORA-16826: apply service state is inconsistent with the DelayMins property Fast-Start Failover: DISABLED Configuration Status: WARNING DGMGRL> This is because I managed my standby database with NODELAY option. ALTER DATABASE RECOVER MANAGED STANDBY DATABASE  THROUGH ALL SWITCHOVER DISCONNECT  NODELAY; To fix this cancel recover managed: SQL> alter database recover managed standby database cancel; Database altered. Start with current logfile option: SQL> alter database recover managed standby database using current logfile disconnect; Database altered. Try again DGMGRL> show configuration; Configuration - DGMANAGER   Pr...

Hello, Today I want to share my experience about online patching. Download needed patch : https://support.oracle.com For tutorial I got p16928674_112030_Generic.zip file. 1. Go to $ORACLE_HOME/Opatch dir and call opatch with parameters [oracle@dbserver OPatch]$ pwd /u01/app/oracle/product/11.2.0/db_1/OPatch [oracle@dbserver OPatch]$ ./opatch lsinventory Invoking OPatch 11.2.0.1.7 Oracle Interim Patch Installer version 11.2.0.1.7 Copyright (c) 2011, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/11.2.0/db_1 Central Inventory : /u01/app/oraInventory from : /etc/oraInst.loc OPatch version : 11.2.0.1.7 OUI version : 11.2.0.3.0 Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2014-10-08_11-53-07AM.log Lsinventory Output file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2014-10-08_11-53-07AM.txt -------------------------...