Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: clean up ocr?

Re: clean up ocr?

From: herta <herta.vandeneynde_at_gmail.com>
Date: Sun, 01 Jul 2007 00:50:32 -0000
Message-ID: <1183251032.497313.194270@w5g2000hsg.googlegroups.com>


> - remove the database using dbca

If I did that, it'd only remove the newly created database.

> - remove all the services, instances and then the database using
> srvctl

Already tried that.

> - try to recover your ocr from a backup previous to the database
> creation ($CRS_HOME/cdata/<cluster_name>)
Unfortunately not available. I erroneously postponed taking backups. The idea was to take the backup once the initial setup was done for all databases.

Thanks for the suggestions,

Herta

On Jun 27, 4:36 pm, Valentin Minzatu <valentinminz..._at_yahoo.com> wrote:
> On Jun 26, 8:00 pm,herta<herta.vandeney..._at_gmail.com> wrote:
>
>
>
> > On Jun 26, 10:23 pm, Valentin Minzatu <valentinminz..._at_yahoo.com>
> > wrote:
>
> > > On Jun 26, 3:27 am,herta<herta.vandeney..._at_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- Hide quoted text -
>
> > - Show quoted text -
>
> That is a bit strange. Aside of what has already been mentioned, I
> would try actioning the following:
> - remove the database using dbca
> - remove all the services, instances and then the database using
> srvctl
> - try to recover your ocr from a backup previous to the database
> creation ($CRS_HOME/cdata/<cluster_name>) - make sure you have all the
> safety nets in place (including a new backup of the current) and test
> thoroughly.
>
> Valentin
Received on Sat Jun 30 2007 - 19:50:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US