clean up ocr?
This is a discussion on clean up ocr? within the Oracle Database forums, part of the Database Server Software category; --> environment: Oracle EE 10.2.0.3 on SLES10 I'm setting up Data Guard largely following the instructions in http://www.oracle.com/technology/dep...calStandby.pdf In doing ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-26-2008, 07:31 AM
| ||||
| ||||
 clean up ocr? environment: Oracle EE 10.2.0.3 on SLES10 I'm setting up Data Guard largely following the instructions in http://www.oracle.com/technology/dep...calStandby.pdf In doing so, I ran into a few issues, due to which I had to start over a couple of times. Data Guard is up and running now, but I'm having problems adding the standby database (back) into the cluster, because it claims the database already exists. Oracle's solution, "choose a different name for the database being created" is not practicable in this case, as it would upset our naming schemes, and hence cause scripting issues. Is there a way to clean the entries for this database from the ocr? Kind regards, Herta $ srvctl add database -d pa99nb -o /oracle/base/product/10.2.0/db_1/ PRKP-1073 : Cannot create database pa99nb because a database named pa99nb already exists. $ srvctl remove database -d pa99nb Remove the database pa99nb? (y/[n]) y $ srvctl add database -d pa99nb -o /oracle/base/product/10.2.0/db_1/ PRKP-1073 : Cannot create database pa99nb because a database named pa99nb already exists. $ crs_stat | grep pa99nb ; echo $? 1 $ ocrdump -stdout | grep -i pa99nb [DATABASE.LOG.pa99nb] [DATABASE.LOG.pa99nb.INSTANCE] [DATABASE.DATABASES.pa99nb] ORATEXT : pa99nb [DATABASE.DATABASES.pa99nb.ORACLE_HOME] [DATABASE.DATABASES.pa99nb.DOMAIN] [DATABASE.DATABASES.pa99nb.SPFILE] [DATABASE.DATABASES.pa99nb.DB_NAME] [DATABASE.DATABASES.pa99nb.ROLE] [DATABASE.DATABASES.pa99nb.START_OPTIONS] [DATABASE.DATABASES.pa99nb.ENABLED] [DATABASE.DATABASES.pa99nb.POLICY] [DATABASE.DATABASES.pa99nb.PRIOR_POLICY] [DATABASE.DATABASES.pa99nb.SERVICE] [DATABASE.DATABASES.pa99nb.CONFIG_VERSION] [DATABASE.DATABASES.pa99nb.ENVIRONMENT] [DATABASE.DATABASES.pa99nb.INSTANCE]      |
