Verify success of database backup

Hi,

I am using oracle 10.2.0.1.0 on my server. I am taking daily export backup on HP-UX. I do have log file through which i can able to verify the success of the export database backup.

Is there any dynamic performance view available in oracle to verify the success of the export database backup.

Thanks
Prashant Hirani

no, you need to test out your backusps by restoring them

and an export isnt a backup

Hi,

Thanks for the reply.

can you please clarify "an export isnt a backup"

Thanks
Prashant

Hi

With export you cannot recover to the point of failure, you cannot recover if you lose a datafile, you must recreate the whole database and only able to recover until last export.

Therefore export is not a valid backup strategy, it is used to support backkup strategy, useful to recover static tables or stored programs

Hi Pando,
Would like to clarify on ething.
Export is also a form of backup.

There are two kinds of backup
1)Logical Backups
Example:Export.This can be used when there are logical corruptions only.

2)Physical Backup
Ex:All physical backups which we take using RMAN or user managed backups.These backups are used for recovery.


Correct me if i am wrong.

export is not a backup - never will be

you cant recover using it

export arent only useful for moving data between databases and static tables

@@Davey

If you go through my previous post i had mentioned that exports are logical backups.

Please go through the below links

http://www.orafaq.com/wiki/Oracle_da...d_Recovery_FAQ

http://www.oracle.com/technology/dep...R_Overview.htm

http://www.orafaq.com/wiki/Logical_Backups/Exports

WHATS YOUR VIEW ON THIS

exports arent backups - anyone who things they are - are wrong

Hi Dave -

Interesting ! Oracle says exports are " LOGICAL Backups " but you are not accepting it.

I know one can not do any kind of recovery using the so called logical backups. Does it the only reason you are saying exports are not (logical) backups?

Appreciate your clarification.

Thanks,

http://marist89.blogspot.com/2005/05/backup-top-11.html

Thanks Jeff.

Thanks,

We need to first look at what a backup really means

backup is something using which you can go back to the previous state or backup is copy of the database which can be used if anything goes wrong.


Now coming to export
export can be useful if any table is lost it can be restored using the export file.So it is called "Logical backup"

So if a recovery or restoration of table is possible,how can anyone say that exports are not backup?

"Exports are Logical Backups"

That's what Jeff wrote in his blog.

Thanks,

Ok...sorry i did not have a look at the blog...i was just continuing my discussion....