My company is planning on providing a bureau service where different clients
can access the database.
We would like to isolate the different clients' database and so that if
anything were to happen to a particular one, we could just restore for that
particular client.

What would be  a good approach ?

1. Assign a different user name to each client.
2. Use parallel server to assign another instance of the database to each
client, ie., a different oracle SID for client.

Would appreciate feedback from experience people who have done this sort of
stuff.

--
regards,
tony

Tony, With OPS or an exclusive database there is only one database and the
entire database pretty much has to be at recovered as a unit to the same
point in time, except when performing a tablespace point-in-time recovery.
If you
assign each client to a seperate user id and place all objects for a user in
their own tablespace then you could use this option to isolate clients when
the recovery does not require that the system, rbs, or temp tablespaces be
part of the recovery.

See the Backup and recovery manual.  It warns that TSPITR is a complex process
that should be done with the help of support.

-- Mark D. Powell --

 -----  Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web  -----
  http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups
   NewsOne.Net prohibits users from posting spam.  If this or other posts