Let’s have look on the commands are used for “RMAN Parallel Backup”. Run the backup RMAN> run { allocate channel c1 type disk; allocate channel c2 type disk; backup (datafile 1,2,3 channel c1) (archivelog all channel c2); } Create more allocate channel RMAN> run { allocate channel c1 type disk; allocate channel c2 type disk; backup (database channel c1) (archivelog all channel c2); } Set the parallelism parameter and run the backup again RMAN> configure device type disk parallelism 3; RMAN> backup (datafile 1,2) (datafile 3,4) (archivelog all); Thought of the day.. “You will ..read more

To upgrade from Oracle 11gR2 to Oracle 18c/19c, we need to remove Streams setup. For detailed steps, refer to the section “Removing an Oracle Streams Configuration” in the Oracle Streams Concepts and Administration Guide specific for the Oracle release from which you are removing. It is observed that even though there are no Streams Processes or Rules. sqlplus /nolog connect / as sysdba delete from sys.apply$_source_obj ; delete from sys.apply$_source_schema; commit; Then run again the preupgrade script. Stay tuned for more articles on Oracle 19c  Thank you for gi ..read more

There are many cases where we need to capture the ddl statements in our production environment where application team have direct access for create or drop any object in the application schema in the production database . What is DDL ?? DDL (Data Definition Language) is a language used by a database management system that allows users to define the database and specify data types, structures and constraints on the data. Examples DDL statements are: CREATE TABLE, CREATE INDEX, ALTER, and DROP. Here we need to create a table w ..read more

Today we are going to work on the steps used for Resize the online Redo Logfiles.  Let’s follow the steps:- Single Instance: 1. First, see the size of the current logs: sqlplus /nolog SQL> connect / as sysdba SQL> select group#, bytes, status from v$log; GROUP# BYTES STATUS ———- ———- —————- 1 1048576 INACTIVE 2 1048576 CURRENT 3 1048576 INACTIVE 2. Logs are 1MB from above, let’s size them to 10MB. Retrieve all the log member names for the groups: SQL> select group#, member from v$logfile; GROUP# MEMBER ————— —————————————- 1 /usr/oracle/dbs/log1PROD.dbf 2 /usr/oracle/dbs/log ..read more

Today we are going to work on the steps which are used to clone Oracle Binaries.  Sometimes we install Oracle software by using a utility such as tar to copy an existing installation of the Oracle binaries to a different server. Installing Oracle with an existing copy of the binaries is a two-part process Copy the binaries Attach the Oracle home Step 1. Copy the Binaries You can use any OS copy utility to perform this step. $ echo $ORACLE_HOME /u01/app/oracle/product/12.1.0.1/db_1 Now the tar utility copies every file and subdirectory in the db_1 directory: $ cd $ORACLE_HOME $ cd ..read more

Today we are going to explore the steps which we use for set IDLE TIME in Oracle Database.  Let’s follow the steps. Step1:- connect as sysdba user SQL> conn /as sysdba SQL> sho parameter resource_limit NAME TYPE VALUE ———————————— ———– —————————— resource_limit boolean FALSE Step2:- Change the resource parameter to true SQL> alter system set resource_limit=TRUE scope=both; System altered. SQL> select * from dba_profiles where profile='DEFAULT' and resource_name in (‘IDLE_TIME’,’CONNECT_TIME’); PROFILE RESOURCE_NAME RESOURCE LIMIT —————————— ——————————– ——– —————————————- D ..read more

After the core DBA, continue our journey towards RAC environment. Today we are going to explore the steps use for “How to disable and enable archive log in oracle RAC“ Let’s follow the steps. Hopefully, you will feel the difference in RAC. Step1: First we need to stop database instance on node1 using sqlplus. [oracle@rac-node1 bin]# sqlplus /nolog SQL> select instance_name from v$instance; TEST1 SQL> shutdown immediate; Step2: As we are working on 2 node environment now we stop database instance on node2 using sqlplus. [oracle@rac-node2 bin]# sqlplus /nolog SQL> select instance_nam ..read more

Today we are going to explore the steps to use for configure Shared server mode. Let’s follow the steps. We need to set the init parameters SQL>alter system set shared_servers=5; SQL>alter system set max_dispatchers=10 scope=spfile;; SQL>alter system set shared_server_sessions=5 scope=spfile;; SQL>alter system set circuits=300 scope=spfile;; SQL>alter system set dispatchers="(protocol=TCP)(dispatchers=3)(connections=100)" scope=spfile; Now client tnsfile should be like sales= (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=sal ..read more

Hi Readers Finally, I’ve successfully passed 1Z0-997, Oracle Cloud Infrastructure 2019 Architect Professional. It was almost more than 3 years that I’ve been working in OCI starting from OCI classic, Gen1, & Gen2. To clear this exam you must have good hands-on on OCI. OCI Classic – 1Z0-337 Oracle Infrastructure as a Service Cloud 2017 Implementation Essentials OCI 2018 – 1Z0-932 Oracle Cloud Infrastructure (1Z0-932) OCI 2019 – 1Z0-1072 Oracle Cloud Infrastructure 2019 (1Z0-1072)   The Exam contains 50 questions related to OCI which includes almost all topics and services of ..read more

Hi Readers Finally, I’ve successfully passed 1Z0-1084-20, Oracle Cloud Infrastructure Developer 2020 Associate. It was almost more than 4-6 months that I’ve been preparing for this. The Exam contains 60 questions related to OCI which includes OCI Functions, OCI Kubernetes, OCI API Gateways etc.. To earn this certification you need to get 70% marks. This was the result of the journey: Oracle Cloud Infrastructure Developer 2020 Associate In this post you will find: A path to achieve it Study Materials Exam Detail & Score How to Achieve this Certification? Before appearing to thi ..read more