Thursday 20 October 2022

RAC commands --

 To get cluster stack health status

$crsctl check crs



Check visibility of CRS across nodes

$crsctl check cluster -n node_name



Stop/Start Cluster

$crsctl start cluster -n node_name

$crsctl stop cluster -n node_name

$crsctl start cluster –all

$crsctl stop cluster -all



Start/Stop CRS

$crsctl start crs

$crsctl stop crs (or)

$/etc/init.d/init.ohasd run

$/etc/init.d/init.crs stop



Enable/Disable CRS

$crsctl enable crs

$crsctl disable crs (or)

$/etc/init.d/init.crs enable

$/etc/init.d/init.crs disable


Check status of running deamons

$ps -ef | grep d.bin

$crsctl check cssd

$crsctl check crsd

$crsctl check evmd

$crsctl check oprocd

$crsctl check ctss



Query voting disk files

$crsctl query css votedisk



Add/Delete voting disks

For non-ASM

$crsctl add css votedisk <<PATH>>

$crsctl add css votedisk <<PATH>> -force — if Clusterware is not running

$crsctl delete css votedisk <<PATH>>

$crsctl delete css votedisk <<PATH>> -force — if Clusterware is not running


For ASM

$crsctl replace votedisk <<DISK_GROUP_NAME>>


Set VD parameters

$crsctl set css misscount 100

$crsctl unset css misscount — — sets CSS parameter to its default

$crsctl get css disktimeout

$crsctl get css miscount

$crsctl get css reboottime


Working with resources

$crsctl start resource ora.DATA.dg

$crsctl status resource –t

$crsctl stat resource -t



Listing modules

$crsctl lsmodules crs

$crsctl lsmodules css

$crsctl lsmodules evm



Working with HAS

$crsctl start has (HAS – High Availability Services)

$crsctl stop has

$crsctl check has



OCR Modules — cannot be listed with crsctl lsmodules command

OCRAPI

OCRCLI

OCRSRV

OCRMAS

OCRMSG

OCRCAC

OCRRAW

OCRUTL

OCROSD


Debugging

$crsctl debug statedump crs — dumps state info for crs objects

$crsctl debug statedump css — dumps state info for css objects

$crsctl debug statedump evm — dumps state info for evm objects

$crsctl debug log crs [module:level]{,module:level} …



–Turns on debugging for CRS

$crsctl debug log crs CRSEVT:5,CRSAPP:5,CRSTIMER:5,CRSRES:5,CRSRTI:1,CRSCOMM:2

$crsctl debug log css [module:level]{,module:level} …



– Turns on debugging for CSS

$crsctl debug log css CSSD:1

$crsctl debug log evm [module:level]{,module:level} …



– Turns on debugging for EVM

$crsctl debug log evm EVMCOMM:1

$crsctl debug trace crs — dumps CRS in-memory tracing cache

$crsctl debug trace css — dumps CSS in-memory tracing cache

$crsctl debug trace evm — dumps EVM in-memory tracing cache

$crsctl debug log res resource_name:level — turns on debugging for resources

$crsctl debug log res “ora.lnx04.vip:1″

$crsctl trace all_the_above_commands — tracing by adding a “trace” argument.

$crsctl trace check css


====================================================


Dual Environment CRSCTL Commands:

crsctl add resource

crsctl add type

crsctl check css

crsctl delete resource

crsctl delete type

crsctl get hostname

crsctl getperm resource

crsctl getperm type

crsctl modify resource

crsctl modify type

crsctl setperm resource

crsctl setperm type

crsctl start resource

crsctl status resource

crsctl status type

crsctl stop resource


Oracle RAC Environment CRSCTL Commands:

crsctl add crs administrator

crsctl add css votedisk

crsctl add serverpool

crsctl check cluster

crsctl check crs

crsctl check resource

crsctl check ctss

crsctl config crs

crsctl delete crs administrator

crsctl delete css votedisk

crsctl delete node

crsctl delete serverpool

crsctl disable crs

crsctl enable crs

crsctl get css

crsctl get css ipmiaddr

