| Multiple DB Instances on single DB server/host [message #653771] |
Mon, 18 July 2016 10:50  |
 |
TurtleTank112
Messages: 5
Registered: July 2016
|
Junior Member |
|
|
(Complete DB/Ora noob alert)
Hello, i'm trying to achieve the following.
Currently I have one DB being consumed by 5 testers. I'd like to replicate that DB 5 times with a unique SID and have 5 instances of the same DB running on the same DB Server.
I've looked at rman some and some of the other options but I get confused when it comes to data files etc. ie; in the above example, would there be separate datafiles created for each DB instance? My root, or base DB has appx 12GB data files. (Although I think that means its allocated and not necessarily used) does that mean if I want 5 instances on a DB server, Id need 5x12GB storage capacity as example? Does the data for the DB live in those data files? like Flat File DB kind of?
Is a simpler way to do this to just make a template of the 'root' db and then use that template to create the additional DB instances (SIDS). Is there any consideration on how to tweak storage? We are using "File System" - Can I just change that to ASM (Needed for any reason? I donno, seemed a more dynamic/grow option maybe).
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Multiple DB Instances on single DB server/host [message #653777 is a reply to message #653775] |
Mon, 18 July 2016 11:29  |
 |
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Quote:Does using a schema still require me to make the DB's prior to using the schema to populate?
No, you can use the current one.
Assume you have a database with current schema SCHEMA.
Then you create the 5 tester schemes as (assuming you have enough space on your disk to support 5 more schemes):
expdp system/manager schema=SCHEMA DUMPFILE=schema.dmp
impdp system/manager fromschema=SCHEMA toschema=TESTER1 DUMPFILE=schema.dmp
impdp system/manager fromschema=SCHEMA toschema=TESTER2 DUMPFILE=schema.dmp
impdp system/manager fromschema=SCHEMA toschema=TESTER3 DUMPFILE=schema.dmp
impdp system/manager fromschema=SCHEMA toschema=TESTER4 DUMPFILE=schema.dmp
impdp system/manager fromschema=SCHEMA toschema=TESTER5 DUMPFILE=schema.dmp
That's all.
[Updated on: Mon, 18 July 2016 11:30] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
I'll research more on schemas. How do they compare to using a template? Does using a schema still require me to make the DB's prior to using the schema to populate?