Oracle 18c Datapump-ADD_FILE Parameter

ADD_FILE :

ADD_FILE  is used to add a new additional dump file to the currently running job.

[oracle@18c ~]$ expdp hari/oracle directory=test_dir dumpfile=hari_data.dmp logfile=hari_data.log schemas=hari filesize=500k

Export: Release 18.0.0.0.0 - Production on Wed Aug 22 00:05:36 2018
Version 18.3.0.0.0

Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Starting "HARI"."SYS_EXPORT_SCHEMA_04": hari/******** directory=test_dir dumpfile=hari_data.dmp logfile=hari_data.log schemas=hari filesize=500k
^C
Export> ADD_FILE=hari_data1.dmp

Export> STATUS

Job: SYS_EXPORT_SCHEMA_04
Operation: EXPORT
Mode: SCHEMA
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Job heartbeat: 10
Dump File: /u01/empdata/hari_data.dmp
size: 512,000
bytes written: 49,152
Dump File: /u01/empdata/hari_data1.dmp
size: 512,000
bytes written: 4,096

Worker 1 Status:
Instance ID: 1
Instance name: prod18c
Host name: 18c.localdomain.com
Object start time: Wednesday, 22 August, 2018 0:05:44
Object status at: Wednesday, 22 August, 2018 0:05:46
Process Name: DW00
State: EXECUTING

 

Catch Me On:- Hariprasath Rajaram

Telegram:https://t.me/joinchat/I_f4DhGF_Zifr9YZvvMkRg
LinkedIn:https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page: https://www.facebook.com/dbahariprasath/?
Twitter: https://twitter.com/hariprasathdba

Step by Step to Configure Oracle 18c Database using DBCA Method

Description:-

In this article we are going to see Step by Step to Configure Oracle 18c Database using DBCA Method.

  1. we are going to create a 18.3 new database using dbca method
  2. Database name orcl101
  3. Oracle 18.3 Software installation here

Let’s start the demo:-

bash_profile

# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_HOSTNAME=prod101.oracledbwr.com; export ORACLE_HOSTNAME
ORACLE_UNQNAME=orcl101; export ORACLE_UNQNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=/u01; export ORACLE_HOME
ORACLE_SID=orcl101; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

Step1:- Select Create database

Step2:-select Advance Configuration

Step3:-Click next

Step4:-Database name “orcl101”

Step5:-Click next

Step6:-click next

Step7:-select listener 

Step8:-click next

Step9:-select ASMM ad click nextStep:10 Click next

Step11:- Set Password Step12:-Create database

Step13:-Click Finesh

Step14:-Database is in progress Step15:-Oracle 18c Database Creation completed. Step16:-Check the database Status

[oracle@prod101:~ orcl101] sqlplus '/as sysdba'
SQL*Plus: Release 18.0.0.0.0 - Production on Sun Jul 29 19:59:05 2018
Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle. All rights reserved.
Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0

SQL> select name from v$database;
NAME
---------
ORCL101

Catch Me On:- Hariprasath Rajaram

Telegram:https://t.me/joinchat/I_f4DhGF_Zifr9YZvvMkRg
LinkedIn:https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page: https://www.facebook.com/dbahariprasath/?
Twitter: https://twitter.com/hariprasathdba