Long running RMAN jobs

If you are going to restore a huge database, then it’s important, that the rman session can’t abort due to a session disconnection. So it’s best to start rman as follows under linux:

nohup rman target / cmdfile rmancommand log rmanlog.txt &

you can monitor the rman session and check the estimated remaining time in seconds

> set lines 132
> col message for a100
> SELECT time_remaining, message FROM v$session_longops WHERE substr(opname,1,4)='RMAN' and time_remaining > 0;

TIME_REMAINING MESSAGE
-------------- ----------------------------------------------------------------------------------------------------
           767 RMAN: incremental datafile backup: Set Count 98209: 458878 out of 1048576 Blocks done
           767 RMAN: incremental datafile backup: Set Count 98206: 459262 out of 1048576 Blocks done
            74 RMAN: incremental datafile backup: Set Count 98226: 323710 out of 786432 Blocks done
           760 RMAN: incremental datafile backup: Set Count 98212: 458622 out of 1048576 Blocks done
           725 RMAN: incremental datafile backup: Set Count 98203: 487678 out of 1048576 Blocks done
           879 RMAN: incremental datafile backup: Set Count 98219: 328574 out of 1048576 Blocks done
           383 RMAN: aggregate input: backup 32: 509908909 out of 541901262 Blocks done
           305 RMAN: incremental datafile backup: Set Count 98217: 618878 out of 1048576 Blocks done
            45 RMAN: incremental datafile backup: Set Count 98225: 756862 out of 1048576 Blocks done

Here you can see 383 remaining seconds for this backup.

Schreibe einen Kommentar

Trage deine Daten unten ein oder klicke ein Icon um dich einzuloggen:

WordPress.com-Logo

Du kommentierst mit Deinem WordPress.com-Konto. Abmelden / Ändern )

Twitter-Bild

Du kommentierst mit Deinem Twitter-Konto. Abmelden / Ändern )

Facebook-Foto

Du kommentierst mit Deinem Facebook-Konto. Abmelden / Ändern )

Google+ Foto

Du kommentierst mit Deinem Google+-Konto. Abmelden / Ändern )

Verbinde mit %s