
ORACLE-HELP - Oracle DBA and Cloud Articles
760 FOLLOWERS
Oracle-Help.com is website for sharing knowledge in Oracle Databases and Oracle Cloud.
ORACLE-HELP - Oracle DBA and Cloud Articles
4y ago
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
ORACLE-HELP - Oracle DBA and Cloud Articles
5y ago
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
ORACLE-HELP - Oracle DBA and Cloud Articles
5y ago
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
ORACLE-HELP - Oracle DBA and Cloud Articles
5y ago
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
ORACLE-HELP - Oracle DBA and Cloud Articles
5y ago
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
ORACLE-HELP - Oracle DBA and Cloud Articles
5y ago
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
ORACLE-HELP - Oracle DBA and Cloud Articles
5y ago
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
ORACLE-HELP - Oracle DBA and Cloud Articles
5y ago
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
ORACLE-HELP - Oracle DBA and Cloud Articles
5y ago
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
ORACLE-HELP - Oracle DBA and Cloud Articles
5y ago
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