crsctl get nodename

crsctl getperm serverpool

crsctl lsmodules

crsctl modify serverpool

crsctl pin css

crsctl query crs administrator

crsctl query crs activeversion

crsctl query crs releaseversion

crsctl query crs softwareversion

crsctl query css ipmidevice

crsctl query css votedisk

crsctl relocate resource

crsctl relocate server

crsctl replace discoverystring

crsctl replace votedisk

crsctl set css

crsctl set css ipmiaddr

crsctl set css ipmiadmin

crsctl setperm serverpool

crsctl start cluster

crsctl start crs

crsctl status server

crsctl status serverpool

crsctl stop cluster

crsctl stop crs

crsctl unpin css

crsctl unset css


Oracle Restart Environment CRSCTL Commands:

crsctl check has

crsctl config has

crsctl disable has

crsctl enable has

crsctl query has releaseversion

crsctl query has softwareversion

crsctl start has

crsctl stop has


Deprecated in Oracle Clusterware 11g release 2 (11.2):

crs_stat

crs_register

crs_unregister

crs_start

crs_stop

crs_getperm

crs_profile

crs_relocate

crs_setperm

crsctl check crsd

crsctl check cssd

crsctl check evmd

crsctl debug log

crsctl set css votedisk

crsctl start resources

crsctl stop resources

====================================================


crsctl – Cluster Ready Service Control


To Get CRSCTL  help

$crsctl -h


To Get Active Cluster Version


$crsctl query crs activeversion


To Get cluster version of given node


$crsctl query crs softwareversion [node_name]


Ex:$crsctl query crs softwareversion rac1


#crsctl start crs


#crsctl stop crs


(or)


#/etc/init.d/init.crs start


#/etc/init.d/init.crs stop


#crsctl enable crs


#crsctl disable crs


(or)


#/etc/init.d/init.crs enable


#/etc/init.d/init.crs disable


To get cluster stack health status


$crsctl check crs


To get the viability of CSS across nodes


$crsctl check cluster [-node node_name]   — 11gR2 RACcommand


#crsctl start cluster -n HostName — 11g R2


#crsctl stop cluster -n HostName — 11g R2


#crsctl stop cluster -all  — 11g R2


$ps -ef | grep d.bin


$crsctl check cssd


$crsctl check crsd


$crsctl check evmd


$crsctl check oprocd


$crsctl check ctss


#/etc/init.d/init.cssd stop


#/etc/init.d/init.cssd start


#/etc/rc.d/init.d/init.evmd

#/etc/rc.d/init.d/init.cssd

#/etc/rc.d/init.d/init.crsd

#mv /etc/rc3.d/S96init.cssd /etc/rc3.d/_S96init.cssd — to stop cssd from autostarting after reboot


#crsctl check css votedisk


#crsctl query css votedisk — lists the voting disks used by CSS command in 11gR2


#crsctl add css votedisk PATH


#crsctl add css votedisk PATH -force — if Clusterware is not running


#crsctl delete css votedisk PATH


#crsctl delete css votedisk PATH -force — if Clusterware is not running


#crsctl set css parameter_name value — set parameters on OCR


#crsctl set css misscount 100


#crsctl unset css parameter_name — sets CSS parameter to its default


#crsctl unset css misscount


#crsctl get css parameter_name — gets the value of a CSS parameter


#crsctl get css disktimeout


#crsctl get css misscount


#crsctl get css reboottime


#crsctl start resources — starts Clusterware resources


#crsctl start resource ora.DATA.dg

#crsctl stop resources — stops Clusterware resources


$crsctl status resource


$crsctl status resource -t


$crsctl stat resource -t


#crsctl lsmodules crs — lists CRS modules that can be used for debugging( need root privilage)


List CRSD Debug Module: AGENT


List CRSD Debug Module: AGFW


List CRSD Debug Module: CLSFRAME


List CRSD Debug Module: CLSVER


List CRSD Debug Module: CLUCLS


List CRSD Debug Module: COMMCRS


List CRSD Debug Module: COMMNS


