Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 29 Jan 2014 @ 22:27:10 GMT


     
  <Prev Next>   <<First <Prev
Next>
Last>>
 


Subj:   Re: BACKUP Session blocking in ONLINE MODE
 
From:   Martin Barrow

Hi Sravan,

So, If I acquire check point/(lock), from then on, databases will be available for WRITE and READ for other users, right?

MB -

Once checkpoint is taken, then the tables are fully usable. Be conscious of capacity needs to capture any data changes whilst the backups are taking place - both DBC (transient journals are used to capture the changes as I found out to my cost once resusage had been disabled) and the database being backed up are impacted (changes logged in database space)


What if a user has already write locked a table/(database), My backup user should wait until the lock is released?

MB -

The checkpoint on the DB would wait until it can take it's lock.


My client has a requirement that tables should be available all time as they run the batch loads 24*7. How can we achieve this?

MB -

The push here should be getting a reliable RPO - hence a need to put a line in the sand (stopping batch for checkpoint) so you know where all your backups will restore. This is a common problem where the request is for 24x7 usage, but presuming the backups are taken for application support/DR scenario, then I always push back on RPO.


Regards,

Martin Barrow
Lead DBA, PHI IT - EDWBI BAU Support



     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023