Hi, Spyros

Oracle has three methods of backup/recovery

1. Export
2. Archive logs - These record all transactions to log files.
3. Backup to tape

There is a feature that was introduced in Oracle9i called "flashback query". This allows you to restore any mistakes by "rolling back" any mistaken commits to the database. The default value is 15 minutes but it is adjustable to whatever you want it to be. The value is in seconds.

If this isn't enough detail, then let me know and I'll try to provide more details.

Regards,


>Dear Experts,
>
>We have a very simple question about Oracle Database. My company currently is using Visual FoxPro but because of the 2GB Limitation we need to move forward and select a different database system.
>
>The 2 candidate systems are Oracle and SQL Server. Our systems are very data intensive in the following manner.
>
>In accounting systems you go to a screen and prepare an order for a customer and you need to add max 50 records per transaction in the database.
>
>This is not our case.
>Step 1:
>For each period in our system we have to retrieve around 5 million records
>Step 2
>Perform some calculations (Average, Median, get information from previous periods)
>Step 3
>Group the results in a higher level
>Step 4
>Perform again some calculations (Standard Deviation, get information from previous periods)
>Step 5
>Create a relation between the data we got in step 1 and in step 3 and update the data in step 1.
>Step 6
>Update the original data we have in our tables. (Based on Step 1 updated values)
>
>So far we looked in SQL Server and we found that for a Database we can have as a recovery model three options: Full, Bulk-Logged, Simple. In our case even the simple model is too slow. After a transaction is committed or an Insert, Update, Delete command has updated the necessary tables we don't want to go to previous values.
>
>What we need to know is what recovery models we have in Oracle so that we can perform all the necessary calculations to our database at maximum speed and if possible with minimum or zero logging (recovery)
>
>Any help will be very valuable for us.
>
>Thanks in advance.
>
>Regards,
>
>Spyros Christodoulou