Teradata Hot-Back up

Database
N/A

Teradata Hot-Back up

Hi,

We carry out Hot back-up of our databases i.e. our processes will be running at the back end and database back-up at the same time.

Just i want to know that how this process will be carried out. What kind of lock is applied on DB objects in such back-ups? When I try to insert, delete, update on table whose back-up is going on, my query will be blocked. Can we collect stats on tables whose back-up is going on at the back-end?

And also please let me know where can i get more information of such things for future reference.

2 REPLIES
N/A

Re: Teradata Hot-Back up

Hi,

Please anyone clear my above doubt on locks during back-ups.

N/A

Re: Teradata Hot-Back up

Hi Mahesh,

what activity is allowed during an Online Backup depends on your release.

An overview is found in Chapter 10: Archiving, Restoring, and Recovering DataT of the "Databasa Administration" and all details are in the "Teradata Archive/Recovery Utility Reference" manual.

Dieter