T24

[Badurudeen Abuthahir]

Hi,

I deleted the file  FBNK.BL.BILL using DELETE.FILE command.  Is there any way to recover this file

I used jstat command to check the details

File = default_FBNK_BL_BILL

Type = XMLORACLE, Version R09.1.78047, Table = FBNK_BL_BILL

Schema = T24, Tablespace =

Please provide suggestion

--
Thanks
BADURU-DEEN

[Anar Veliyev]

do you got TransactionJournaling running on your site ?

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

--
Anar Veliyev
tel: +99 450 559 02 74 (mobile)

[Anar Veliyev]

seems I noticed after pushing the "send" button that you got Oracle as a backend.
you may replace "TransactionJournaling" with the "ARCHIVELOG" in the question I did ask.

On Mon, Feb 1, 2010 at 2:20 PM, Badurudeen Abuthahir <badurudeen.sa@gmail.com> wrote:

--

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

[Pawel (privately)]

Hi,

 

1. Could not you revert your Oracle database to the point before issuing DELETE.FILE command?

2. Try something like CREATE-FILE DATA FBNK.BL.BILL TYPE=XMLORACLE / CREATE-FILE DICT FBNK.BL.BILL TYPE=XMLORACLE (assuming VOC entries are there). You will not get records back however ;)

Example for CREATE-FILE should be included somewhere in the documentation of ORAdriver.

 

Kind regards

Pawel

 

Dnia 1-02-2010 o godz. 13:23 Anar Veliyev napisaďż˝(a):

[Badurudeen]

Hi,

Thanks for your suggestion.
I tried with CREATE.FILE command and i got the FILE BACK but not the
records as u said.

--
Thanks
BADURU-DEEN

On Feb 3, 1:25 am, "Pawel (privately)" <pprivat...@wp.pl> wrote:
> Hi,
>
>  
>
> 1. Could not you revert your Oracle database to the point before issuing DELETE.FILE command?
>
> 2. Try something like CREATE-FILE DATA FBNK.BL.BILL TYPE=XMLORACLE / CREATE-FILE DICT FBNK.BL.BILL TYPE=XMLORACLE (assuming VOC entries are there). You will not get records back however ;)
>
> Example for CREATE-FILE should be included somewhere in the documentation of ORAdriver.
>
>  
>
> Kind regards
>
> Pawel
>
>  
>

> Dnia 1-02-2010 o godz. 13:23 Anar Veliyev napisa (a):
>
> do you got TransactionJournaling running on your site ?On Mon, Feb 1, 2010 at 2:20 PM, Badurudeen Abuthahir<baduru...@gmail.com>wrote:Hi,

[kashif ahmed]

Badurudeen,

 

 for next time if you want to delete the records first select them from application and then delete it

 and try to prevent to use DELETE.FILE command

regards,
kashif

On Mon, Feb 8, 2010 at 10:16 AM, Badurudeen <badurudeen.sa@gmail.com> wrote:

Hi,

Thanks for your suggestion.
I tried with CREATE.FILE command and i got the FILE BACK but not the
records as u said.

--
Thanks
BADURU-DEEN

On Feb 3, 1:25 am, "Pawel (privately)" <pprivat...@wp.pl> wrote:
> Hi,
>
>  
>
> 1. Could not you revert your Oracle database to the point before issuing DELETE.FILE command?
>
> 2. Try something like CREATE-FILE DATA FBNK.BL.BILL TYPE=XMLORACLE / CREATE-FILE DICT FBNK.BL.BILL TYPE=XMLORACLE (assuming VOC entries are there). You will not get records back however ;)
>
> Example for CREATE-FILE should be included somewhere in the documentation of ORAdriver.
>
>  
>
> Kind regards
>
> Pawel
>
>  
>

> Dnia 1-02-2010 o godz. 13:23 Anar Veliyev napisa (a):

>
> do you got TransactionJournaling running on your site ?On Mon, Feb 1, 2010 at 2:20 PM, Badurudeen Abuthahir<badurudeen.sa@gmail.com>wrote:Hi,

>
>  
>
> I deleted the file  FBNK.BL.BILL using DELETE.FILE command.  Is there any way to recover this file
>
>  
>
> I used jstat command to check the details
>
>  
>
> File = default_FBNK_BL_BILL
>
> Type = XMLORACLE, Version R09.1.78047, Table = FBNK_BL_BILL
>
> Schema = T24, Tablespace =
>
>  
>
>  
>
> Please provide suggestion
>
>  
>
> --
> Thanks
> BADURU-DEEN