List CRSD Debug Module: CRSAPP


List CRSD Debug Module: CRSCCL


List CRSD Debug Module: CRSCEVT


List CRSD Debug Module: CRSCOMM


List CRSD Debug Module: CRSD


List CRSD Debug Module: CRSEVT


List CRSD Debug Module: CRSMAIN


List CRSD Debug Module: CRSOCR


List CRSD Debug Module: CRSPE


List CRSD Debug Module: CRSPLACE


List CRSD Debug Module: CRSRES


List CRSD Debug Module: CRSRPT


List CRSD Debug Module: CRSRTI


List CRSD Debug Module: CRSSE


List CRSD Debug Module: CRSSEC


List CRSD Debug Module: CRSTIMER


List CRSD Debug Module: CRSUI


List CRSD Debug Module: CSSCLNT


List CRSD Debug Module: OCRAPI


List CRSD Debug Module: OCRASM


List CRSD Debug Module: OCRCAC


List CRSD Debug Module: OCRCLI


List CRSD Debug Module: OCRMAS


List CRSD Debug Module: OCRMSG


List CRSD Debug Module: OCROSD


List CRSD Debug Module: OCRRAW


List CRSD Debug Module: OCRSRV


List CRSD Debug Module: OCRUTL


List CRSD Debug Module: SuiteTes


List CRSD Debug Module: UiServer


$crsctl lsmodules css — lists CSS modules that can be used for debugging


The following are the Cluster Synchronization Services modules::


CSSD


COMMCRS


COMMNS


CLSF


SKGFD


$crsctl lsmodules evm — lists EVM modules that can be used for debugging


The following are the Cluster Synchronization Services modules::


CSSD


COMMCRS


COMMNS


CLSF


SKGFD

$crsctl start has   (HAS – High Availability Services)

$crsctl stop has


$crsctl check has


CRS-4638 Oracle High Availability Service is online


OCR Modules — cannot be listed with crsctl lsmodules command


OCRAPI


OCRCLI


OCRSRV


OCRMAS


OCRMSG


OCRCAC


OCRRAW


OCRUTL


OCROSD


#crsctl debug statedump crs — dumps state info for crs objects


#crsctl debug statedump css — dumps state info for css objects


#crsctl debug statedump evm — dumps state info for evm objects


#crsctl debug log crs [module:level]{,module:level} …


— Turns on debugging for CRS


#crsctl debug log crs CRSEVT:5,CRSAPP:5,CRSTIMER:5,CRSRES:5,CRSRTI:1,CRSCOMM:2


#crsctl debug log css [module:level]{,module:level} …


— Turns on debugging for CSS


#crsctl debug log css CSSD:1


#crsctl debug log evm [module:level]{,module:level} …


— Turns on debugging for EVM


#crsctl debug log evm EVMCOMM:1


#crsctl debug trace crs — dumps CRS in-memory tracing cache


#crsctl debug trace css — dumps CSS in-memory tracing cache


#crsctl debug trace evm — dumps EVM in-memory tracing cache


#crsctl debug log res resource_name:level — turns on debugging for resources


#crsctl debug log res “ora.lnx04.vip:1”


#crsctl trace all_the_above_commands — tracing by adding a “trace” argument.


#crsctl trace check css


#crsctl backup -h


#crsctl backup css votedisk


Here is the list of the options for CRSCTL in 11gR2:


crsctl add       – add a resource, type or other entity


crsctl backup    – back up voting disk for CSS


crsctl check     – check a service, resource or other entity


crsctl config    – output autostart configuration


crsctl debug     – obtain or modify debug state


crsctl delete    – delete a resource, type or other entity


crsctl disable   – disable autostart


crsctl discover  – discover DHCP server


crsctl enable    – enable autostart


crsctl get       – get an entity value


crsctl getperm   – get entity permissions


crsctl lsmodules – list debug modules


crsctl modify    – modify a resource, type or other entity


crsctl query     – query service state


crsctl pin       – Pin the nodes in the nodelist


crsctl relocate  – relocate a resource, server or other entity


