Find the last RMAN backup’s log?

 Find the last RMAN backup’s log?

Execute the script to check RMAN log

set pagesize 2000

set linesize 2000

select

output

from

GV$RMAN_OUTPUT

where

session_recid =

(

select

session_recid

from

V$RMAN_BACKUP_JOB_DETAILS

where

session_key=(select max(session_key) from v$RMAN_BACKUP_JOB_DETAILS)

);

Output

connected to target database: WYPTCDB (DBID=2161084537)

using target database control file instead of recovery catalog

run {

report obsolete recovery window of 30 days;

delete noprompt obsolete recovery window of 30 days;

no obsolete backups found

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=927 device type=DISK

allocated channel: ORA_DISK_2

channel ORA_DISK_2: SID=1382 device type=DISK

allocated channel: ORA_DISK_3

channel ORA_DISK_3: SID=1611 device type=DISK

allocated channel: ORA_DISK_4

channel ORA_DISK_4: SID=15 device type=DISK

allocated channel: ORA_DISK_5

channel ORA_DISK_5: SID=468 device type=DISK

allocated channel: ORA_DISK_6

channel ORA_DISK_6: SID=929 device type=DISK

allocated channel: ORA_DISK_7

channel ORA_DISK_7: SID=1384 device type=DISK

allocated channel: ORA_DISK_8

channel ORA_DISK_8: SID=1610 device type=DISK

no obsolete backups found

Starting backup at 07-AUG-2021 15:15:44

using channel ORA_DISK_1

using channel ORA_DISK_2

using channel ORA_DISK_3

using channel ORA_DISK_4

using channel ORA_DISK_5

using channel ORA_DISK_6

using channel ORA_DISK_7

using channel ORA_DISK_8

channel ORA_DISK_1: starting compressed incremental level 0 datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

Finished Control File and SPFILE Autobackup at 07-AUG-2021 15:22:30

released channel: ORA_DISK_1

released channel: ORA_DISK_2

released channel: ORA_DISK_3

released channel: ORA_DISK_4

released channel: ORA_DISK_5

released channel: ORA_DISK_6

released channel: ORA_DISK_7

released channel: ORA_DISK_8

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=927 device type=DISK

allocated channel: ORA_DISK_2

channel ORA_DISK_2: SID=1382 device type=DISK

allocated channel: ORA_DISK_3

channel ORA_DISK_3: SID=1611 device type=DISK

allocated channel: ORA_DISK_4

channel ORA_DISK_4: SID=15 device type=DISK

allocated channel: ORA_DISK_5

channel ORA_DISK_5: SID=468 device type=DISK

allocated channel: ORA_DISK_6

channel ORA_DISK_6: SID=929 device type=DISK

allocated channel: ORA_DISK_7

channel ORA_DISK_7: SID=1384 device type=DISK

allocated channel: ORA_DISK_8

channel ORA_DISK_8: SID=1610 device type=DISK

exit;