Whole Database online backup

[Former Member]

Dear users

I wanted to know the Difference between Whole Database Online backup and

Full Database online backup.

If I have taken a backup of Database thru Whole database online backup, is this backup recoverable in case of any database crash after the backup is completed.

Regards

Shankar

[Former Member]

hi,

you have to use full mode backup. that will be better for recovery.

with regards,

Harish Reddy

[fidel_vales]

> hi,

>

> you have to use full mode backup. that will be

> better for recovery.

>

Can you give a proper explanation why a full backup is better for recovery than a whole backup?

That statement is true is SOME circunstances, but NOT all of them.

I think that if you make such statement you are able to explain why.

Regards

[fidel_vales]

Regarding the original question:

Whole backup:

Backs up all database files, but this backup is <b>not</b> cataloged as a level-0 backup, which means that <b>you cannot use it as a reference backup for an incremental backup</b> with RMAN.

Full backup

Backs up all database files. You can perform a full backup with or without RMAN. If you do not use RMAN, then RMAN is called separately to catalog the backup as level 0. This means that you can use this backup as a reference backup for an incremental backup with RMAN.

If you do not use RMAN, then perform whole backup.

If you use RMAN, and want to perform incremental backups you must perform full backup.

[andreas_herzog]

if you choose to make a <b>consistent online backup</b>: YES...ONLINE_CONS would be the option...for example:

> brbackup -u / -t online_cons -c

GreetZ, AH

[former_member204746]

or run BRBACKUP with a follow-up job of BRARCHIVE