-: For Single Instance :- Adding Online Redo log groups - Single Instance: #Groups to be added are group#4, group#5, group#6. SQL> set lines 300 pages 3000 SQL> col member for a70 SQL> select group#,type,member from v$logfile order by 1; GROUP# TYPE    MEMBER ------ ------- ----------------------------------------------      1 ONLINE  D:\RUPESH\SETUPS\TEST\TEST\ONLINELOG\REDO1.LOG      2 ONLINE  D:\RUPESH\SETUPS\TEST\TEST\ONLINELOG\REDO2.LOG      3 ONLINE  D:\RUPESH\SETUPS\TEST\TEST\ONLINELOG\R ..read more

#Error while dropping less than two redo log groups. SQL> alter database drop logfile group 1; alter database drop logfile group 1 * ERROR at line 1: ORA-01567: dropping log 1 would leave less than 2 log files for instance test (thread 1) ORA-00312: online log 1 thread 1: 'D:\RUPESH\SETUPS\TEST\TEST\ONLINELOG\REDO01.LOG' Cause:  You can not drop all the groups and keep only one group. Minimum two redo log groups are required for the instance.  Solution: Add more redo log groups and drop the existing ones if you want to drop it. #First check the status of the re ..read more

#Error while dropping current redo log group members SQL> alter database drop logfile group 3; alter database drop logfile group 3 * ERROR at line 1: ORA-01623: log 3 is current log for instance test (thread 1) - cannot drop ORA-00312: online log 3 thread 1: 'D:\RUPESH\SETUPS\TEST\TEST\ONLINELOG\REDO03.LOG' Cause:  You can not drop current or active redo log group members. Solution: Switch 2-3 logs and change the status of current or active to inactive and then drop the redo log group members. #First check the status of the redo log group members. SQL> select group ..read more

LNS, NSS, NSA, TT are the redo transport processes in Oracle Dataguard for SYNC and ASYNC mode. 1) NSS - Network Server SYNC Process 2) NSA - Network Server ASYNC Process 3) TT - Redo Transport Slave Process 1) NSSn: This transfers the redo from current online redo logs to remote standby destinations configured for SYNC transport. Here, n is 1-9 or A. 2) NSA: This transfers the redo from current online redo logs to remote standby destinations configured for ASYNC transport.  3) TTnn: This ships the redo from current online and standby redo logs to remote st ..read more

What is Standby Redo Log or SRLs? Why do we need Standby Redo Logs ? Standby redo logs or SRLs are used only when the database is running in the standby role. Standby Redo logs (SRLs) are not required if the database role is Primary, but these can be created in Primary database since these are required after switchover operation when Primary database becomes standby database. Standby redo logs can be created during standby configuration or after the standby creation. Standby Redo Logs are required to avoid data loss in case of Primary DB server outages like failover situation. From ..read more

#Error while exporting data into multiple dumps. C:\Windows\System32>expdp directory=DIR_TEST schemas=test dumpfile=schema_%U.dmp logfile=schema.log filesize=10k Export: Release 19.0.0.0.0 - Production on Fri Mar 15 20:23:53 2024 Version 19.16.0.0.0 Copyright (c) 1982, 2022, Oracle and/or its affiliates.  All rights reserved. Username: test Password: Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production ORA-39001: invalid argument value ORA-39000: bad dump file specification ORA-31618: FILESIZE is outside valid range of 40KB to 16TB Ca ..read more

  Environment Configuration Details: Operating System: Oracle Linux 6.3 64 Bit Oracle Database Software version to be installed : 12.1.0.2 RAC: YES (2 - Node Setup) DNS: No To install Oracle RDBMS 12c RAC, you must install Oracle Grid Infrastructure (Oracle Clusterware and Oracle ASM) 12c first on your cluster.  Refer below link Step by Step Installation and Configuration of Oracle 12c RAC on Linux 6 - Part - I to install GRID 12c RAC software step by step. Steps to install Oracle 12c RAC Database Software  -- Par ..read more

Environment Configuration Details: Oracle Grid Infrastructure Software version: 12.1.0.2 RAC: YES No. Of Nodes: 2-Node RAC Cluster Operating System: Oracle Linux 6.3 64 Bit Points to be checked before starting RAC installation prerequisites: 1) Am I downloading GRID software of correct version? 2) Is GRID Infrastructure certified on current Operating System ? 3) Is my GRID software architecture 32 bit or 64 bit ? 4) Is Operating System architecture 32 bit or 64 bit ? 5) Is Operating System Kernel Version compatible with software to be installed? 6) Is my server runlevel ..read more

The error "ORA-39710: The database mode conflicts with the connection type" usually occurs when your instance is started is upgrade mode and another user other than SYSDBA or SYSOPER roles is trying to connect to the database which will face this error. Below command will let you know your instance is in RESTRICTED mode or not. SQL> select instance_name,status,logins from v$instance; INSTANCE_NAME    STATUS       LOGINS ---------------- ------------ ---------- pr               OPEN  ..read more

The error "ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege" usually occurs when your instance is running is RESTRICTED mode and another user other than SYS is trying to connect to the database which will face this error. Below command will let you know your instance is in RESTRICTED mode or not. SQL> select instance_name,status,logins from v$instance; INSTANCE_NAME    STATUS       LOGINS ---------------- ------------ ---------- pr               OPEN        &nbs ..read more