Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 11 Jun 2014 @ 12:08:41 GMT


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


Subj:   Re: Restrict updates during backup run
 
From:   Bodla, Sravan Kumar

Hi Mark,

WE do run our backups in ONLINE mode, but, it does have quite a few disadvantages.

My client wants the system to be available 24*7 (for read and write), but, there is some issue now and then.

When my backup starts to "Enable Archive logging on...." on Databases, and if some DML is already running, backup goes into blocked state and sometime it is in turn causing the blocked sessions to go into DEADLOCK scenario.

Online backups doesn't support DDL's (Also, your Fastloads might cause backup to fail when it tries to create/drop error tables).


Thanks,

Sravan.

SRAVAN KUMAR BODLA
GCC International - Technical Consultant



     
  <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