Hot Backup Consistency Question.

Hello,

I've read a fair amount about Hot Backups, but never had to perform them in practice.

The question I have concerns hot backup of multiple tablespaces.

By all accounts the way to do this is to perform serial backups i.e.

Alter tablespace1 begin backup
backup tablespace1
alter tablespace1 end backup

Alter tablespace2 begin backup
backup tablespace2
alter tablespace2 end backup

Assuming that lots of DML is happening in both tablespaces, there may well be referential ties between the two.

So the scenario is...

1) Tablespace1 backup started.
2) A trigger in tablespace2 updates a table in tablespace1
3) Tablespace1 backup finished.
4) Tablespace2 backup started and completed.

I understand that thanks to the redo activity, that the live database will have consistent data.

However, is it the case that the backup files created will have inconsistent data because the update actioned by the trigger will not have been recorded in the tablespace1 backup?

And if you have to restore these, will this still be the case, or is there some process that I haven't seen yet that deals with this?

regards

Steve Roper Received on Fri Jul 16 2004 - 06:46:59 CDT