crsctl replace   – replaces the location of voting files


crsctl release   – release a DHCP lease


crsctl request   – request a DHCP lease


crsctl setperm   – set entity permissions


crsctl set       – set an entity value


crsctl start     – start a resource, server or other entity


crsctl status    – get status of a resource or other entity


crsctl stop      – stop a resource, server or other entity


crsctl unpin     – unpin the nodes in the nodelist


crsctl unset     – unset a entity value, restoring its default


How do I identify the voting disk/file location?

#crsctl query css votedisk


How to take backup of voting file/disk?

crsctl backup css votedisk


#################################################

Sunday 9 October 2022

Expdp - AWR dump example awrextr.sql


Expdp - AWR dump example awrextr.sql

SQL> start $ORACLE_HOME/rdbms/admin/awrextr.sql

~~~~~~~~~~~~~

AWR EXTRACT

~~~~~~~~~~~~~

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

~  This script will extract the AWR data for a range of snapshots  ~

~  into a dump file.  The script will prompt users for the         ~

~  following information:                                          ~

~     (1) database id                                              ~

~     (2) snapshot range to extract                                ~

~     (3) name of directory object                                 ~

~     (4) name of dump file                                        ~

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~



Databases in this Workload Repository schema

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


   DB Id     DB Name      Host

------------ ------------ ------------

* 123456 Test_db      Test_hostname


The default database id is the local one: '123456'.  To use this

database id, press <return> to continue, otherwise enter an alternative.


Enter value for dbid: 123456


Using 123456 for Database ID



Specify the number of days of snapshots to choose from

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Entering the number of days (n) will result in the most recent

(n) days of snapshots being listed.  Pressing <return> without

specifying a number lists all completed snapshots.



Enter value for num_days: 2


Listing the last 2 days of Completed Snapshots


DB Name        Snap Id    Snap Started

------------ --------- ------------------

Test_db          44424 07 Sep 2022 00:00

                 44425 07 Sep 2022 01:00

                 44426 07 Sep 2022 02:00

                 44427 07 Sep 2022 03:00

                 44428 07 Sep 2022 04:00

                 44429 07 Sep 2022 05:01

                 44430 07 Sep 2022 06:00

                 44431 07 Sep 2022 07:00

                 44432 07 Sep 2022 08:00

                 44433 07 Sep 2022 09:00

                 44434 07 Sep 2022 10:00


DB Name        Snap Id    Snap Started

------------ --------- ------------------

Test_db          44435 07 Sep 2022 11:00

                 44436 07 Sep 2022 12:00

                 44437 07 Sep 2022 13:00

                 44438 07 Sep 2022 14:00

                 44439 07 Sep 2022 15:00

                 44440 07 Sep 2022 16:00

                 44441 07 Sep 2022 17:00

                 44442 07 Sep 2022 18:00

                 44443 07 Sep 2022 19:00

                 44444 07 Sep 2022 20:00

                 44445 07 Sep 2022 21:00


DB Name        Snap Id    Snap Started

------------ --------- ------------------

Test_db          44446 07 Sep 2022 22:00

                 44447 07 Sep 2022 23:00

                 44448 08 Sep 2022 00:00

                 44449 08 Sep 2022 01:00

                 44450 08 Sep 2022 02:00

                 44451 08 Sep 2022 03:00

                 44452 08 Sep 2022 04:00

                 44453 08 Sep 2022 05:00

                 44454 08 Sep 2022 06:00

                 44455 08 Sep 2022 07:00

                 44456 08 Sep 2022 08:00


DB Name        Snap Id    Snap Started

------------ --------- ------------------

Test_db          44457 08 Sep 2022 09:00

                 44458 08 Sep 2022 10:00

                 44459 08 Sep 2022 11:00

                 44460 08 Sep 2022 12:00

                 44461 08 Sep 2022 13:00

                 44462 08 Sep 2022 14:00

                 44463 08 Sep 2022 15:00

                 44464 08 Sep 2022 16:00

                 44465 08 Sep 2022 17:00

                 44466 08 Sep 2022 18:00



