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 On Fri, Apr 15, 2011 at 1:06 PM, VK <[email protected]> wrote: > Hi, > post here the restore command you're using. > > On Apr 14, 5:57 pm, Wilson Chikatala <[email protected]> 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. > > > > On Thu, Apr 14, 2011 at 2:05 PM, Wilson Chikatala <[email protected] > >wrote: > > > > > > > > > > > > > > > > > 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. > > > > > On Thu, Apr 14, 2011 at 9:26 AM, VK <[email protected]> wrote: > > > > >> 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 > > > > >> On Apr 12, 7:43 am, Wilson Chikatala <[email protected]> wrote: > > >> > 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 > > > > >> > On Thu, Mar 31, 2011 at 10:47 PM, pat <[email protected]> wrote: > > >> > > '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. > > > > >> > > On Mar 31, 6:42 pm, wchikatala <[email protected]> wrote: > > >> > > > 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 > > > > >> > > -- > > >> > > 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 [email protected] > > >> > > To unsubscribe, send email to [email protected] > > >> > > For more options, visit this group at > > >> > >http://groups.google.com/group/jBASE?hl=en > > > > >> -- > > >> 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 [email protected] > > >> To unsubscribe, send email to [email protected] > > >> For more options, visit this group at > > >>http://groups.google.com/group/jBASE?hl=en > > -- > 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 [email protected] > To unsubscribe, send email to [email protected] > For more options, visit this group at > http://groups.google.com/group/jBASE?hl=en > -- 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 [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
