What if RMAN backup fails?

[229257]

Hi, I have recently setup an RMAN backup that is scheduled via windows scheduler, i must admit this is pretty new to me. How will i know if the backup has failed? I would also like to know how long the backup has taken? I would like to be able to run something every morning in Oracle (via script or procedure) to view the result (success or failure) of the previous nights backup. Does anyone know how this could be done?

There is a log created by RMAN but this is overwritten everytime the backup job is run, preferably i'd like to keep a history of the backups.

Thanks
229257

 

[KenCunningham]

Why not simply create an 'at' job (or whatever the equivalent is nowadays) to rename the log with, say, a date extension to run before the backup.

Presumably the RMAN log will tell you if the job failed and start and stop times? If not, I guess you could subtract the start time from the time the log file was last accessed to give you the duration. Or am I being a little unix-centric?

 

[Scunningham99]

you can do this in rman, which gives you elapsed time and status

RMAN> list backup of database;


List of Backup Sets
===================

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2146331 Incr 0 131G SBT_TAPE 01:40:18 17-MAR-06
BP Key: 2146332 Status: AVAILABLE Tag: HOT_AEULIVE_03172006-100930
Piece Name: bk_27535_1_585310182
List of Datafiles in backup set 2146331
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 0 Incr 1928929785025 17-MAR-06 /AEULIVE/oradata/system01.dbf
2 0 Incr 1928929785025 17-MAR-06 /AEULIVE/oradata/undotbs01.dbf
3 0 Incr 1928929785025 17-MAR-06 /AEULIVE/oradata/CCIDAT.dbf
4 0 Incr 1928929785025 17-MAR-06 /AEULIVE/oradata/CCIIND.dbf
5 0 Incr 1928929785025 17-MAR-06 /AEULIVE/oradata/drsys01.dbf
6 0 Incr 1928929785025 17-MAR-06 /AEULIVE/oradata/ORAFINDAT.dbf
7 0 Incr 1928929785025 17-MAR-06 /AEULIVE/oradata/ORAFININD.dbf
8 0 Incr 1928929785025 17-MAR-06 /AEULIVE/oradata/PAUDIT.dbf
9 0 Incr 1928929785025 17-MAR-06 /AEULIVE/oradata/PREMDAT.dbf

you can also issue

list backup of databse summary for summary view

hth



Sy UK

 

[Thargy]

You can also issue the command

RESTORE DATABASE VALIDATE;

As part of your backup script. Its output will be included in the RMAN log, and will confirm the status of the backup.

See my post in thread1177-1204639 for further info.

Regards

Tharg

Grinding away at things Oracular