Restore Data from backup files in T24

[wchikatala]

Hi Friends!

Kindly help if you can. I have been using T24 for about six months
now. I want restore data from backup files sitting on hard disk of
backup server. I want to restore to a test database also sitting on
the backup server. Transaction journaling is enabled in the live
database, the source of these backups. Backups are in this format:
live.110104.20110106T1521.FULL.SOD-journal.tar.

Can someone help me on how I can restore from such backups using
jlogdup. I want to restore TT, DC, and FT data only. If this can’t
work I wouldn’t mind to have a full restoration.

Regards

[pat]

'tar' files ( assuming the 'naming convention' of this file suggests
it is a 'tar' file ), are restored on Unix systems using the Unix
'tar' command, eg :

tar -xvf live.110104.20110106T1521.FULL.SOD-journal.tar

See 'man tar' for further details

I suspect however that extracting the files from this 'tar' file is
just the start of your restoration process

Pat.

[Wilson Chikatala]

Thanks Pat. I need further help. I was able to extract the log sets using the tar archiver. Now I need to restore the data using jlogdup. preferrably, I just want to restore TT, DC, and FT. However, if this can't work, even a full restoration is okay.

 

Thanks

--
Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines

IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24

To post, send email to jB...@googlegroups.com
To unsubscribe, send email to jBASE-un...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en

[VK]

Hi,
the extraction took so much time? :)))

To restore with jlogdup you'll need an older full copy of your area
where to apply the journal. If you want only TT then restore
FBNK.TELLER table, for FT it's FBNK.FUNDS.TRANSFER (assuming that you
have so-called "single-company setup", it might be different prefix in
the other case and several files instead of each mentioned above).

For DC tables are STMT.ENTRY or CATEG.ENTRY, see above the note about
prefix (and you'll have to filter the records since these tables
contain all accounting entries - unless some of them being archived).

If you have certain tables extracted and nothing else, you're not able
to see the data properly in T24 - just raw records (yes there are many
dependencies which are usually not documented).

VK

[Wilson Chikatala]

VK,

 

Not really. I had just shelved the research. Was working on quarterly reports. Will try your good solution and tell you how it goes.

[Wilson Chikatala]

Hi VK,

 

Kindly guide me with an example.

 

From the backup live.110104.20110106T1809.DATA.EOD-journal.tar.bz2, I restored the following log set files into emerge/journal of test database area: log2.1, log2.2, log2.3 and log2.4. When I do a restoration, this is what I get:

 

17:08:29 14 APR 2011 : STATUS:
    Termination Statistics: usr 0.02 , sys 0.01 , elapsed 0m0.00
    INPUT : 0 records , 0 blocks , 0 record bytes , 0 errors
    OUTPUT: 0 records , 0 blocks , 0 bytes , 0 errors
17:08:29 14 APR 2011 : STATUS:
    Program terminated. Exit code is 0

 

It is drawing zeros.

 

Can you please show me with an example, how I can restore TT for instance?

 

Thanks,

Wilson.

[VK]

Hi,
post here the restore command you're using.

On Apr 14, 5:57 pm, Wilson Chikatala <wchikat...@gmail.com> wrote:
> Hi VK,
>
> Kindly guide me with an example.
>
> From the backup live.110104.20110106T1809.DATA.EOD-journal.tar.bz2, I
> restored the following log set files into emerge/journal of test database
> area: log2.1, log2.2, log2.3 and log2.4. When I do a restoration, this is
> what I get:
>
> 17:08:29 14 APR 2011 : STATUS:
>     Termination Statistics: usr 0.02 , sys 0.01 , elapsed 0m0.00
>     INPUT : 0 records , 0 blocks , 0 record bytes , 0 errors
>     OUTPUT: 0 records , 0 blocks , 0 bytes , 0 errors
> 17:08:29 14 APR 2011 : STATUS:
>     Program terminated. Exit code is 0
>
> It is drawing zeros.
>
> Can you please show me with an example, how I can restore TT for instance?
>
> Thanks,
> Wilson.
>

[Wilson Chikatala]

Hi,

Here is the command:

 

jlogdup -v INPUT set=CURRENT OUTPUT set=database rename=/emerge/database/live, /emerge/database/pastel

 

That is the command.

 

Thanks,

Regards

[VK]

hi,

try the following in jsh prompt:

CREATE-FILE TJ1 TYPE=TJLOG

Then you can see the contents of the current log set using LIST TJ1
etc. Maybe the set is empty?

If it's not, you can proceed wit partial restore. See
http://www.jbase.com/r5/knowledgebase/manuals/3.0/30manpages/man/trj2_jlogdup.htm
for more detail.

VK