| ajay |
Posted: Apr 03, 2007 08:14:25 AM |
Total Post: 24
Joined: Mar, 2007
|
hi DBA's
i am very much confuse with standby and clone wat is the diffrence...
and wat is the diffrence between database name(db_name),instance name (instance_name),service name and database id
thanks.... |
|
|
 Tina |
| Posted: Apr 03, 2007 02:20:45 PM |  |
|
Total Post: 9
Joined: Apr, 2007
|
Hi,
database name (parameter = db_name) = name of your database which should be max 8 character
instance name = name of your database instace (instace is responsible to communicate with the database) which should be max 8 character
service name = instance is having one service which should be in running mode in order to access the database (while creating database on command line, you need to create one service manually)
database id= database identifire (dbid) which is 10 numeric character
stand alone db is a offline copy of the live production database. I guess clone and stand by are the same. Not pretty sure about it.
Thanks,
Tina K.
|
|
|
|
|
| Sabdar Syed |
| Posted: Apr 04, 2007 03:31:34 AM | |
|
Total Post: 35
Joined: Mar, 2007
|
Cloned Database:
---------------
The cloned database means it is the duplicate copy of your original database i.e. Production. This cloned database is used for testing, development, training, patching, etc. Whenever there is a problem/error/issue on original (Production) databae, first we do fix this on cloned database (duplicate copy of production), if that fix is done perfectly on cloned db then we will fix the problem in Production.
Standby Database:
-----------------
This is also a copy of your database, but this can be your secondary (standby) database. Every archived log generated in primary database will be copied to Standby database to keep the standby up to date. Whenever there is an issue/problem in the Primary Database (Production), We switch over to the secondary (standby) database.
I request you to read the Oracle Documentation for Standby concepts. Below is an URL for the same.
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14239/toc.htm
Regards,
Sabdar syed.
http://sabdarsyed.blogspot.com/
|
|
|
|
|
| ajay |
| Posted: Apr 04, 2007 05:13:57 AM | |
|
Total Post: 24
Joined: Mar, 2007
|
thanks... sshpcop
thanks...tina..
|
|
|
|
|
| Sanju |
| Posted: Apr 11, 2007 11:42:08 AM | |
|
Total Post: 8
Joined: Feb, 2007
|
Standby database is the copy of production database the difference between standby db and prod. db of current redo cuz it regularly updated by server process if we had configure the parameters for it. we use it for data guard.
Clone database is also the copy of prod. database but we cant use it for dataguard cuz its not regulary updated. we can use it as development database.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
