Jun 29, 2022
RMAN Backup Status
#RMAN, #backup #RMANbackup, #oracleebs #oracleapps #oracledba #oracledatabase #rman #Backup #oracle @oracle @oraclebs
RMAN Historical backup details: select SESSION_KEY, INPUT_TYPE, STATUS, to_char(START_TIME,’mm-dd-yyyy hh24:mi:ss’) as RMAN_Bkup_start_time, to_char(END_TIME,’mm-dd-yyyy hh24:mi:ss’) as RMAN_Bkup_end_time, elapsed_seconds/3600 Hours from V$RMAN_BACKUP_JOB_DETAILS order by session_key; Running status of the RMAN Backup : SQL> SELECT SID, SERIAL#, CONTEXT, SOFAR, TOTALWORK, ROUND…
View On WordPress