Re: Massively multiuser application

As a minor variation on that theme,

If you can create tablespaces for each user then you can recover just the System, Rollback, and that user's tablespaces - saving the space and time on recovery.

You could also look into the recent 'tablespace point in time recovery' option - which isn't much easier to use than Mike's suggestion.

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Mike Burden wrote in message <36D511B9.85BD31EE_at_capgemini.co.uk>...
>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.
>
Received on Thu Feb 25 1999 - 13:53:27 CST