Specify the Begin and End Snapshot Ids

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Enter value for begin_snap: 44457

Begin Snapshot Id specified: 44457


Enter value for end_snap: 44466

End   Snapshot Id specified: 44466



Specify the Directory Name

~~~~~~~~~~~~~~~~~~~~~~~~~~


Directory Name                 Directory Path

------------------------------ -------------------------------------------------

DATA_PUMP_DIR                  <location>/Test_dbdump/exp


DATA_PUMP_DIR                  <location>/Test_dbdump/exp

Directory Name                 Directory Path

------------------------------ -------------------------------------------------

DATA_PUMP_DIR                  <location>/Test_dbdump/exp

DATA_PUMP_DIR                  <location>/Test_dbdump/exp


Choose a Directory Name from the above list (case-sensitive).


Enter value for directory_name: DATA_PUMP_DIR


Using the dump directory: DATA_PUMP_DIR


Specify the Name of the Extract Dump File

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

The prefix for the default dump file name is awrdat_44457_44466.

To use this name, press <return> to continue, otherwise enter

an alternative.


Enter value for file_name: awrdat_44457_44466


Using the dump file prefix: awrdat_44457_44466

|

| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

|  The AWR extract dump file will be located

|  in the following directory/file:

|   <location>/Test_dbdump/exp

|   awrdat_44457_44466.dmp

| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

|

|  *** AWR Extract Started ...

|

|  This operation will take a few moments. The

|  progress of the AWR extract operation can be

|  monitored in the following directory/file:

|   <location>/Test_dbdump/exp

|   awrdat_44457_44466.log

|


End of AWR Extract

SQL> exit

Impdp example using attach increase parallel from 10 to 17

Impdp example using attach increase parallel from 10 to 17 


[oracle@TEST_hostname <Dir>]$ impdp attach=SYS_IMPORT_SCHEMA_05


Export: Release 19.0.0.0.0 - Production on Tue Aug 23 10:08:27 2022

Version 19.16.0.0.0


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


Username: / as sysdba



Import: Release 19.0.0.0.0 - Production on Tue Aug 23 10:08:49 2022

Version 19.16.0.0.0


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


Username: / as sysdba


Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production


Job: SYS_IMPORT_SCHEMA_05

  Owner: SYS

  Operation: IMPORT

  Creator Privs: TRUE

  

  Start Time: Monday, 22 August, 2022 8:18:03

  Mode: SCHEMA

  Instance: TEST_DB

  Max Parallelism: 10

  Timezone: -05:00

  Timezone version: 32

  Endianness: LITTLE

  NLS character set: AL32UTF8

  NLS NCHAR character set: AL16UTF16

  EXPORT Job Parameters:

  Parameter Name      Parameter Value:

     CLIENT_COMMAND        "/******** AS SYSDBA" parfile=expdp_.par

     LOGTIME               ALL

     METRICS               1

     TRACE                 0

  IMPORT Job Parameters:

  Parameter Name      Parameter Value:

     CLIENT_COMMAND        "/******** AS SYSDBA" parfile=impdp_.par

     LOGTIME               ALL

     METRICS               1

     TRACE                 0

  State: EXECUTING

  Bytes Processed: 107,367,434,768

  Percent Done: 99

  Current Parallelism: 10

  Job Error Count: 0

  Job heartbeat: 1511

  Dump File: <Directory>%u.dmp

  Dump File: <Directory>01.dmp

  Dump File: <Directory>02.dmp

  Dump File: <Directory>03.dmp

  Dump File: <Directory>04.dmp

  Dump File: <Directory>05.dmp

  Dump File: <Directory>06.dmp

  Dump File: <Directory>07.dmp

  Dump File: <Directory>08.dmp

  Dump File: <Directory>09.dmp

  Dump File: <Directory>10.dmp

  Dump File: <Directory>11.dmp

  Dump File: <Directory>12.dmp

  Dump File: <Directory>13.dmp

  Dump File: <Directory>14.dmp

  Dump File: <Directory>15.dmp

  Dump File: <Directory>16.dmp

  Dump File: <Directory>17.dmp


