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 |
Table of Contents
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;
page revision: 1, last edited: 23 May 2017 09:48