Friday, July 18, 2025

Oracle Version 19.24 onwards: RMAN Progress Status Report

I was restoring a DB in  Oracle DB version 19.27, I noticed a new way oracle starting to dump the restore log. Below is an example content (sourced from internet):


This feature seems to be there from 19.24.
The log file gets updated normally in the begining like

Channel cx: restoring datafile 0004 to 'zzz' 
..

But after a while a message of the below starts printing


RMAN Progress Status Report at 20/05/2025 21:30:48
Progress for current step on channel: ch03 [INSTID = 1, SID = 5, SERIAL = 7654, Polling channel id= 150]
Type Total_Blocks Procd_Blocks Open_Time status setcount File_Name
IN 0 734862848 20/05/2025 20:02:59 IN PROGRESS 43126 76888_TESTDB_3xxxx_121_1_1
OUT 3932160 1679871 20/05/2025 21:35:58 IN PROGRESS 43126 ..
OUT 3932160 1679871 20/05/2025 21:35:58 IN PROGRESS 43126 ..
OUT 3932160 1679871 20/05/2025 21:35:58 IN PROGRESS 43126 ..


A little nice feature.

Thanks


..

No comments:

Post a Comment

Troubleshooting the “Cannot Generate SSPI Context” Error After SQL Server Migration

  Introduction After a recent  SQL Server migration from 2012 to 2022 , our team encountered a classic authentication issue: The target prin...