Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 12 Mar 2013 @ 19:18:22 GMT


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


Subj:   To restore a database from Journal
 
From:   Bakthavachalam, Roopalini

Hi Forum,

I am trying to restore a database from Journal backup that I took. I have provided the backup and the restore scripts. Backup runs fine. The first part of restore runs fine, the roll forward doesn't work. I am trying to roll forward an entire database.

Backup Script

     LOGON $LOGON;
     CHECKPOINT(RB_JOURNAL.JOURNALTBL), WITH SAVE, NAMED JOURNAL_TBL; ARCHIVE JOURNAL TABLES
               (RB_JOURNAL.JOURNALTBL), RELEASE LOCK, FILE=JOURNAL;

     LOGOFF;

Restore

     LOGON $LOGON;


     RESTORE JOURNAL TABLES
             (RB_JOURNAL), RELEASE LOCK,
     FILE=JOURNAL;

     ROLLFORWARD (BAKTHRO) ,
     TO JOURNAL_TBL,
     RELEASE LOCK,
     NO DELETE,
     USE RESTORED JOURNAL;

Below is the error I get

     03/12/2013 10:39:45  *** Error 3658:ROLLBACK/ROLLFORWARD table specifications
                          are invalid.
     03/12/2013 10:39:45  'ROLLFORWARD' SKIPPED DUE TO ERRORS
     03/12/2013 10:39:45  STATEMENT COMPLETED

Thanks

Roopalini



     
  <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: 27 Dec 2016