Re: Massively multiuser application

How about:

Run in Archive Log Mode.

When you need to restore one user:

Restore database to last backup. Note: use a new instance so current users are not affected.
Roll forward to required point in time. Export users tables and import them to live database. This will also allow you to restore individual tables.

Of course it does need twice the amount of space.

If you don't have twice the amount of space you can bring the whole system down for the duration of the restore. However you will need to restore the existing database and roll forward twice to bring you back to the start.

Best of luck.

Fred Aol wrote:

> Greetings,
>
> I am designing an application which will create a schema for every user
> and create their base tables for them. My knowledge of Oracle backup
> systems is poor, and my brief perusals of several texts on the subject
> failed to yield the answer to this question:
>
> How can I create archive the database so any user to reset his table(s)
> to the state in which it existed at any given point in time?
>
> Any responses appreciated, but please reply here.
Received on Thu Feb 25 1999 - 03:02:49 CST