multiple users or multiple oracle instance of the same database 
Author Message
 multiple users or multiple oracle instance of the same database

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



Fri, 10 Oct 2003 15:01:11 GMT
 multiple users or multiple oracle instance of the same database


Quote:

>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



Fri, 10 Oct 2003 22:38:43 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Advice needed: Multiple instances vs Multiple users in 1 instance

2. Multiple Databases/Multiple Instances

3. Multiple database - multiple query - multiple server

4. Multiple Instances or Multiple Servers

5. Multiple Schemas vs. Multiple Instances

6. Multiple Instances Vs Multiple Servers

7. Multiple instances vs. users

8. 1 user for multiple DB instances?

9. Multiple instances of a database on one database server

10. Restoring same database to multiple database instances on same dbserver

11. Single-Instance Cluster vs Multiple-Instance Cluster

12. Moving a Single Instance to a Multiple Instance Cluster


 
Powered by phpBB® Forum Software