ORA RMAN & DATA PUMP
main monitor ddl objects dml stato e configurazione rman & dpump pl/sql cluster ASM
main config start-shut process memory monitor diag
user rman & dpump pl/sql cluster ASM
Links
Backups elapsed time
col STATUS format a9
col hrs format 999.99
SELECT SESSION_KEY, session_recid, INPUT_TYPE, STATUS, 
           to_char(START_TIME,'mm/dd/yy hh24:mi') start_time, 
           to_char(END_TIME,'mm/dd/yy hh24:mi') end_time, 
           elapsed_seconds/3600 hrs
     FROM V$RMAN_BACKUP_JOB_DETAILS
     WHERE INPUT_TYPE like '%FULL%'
     ORDER BY input_type, session_key;
Esempi di parfile
/***** semplice ****/
userid=scott/tiger
job_name=query_export
query=scott.emp:"WHERE ENAME in ('JAMES', 'TURNER')"
tables=scott.emp
directory=DATA_PUMP_DIR /* (predefinita in oracle) */
dumpfile=QUERY_EXP.dmp
logfile=QUERY_EXP.log
/* parallela */
JOB_NAME=export_full_KIM_PRO
FULL=Y
CONTENT=ALL
DIRECTORY=DATA_PUMP_DIR
LOGFILE=export_full_KIM_PRO%U.log
DUMPFILE=export_full_KIM_PRO.dmp
PARALLEL=4
Backups: which command for sessions
select SESSION_KEY, operation, OUTPUT_BYTES
        from V$RMAN_BACKUP_SUBJOB_DETAILS
        where SESSION_KEY IN( 144392, 144397)
        order by SESSION_KEY;
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License