Uncategorized

RMAN Backup Status

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 (SOFAR/TOTALWORK*100, 2) “% COMPLETE” FROM V$SESSION_LONGOPS WHERE OPNAME LIKE ‘RMAN%’ AND OPNAME NOT LIKE ‘%aggregate%’ AND TOTALWORK! …

RMAN Backup Status Read More »

How to Switch to a New Undo Tablespace

RMAN-03009: failure of backup channel c3: specifying datafile(s) in backup setincluding current SPFILE in backup setchannel c3: starting piece 1 at 05-MAR-22channel c3: finished piece 1 at 05-MAR-22piece handle=/oraprod/RMAN/CURBKP/PROD_20220305_53376_1_FULL tag=BESCOM_FULL comment=NONEchannel c3: backup set complete, elapsed time: 00:00:01channel c4: finished piece 1 at 05-MAR-22piece handle=/oraprod/RMAN/CURBKP/PROD_20220305_53373_1_FULL tag=BESCOM_FULL comment=NONEchannel c4: backup set complete, elapsed time: 00:04:25channel c2: …

How to Switch to a New Undo Tablespace Read More »