|
02-26-2008, 07:31 AM
| |||
| |||
| Re: clean up ocr? On Tue, 26 Jun 2007 07:27:17 +0000, herta wrote: > environment: Oracle EE 10.2.0.3 on SLES10 > > I'm setting up Data Guard largely following the instructions in > http://www.oracle.com/technology/dep...ilability/pdf/ MAA_WP_10g_RACPrimaryRACPhysicalStandby.pdf > > In doing so, I ran into a few issues, due to which I had to start over a > couple of times. Data Guard is up and running now, but I'm having > problems adding the standby database (back) into the cluster, because it > claims the database already exists. Oracle's solution, "choose a > different name for the database being created" is not practicable in > this case, as it would upset our naming schemes, and hence cause > scripting issues. > > Is there a way to clean the entries for this database from the ocr? > > Kind regards, > > Herta > > $ srvctl add database -d pa99nb -o /oracle/base/product/10.2.0/db_1/ > PRKP-1073 : Cannot create database pa99nb because a database named > pa99nb already exists. > > $ srvctl remove database -d pa99nb > Remove the database pa99nb? (y/[n]) y $ srvctl add database -d pa99nb > -o /oracle/base/product/10.2.0/db_1/ PRKP-1073 : Cannot create database > pa99nb because a database named pa99nb already exists. > > $ crs_stat | grep pa99nb ; echo $? > 1 > > $ ocrdump -stdout | grep -i pa99nb > [DATABASE.LOG.pa99nb] > [DATABASE.LOG.pa99nb.INSTANCE] > [DATABASE.DATABASES.pa99nb] > ORATEXT : pa99nb > [DATABASE.DATABASES.pa99nb.ORACLE_HOME] > [DATABASE.DATABASES.pa99nb.DOMAIN] > [DATABASE.DATABASES.pa99nb.SPFILE] > [DATABASE.DATABASES.pa99nb.DB_NAME] > [DATABASE.DATABASES.pa99nb.ROLE] > [DATABASE.DATABASES.pa99nb.START_OPTIONS] > [DATABASE.DATABASES.pa99nb.ENABLED] > [DATABASE.DATABASES.pa99nb.POLICY] > [DATABASE.DATABASES.pa99nb.PRIOR_POLICY] > [DATABASE.DATABASES.pa99nb.SERVICE] > [DATABASE.DATABASES.pa99nb.CONFIG_VERSION] > [DATABASE.DATABASES.pa99nb.ENVIRONMENT] > [DATABASE.DATABASES.pa99nb.INSTANCE] Why would you want to add a single-instance standby to the cluster registry? You are aware of the fact that standby database is a single instance thing, usually not only outside the cluster but also in separate location. In the company that I work for, standby databases are in another state. Registry and a voting file are data files and the only way to clean them up is to copy approximately 64MB of zeros over them, by doing something like dd if=/dev/zero of=/dev/rdsk/ocr bs=1024k count=64 That will make the cluster registry squeaky clean, nothing will survive. Unfortunately, oracle doesn't yet have anything like the (in)famous "regedit" utility. On the other hand, ORA-0600 and ORA-7445 are Oracle versions of BSOD. -- http://www.mladen-gogala.com |
|
02-26-2008, 07:32 AM
| |||
| |||
| Re: clean up ocr? On Jun 26, 2:45 pm, Mladen Gogala <mgogala.SPAM_ME....@verizon.net> wrote: > On Tue, 26 Jun 2007 07:27:17 +0000, herta wrote: > > environment: Oracle EE 10.2.0.3 on SLES10 > > > I'm setting up Data Guard largely following the instructions in > >http://www.oracle.com/technology/dep...ilability/pdf/ > > MAA_WP_10g_RACPrimaryRACPhysicalStandby.pdf > > > > > > > In doing so, I ran into a few issues, due to which I had to start over a > > couple of times. Data Guard is up and running now, but I'm having > > problems adding the standby database (back) into the cluster, because it > > claims the database already exists. Oracle's solution, "choose a > > different name for the database being created" is not practicable in > > this case, as it would upset our naming schemes, and hence cause > > scripting issues. > > > Is there a way to clean the entries for this database from the ocr? > > > Kind regards, > > > Herta > > > $ srvctl add database -d pa99nb -o /oracle/base/product/10.2.0/db_1/ > > PRKP-1073 : Cannot create database pa99nb because a database named > > pa99nb already exists. > > > $ srvctl remove database -d pa99nb > > Remove the database pa99nb? (y/[n]) y $ srvctl add database -d pa99nb > > -o /oracle/base/product/10.2.0/db_1/ PRKP-1073 : Cannot create database > > pa99nb because a database named pa99nb already exists. > > > $ crs_stat | grep pa99nb ; echo $? > > 1 > > > $ ocrdump -stdout | grep -i pa99nb > > [DATABASE.LOG.pa99nb] > > [DATABASE.LOG.pa99nb.INSTANCE] > > [DATABASE.DATABASES.pa99nb] > > ORATEXT : pa99nb > > [DATABASE.DATABASES.pa99nb.ORACLE_HOME] > > [DATABASE.DATABASES.pa99nb.DOMAIN] > > [DATABASE.DATABASES.pa99nb.SPFILE] > > [DATABASE.DATABASES.pa99nb.DB_NAME] > > [DATABASE.DATABASES.pa99nb.ROLE] > > [DATABASE.DATABASES.pa99nb.START_OPTIONS] > > [DATABASE.DATABASES.pa99nb.ENABLED] > > [DATABASE.DATABASES.pa99nb.POLICY] > > [DATABASE.DATABASES.pa99nb.PRIOR_POLICY] > > [DATABASE.DATABASES.pa99nb.SERVICE] > > [DATABASE.DATABASES.pa99nb.CONFIG_VERSION] > > [DATABASE.DATABASES.pa99nb.ENVIRONMENT] > > [DATABASE.DATABASES.pa99nb.INSTANCE] > > Why would you want to add a single-instance standby to the cluster > registry? You are aware of the fact that standby database is a single > instance thing, usually not only outside the cluster but also in separate > location. In the company that I work for, standby databases are in another > state. > Registry and a voting file are data files and the only way > to clean them up is to copy approximately 64MB of zeros over them, by > doing something like dd if=/dev/zero of=/dev/rdsk/ocr bs=1024k count=64 > That will make the cluster registry squeaky clean, nothing will survive. > Unfortunately, oracle doesn't yet have anything like the (in)famous > "regedit" utility. On the other hand, ORA-0600 and ORA-7445 are Oracle > versions of BSOD. > > --http://www.mladen-gogala.com You can run standby databases in a cluster, as is explained in both the document I already referred to and in the Oracle® Data Guard Concepts and Administration manual (cf. http://download-uk.oracle.com/docs/c...htm#sthref2203) We decided to use a cluster at our disaster recovery site to have high availability there as well. We don't have HW support on the database server systems that we ship there, and having a cluster already up and running should make it easier to add nodes in case we have do a disaster. And yes, a 'regedit' type tool is what I was hoping for. :-( Kind regards, Herta |
|
02-26-2008, 07:32 AM
| |||
| |||
| Re: clean up ocr? herta wrote: > You can run standby databases in a cluster, as is explained in both > the document I already referred to and in the Oracle® Data Guard > Concepts and Administration manual That you can, at least in theory, may not be debatable but what is the point? What is the purpose you expect this standby to serve if it is co-located with your cluster? What is the business case? -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.org |
|
02-26-2008, 07:33 AM
| |||
| |||
| Re: clean up ocr? On Jun 26, 3:27 am, herta <herta.vandeney...@gmail.com> wrote: > environment: Oracle EE 10.2.0.3 on SLES10 > > I'm setting up Data Guard largely following the instructions inhttp://www.oracle.com/technology/deploy/availability/pdf/MAA_WP_10g_R... > > In doing so, I ran into a few issues, due to which I had to start over > a couple of times. Data Guard is up and running now, but I'm having > problems adding the standby database (back) into the cluster, because > it claims the database already exists. Oracle's solution, "choose a > different name for the database being created" is not practicable in > this case, as it would upset our naming schemes, and hence cause > scripting issues. > > Is there a way to clean the entries for this database from the ocr? > > Kind regards, > > Herta > > $ srvctl add database -d pa99nb -o /oracle/base/product/10.2.0/db_1/ > PRKP-1073 : Cannot create database pa99nb because a database named > pa99nb already exists. > > $ srvctl remove database -d pa99nb > Remove the database pa99nb? (y/[n]) y > $ srvctl add database -d pa99nb -o /oracle/base/product/10.2.0/db_1/ > PRKP-1073 : Cannot create database pa99nb because a database named > pa99nb already exists. > > $ crs_stat | grep pa99nb ; echo $? > 1 > > $ ocrdump -stdout | grep -i pa99nb > [DATABASE.LOG.pa99nb] > [DATABASE.LOG.pa99nb.INSTANCE] > [DATABASE.DATABASES.pa99nb] > ORATEXT : pa99nb > [DATABASE.DATABASES.pa99nb.ORACLE_HOME] > [DATABASE.DATABASES.pa99nb.DOMAIN] > [DATABASE.DATABASES.pa99nb.SPFILE] > [DATABASE.DATABASES.pa99nb.DB_NAME] > [DATABASE.DATABASES.pa99nb.ROLE] > [DATABASE.DATABASES.pa99nb.START_OPTIONS] > [DATABASE.DATABASES.pa99nb.ENABLED] > [DATABASE.DATABASES.pa99nb.POLICY] > [DATABASE.DATABASES.pa99nb.PRIOR_POLICY] > [DATABASE.DATABASES.pa99nb.SERVICE] > [DATABASE.DATABASES.pa99nb.CONFIG_VERSION] > [DATABASE.DATABASES.pa99nb.ENVIRONMENT] > [DATABASE.DATABASES.pa99nb.INSTANCE] Have you tried to remove the instance entries (i.e. srvctl remove instance -d pa99nb -i <instance_name>)? |
|
02-26-2008, 07:33 AM
| |||
| |||
| Re: clean up ocr? On Jun 26, 10:23 pm, Valentin Minzatu <valentinminz...@yahoo.com> wrote: > On Jun 26, 3:27 am, herta <herta.vandeney...@gmail.com> wrote: > > > > > environment: Oracle EE 10.2.0.3 on SLES10 > > > I'm setting up Data Guard largely following the instructions inhttp://www.oracle.com/technology/deploy/availability/pdf/MAA_WP_10g_R... > > > In doing so, I ran into a few issues, due to which I had to start over > > a couple of times. Data Guard is up and running now, but I'm having > > problems adding the standby database (back) into the cluster, because > > it claims the database already exists. Oracle's solution, "choose a > > different name for the database being created" is not practicable in > > this case, as it would upset our naming schemes, and hence cause > > scripting issues. > > > Is there a way to clean the entries for this database from the ocr? > > > Kind regards, > > > Herta > > > $ srvctl add database -d pa99nb -o /oracle/base/product/10.2.0/db_1/ > > PRKP-1073 : Cannot create database pa99nb because a database named > > pa99nb already exists. > > > $ srvctl remove database -d pa99nb > > Remove the database pa99nb? (y/[n]) y > > $ srvctl add database -d pa99nb -o /oracle/base/product/10.2.0/db_1/ > > PRKP-1073 : Cannot create database pa99nb because a database named > > pa99nb already exists. > > > $ crs_stat | grep pa99nb ; echo $? > > 1 > > > $ ocrdump -stdout | grep -i pa99nb > > [DATABASE.LOG.pa99nb] > > [DATABASE.LOG.pa99nb.INSTANCE] > > [DATABASE.DATABASES.pa99nb] > > ORATEXT : pa99nb > > [DATABASE.DATABASES.pa99nb.ORACLE_HOME] > > [DATABASE.DATABASES.pa99nb.DOMAIN] > > [DATABASE.DATABASES.pa99nb.SPFILE] > > [DATABASE.DATABASES.pa99nb.DB_NAME] > > [DATABASE.DATABASES.pa99nb.ROLE] > > [DATABASE.DATABASES.pa99nb.START_OPTIONS] > > [DATABASE.DATABASES.pa99nb.ENABLED] > > [DATABASE.DATABASES.pa99nb.POLICY] > > [DATABASE.DATABASES.pa99nb.PRIOR_POLICY] > > [DATABASE.DATABASES.pa99nb.SERVICE] > > [DATABASE.DATABASES.pa99nb.CONFIG_VERSION] > > [DATABASE.DATABASES.pa99nb.ENVIRONMENT] > > [DATABASE.DATABASES.pa99nb.INSTANCE] > > Have you tried to remove the instance entries (i.e. srvctl remove > instance -d pa99nb -i <instance_name>)? Yes, I can add and remove the instances using srvctl. It's just the database itself which I cannot remove. Kind regards, Herta |
|
02-26-2008, 07:33 AM
| |||
| |||
| Re: clean up ocr? On Jun 26, 5:18 pm, DA Morgan <damor...@psoug.org> wrote: > herta wrote: > > You can run standby databases in a cluster, as is explained in both > > the document I already referred to and in the Oracle® Data Guard > > Concepts and Administration manual > > That you can, at least in theory, may not be debatable but what is the > point? > > What is the purpose you expect this standby to serve if it is co-located > with your cluster? > > What is the business case? > -- > Daniel A. Morgan > University of Washington > damor...@x.washington.edu (replace x with u to respond) > Puget Sound Oracle Users Groupwww.psoug.org I think I just explained. The standby databases are in a remote location. We want redundancy there for two reasons: 1. for high availability during normal standby operations as the two servers don't have HW support contracts 2. to have high availability already in place in case we have a disaster. We can then startup using the servers we have, and add more servers (which will be required to carry the load as more applications will get on line again) without disrupting the operations already in progress. As you know, you cannot move a single instance database to a RAC config without shutting down the database. |
|
02-26-2008, 07:33 AM
| |||
| |||
| Re: clean up ocr? On Jun 26, 5:18 pm, DA Morgan <damor...@psoug.org> wrote: > herta wrote: > > You can run standby databases in a cluster, as is explained in both > > the document I already referred to and in the Oracle® Data Guard > > Concepts and Administration manual > > That you can, at least in theory, may not be debatable but what is the > point? > > What is the purpose you expect this standby to serve if it is co-located > with your cluster? > > What is the business case? > -- > Daniel A. Morgan > University of Washington > damor...@x.washington.edu (replace x with u to respond) > Puget Sound Oracle Users Groupwww.psoug.org Ah, just saw what causes the confusion: I don't intend to co-locate the standby databases with the cluster running the primary databases. The standby databases will run in their proper cluster environment, of course. |
|
02-26-2008, 07:33 AM
| |||
| |||
| Re: clean up ocr? On Tue, 26 Jun 2007 14:49:33 +0000, herta wrote: > You can run standby databases in a cluster, as is explained in both the > document I already referred to and in the Oracle® Data Guard The manual says you can, but it doesn't explain why would you do something like that. you can always create a single instance with CRS installed and then add another instance, if needed. The problem with clustered standby instances is that you have multiple machines doing recovery, which is a waste. -- http://www.mladen-gogala.com |
|
02-26-2008, 07:33 AM
| ||||
| ||||
| Re: clean up ocr? herta wrote: > On Jun 26, 5:18 pm, DA Morgan <damor...@psoug.org> wrote: >> herta wrote: >>> You can run standby databases in a cluster, as is explained in both >>> the document I already referred to and in the Oracle® Data Guard >>> Concepts and Administration manual >> That you can, at least in theory, may not be debatable but what is the >> point? >> >> What is the purpose you expect this standby to serve if it is co-located >> with your cluster? >> >> What is the business case? >> -- >> Daniel A. Morgan >> University of Washington >> damor...@x.washington.edu (replace x with u to respond) >> Puget Sound Oracle Users Groupwww.psoug.org > > I think I just explained. > The standby databases are in a remote location. We want redundancy > there for two reasons: > 1. for high availability during normal standby operations as the two > servers don't have HW support contracts > 2. to have high availability already in place in case we have a > disaster. We can then startup using the servers we have, and add > more servers (which will be required to carry the load as more > applications will get on line again) without disrupting the operations > already in progress. As you know, you cannot move a single instance > database to a RAC config without shutting down the database. That's not an explanation. I understand why you would want a DR site. I understand why you might want a RAC cluster or Data Guard at a DR site. That's not what you indicated you wanted to do. You wrote: "You can run standby databases in a cluster" and I am asking for the business case that supports this specific configuration. Because I don't believe there is one. -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.org |
Linear Mode
