The term Consistent means that when the backup completed everything was backed up and nothing new happened while the backup was going on ... its true in offline case..
online consistent backup -- its the backup where the database is not shutdown and the redo log files are generated while the backup is being taken.. so when the backup is complete there is a redo log switch and the brbackup takes the backup of only those redolog files that were generated during the backup... hence u can recover a database with it alone ... brarchive has no role in it as everything is done by brbackup. ( as Snowy mentioned )
Online backup is the backup without redo log files backup by brbackup .... there u have to use brarchive..
The only place which i think is the online consistent backup is used is whole database reset ..there too we can use offline backup.
Actually this condition is only for whole database reset ... we can recover the system with a unconsistent backup + the redo log backup ..
The Whole and Full backup have the difference when incremental backups and RMAN comes into picture....
Hope this is all what is there as far as backup is concerned...
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.