Worker 1 Status:

  Instance ID: 1

  Instance name: TEST_DB

  Host name: TEST_hostname

  Access method: direct_path

  Object start time: Monday, 22 August, 2022 8:51:57

  Object status at: Monday, 22 August, 2022 8:51:57

  Process Name: DW00

  State: WORK WAITING


Worker 2 Status:

  Instance ID: 1

  Instance name: TEST_DB

  Host name: TEST_hostname

  Access method: direct_path

  Object start time: Monday, 22 August, 2022 8:51:59

  Object status at: Monday, 22 August, 2022 8:51:59

  Process Name: DW01

  State: WORK WAITING


Worker 3 Status:

  Instance ID: 1

  Instance name: TEST_DB

  Host name: TEST_hostname

  Access method: direct_path

  Object start time: Monday, 22 August, 2022 8:50:09

  Object status at: Monday, 22 August, 2022 8:50:09

  Process Name: DW02

  State: WORK WAITING


Worker 4 Status:

  Instance ID: 1

  Instance name: TEST_DB

  Host name: TEST_hostname

  Object start time: Monday, 22 August, 2022 8:18:22

  Object status at: Monday, 22 August, 2022 8:18:22

  Process Name: DW03

  State: EXECUTING

  Object Schema: VRAADMIN

  Object Name: PROPERTY_VALUES

  Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA

  Completed Objects: 7

  Completed Rows: 3,424,119

  Completed Bytes: 305,046,291,952

  Percent Done: 63

  Worker Parallelism: 8


Worker 5 Status:

  Instance ID: 1

  Instance name: TEST_DB

  Host name: TEST_hostname

  Access method: direct_path

  Object start time: Monday, 22 August, 2022 8:50:14

  Object status at: Monday, 22 August, 2022 8:50:14

  Process Name: DW04

  State: WORK WAITING


Worker 6 Status:

  Instance ID: 1

  Instance name: TEST_DB

  Host name: TEST_hostname

  Access method: direct_path

  Object start time: Monday, 22 August, 2022 8:58:33

  Object status at: Monday, 22 August, 2022 8:58:33

  Process Name: DW05

  State: WORK WAITING


Worker 7 Status:

  Instance ID: 1

  Instance name: TEST_DB

  Host name: TEST_hostname

  Access method: direct_path

  Object start time: Monday, 22 August, 2022 8:50:14

  Object status at: Monday, 22 August, 2022 8:50:14

  Process Name: DW06

  State: WORK WAITING


Worker 8 Status:

  Instance ID: 1

  Instance name: TEST_DB

  Host name: TEST_hostname

  Access method: direct_path

  Object start time: Monday, 22 August, 2022 8:51:57

  Object status at: Monday, 22 August, 2022 8:51:57

  Process Name: DW07

  State: WORK WAITING


Worker 9 Status:

  Instance ID: 1

  Instance name: TEST_DB

  Host name: TEST_hostname

  Access method: direct_path

  Object start time: Monday, 22 August, 2022 8:51:59

  Object status at: Monday, 22 August, 2022 8:51:59

  Process Name: DW08

  State: WORK WAITING


Worker 10 Status:

  Instance ID: 1

  Instance name: TEST_DB

  Host name: TEST_hostname

  Access method: direct_path

  Object start time: Monday, 22 August, 2022 8:50:09

  Object status at: Monday, 22 August, 2022 8:50:09

  Process Name: DW09

  State: WORK WAITING


Import> parallel=17


Import> status


