This blog provides valuable insights and information for Oracle DBA professionals.
datapump_info.sql
Get link
Facebook
Twitter
Pinterest
Email
Other Apps
-- ************************************************************************************************************
-- * Filename : datapump_info.sql
-- * Author : Saravanakumar K
-- * Description : This script with show progress of export/import
-- * Usage : @datapump_info.sql
-- * Version : v1
-- *************************************************************************************************************
set lines 200 pages 9999
col "SID,SERIAL#,Username" for a25
col message for a75
col STATE for a15
col JOB_MODE for a12
col OPERATION for a12
SELECT
s.sid
|| ','
|| s.serial#
|| ','
|| dp.owner_name "SID,SERIAL#,Username",
sl.sofar,
sl.totalwork,
dp.state,
dp.job_mode,
dp.operation,
sl.message
FROM
gv$session s,
gv$session_longops sl,
dba_datapump_jobs dp
WHERE
s.sid = sl.sid
AND s.serial# = sl.serial#
AND s.username = dp.owner_name
AND ( sl.time_remaining > 0
OR sl.totalwork > 0 )
and dp.state = 'EXECUTING';
clear col
Goldengate initial load options - File to Replicat This method allows the Extract process to write to a file on the target system, which the Replicat applies using SQL INSERT statements. The Extract process generates a file in a universal format for the Replicat to load. This approach fundamentally resembles the standard GoldenGate data replication method used for change data capture (CDC). During the initial load, you can enable CDC. In a live environment, you should use the SQLPREDICATE key to specify the SCN# to maintain data integrity. Please follow the below steps to enable goldengate initial load using File to Replicat method On source: Add initial load extract process. Create a parameter file. Verify task(initia
Oracle Recovery Manager (RMAN) is a robust utility designed for the backup, restoration, and recovery of Oracle databases. RMAN simplifies database management by offering comprehensive backup options, automatic recovery features, and seamless integration with Oracle Database. It supports full and incremental backups, point-in-time recovery, and database cloning. RMAN can be executed through command-line, integrated with Oracle Enterprise Manager, and offers advanced features like block media recovery, encryption, and compression, ensuring efficient and secure database management. One of the most tedious processes is resetting all RMAN configurations in a single command. If you want to clear configurations, use " CONFIGURE..CLEAR" . Sometimes, restoring a standby or duplicate database can fail due to configurations from the source database. Therefore, it's essential to reset all configurations beforehand using the fo
Comments
Post a Comment