Archives of the TeradataForum

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

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

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>>