Job: SYS_IMPORT_SCHEMA_05

  Operation: IMPORT

  Mode: SCHEMA

  State: EXECUTING

  Bytes Processed: 107,367,434,768

  Percent Done: 99

  Current Parallelism: 17

  Job Error Count: 0

  Job heartbeat: 2

  Dump File: <Directory>%u.dmp

  Dump File: <Directory>01.dmp

  Dump File: <Directory>02.dmp

  Dump File: <Directory>03.dmp

  Dump File: <Directory>04.dmp

  Dump File: <Directory>05.dmp

  Dump File: <Directory>06.dmp

  Dump File: <Directory>07.dmp

  Dump File: <Directory>08.dmp

  Dump File: <Directory>09.dmp

  Dump File: <Directory>10.dmp

  Dump File: <Directory>11.dmp

  Dump File: <Directory>12.dmp

  Dump File: <Directory>13.dmp

  Dump File: <Directory>14.dmp

  Dump File: <Directory>15.dmp

  Dump File: <Directory>16.dmp

  Dump File: <Directory>17.dmp


Worker 1 Status:

  Instance ID: 1

  Instance name: TEST_DB

  Host name: TEST_hostname

  Access method: direct_path

  Object start time: Monday, 22 August, 2022 8:51:57

  Object status at: Monday, 22 August, 2022 8:51:57

  Process Name: DW00

  State: WORK WAITING


Worker 2 Status:

  Instance ID: 1

  Instance name: TEST_DB

  Host name: TEST_hostname

  Access method: direct_path

  Object start time: Monday, 22 August, 2022 8:51:59

  Object status at: Monday, 22 August, 2022 8:51:59

  Process Name: DW01

  State: WORK WAITING


Worker 3 Status:

  Instance ID: 1

  Instance name: TEST_DB

  Host name: TEST_hostname

  Access method: direct_path

  Object start time: Monday, 22 August, 2022 8:50:09

  Object status at: Monday, 22 August, 2022 8:50:09

  Process Name: DW02

  State: WORK WAITING


Worker 4 Status:

  Instance ID: 1

  Instance name: TEST_DB

  Host name: TEST_hostname

  Object start time: Monday, 22 August, 2022 8:18:22

  Object status at: Monday, 22 August, 2022 8:18:22

  Process Name: DW03

  State: EXECUTING

  Object Schema: VRAADMIN

  Object Name: PROPERTY_VALUES

  Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA

  Completed Objects: 7

  Completed Rows: 3,424,119

  Completed Bytes: 305,046,291,952

  Percent Done: 63

  Worker Parallelism: 8


Worker 5 Status:

  Instance ID: 1

  Instance name: TEST_DB

  Host name: TEST_hostname

  Access method: direct_path

  Object start time: Monday, 22 August, 2022 8:50:14

  Object status at: Monday, 22 August, 2022 8:50:14

  Process Name: DW04

  State: WORK WAITING


Worker 6 Status:

  Instance ID: 1

  Instance name: TEST_DB

  Host name: TEST_hostname

  Access method: direct_path

  Object start time: Monday, 22 August, 2022 8:58:33

  Object status at: Monday, 22 August, 2022 8:58:33

  Process Name: DW05

  State: WORK WAITING


Worker 7 Status:

  Instance ID: 1

  Instance name: TEST_DB

  Host name: TEST_hostname

  Access method: direct_path

  Object start time: Monday, 22 August, 2022 8:50:14

  Object status at: Monday, 22 August, 2022 8:50:14

  Process Name: DW06

  State: WORK WAITING


Worker 8 Status:

  Instance ID: 1

  Instance name: TEST_DB

  Host name: TEST_hostname

  Access method: direct_path

  Object start time: Monday, 22 August, 2022 8:51:57

  Object status at: Monday, 22 August, 2022 8:51:57

  Process Name: DW07

  State: WORK WAITING


Worker 9 Status:

  Instance ID: 1

  Instance name: TEST_DB

  Host name: TEST_hostname

  Access method: direct_path

  Object start time: Monday, 22 August, 2022 8:51:59

  Object status at: Monday, 22 August, 2022 8:51:59

  Process Name: DW08

  State: WORK WAITING


Worker 10 Status:

  Instance ID: 1

  Instance name: TEST_DB

  Host name: TEST_hostname

  Access method: direct_path

  Object start time: Monday, 22 August, 2022 8:50:09

  Object status at: Monday, 22 August, 2022 8:50:09

  Process Name: DW09

  State: WORK WAITING


Import>